Split a spreadsheet: CSV and Excel
Split a large CSV or Excel file into smaller files, for example for an import with a row limit. The header row can be repeated in every file.
The tool could not be loaded. It needs JavaScript: please enable it or reload the page.
or drag them here
CSV, TXT, Excel (XLSX, XLS), OpenDocument (ODS) or JSON.
Values like 12.50 become numbers. Leading zeros (postcodes, IDs) stay text.
Preview
No image chosen yet.
Frequently asked questions
Why split a table?
Many programs only accept a certain number of rows on import, e.g. newsletter services or web shops. Once split, each file stays below the limit.
Is the header row in every file?
Yes, if “First row is the header row” is switched on. It then doesn’t count towards the rows per file.
More tools in this category
- Convert spreadsheets Convert between CSV, Excel, ODS and JSON.
- XML ↔ JSON Convert XML to JSON and back.
- Compare tables Compare two Excel or CSV files.
- Remove duplicates Delete duplicate rows in Excel or CSV.
- Average & median Mean, median, standard deviation, quartiles.
- YAML ↔ JSON Convert YAML to JSON and back.