SQL Dump to Split CSVs
Budget: €30 – €250 EUR
I have a 1.6 GB MySQL dump (.sql) that I need converted into flat files I can open directly in Excel. The steps are straightforward:
• Restore or parse the MySQL dump.
• Export each table to its own Excel-compatible CSV (headers retained, UTF-8).
• Keep every file under roughly 20 MB so the end result is about 80–85 files.
I only need the raw data converted and correctly split—no additional cleaning, mapping, or analysis. Please double-check that row counts and basic checksums match the source so I know nothing was lost in the process. Provide the files in a single compressed archive along with a brief log of the commands or script you used so I can reproduce the workflow later if needed.
A simple, reliable approach—MySQL Workbench, mysqldump + csvkit, Python + pandas, or anything similar—is fine as long as the output opens in Excel without issues.
• Restore or parse the MySQL dump.
• Export each table to its own Excel-compatible CSV (headers retained, UTF-8).
• Keep every file under roughly 20 MB so the end result is about 80–85 files.
I only need the raw data converted and correctly split—no additional cleaning, mapping, or analysis. Please double-check that row counts and basic checksums match the source so I know nothing was lost in the process. Provide the files in a single compressed archive along with a brief log of the commands or script you used so I can reproduce the workflow later if needed.
A simple, reliable approach—MySQL Workbench, mysqldump + csvkit, Python + pandas, or anything similar—is fine as long as the output opens in Excel without issues.
Related categories:
Python
Data Processing
Excel
SQL
MySQL
PostgreSQL
Data Analysis
Database Management