Splitting a Large CSV by Number of Rows
Key points
- Choose the CSV
- Choose "Split" and the rows
- Save the ZIP
In Merge and Split CSV Files, the header is added to each file.
Steps
- Choose the CSV to split
- Choose "Split by number of rows" and enter the rows per file
- Tap "Run and save" and open the ZIP
An Excel sheet holds about 1,048,576 rows at most.
Use "Merge, Split and Pick Columns from CSV" (free)
Tools that go well with this
- Convert CSV and JSON: Convert between CSV and JSON instantly.
- Convert CSV to Excel (.xlsx): Convert a CSV to an Excel (.xlsx) file.
- Convert Text Encoding (Fix Garbled Text): Convert text files between Shift_JIS, UTF-8, EUC-JP and more to fix garbled text.