A CSV splitter breaks one large spreadsheet file into several smaller ones. Many programs struggle with huge files, and many upload forms have a limit on the number of rows that they'll accept. Choose your file or paste your data, say how many rows you want in each part, and this CSV splitter does the rest. It copies the header row into every file, and it keeps quoted fields together correctly, even if they contain commas or line breaks. Everything happens in your browser, so your file isn't uploaded, which matters when it contains customer or business data.
How to use the CSV splitter
- Choose a CSV file, or paste your data.
- Enter the number of rows that you'd like in each file.
- Tick the header option if your first row contains column names.
- Press Split file.
- Download each part.
What is a CSV file?
Comma-separated values, or CSV, is a plain text data format for storing tabular data, where the fields of a record are separated by a comma and each record is on its own line. CSV is commonly used in software that deals with tabular data, such as databases and spreadsheets. Its benefits include simplicity of use and human readability. It's also the reason that files can get so large, as there's no compression at all.
A worked example
Suppose that you have a file called customers.csv with a header row and 2,500 data rows, and your email tool will only import 1,000 at a time. Enter 1000 and press Split file. You'll get three files: customers-part-001.csv and customers-part-002.csv with 1,000 rows each, and customers-part-003.csv with the remaining 500. Each of them starts with the same header row, so each one can be imported by itself without any further editing.
How quoted fields are handled
A simple approach would just cut the file at every line break, but that goes wrong if a cell contains a line break of its own. In a CSV file, such a cell is wrapped in double quotation marks. This tool reads the quotes properly, so a multi-line address or comment stays in one record instead of being broken in two.
| Cell content | How it's written in CSV |
|---|---|
| Plain text | hello |
| A comma | "Smith, Jo" |
| A quotation mark | "She said ""hi""" |
| A line break | "line one (new line) line two" |
Why split a CSV?
- Import limits: email and advertising tools often cap the number of rows.
- Spreadsheet performance: smaller files open faster.
- Email attachments: smaller parts can fit within size limits.
- Sharing work: give each person a portion of the list.
- Batch processing: run a script over a part at a time.
Choosing the number of rows
Start by finding the limit of the system that you're importing into, and choose a figure a little below that. If there's no limit, think about what's comfortable to open and review. Remember that the header row doesn't count toward the number that you enter, so a part with 1,000 data rows will have 1,001 lines in total. You can make up to 500 files in one go, so choose a larger number if you reach that limit.
When your file doesn't have a header
If the first row is real data, untick the header option, or that row will be repeated in every part. If you aren't sure, open the file in a text editor and look at the first line. Column names like email or price indicate a header. Numbers or names of real people indicate data.
Keeping your data safe
CSV exports often contain names, addresses and other personal details. This tool reads your file with your browser, and the parts are created on your own device. Nothing is sent to our server. Very large files need a lot of memory, so close other tabs if your browser becomes slow. Once you've finished, delete any copies that you no longer need.
Opening the parts in Excel
Each part is an ordinary CSV file that can be opened in Excel, Google Sheets or similar programs. Be aware that spreadsheets can change data when opening a CSV. For example, long numbers might be shown in scientific notation, and leading zeros can vanish. If that matters, import the file using the Text Import option, and set those columns as text.
Putting the files back together
If you need to combine the parts later, keep them in order and remove the repeated header rows.
Common mistakes
- Leaving the header option on for headerless data. The first row gets repeated.
- Opening and resaving parts carelessly. Spreadsheets can change values.
- Choosing a size that's over the limit. Check your target system first.
Related data tools
Convert the format with the CSV to JSON converter, go the other way with the JSON to CSV converter, and clean up text with the word counter.
What next
Use this often? Add CSV Split to your Home screen.
Frequently asked questions
How does the CSV splitter work?
It reads your file, keeps quoted fields together and writes a new file for each group of rows.
Is the header kept in each file?
Yes, if you tick the header option.
Can it handle commas and line breaks inside cells?
Yes, as long as those cells are properly quoted.
Is my file uploaded?
No. It's split in your browser.
How big can the file be?
Up to 100 MB, though very large files use a lot of memory.
Was this tool helpful?
What went wrong?
We only receive the reason you pick, never what you typed into the tool.
Thanks for your feedback.