screaming-frog-cleanuplisted
Install: claude install-skill selfcanonical/screaming-frog-cleanup
# Screaming Frog Audit Cleanup
Turns a noisy Screaming Frog "Bulk Export > Issues > All" export into:
1. **A clean workbook** (`<client>_seo_audit_clean.xlsx`): Executive Summary tab (color-coded priority, linked to detail tabs), All Issues tab (every SF issue with SF vs clean counts and SF fix notes), and one trimmed tab per kept issue.
2. **A raw merged workbook** (`sf_raw_merged.xlsx`): every CSV from the export as its own tab, untouched, with real headers in row 1 and a linked Index tab. Made for manual work in Excel or Google Sheets. Only created when the input is a zip or folder of CSVs.
3. **An executive audit summary PDF** (`<client>_executive_summary.pdf`) written for a client or stakeholder.
This skill ships two scripts next to this file:
- `sf_clean.py` builds the two workbooks and a JSON summary (needs `pandas` and `openpyxl`).
- `sf_pdf.py` turns the Markdown summary into the PDF (needs `reportlab`).
## Inputs accepted
- A `.zip` of the SF CSVs (the raw export, e.g. `All_Issues.zip`)
- A folder of the CSVs
- A merged `.xlsx` where row 1 of each tab is `File Name: x.csv` (for example, from https://selfcanonical.com)
The export must include `issues_overview_report.csv`. If it is missing, ask the user to re-export with Bulk Export > Issues > All. The set of CSVs changes with each site, since SF only exports checks that found something. The scripts handle any subset.
## Steps
1. Find the uploaded file. Copy it into its own empty folder (e.g. `~/sf_in/`). Ask f