Python CSV Cleaner Toolkit: Clean, Merge, Split & Inspect CSV Files (Beginner-Friendly Scripts + Guide)

Details

Stop fixing CSV exports by hand. These scripts do the boring part in seconds and never touch your original file: csvclean always previews first, and results go to a new file.

No installs beyond Python itself, no internet, no data leaves your computer.

What's inside

• csvclean.py: trim spaces, remove empty rows and duplicates (by row or key columns), dates → YYYY-MM-DD, 1.234,50 → 1234.50, lowercase emails, snake_case headers, dry-run by default
• csvmerge.py: combine many CSVs by column name, optional source-file column
• csvsplit.py: split by a column value or by N rows
• csvinspect.py: read-only profile of rows, blanks, unique values and duplicates
• Sample files and a self-test (tests/run_tests.py)
• 6-page PDF guide with install steps for Windows, macOS and Linux

Good to know

• Python 3.8+ (free). Standard library only.
• Self-test passes on Linux with Python 3; the scripts use only cross-platform standard library features. Windows and macOS steps are in the guide.
• Detects , ; tab | delimiters and UTF-8 / Windows-1252 / Latin-1 encodings.
• Never overwrites your input or earlier results.

Format & delivery

• One ZIP file containing:
• CSV-Cleaner-Toolkit-Guide.pdf
• csvclean.py
• csvinspect.py
• csvkit_common.py
• csvmerge.py
• csvsplit.py
• samples/customers-messy.csv
• samples/february.csv
• samples/january.csv
• tests/run_tests.py
• README.txt
• Instant digital download after checkout. You also get the link by email.

Licence: personal use. Please don't resell or share the files.

Questions? [email protected]