How to use the Merge or Split Files: CSV, JSON, Excel, Parquet
Combine many files into one, or split one file into many parts.
Merge or Split Files combines many CSV, JSON, Excel or Parquet files into one table, or cuts one big file into many parts. When merging, files are stacked one after another, with an optional source_file column. When splitting, you choose rows per file, a number of equal parts, or one file per value of a column, and download all parts as one ZIP in CSV, JSON, Excel or Parquet. It runs in your browser and nothing is uploaded.
Choose Merge or Split
Add your files and set the options
Download the result
Tips
Turn on source_file to see which file each row came from.
The header row is kept in every part when you split.
Very large files are limited by your computer memory.
Yes. You can mix CSV, JSON, Excel and Parquet files. They are read, stacked one after another and saved in the format you choose.
How can I split a file?
Choose rows per file, a number of equal parts, or one file per value of a column. You download all parts as one ZIP, in CSV, JSON, Excel or Parquet.
What if the files have different columns?
All columns are kept. Cells for a column that a file does not have are left empty, and the tool lists those columns so you can check.
Can I merge CSV and Parquet files together?
Yes. You can mix CSV, JSON, Excel and Parquet files. They are stacked in the order you add them and saved in the format you choose. Columns missing in some files are left empty.
How do I split a big CSV file?
Load the file, choose rows per file, a number of equal parts or one file per value of a column, and download the ZIP. The header is kept in every part. Up to 500 parts at a time.
Related pages
Combine Multiple CSV Files into One: Combine many CSV files into one file in your browser. Add a source_file column, mix in Excel or JSON files, and download CSV, Excel or Parquet. Free.
Merge Parquet Files into One: Merge several Parquet files into one Parquet, CSV or Excel file in your browser. No code and no upload. Free, with a source_file option.
Split a CSV File into Parts: Split a CSV into smaller files by number of rows, number of parts or the value of a column. Download them as one ZIP. Free, in your browser.
Split a Large CSV into Smaller Files: Split a large CSV into smaller files so Excel or an import tool can open them. Choose rows per file and download all parts as a ZIP. Free, no upload.
Split a Parquet File into Parts: Split a Parquet file into smaller Parquet, CSV or Excel files by rows, equal parts or a column value. Free, in your browser, nothing uploaded.