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.
Quick answer: Combine many files into one, or split one file into many parts.
Related: Merge or Split Files: CSV, JSON, Excel, Parquet · Combine Multiple CSV Files into One · Merge Parquet Files into One · Split a Large CSV into Smaller Files · CSV Guides and Free CSV Tools
How to use the Split a CSV File into Parts 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. Example Input: orders.csv (100,000 rows)
Output: 10 files of 10,000 rows
Browse by topic Who uses Data Utility Frequently asked questions · Data format benchmark
Frequently asked questions How do I split a CSV by rows? Load the file, choose Rows per file, type a number such as 10,000, and download the ZIP of parts. The header row is kept in every part.
Can I split by a column? Yes. Choose Value of a column, for example country, and you get one file per value.
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 Merge or Split Files: CSV, JSON, Excel, Parquet : Combine many CSV, JSON, Excel or Parquet files into one, or split one big file into many parts. Free, and your files stay in your browser.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 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.Topic guides Guides More free tools JSON, CSV, Parquet and Excel Converter JSON to CSV Converter CSV to JSON Converter CSV to Parquet Converter JSON to Parquet Converter Parquet to CSV Converter Parquet to JSON Converter CSV to Excel Converter JSON to Excel Converter Excel to CSV Converter Excel to JSON Converter Data Formatter: JSON, CSV, XML and YAML JSON Formatter and Validator CSV Formatter and Cleaner XML Formatter and Validator YAML Formatter and Validator JSON Validator Online JSON Minifier XML Validator Online YAML to JSON Converter Remove Duplicates from CSV CSV to SQL Converter Excel to SQL Converter Mask Emails in a CSV File Compare Two CSV Files CSV Data Quality Checker JSON Beautifier XML Beautifier YAML Validator Online CSV Delimiter Converter Compare Two Excel Files CSV Diff Tool JSON to SQL Converter SQL INSERT Statement Generator Anonymize CSV Data Mask PII in Excel Files Fake Data Generator CSV Data Profiler Gzip Compress Files Online Open .gz Files Online (Gunzip) Image to Excel Converter (OCR) Image to CSV Converter (OCR) Chat with Your CSV File Chat with Your Excel File Generate Data from CREATE TABLE JSON Schema Data Generator File Compressor: Gzip JSON, CSV, XML, YAML, Parquet Screenshot to Table Converter (OCR) SQL INSERT Generator from CSV, JSON, Excel or Parquet Schema-Based Data Generator (JSON Schema) Mock Data Generator Data Profiler Data Comparison (CSV and Excel Diff) Chat with Your Data Data Dictionary Generator Dataset README Generator Data Lineage: See Which Tool Changed Your File API Response to Table: JSON API to CSV JSON API Response to CSV Document Database Columns with AI Generate SQL Column Comments README for a CSV Dataset Dataset Documentation Generator Change Date Format in a CSV File Convert Excel Date Numbers to Dates File Size Calculator: CSV, JSON, Excel, Parquet Merge or Split Files: CSV, JSON, Excel, Parquet Combine Multiple CSV Files into One Merge Parquet Files into One Split a CSV File into Parts Split a Large CSV into Smaller Files Split a Parquet File into Parts Text to Table: Paste Text, Get a Table Paste Text into a Table for Excel Convert Text to CSV Markdown Table to CSV Copy a PDF Table into Excel Screenshot to CSV Screenshot to Excel Picture to Excel Photo of a Table to Data JPG to Excel PNG to CSV OCR Table to Excel Convert Many Images to Excel Batch Screenshot to CSV Synthetic Data Generator: Realistic Data From Your File Generate Synthetic Data from a CSV Privacy-Safe Test Data from Real Data Synthetic Dataset from an Excel File Data Transformation: Join, Trim, Concatenate Join Two CSV Files on a Key Merge CSV Files by a Common Column VLOOKUP Alternative for CSV and Excel Files Join Two Excel Files on a Key Column Concatenate Columns in a CSV File Trim Spaces in a CSV File Split a CSV Column into Two or More Filter CSV Rows Online Combine First and Last Name Columns Data Lineage Tool: Track Every Change to a File Track Changes Made to a Data File Data Masking and Anonymization About Data Utility: Free Online Data Tools Privacy Policy Blog & Guides How to Convert JSON, CSV, Parquet and Excel Files Online How to Convert JSON to CSV Online (Free, No Upload) How to Convert CSV to JSON Online (Free, No Upload) How to Convert CSV to Parquet Online (Free, No Upload) How to Convert JSON to Parquet Online (Free, No Upload) How to Convert Parquet to CSV Online (Free, No Upload) How to Convert Parquet to JSON Online (Free, No Upload) How to Convert CSV to Excel Online (Free, No Upload) How to Convert JSON to Excel Online (Free, No Upload) How to Convert Excel to CSV Online (Free, No Upload) How to Convert Excel to JSON Online (Free, No Upload) Data Formatter: Fix and Format JSON, CSV, XML and YAML JSON Formatter and Validator: Fix Broken JSON Online How to Clean a CSV File Online: Remove Duplicates and Empty Rows XML Formatter and Validator: Beautify and Check XML YAML Formatter and Validator: Check and Fix YAML Screenshot to Table: Image to Excel, CSV or Parquet (OCR) SQL INSERT Generator: Turn CSV, Excel or Parquet into SQL Free Mock Data Generator: Create Fake Test Data (CSV, JSON, Excel) Data Profiler: Check Data Quality Before You Use It Compare Two CSV or Excel Files: Find Added, Removed and Changed Rows Data Masking: Hide Emails, Phones and Names Before Sharing Chat with Your Data: CSV, Excel, JSON and Parquet (Free AI) Data Dictionary Generator: CREATE TABLE with AI Descriptions Dataset README Generator: Explain Your Data with AI Password-Protected Data Reports: Share a Locked HTML File How to Compress JSON, CSV, XML, YAML and Parquet Files Generate Test Data from a CREATE TABLE (500k Rows) CSV vs JSON vs Parquet vs Excel: Which to Use How to Open a Parquet File (3 Easy Ways) Data Lineage: See Which Tool Changed Your File Data Transformation: Join, Trim and Concatenate Files Online VLOOKUP Alternative: Join Two CSV or Excel Files Online How to Concatenate Columns in a CSV (First and Last Name) How to Turn an API Response into a CSV (With a Bearer Token) How to Flatten Nested JSON From an API Into Columns CSV vs Parquet: File Size Test With 100,000 Rows Convert CSV to Parquet: pandas, DuckDB or Your Browser What Is Parquet? The Columnar File Format Explained CSV to JSON, Excel or Parquet: Size and Speed Test How Much Does Gzip Shrink CSV, JSON, Parquet and Excel? How to Fix Mixed Date Formats in a CSV (With Examples) Turn a Public API into a Table: A Worked Example CSV vs JSON: Which One Should You Use? JSON vs Parquet: Which Format Should You Choose? Excel vs CSV: Which Should You Use for Data? VLOOKUP vs Join: Which Is Better for Combining Files? How to Merge Many CSV Files into One File How to Split a Large CSV File into Smaller Files How to Copy a Table from a PDF or Web Page into Excel Synthetic Data vs Random Fake Data: What Is the Difference? How to Generate Synthetic Data From a CSV, Step by Step How to Convert Many Screenshots to Excel or CSV at Once Reuse an Edited File in Another Tool: Recent Files Test Data Without Using Production Data Data Format Benchmark: CSV, JSON, Excel and Parquet Parquet Guides and Free Parquet Tools CSV Guides and Free CSV Tools JSON Guides and Free JSON Tools Excel Guides and Free Excel Tools Data Privacy Guides and Free Tools Test Data Guides and Free Generators Data Cleaning Guides and Free Tools AI Data Tools and Guides Extract Data from Screenshots and APIs File Format Guides and Free Tools Free Data Tools for Marketing Lists Free Data Tools for Finance and Accounting Exports Free Data Tools for Developers Free Data Tools for Data Analysts Free Data Tools for Small Business Frequently Asked Questions