Fidument Tools · Beta version

How do I split a CSV into files by row count?

Set the rows per file and download numbered CSV parts with headers in one ZIP.

How do I split a CSV into files by row count?

How to use this tool

  1. Choose a CSV file

    Open a UTF-8 CSV. Check the input delimiter and choose the output delimiter.

  2. Set rows per file

    Enter between 1 and 20,000 data rows per file. Each part includes the header outside that limit.

  3. Download and unzip

    Select Split file, check the number of parts, and download the ZIP. Row order is preserved, and multiline fields stay in the same record.

How do I stay within the part limit?

If the ZIP would contain more than 100 files, increase the rows per part. For 20,000 rows, choose at least 200 rows per file.

Who is it for?

  • People working with CSV exports and spreadsheets

Input

  • CSV UTF-8

Output

  • ZIP (CSV)

Capabilities

  • Open a UTF-8 CSV. Check the input delimiter and choose the output delimiter.
  • Enter between 1 and 20,000 data rows per file. Each part includes the header outside that limit.
  • Select Split file, check the number of parts, and download the ZIP. Row order is preserved, and multiline fields stay in the same record.

Limitations

  • UTF-8 CSV with unique headers up to 2 MiB, 20,000 rows and 100 columns. Up to 100 parts. The total size of the parts and the ZIP each have an 8 MiB limit.
  • Formula-like fields may receive an apostrophe.

Example use

Splitting 2,500 data rows at 1,000 per file yields parts of 1,000, 1,000, and 500 rows.

Questions and answers

Where is my file processed?

Your browser processes the file on your device.

Related tools

Merge CSV files

Merge CSV files in your browser. Match columns by header name and choose file order.

Filter CSV

Set conditions on selected CSV columns and download matching rows. The browser processes your file.

Split CSV by rows

Check access and export conditions in the app. A product description does not grant access.