← ClaudeAtlas

screaming-frog-cleanuplisted

Clean a Screaming Frog Bulk Export > Issues > All export (zip of CSVs or merged xlsx) into a clean audit workbook, a raw merged workbook, and a plain-language executive SEO audit summary PDF.
selfcanonical/screaming-frog-cleanup · ★ 1 · Data & Documents · score 74
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