SPLIT COLUMN

Which Delimiters Can You Split On?

• Space, comma, semicolon, dash, pipe, @, or slash.
• Any other text you type, such as a double colon or a word.

The new columns are named after the original, such as name_1 and name_2, and they appear next to it. You can keep the original column for reference or drop it once the split looks right. Trim parts removes the spaces left around each piece, which matters when the delimiter is a comma followed by a space.

How Many Columns Does a Split Make?

Choose as many as needed, and the tool makes enough columns for the value with the most parts, up to 50. Choose a fixed number when you want exactly that many columns. With a fixed number the last part keeps the remainder, so splitting Mary Ann Smith into two parts at a space gives Mary and Ann Smith, and nothing is lost.

What If You Need to Undo or Reverse a Split?

Undo restores the table for the last five changes. To put split values back together, or to join any columns into one, use Merge columns, which picks columns in order and joins them with a separator you choose. If a split column holds dates or numbers, the column type converter can clean them afterwards.

Splitting works on a single column within one file. It does not split a file into several files; for that, the CSV splitter cuts a large table into parts with the header repeated in each.

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.
• 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.
• CSV splitter: Split a large CSV into smaller files of a set number of rows, with the header repeated in each.

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.