Home › Spreadsheets & Data › Split CSV
✂️

Split CSV

Cut a large CSV into files of N rows each.

✓ Free✓ No watermark
Advertisement
  1. 1Upload
  2. 2Settings
  3. 3Download

How to use Split CSV

Add your file (or type your content) using the box above.
Adjust the options if you want something different from the defaults.
Click the button, then download your result.

About Split CSV

Very large CSV files are slow to open and many import tools refuse anything over a row or size limit. This free tool cuts a CSV into several smaller files with the number of data rows you choose, in your browser.

The header row is repeated at the top of every part, so each file can be opened and imported on its own. Parts are named after your file with _part001, _part002 and so on, and you can download them all as one ZIP. The default is 1,000 rows per file, and a split that would produce more than 500 files is refused with a suggestion to use a larger number.

How it works: the tool divides a large CSV into several smaller files, repeating the header row in each so that every part can be opened and imported on its own. Quoted cells with line breaks are handled so rows are not cut in half.

Step by step: 1) add the CSV; 2) choose how to split, for example by number of rows per file; 3) run it; 4) download the parts. Open a part to check that the header and last row look right.

Realistic limits: older spreadsheet programs open only about a million rows, and many web importers limit rows or megabytes per upload, which is the usual reason to split. The tool does not sort or deduplicate, so each part simply follows the original order. Very large files depend on browser memory.

Typical uses: loading an export into a system with an upload cap, sharing a customer list among several people, or opening a dataset that is too big for your spreadsheet.

Choosing sizes: many online importers accept between 1,000 and 100,000 rows or a certain number of megabytes, so check the limit and choose a safe value below it. If you plan to share parts with several people, pick a row count that gives each person a similar amount of work. Because the header is repeated, every part is self-contained and can be opened without the others.

After splitting: open the first and last parts and compare their row numbers with the original. Total rows across the parts, minus the repeated headers, should equal the original data rows. Keep file names consistent with a numeric suffix so the parts sort in order, which makes reassembling with a merge step straightforward.

Tips for better results

  • Choose the row count from the limit of the system you are importing into, for example 5,000 or 10,000 rows.
  • The file needs a header and at least one data row.
  • To put the parts back together later, use CSV merge.
  • Pick a row count comfortably below your target system limit.
  • Combine the parts again with CSV Merge when needed.
  • Keep the original file as a master copy.