Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to parse a CSV string inside a single cell in Excel and Google Sheets
Topic:Text manipulationHeads up: Excel and Google Sheets do this differently.
Excel
=TEXTSPLIT(A2, ",")Google Sheets
=SPLIT(A2, ",")Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Place the CSV string in A2, e.g. apple,banana,cherry,date.
- 2In Excel 365: enter =TEXTSPLIT(A2, ",") in B2 — values spill horizontally across B2, C2, D2, E2.
- 3In Google Sheets: enter =SPLIT(A2, ",") in B2 — same horizontal spill behavior.
- 4To spill values vertically instead, in Excel use =TEXTSPLIT(A2, , ",") (col_delimiter blank, row_delimiter is the comma); in Sheets use =TRANSPOSE(SPLIT(A2, ",")).
- 5To trim surrounding whitespace from each value, wrap with TRIM: =TRIM(TEXTSPLIT(A2, ",")) in Excel — TRIM applies to the whole array automatically.
Tips
- TEXTSPLIT is only available in Excel 365 and Excel 2024+. In older Excel, use Data → Text to Columns (one-time, not dynamic) or a formula with TRIM/MID/FIND.
- SPLIT in Sheets treats each character in the delimiter string as a separate delimiter by default. Use SPLIT(A2, ",", TRUE, TRUE) with the third argument FALSE to treat the whole delimiter as one unit.
- If values themselves may contain commas (quoted CSV like "Smith, John"), TEXTSPLIT supports a quote character argument: =TEXTSPLIT(A2, ",", , , , "\"").
Need the Google Sheets version instead? Open Sheets variant in workspace →
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
How do I handle a CSV string with a variable number of values?
Both TEXTSPLIT and SPLIT handle variable-length strings automatically — the spill region expands to however many values exist. No need to pre-count.
Can I TEXTSPLIT a range of cells at once?
Yes in Excel: =TEXTSPLIT(TEXTJOIN("|", TRUE, A2:A5), ",", "|") combines all rows first, then splits on commas, using | as the row delimiter. In Sheets, wrap SPLIT in ARRAYFORMULA for a row-at-a-time split.
What if my CSV uses semicolons instead of commas?
Just change the delimiter argument: =TEXTSPLIT(A2, ";") or =SPLIT(A2, ";"). Both functions accept any string as the delimiter.
More on Text manipulation
See all →How-to
How to split text into columns
Split a full name or any delimited text into separate columns. Google Sheets uses SPLIT; Excel uses TEXTSPLIT — here is each.
How-toHow to remove extra spaces
Clean leading, trailing, and double spaces with TRIM — the usual fix for lookups that fail on values that look identical.
How-toHow to convert text to a number
Turn numbers stored as text into real numbers with VALUE or by multiplying by 1 — the fix for sums that ignore values.
How-toHow to extract the domain from an email address
Pull everything after the @ from an email using FIND and MID. Works the same in Excel and Google Sheets.
How-toHow to extract the first name from a full name
Get the first name from a full name with LEFT and FIND, splitting on the first space. Works in Excel and Google Sheets.
How-toHow to add leading zeros
Pad numbers to a fixed width with leading zeros using TEXT, or a custom number format. Works in Excel and Google Sheets.