How to Split Text Into Columns in Google Sheets Easily

To split text in Google Sheets, select the cells, choose Data > Split text to columns, then pick the separator that appears in the data, such as a comma or space. Sheets places each piece in a separate column. Make room to the right first, because the results can replace existing cell contents. This guide covers the built-in tool, common delimiter problems, and what to use if by “split sheet” you mean dividing the view or organizing a spreadsheet.

What You’ll Need

A Google account and a spreadsheet open in Google Sheets in a web browser.
A column or range containing text with a consistent separator, such as commas, semicolons, spaces, or a character like a vertical bar.
Enough empty columns to the right of the selected cells for the split results. If your source contains several pieces, allow for the maximum number you expect.

You do not need to install an add-on for a basic split. If the source data matters, make a copy of the sheet or duplicate the source column before changing it. That gives you a simple way to compare the original values with the separated results.

Step-by-Step

Check how the text is separated. Look at several rows before splitting. For example, entries such as “Mina Lee,Seattle,WA” use commas, while “Mina Lee | Seattle | WA” use vertical bars. Confirm that the separator is consistent. If commas also occur inside names or descriptions, a comma may split those values in the wrong place.
Make room for the output. Identify the source column and inspect the cells immediately to its right. The split results expand horizontally from the selected cells, so make sure those destination cells do not contain information you need. Insert blank columns if necessary: right-click a column letter and choose Insert 1 column left or Insert 1 column right, as appropriate. You can also copy the source column to an empty area or a new sheet first.
Select the cells to split. Click the first cell in the data, then drag down to select the relevant range. To split a whole column, click its letter at the top. Selecting just the populated range is often safer when the sheet has other content or formatting below the data. Include the header only if you want it split by the same rule.
Open the split tool. In the Google Sheets menu bar, choose Data > Split text to columns. A small separator control appears near the selected range, generally along its lower edge. If you do not see the control, check that a range containing text is selected and that you are editing the spreadsheet, rather than viewing a read-only copy.
Choose the separator. Use the control’s separator menu to select the character between the pieces of text. Choose Comma for comma-separated values, Semicolon for semicolon-separated values, or Space for values separated by spaces. If the separator is another character, choose Custom and enter that character. For instance, for “Mina Lee | Seattle | WA,” select or enter the vertical bar. The preview should show the intended divisions.
Review the results before moving on. Check a few rows, including the longest and messiest examples. With “Mina Lee,Seattle,WA” and a comma separator, the expected columns are “Mina Lee,” “Seattle,” and “WA.” If one value has landed in two columns or stayed joined to another value, stop and change the separator before editing the results further.
Clean up and label the new columns. Add useful headings above the separated fields, such as Name, City, and State. Check for leading or trailing spaces, empty pieces, and unexpected extra columns. If your original column is no longer needed, keep it until you have confirmed the split is correct; then remove it only if doing so suits your workflow.
Save a reusable version if appropriate. Google Sheets saves changes automatically. If the split is part of a repeatable import process, keep an untouched copy of the incoming data and perform the split on a working copy. That makes it easier to repeat the steps next time and gives you a reference if the source format changes.

The separator is the key decision. A comma-delimited row such as “Ravi Shah,Support,North” can be split into three fields with Comma. A full name such as “Ravi Shah” should not be split on spaces if you want the name to remain together. In that case, look for a different separator in the source, or use a more carefully prepared data format. The split tool follows the character you choose; it cannot tell which spaces or punctuation are meaningful.

Common Mistakes

Splitting on a character that appears inside the data. If a notes field contains commas, choosing comma may produce more columns than expected. Inspect representative rows first and use a delimiter that marks the boundary between fields but does not appear within them.
Overlooking occupied cells to the right. Splitting expands the selected data across neighboring columns. Existing values in the output area may be replaced. Insert empty columns or move the work to a blank area before using the command.
Selecting a whole column without checking the sheet. A full-column selection can be convenient, but it may include unrelated content or make it harder to spot where the real data ends. Select only the data range when the column includes notes, totals, or other material below the list.
Using Space for multiword values. Space is a valid separator, but it divides every space-separated piece. Splitting “Jordan Kim” by space produces separate first- and last-name values, which may be useful for names but is not suitable when a field such as a street address or product title must stay intact.
Assuming every row has the same structure. Some rows may have missing fields, extra separators, or a different format. A split can leave blank cells or create additional columns for those rows. Review exceptions before using the output for reports, sorting, or importing elsewhere.
Confusing a split with a permanent source connection. The menu command separates the text currently in the selected cells. Do not assume the new columns will automatically update in the same way as a live formula when you later edit the original values. Keep a clean source and repeat the operation if new data arrives.

