How to use Column Split and Combine
- Paste CSV or TSV, or choose a CSV, TSV or XLSX file. For a workbook, select its worksheet by name or number; check the header and delimiter settings.
- Choose Split one column or Combine columns, then identify the relevant columns by heading or 1-based position.
- For splitting, choose a separator or fixed-width slices and a part limit. Name and address presets apply literal split rules; check that those rules fit your data.
- For combining, choose the text between joined values, whether to skip empty cells and the new column name. Decide whether to retain the source columns.
- Transform the columns and review the preview. Download the new CSV, checking any spreadsheet-formula prefixes before importing elsewhere.
Example: Column Split and Combine
Split a product code into its three parts while keeping the original column.
Options
- CSV or TSV text
- Paste the rows to change, or leave this empty and choose a file. Values are kept exactly as they appear in the text.
- Worksheet name or number
- Choose the worksheet used for column transformation. An empty choice uses the first visible sheet; otherwise enter its name or 1-based position.
- Preset
- A preset sets the mode, the separator and friendly new column names. Pick the column to split underneath, and the other split settings are taken from the preset.
- The first row holds the column names
- For column transformation, enable this when the first record names the columns. Without headings, refer to columns by their 1-based positions.
- Column to split
- Its heading or its 1-based position. Used by the split mode.
- Another separator character
- One character, used when the separator choice is Another character.
- Characters per slice
- Used by the fixed-width split. A width of 3 turns ABCDEF into ABC and DEF.
- Trim spaces around each part
- A value such as "Springfield, IL" splits at the comma into "Springfield" and "IL" without a leading space. A preset turns this on.
- Parts to keep
- At most 20 parts per row. In the split mode, anything beyond the last part stays in that part.
- Keep the original column
- When this is on, the new columns are placed next to the column that was split. Turn it off to replace that column.
Supported inputs and limits
- CSV/TSV/XLSX input uses the chosen file instead of pasted text.
- Up to 20 MiB, 100,000 data rows, 500 columns and 2,000,000 cells.
- Split into at most 20 parts, preserving excess text in the last part.
- Name/address presets are literal separator rules, without linguistic or address validation.
- Output is CSV; formula protection prefixes risky strings and changes those stored values.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
What the new column names are built from
Each part is named after the column it came from and its position, such as code_1 and code_2. Those names are checked against every other column in the result before the table is written, and a clash is resolved with a number suffix you can see in the report.
Questions about Column Split and Combine
What happens to a value with more parts than I allowed?
In a separator split, everything after the last allowed separator stays in that last part. In a fixed-width split, the last slice keeps the whole remainder of the value.
Why did a split column come out as code_1_2?
The table already had a column called code_1, so the new name took the next free number rather than creating two columns with the same heading. Every renamed column is listed under the preview.
Can I keep the column I split?
Yes. Keep the original column is on by default, and the new parts are placed directly after it. Turn it off to replace that column with the parts.
Is my file uploaded?
No. The file is read in this browser, the new table is built there, and the download comes from that data on your device.