Skip to content

CSV Splitter

Split CSV files by size or row count. Keep related rows together, repeat headers and download every part as a ZIP — privately in your browser.

UTF-8 CSV · Up to 25 MB and 200,000 data rows · Files stay on your device

1 MB = 1,000,000 bytes. Size includes headers and any UTF-8 BOM. Grouping matches exact cell values and brings matching rows together in first-seen group order. Blank group values are rejected. Cell values stay unchanged; CSV quoting and line endings are normalized.

Your data is processed locally in your browser whenever supported and is not uploaded to our servers.

Split large CSV files without losing related rows

Prepare smaller files for imports, spreadsheet workflows or sharing. Use row limits for predictable batches, or byte limits when your destination restricts file size. Optional column grouping keeps related records together.

01

Choose a UTF-8 CSV

02

Set a limit and optional group column

03

Download all parts as a ZIP

For product imports, check the current Shopify CSV import requirements.

CSV splitting questions

How do I split a CSV into smaller files?

Choose your UTF-8 CSV, set a maximum file size or data-row count, and select Split CSV. Download the resulting files together as a ZIP. When enabled, the first row is repeated as a header in every part.

Can I keep product variants together?

Yes. Enter the column number containing the product identifier, such as the Handle column in a Shopify product export. Matching values are kept in the same output file, even when they were separated in the source. Groups follow their first appearance; rows within each group retain their order. This may change the overall row order. Empty group identifiers must be filled before grouping.

What if a group is larger than the limit?

The tool stops with an explanation. It does not silently break a protected group or create an oversized part. Increase the limit or disable grouping. Disabling grouping may be unsuitable for product imports.

Can this prepare a Shopify CSV?

It can split an existing product CSV while keeping rows with the same Handle together. The default 14 MB target leaves room below Shopify's documented 15 MB product CSV limit. This tool does not validate Shopify fields or guarantee an import. Keep your original file and test a small import first.

Does this change my data?

Cell values, leading zeros and formulas are preserved as text in the CSV. Quoting and record endings are normalized to valid CSV with CRLF endings. Empty physical lines are skipped; a UTF-8 BOM is preserved if present. The detected or selected delimiter is used in every output. This is a splitter, not an encoding or formula-safety converter.

What are the limits?

Input must be valid UTF-8, up to 25 MB and 200,000 data rows. Output is limited to 500 files and 60 MB in total. Processing stops after 30 seconds; try a smaller input or larger part size. A maximum row count excludes the repeated header; byte limits include it.

Are my files uploaded?

No. Parsing, grouping and ZIP creation run in a worker inside your browser. The tool does not upload your CSV or save it in browser storage. Changing a setting clears the previous download.

Keep working