Tips

Use a distinctive delimiter when you control the source. A character such as a vertical bar or tilde is less likely than a space or comma to occur naturally in names and descriptions. Consistent delimiters make later imports much easier to split.
Test on a few copied rows. If you are not certain which separator to choose, copy a handful of representative rows to an empty area and try the operation there. Include a typical row, a long row, and any known exceptions. Once the output looks right, apply the same choice to the full range.
Keep the raw data intact. For recurring work, use one tab for the original import and another for cleaned data. Name the tabs clearly, for example Raw Import and Split Results. This prevents accidental loss of the original and helps another person understand the process.
Choose the right tool for the job. If you mean dividing text inside a cell, use Data > Split text to columns. If you mean keeping row or column headings visible while scrolling, use View > Freeze instead; freezing does not split the contents into separate cells. If you mean separating one spreadsheet into multiple tabs or files, move or copy the relevant data rather than using the text-splitting command.
Do not treat a line break as an ordinary space. Copied text may include line breaks or unusual whitespace that is hard to see. If a normal space separator does not produce the expected result, inspect the source or replace its inconsistent separators before splitting.

Troubleshooting

The menu command is unavailable or does not appear to work. Confirm that you have selected cells containing text and that you have permission to edit the file. If the file is in view-only mode, request edit access or make an editable copy if permitted. In a browser, reload the spreadsheet if the toolbar or menu is unresponsive, then select the cells again.

Everything remains in one column. The selected separator may not match the character in the data. Open the separator control and try the exact character used between fields. A comma, semicolon, slash, dash, and vertical bar are different separators. Check whether there are spaces around the punctuation; splitting on comma may leave a leading space at the start of the next value.

The output has too many columns. The chosen separator may also appear within a field, or the source may contain inconsistent punctuation. Undo immediately with Edit > Undo or Ctrl+Z on Windows and ChromeOS (Command+Z on Mac), then inspect the original and test another separator on a copy. If the delimiter is reused inside values, the text may need to be cleaned or quoted consistently before it can be separated reliably.

Some rows split correctly and others do not. Compare a working row with an incorrect one character by character. Look for missing separators, double spaces, different punctuation, or extra fields. You may need to standardize the source first or handle exceptional rows separately. Avoid forcing one split rule across rows that follow different patterns.

Values to the right disappeared or changed. Use Undo as soon as you notice the problem. If additional edits have already been made, restore the data from a version history or an earlier copy rather than guessing at the original values. Before repeating the split, insert enough blank columns or work in an empty area.

The result has unwanted spaces or blank fields. Check whether there are repeated separators or spaces immediately before or after the delimiter. For example, “Ravi, Support” has a space after the comma. The split may retain that space in the next cell. You can clean the affected values manually for a small range, or standardize the source text before splitting a large dataset.

Frequently Asked Questions

Can I split one cell into multiple columns in Google Sheets?
Yes. Select the cell or range, choose Data > Split text to columns, and choose the character that separates the pieces. The output fills neighboring columns, so check that they are empty first.

Can Google Sheets split text automatically at commas?
Yes. Select the relevant cells, open Data > Split text to columns, and set the separator to Comma. If the separator menu offers automatic detection, review the preview rather than assuming it has identified the correct character.

How do I split first and last names?
If each cell contains exactly a first name, one space, and a last name, select the cells and choose Space as the separator. Check names with middle names, compound surnames, or extra spaces first, because those can create additional pieces or incorrect divisions.

Can I split text into rows instead of columns?
The Split text to columns command places separated pieces across columns. It does not directly turn each piece into a new row. If you need a vertical list, you will need to rearrange the results after splitting or use a suitable transformation approach for your data.

Does Google Sheets have split panes like Excel?
Google Sheets does not provide Excel’s split-pane view. To keep headings visible while scrolling, use View > Freeze and choose the rows or columns to freeze. This changes the view, not the organization of the cell contents.

Will new rows split automatically?
No. The menu command works on the selected data when you run it; it is not a standing rule for future rows. Keep new incoming data in a raw-data area and repeat the split on the added rows, checking the delimiter and output columns each time.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.