← All guides

How to Split a Large CSV File Without Excel

Quick answer: open the free CSV Splitter, drop in your file, choose how many rows you want per part, and click Split. Every part keeps the header row and downloads instantly. The file is processed in your browser, so nothing is uploaded and there is no size limit.

Why Excel fails on large CSV files

Excel has a hard limit of 1,048,576 rows per worksheet. Open a bigger CSV and Excel silently truncates the data, which is a common cause of broken reports and incomplete imports. Even below the limit, files with hundreds of thousands of rows make Excel slow, and saving from Excel can mangle encodings, dates and leading zeros.

Option 1: a browser-based splitter (easiest)

The fastest method that works on any operating system:

  1. Open the CSV Splitter.
  2. Drag your file into the drop zone. A preview confirms the file parsed correctly.
  3. Choose By number of rows and enter a value, for example 1000000 so every part opens in Excel, or 50000 for easy email/CRM imports.
  4. Click Split CSV and download the parts individually or as a ZIP.

Because the splitter streams the file inside your browser, a 500 MB file splits in seconds and your data never leaves your device, which matters for customer lists and financial exports.

Option 2: the command line

On macOS or Linux, split can divide a file by line count:

tail -n +2 big.csv | split -l 50000 - part_ --additional-suffix=.csv

The catch: this strips the header from all parts (the tail skips it), so you must re-add headers to each part yourself, and quoted fields containing newlines will be cut mid-record. It is fine for simple files, risky for real-world exports.

Option 3: a Python script

pandas.read_csv(..., chunksize=50000) lets you write each chunk to its own file with headers intact. This is the right choice when splitting is part of an automated pipeline, but for a one-off task, installing Python and writing a script is overkill.

Which should you use?

For a one-time split, the browser splitter is the fastest and safest: headers are preserved automatically, quoted multi-line fields are handled correctly, and there is nothing to install. Need to combine the parts again later? Use the CSV Merger.