🚫 Google Disavow File Generator

Auto-build Google disavow files from a spreadsheet of backlinks

---

A specialized Python tool that scans an Excel export of your backlinks and automatically generates a Google disavow file for the suspicious ones — perfect for cleaning up after a negative-SEO or PBN (Private Blog Network) link attack.

🎯 Purpose

When toxic backlinks point at your site, Google lets you disavow them so they're ignored in ranking. Doing this by hand across thousands of rows is painful. This tool reads your backlink spreadsheet, finds links matching a known PBN footprint (by default the wix.com/marketplace/wix-partner pattern), extracts their domains, and writes a ready-to-upload disavow file in Google's exact format.

✨ Features

• 📊 Reads Excel directly — point it at your backlink export (.xlsx).
• 🧠 Smart URL-column detection — works across different export formats without manual mapping.
• 🎯 Pattern filtering — flags links matching the wix.com/marketplace/wix-partner PBN footprint (fully customizable).
• 🌐 Domain extraction — converts matched URLs into domain: entries.
• 📝 Google-ready output — proper headers, timestamps, and domain: formatting for Search Console.
• 🖱️ One-click run — a batch file handles dependencies and execution on Windows.

📋 Requirements

• 🐍 Python 3.6 or higher
• 🐼 pandas (auto-installed by the batch file if missing)

🚀 How to Use

Windows (one-click)

1. Place your backlink Excel file somewhere accessible.
2. Edit run_disavow_generator.bat to point at your file (or use the default path).
3. Double-click run_disavow_generator.bat.
4. A timestamped disavow file appears in the same directory.

Command line

python create_disavow_list.py path/to/backlinks.xlsx

📄 Output Format

The generated file follows Google's disavow specification:

# Disavow file generated by Google Disavow File Generator
# Generated on: 2025-07-03 18:26:32
# Filtered for PBN links matching wix.com/marketplace/wix-partner pattern

domain:example-pbn-site.com
domain:another-suspicious-domain.com

⚙️ How It Works

1. Read the Excel file of backlinks.
2. Detect which column holds the URLs.
3. Filter rows whose URL matches the configured PBN pattern.
4. Extract the domain from each matched URL.
5. Write a formatted disavow file with descriptive headers.

🛠️ Customization

To target a different PBN footprint, open create_disavow_list.py and edit the pattern variable:

# create_disavow_list.py
pattern = r'wix\.com/marketplace/wix-partner'   # ← change to your own regex

📁 Project Structure

Disavow-Generator/
├── create_disavow_list.py      # Core logic
├── run_disavow_generator.bat   # One-click Windows runner
└── README.md

⚠️ Disclaimer

Disavowing links is a powerful, advanced SEO action — disavowing good links can hurt your rankings. Always review the generated file before uploading it to Google Search Console.

👨‍💻 Author

Gunjan Jaswal — www.gunjanjaswal.me — hello@gunjanjaswal.me

☕ Support

If this saved you hours of manual cleanup, consider supporting development on Ko-fi: