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 it for your exact data?
Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.
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.