Merge multiple CSV files into one mega CSV. Simple, fast, offline.
| Manual Merging | CSV Merger |
|---|---|
| β Tedious copy-paste | β One click |
| β Duplicate headers | β Smart header handling |
| β Error-prone | β Automatic validation |
| β Time-consuming | β Batch processing |
| β Scattered outputs | β Organized vault |
- π― Drag & Drop - Interactive interface (Windows)
- Batch Processing - Merge 100+ files at once
- Smart Headers - Automatically keeps one header, skips duplicates
- Recursive Mode - Find CSVs in subfolders
- Organized Output - Timestamped folders in
merge_vault/ - Cross-Platform - Windows, Linux, macOS
- No Dependencies - Just Python 3.x standard library
- No Size Limits - Handles huge files
# 1. Double-click to launch
CSV Merger.bat
# 2. Type or paste folder path - done!chmod +x convert.sh
./convert.sh /path/to/csvs# Merge entire folder
python3 csv_merger.py -d ./data -o merged.csv -v
# Merge specific files
python3 csv_merger.py file1.csv file2.csv file3.csv -o merged.csv -v
# Recursive merge (include subfolders)
python3 csv_merger.py -d ./data -o merged.csv --recursive -vAll outputs saved to timestamped folders:
CSV-Merger/
βββ merge_vault/
βββ 20241107_093015/
β βββ MERGED_ALL.csv
βββ 20241107_143022/
β βββ MERGED_ALL.csv
βββ 20241107_201545/
βββ MERGED_ALL.csv
# Before: 50 CSV files scattered everywhere
# After: One clean CSV with all data combined
python3 csv_merger.py -d ~/data/csvs -o mega.csv -v
# Output: merge_vault/20241107_1430/MERGED_ALL.csv- Scans folder for
.csvfiles - Reads header from first CSV
- Writes that header to output file
- Iterates through all files, skipping their headers
- Appends all data rows to output
- Skips empty rows and handles errors gracefully
β Combine monthly/weekly CSV reports β Merge data exports from multiple sources β Consolidate database dumps β Aggregate Excel exports β Combine WiGLE/Kismet wardriving data β Merge sensor/IoT data logs β Any CSV files!
No installation needed! Just requires Python 3.x:
Windows: Download Python
Linux: sudo apt install python3 (Ubuntu/Debian)
Mac: brew install python3
START_HERE.txt- Quick start guide with ASCII artHOW_TO_USE.txt- Visual guide for WindowsQUICKSTART.md- Platform-specific instructionsREADME.md- This file
python3 csv_merger.py --help
Options:
-d, --directory Directory containing CSV files
-o, --output Output merged CSV file (required)
-v, --verbose Show detailed progress
--recursive Include CSVs in subfolders- Python 3.6 or higher
- No external dependencies (uses standard library only)
MIT - See LICENSE
Made with β€οΈ by ringmast4r