Reads a CSV or spreadsheet export without changing it and reports what is in it, including row and column counts, each column's type, blanks, distinct values, numeric ranges, duplicates, mixed formats, odd outliers and case or spacing variants, then lists what to ask the data's owner before anyone uses it.
npx mdskills install proskillpacks/csv-profile-and-sanity-checkRelated
Give it a CSV. It runs a small read-only script (Python 3 standard library) and reports rows, columns, each column's type, blanks, distinct values, ranges, duplicates, mixed formats, stray spaces, case variants and outliers, then lists questions to ask the data's owner. Without code execution it profiles a pasted sample and says so.
Any assistant that reads the open SKILL.md format works.
csv-profile-and-sanity-check folder into .agents/skills/ in your project (or ~/.agents/skills/ for everywhere). Or run npx skills add proskillpacks/skills. Or use your tool's own skills folder.No install: open prompt.md, copy it into ChatGPT or any chatbot and paste your material where marked.
Any assistant that reads SKILL.md (Claude, Codex, Gemini CLI, Cursor, GitHub Copilot and others) and any chatbot via prompt.md. Tested on Claude Sonnet.
Before: Opening a 891-row export and scrolling for a few minutes to see if it looks fine.
After (skill output, from a real test run): Test run on a public 891-row passenger CSV. It reported 19% blank in Age (177 rows) and 77% blank in Cabin, 15 zero fares, 53 high fare outliers, a Ticket column that should be read as text, trailing spaces in names and 2 blank Embarked values, named the two rows, and asked the owner eight questions, such as whether Fare is per person or per ticket. It changed nothing in the file.
1 run on a real public CSV (Claude Sonnet) with the script. The script output was used as the facts.
Made by Pro Skill Packs. MIT licensed: use it, change it, share it.
More skills: https://proskillpacks.github.io/ . Pairs with the paid Messy CSV Cleaner, Spreadsheet Formula and Cleanup and Survey Results Summariser.
Install via CLI
npx mdskills install proskillpacks/csv-profile-and-sanity-checkCSV Profile And Sanity Check is a free, open-source AI agent skill. Reads a CSV or spreadsheet export without changing it and reports what is in it, including row and column counts, each column's type, blanks, distinct values, numeric ranges, duplicates, mixed formats, odd outliers and case or spacing variants, then lists what to ask the data's owner before anyone uses it.
Install CSV Profile And Sanity Check with a single command:
npx mdskills install proskillpacks/csv-profile-and-sanity-checkThis downloads the skill files into your project and your AI agent picks them up automatically.
CSV Profile And Sanity Check works with Claude Code, Claude Desktop, Cursor, Vscode Copilot, Windsurf, Continue Dev, Codex, Gemini Cli, Amp, Roo Code, Goose, Opencode, Trae, Qodo, Command Code, Chatgpt. Skills use the open SKILL.md format which is compatible with any AI coding agent that reads markdown instructions.