Split Text or CSV Files
Split large text or CSV files by number of rows, file size, or repeating header.
Splitting large text or CSV files is a common requirement when working with data that exceeds import limits, transfer size constraints, or memory capacity. This tool splits files by row count, file size, or repeating header pattern. Split by row count divides the file into chunks of a specified number of rows (e.g., 1000 rows per file). Split by file size creates chunks that do not exceed a target size in MB or KB. Split by repeating header preserves the column header at the top of each output chunk, which is essential for CSV files that need to be imported as separate files. The tool processes files entirely in your browser, streaming the input through a Web Worker to handle files up to 100 MB. Output chunks are available for individual download or batch download as a ZIP archive. This is useful for chunking large CSV exports for database imports, splitting log files for analysis, or dividing datasets for parallel processing.
How to use the Split Files tool
- Load your file: Drag and drop your text or CSV file, choose a file from your file explorer, or paste content directly into the paste area.
- Choose split method: Select how to split: by number of rows, by number of equal parts, or by approximate file size.
- Set split parameters: Enter the value for your chosen split method (e.g., 100 rows per file, 5 parts, or 50000 bytes).
- Configure header option: Toggle whether to keep or prepend the header row in each split file (for CSVs).
- Split and download: Click the "Split File" button. Each split file is listed with its name and size for individual download.