CSV.ink
TSV Viewer

CSV Splitter

Split a large CSV file into smaller files by row count.

The header row is copied into every file.

Click to upload or drag and drop

.csv .tsv .txt

No file at hand?

How to split a CSV file online

  1. 1

    Set how many data rows each file should contain, for example 1000.

  2. 2

    Upload the CSV file. It is split right away in your browser.

  3. 3

    Pick a part from the list to preview it. Every part starts with the original header row.

  4. 4

    Download a single part, or click "Download all (ZIP)" to get every part in one archive.

Example: splitting a file into parts of 2 rows

employees.csv

id,name,city
1,Emma,Seattle
2,Liam,Austin
3,Olivia,Chicago

employees_1.csv and employees_2.csv

id,name,city
1,Emma,Seattle
2,Liam,Austin

id,name,city
3,Olivia,Chicago

Tips for splitting CSV files

Import limits

Many CRMs, email tools and databases limit how many rows one import can have. Set the row count to that limit and import the parts one by one.

Excel's row limit

Excel opens at most 1,048,576 rows. Split larger files into parts below that size to open them completely.

Line breaks inside cells

Quoted values that contain line breaks count as one row, so records are never cut in half.

Ordered file names

Parts are numbered with leading zeros, such as data_01.csv, so they sort in the right order.

CSV Splitter FAQ

Is the CSV splitter free?

Yes. It is free with no sign-up.

Is my file uploaded?

No. The file is split in your browser and never leaves your computer.

How large can the file be?

Files of several hundred megabytes usually work. The limit depends on the memory available in your browser.

Is the header row repeated?

Yes. Every part starts with the header row, so each file can be opened or imported on its own.

Does it work with semicolon or tab separated files?

Yes. The delimiter is detected automatically and kept in the output as standard comma-separated CSV.

All CSV Tools

CSV to JSON

Convert your CSV files to JSON format with ease.

JSON to CSV

Convert your JSON files to CSV format easily.

CSV to Excel

Convert CSV files to Excel format easily

Excel to CSV

Convert Excel spreadsheets to CSV format.

Excel to JSON

Convert Excel spreadsheets (XLSX, XLS) to JSON arrays.

JSON to Excel

Convert JSON data to an Excel (XLSX) spreadsheet.

CSV Splitter

Split a large CSV file into smaller files by row count.

Merge CSV

Combine multiple CSV files into one, matching columns by header.

XML to CSV

Convert XML files to CSV format efficiently.

CSV to XML

Convert CSV files to XML format efficiently.

CSV to YAML

Convert CSV rows to a YAML list.

YAML to CSV

Convert a YAML list to a CSV table.

CSV to Markdown

Convert CSV files to Markdown tables.

Markdown to CSV

Convert Markdown tables to CSV files.

CSV to HTML

Convert CSV files to HTML tables.

HTML Table to CSV

Extract tables from HTML and save them as CSV.

CSV to PDF

Convert CSV files to PDF documents.

CSV to SQL

Convert CSV files to SQL insert statements.

CSV to vCard

Convert CSV files to vCard format for contacts.

CSV to TSV

Convert comma-separated CSV to tab-separated TSV.

TSV to CSV

Convert your TSV files to CSV format easily.

TSV to Excel

Convert your TSV files to Excel format easily.