Skip to main content

locacsv.comSplit a CSV by Rows or Target File Size

Split by rows or file size

Split a CSV by Rows or Target File Size

Split a CSV by a fixed number of data rows or a target file size. Review encoding and delimiter settings, then create up to 100 outputs from a 50 MiB file entirely in your browser.

How to useSpecifications & limits

CSV processing stays in your browser

Your files are not uploaded to a server.

File selection

Drop a CSV file here

or

1 CSV file, up to 50 MiB

Import settings

Change character encoding and header row settings

Auto-detection covers only UTF-8 and Shift_JIS. For CSV files from mainland China, Korea, Taiwan, or Western Europe, select the matching encoding manually.

How it works

Example: split a CSV by rows or target size

Choose the number of rows per file or a target size to save contiguous rows in their original order.

Before splitting

3 columns · 4 rows
Before splitting
IDDateQuantity
A-0012026-01-013
A-0022026-01-025
A-0032026-01-032
A-0042026-01-044

After splitting

2 columns · 2 rows
After splitting
Created fileData rows included
part_001.csvdata rows 1–2
part_002.csvdata rows 3–4
The left table shows the input, and the right table shows the output.

Rows are never cut in half. The original CSV stays unchanged, and the split CSV files are saved in one ZIP.

Your selected CSV is processed entirely in your browser and is never uploaded to a server.

Split a CSV by rows or target size

Split by a fixed data-row count or a target file size, then download the CSV files in a ZIP.

Features

  • Auto-detect UTF-8 or Shift_JIS input, or manually select ISO-8859-1, CP949, Big5, GB18030, or Windows-1252. Choose the output encoding separately from eight options, including UTF-8 with or without a BOM, for up to 100 files.
  • Preserve headers, separators, quotes, and line breaks inside cells. Before saving, confirm that every input row is either included in the output or excluded.

How it works

  1. Choose a CSV and confirm its encoding and header setting.
  2. Choose a method and set the data rows per file or target MiB.
  3. Run the split and download the CSV files and row report as a ZIP.

Before you start

  • Limits: one 50 MiB CSV and 100 outputs. Row mode excludes the header; size mode counts encoded bytes including the BOM and repeated header.
  • A non-UTF-8 output stops instead of replacing unsupported characters; choose UTF-8 when needed.
View FAQs for this tool

Use Split by value for one file per column value, or Merge vertically to recombine results.

Related guide