So nutzt du: Split CSV
- Paste the CSV, or click Open file and choose a .csv (Excel .xlsx works too).
- Pick how to split: Rows per file, Number of files, or Column value to get one file per region, month or customer.
- Keep Repeat the header row on so every file opens with column names, and choose CSV or Excel output.
- Download single files from the list, or click Download all (ZIP).
Why split a CSV file?
Big CSV exports run into limits all the time: email attachments, CRM and newsletter importers that accept 5,000 or 10,000 rows per upload, Google Sheets’ 10-million-cell cap, and Excel’s 1,048,576-row maximum. Splitting turns one unwieldy file into pieces each system accepts — without opening a spreadsheet or writing a script.
Three ways to split
| Split by | Use it when | Example |
|---|---|---|
| Rows per file | An importer has a row limit | 25,000 contacts → 5 files of 5,000 |
| Number of files | You’re sharing work evenly | A lead list split between 4 sales reps |
| Column value | Each group goes somewhere different | One file per region, store or month |
What stays the same
- The header row is repeated at the top of every file, so each piece imports on its own.
- Quoted values — commas, quotes and line breaks inside cells — are written back correctly.
- The delimiter is detected (comma, semicolon, tab or pipe) and reused in the output.
- Row order is preserved inside each file.
Need to go the other way? Combine data with Remove Duplicate Lines, or convert the pieces with CSV to JSON and CSV to SQL.
Auch gesucht als: split csv file, csv splitter, split large csv, split csv into multiple files, csv split by rows, split csv by column, divide csv, chunk csv.
Passende Tools zu: Split CSV
- Split Excel — Split a large .xlsx into smaller workbooks — by rows per file, number of files, column value (one file per region, team or month) or one file per sheet.
- JSON to Excel — Turn a JSON array into a real Excel workbook.
- Excel to JSON — Open an .xlsx workbook or paste cells straight from Excel or Google Sheets and get clean JSON.
- JSON to SQL — Paste a JSON array and get SQL that creates the table and inserts every object as a row — nested objects become columns or JSON values, and every string is escaped for your dialect.
Häufige Fragen
Is my CSV uploaded?
No. The file is read and split in your browser, so the data never leaves your device. You can even go offline after the page loads.
How large a CSV can I split?
Files of tens of megabytes and hundreds of thousands of rows work in a modern browser. The limit is your device’s memory, not a server quota.
Can I split by a column such as country or date?
Yes. Choose Column value and pick the column; you get one file per distinct value, named after it. Empty values go into a “blank” file.
Will Excel open the files correctly?
Choose Excel .xlsx as the output to avoid delimiter and encoding issues entirely, or keep CSV for importers and databases.
Kann ich Split CSV als Web-App installieren und offline nutzen?
Ja. Split CSV ist eine installierbare Web-App (PWA) – sie wird über Ihren Browser installiert und nicht aus einem App-Store heruntergeladen. Klicken Sie oben auf dieser Seite in Chrome oder Edge (Windows, macOS, Linux, ChromeOS) auf „App installieren“ oder verwenden Sie auf Android-Geräten „Teilen“ → „Zum Startbildschirm hinzufügen“ auf dem iPhone und iPad bzw. „Datei“ → „Zum Dock hinzufügen“ in Safari 17+ auf einem Mac. Die App öffnet sich dann in einem eigenen Fenster mit einem eigenen Symbol, und da sie vollständig in Ihrem Browser ausgeführt wird, funktioniert sie auch offline. Firefox auf dem Desktop kann keine Web-Apps installieren. So funktioniert die Installation.