Skip to content

Free toolsDocuments

Split CSV

The header repeated on every part, the parts numbered in one ZIP.

More free conversions, where you upload. The Fylane extension does the same work inside any upload form, on its own free share every day.About the extension

How to split CSV

  1. Drop the CSV.
  2. Type the rows per part.
  3. Press Split and download the ZIP.

What happens to your file

The CSV is read on Fylane’s servers with its delimiter and encoding detected, then written out as parts of the size you chose — each a clean UTF-8, comma-separated file with the header row first — named after the original with a number, and zipped together. Quoted fields, commas inside quotes and line breaks inside cells all survive.

Two hundred parts at most: a million rows at 10 a part is refused with the arithmetic, and a bigger part size fixes it.

Questions

Does the header count towards the rows?

No. 1 000 rows per part means 1 000 data rows plus the header line on each. A file without a header is split as it is.

Do this in code

curl -X POST https://api.fylane.dev/v1/jobs \
  -H "Authorization: Bearer $FYLANE_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "file_id": "<file id>",
    "operation": "csv.split",
    "options": {
      "rows": 1000
    }
  }'

The same operation, csv.split — A CSV cut into parts of so many rows, the header on each, numbered in a ZIP — 200 parts at most. Upload first with the quickstart; every option is on the operations page. 500 free credits a month, then $5 per thousand.