CSV SPLITTER

Which Ways Can You Split a CSV?

• Rows per part: every part holds N rows, and the last holds what is left. Good for importers with a row limit.
• Equal files: the table is divided into N parts of nearly the same size. Good for sharing work between people.

Parts are named after the original file with a number, such as orders-part01.csv, orders-part02.csv, and so on, so they sort in order in any folder. Up to 10,000 parts can be made from one file.

Why Repeat the Header Row?

Most importers read the first line of a CSV as column names. If only the first part has a header, every other part will either fail to import or have its first data row treated as names. Repeating the header, which is on by default, makes every part a complete CSV on its own. Turn it off only when parts will be joined back together.

Before splitting, a quick pass with the CSV validator is worth the minute it takes. A header problem, such as an empty or repeated column name, would otherwise be copied into every one of the parts, and each importer would report the same error separately.

Can You Split Only Some of the Rows?

Yes. If a filter is active in Filter CSV, only the matching rows are split. That lets you take, for example, only one state's orders and cut them into parts. Sorting first with Sort CSV controls which rows land in which part.

The reverse job, stacking several CSV files back into one, is handled by 2join, the 2suite file merger. Splitting one column into several is a different tool, Split column.

What Else Can You Do With a CSV Here?

• CSV viewer: Open a CSV of any size, scroll every row, and see a profile of each column.
• Sort CSV: Sort rows by one or more columns, as text, numbers, or dates, ascending or descending.
• Filter CSV: Show only the rows that match an expression such as price > 10 AND state = "NY".
• CSV validator: Find ragged rows, broken quotes, bad headers, encoding problems, and values of the wrong type.
• Remove duplicates from CSV: Find and remove duplicate rows, comparing whole rows or only the columns you choose.
• Trim CSV whitespace: Trim leading and trailing spaces, collapse double spaces, and drop invisible characters and empty rows.
• Find and replace in CSV: Find text in one column or every column and replace it, with match case, whole cell, and regex options.
• Remove rows from CSV: Delete rows by number or range, the first or last rows, empty rows, or rows that match a rule.
• CSV editor: Edit cells, add or delete rows, and add, delete, rename, or move columns.
• Split CSV column: Split one column into several at a delimiter, such as a full name into first and last.
• Merge CSV columns: Join two or more columns into one with the separator you choose, skipping empty values.
• CSV column type converter: Convert a column to clean numbers, ISO dates, true/false, or upper, lower, or title case.
• CSV to JSON converter: Convert CSV to a JSON array of objects or arrays, or to JSON Lines, with typed values.
• JSON to CSV converter: Convert a JSON array or JSON Lines to CSV, flattening nested objects into dotted column names.
• CSV to SQL converter: Turn a CSV into SQL INSERT statements, with an optional CREATE TABLE, for PostgreSQL, MySQL, SQLite, or SQL Server.
• CSV to TSV converter: Convert a comma-separated file to tab-separated values that paste cleanly into spreadsheets.
• TSV to CSV converter: Convert a tab-separated file to a standard, properly quoted comma-separated CSV.

All eighteen tools are on the 2csv home page, and once a file is open you can switch between them without reloading it. Part of the 2suite.io privacy-first ecosystem.