Column Split and Combine

Split or combine CSV and Excel columns with presets and a custom separator.

On-device No sign-up Free to use

Transform columns controls

Drop your table file here

or choose one from your device

One UTF-8 CSV or TSV file, or one XLSX workbook. A chosen file is used instead of the pasted text.

    ?

    Paste the rows to change, or leave this empty and choose a file. Values are kept exactly as they appear in the text.

    ?

    Only for a workbook. Leave empty to read the first visible worksheet, or name one, such as Sheet1, or give its 1-based number.

    ?

    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.

    What to do
    ?

    Without a names row, columns are addressed by their 1-based position such as 2.

    ?

    Its heading or its 1-based position. Used by the split mode.

    ?

    A value such as "Springfield, IL" splits at the comma into "Springfield" and "IL" without a leading space. A preset turns this on.

    ?

    At most 20 parts per row. In the split mode, anything beyond the last part stays in that part.

    ?

    When this is on, the new columns are placed next to the column that was split. Turn it off to replace that column.

    ?

    Headings or 1-based positions, in the order to join them, separated by commas. Used by the combine mode.

    ?

    Used by the combine mode.

    ?

    A row such as Ada,,Bristol joins as Ada Bristol instead of Ada Bristol.

    ?

    Turn this off to replace the joined columns with the single combined column.

    ?

    Formula-like cells receive an apostrophe prefix in the CSV download. This changes stored text; review the import in your spreadsheet.

    Advanced
    ?

    One character, used when the separator choice is Another character.

    ?

    Used by the fixed-width split. A width of 3 turns ABCDEF into ABC and DEF.

    Result

    Showing an example.

    Split a product code into its three parts while keeping the original column.

    The page reports three parts across two rows and lists the columns name, code, code_1, code_2 and code_3. The download holds the lines name,code,code_1,code_2,code_3 then Ana,EU-01-7,EU,01,7 and Lee,US-22-9,US,22,9.

    Loading the tool. Your result will appear here.

    https://usefreetools.net/column-split-combine · 20 November 2026

    Was this helpful?

    How to use Column Split and Combine

    1. 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.
    2. Choose Split one column or Combine columns, then identify the relevant columns by heading or 1-based position.
    3. 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.
    4. 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.
    5. 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.

    You add
    Pasted text name,code with the rows Ana,EU-01-7 and Lee,US-22-9. What to do: Split one column. Column to split: code. How to split: At a separator. Separator: Dash. Parts to keep: 3. Keep the original column: on.
    You get
    The page reports three parts across two rows and lists the columns name, code, code_1, code_2 and code_3. The download holds the lines name,code,code_1,code_2,code_3 then Ana,EU-01-7,EU,01,7 and Lee,US-22-9,US,22,9.

    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.

    Page updated · Project managed by Tony Hines · Report a problem with Column Split and Combine