Split Comma-Separated Values into Excel Columns

For comma-separated text already in worksheet cells, use Data → Text to Columns → Delimited → Comma. Choose an empty destination range, check the preview, and finish. Use TEXTSPLIT when you want a formula-based result; import the file instead if you are starting with a CSV.

For example, suppose cell A2 contains this sample record:

NB01,North,42

The intended result is three separate fields, with headers you add in row 1:

Record ID	Region	Count
NB01	North	42

Split existing cells with Text to Columns

These steps use Excel’s Convert Text to Columns Wizard on Windows, documented for Microsoft 365 and Excel 2024, 2021, 2019 and 2016. Microsoft’s instructions describe the selection, delimiter, preview and destination controls.

1. Keep a copy of the original column. Make sure the destination has enough empty columns for every field.
2. Select the cells containing the records—for example, A2:A100, without the header.
3. Select Data → Text to Columns.
4. Choose Delimited, then Next. A delimiter is the character separating fields.
5. Select Comma and clear other delimiter choices. Do not select Space just because some entries contain spaces: that could split a region such as North Coast into two fields. If fields are enclosed in double quotes, select the double quote (") as the Text qualifier.
6. Leave Treat consecutive delimiters as one unchecked when adjacent commas represent missing fields. For example, NB02,,17 should keep its empty middle field.
7. Check the preview, then select Next. Select each identifier column in the preview and set its format to Text if it contains values such as 00123; select an explicit date format for date fields when needed.
8. Set Destination to an empty starting cell, such as B2, then select Finish. Add descriptive headers above the resulting columns.

Microsoft’s Text Import Wizard documentation explains the delimiter, text-qualifier and column-format options. Check identifiers before conversion—not after zeros have disappeared.

Use TEXTSPLIT for a result that follows the source

In Excel for Microsoft 365 or Excel 2024, including the Mac editions, enter this formula in B2:

=TEXTSPLIT(A2,",")

For the sample above, the result spills across B2:D2: one formula fills several adjacent cells. Copy the formula down for additional source rows. Microsoft documents the supported editions and delimiter arguments in its TEXTSPLIT reference.

By default, TEXTSPLIT retains empty positions between consecutive delimiters. Keep that default for fixed fields: ignoring an empty region could shift the count into the region column.

Put the formula in an ordinary worksheet range outside an Excel Table, with empty, unmerged cells to its right. If you see #SPILL!, check for obstructing content or merged cells; spilled formulas are not supported inside Excel Tables. Microsoft’s spill-error guidance explains these restrictions.

Do not use a simple comma split to parse quoted CSV records. In this sample:

NB03,"North, Coastal",42

North, Coastal is one field. TEXTSPLIT(A2,",") splits on that embedded comma too. Import the original CSV file instead. For a single-line record already in a cell, use the wizard with a double-quote text qualifier and verify the preview.

Import a CSV file instead of splitting pasted text

If a .csv file opens entirely in column A, return to the original file and import it with the intended delimiter. In Excel for Windows with Get & Transform:

1. Select Data → From Text/CSV and choose the file.
2. Set Delimiter to Comma and inspect the preview. If the source actually uses semicolons or tabs, choose that separator instead.
3. For identifiers with leading zeros, turn off automatic data-type detection so columns initially remain Text. Select Transform Data to review types and convert only genuine measurements or dates.
4. After reviewing the table in the Power Query Editor, use Home → Close & Load to return the result to Excel. If no transformations are needed, select Load directly from the import preview.

Microsoft documents Excel’s Text/CSV import route and the connector’s delimiter, type-detection and load options.

Check the columns before publishing

Compare the output with the originals: row count, field positions, leading zeros, quoted commas and dates. Confirm that measurement columns such as Count are numeric before calculating totals. Unexpected extra columns deserve investigation, not deletion; for inconsistent separators or missing fields, use the broader column-splitting validation workflow.

Give each column a meaningful header and remove sensitive information from the release copy. Never upload sensitive data to a public dataset page. Export only the reviewed table and re-import it to verify the saved values. Follow the CSV export checklist for that final handoff.