# How to split text into columns in Google Sheets on Mac: browser steps and fixes

> How to split text into columns in Google Sheets on Mac: choose Data > Split text to columns, pick a separator, and fix the common problems.

URL: https://www.lazur.app/how-to/split-text-into-columns-in-google-sheets
Updated: 2026-11-06

In Google Sheets on Mac, select the cells with text, then open Data > Split text to columns and pick a separator from the dropdown. Insert empty columns to the right first, because the split overwrites any data already in those columns with no warning.

## Quick answer

- Select the cells, then click Data > Split text to columns in Google Sheets on Mac.
- Insert empty columns to the right first. The split overwrites whatever sits there.
- Pick the separator from the dropdown: Detect automatically, Comma, Semicolon, Period, Space or Custom.
- Press ⌘Z right after the split if the result is wrong. Use TRIM to clear leftover spaces.
- A SPLIT formula does the same job and stays linked to the source cells.

Applies to: Google Sheets in a web browser on a Mac. Time: 5 min. Difficulty: Easy.

## What you need

- A Google account with edit access to the spreadsheet
- Text in one column, with a character between the values
- Empty columns to the right of the text
- A Mac browser that can open Google Sheets

## How to Split text into columns in Google Sheets on Mac in Google Sheets on a Mac

1. **Open the sheet in your browser.** Open the spreadsheet in Google Sheets in your Mac browser. Click the tab that holds the text. You need edit access to split text, so check that you can type in the cells.
2. **Find the separator.** Click one cell that holds text and read it. Look for the character between the values, such as a comma, a space, a semicolon, a period or a pipe. Tip: Read the cell itself, not the source file. Hidden spaces can hide the real separator.
3. **Make room to the right.** (Insert > Column right) Click the column letter to the right of your text. Open Insert > Column right from the menu bar. Repeat until the longest row has enough empty columns. Tip: Google warns that the split overwrites columns to the right with no warning, so leave them blank.
4. **Select the full range.** Click the column letter at the top to select the whole column, or drag across the cells you want. A partial selection leaves some rows unsplit.
5. **Open the Data menu.** (Data) Shortcut: ⌃⌥D. Click Data in the menu bar at the top of the sheet. You can also press Ctrl+Option+D to open the Data menu from the keyboard, which Google lists for Mac.
6. **Click Split text to columns.** (Data > Split text to columns) In the Data menu, click Split text to columns. Sheets shows a Separator dropdown for the selected cells. The menu label matches Google's help page.
7. **Choose the separator.** (Separator dropdown > Comma) Open the dropdown next to Separator. Pick Detect automatically, Comma, Semicolon, Period or Space. Choose Custom for any other character, then type it in the box. Tip: If the result looks wrong, press ⌘Z and try the next option while the undo still works.
8. **Check the result.** Shortcut: ⌘Z. Look at the first rows, the longest row and any merged cells. Spaces after commas show up as leading spaces in the new cells. If something is wrong, press ⌘Z right after the split.
9. **Remove leftover spaces.** Shortcut: ⌘⇧V. In a free cell, type =TRIM(B2), using the first split cell as the reference. Copy the formula down the column. When you need plain text, copy the results and paste with ⌘⇧V to paste values only.

## Where the command lives in Google Sheets on Mac

Split text to columns is a command inside Google Sheets. You reach it from the Data menu at the top of the sheet. Sheets draws its own menu bar on the page. You will not find the command in the Mac menu bar at the top of the screen.

Google's help page for this feature uses one Computer tab for desktop browsers. It does not give Mac-only steps. The menu names are the same on a Mac. The Mac shortcuts use ⌘, ⌥ and ⌃, where Windows uses Ctrl and Alt.

Google's product page says Sheets works on phones, tablets and desktops, and that it can be used offline. It does not describe a separate Mac app. Use your browser, and the steps on this page will match what you see.

## Before you split: make room for the new columns

Most people skip this step, and it causes most of the damage. Google's help page warns that the menu method overwrites data in the columns to the right. If those cells hold anything, it gets replaced with no warning.

Here is a worked example. Column A holds full addresses like Ana Lima, Lisbon, Portugal. Column B holds a note you typed earlier. A comma split writes the pieces into A, B and C, so the note in B is lost unless you make room first.

| Cell | Before the split | After the split |
| --- | --- | --- |
| A2 | Ana Lima, Lisbon, Portugal | Ana Lima |
| B2 | Note from March | Lisbon |
| C2 | Empty | Portugal |

_Comma split on one row. Leading spaces are hidden here so the table stays easy to read._

Insert the empty columns before you select anything. Click the column letter to the right of your text, then use Insert > Column right. Repeat until the longest row has enough empty columns to hold its pieces.

Check the longest row before you count. Some rows split into more pieces than others. Those extra pieces need room too, so count the widest row, not the first one.

## Choosing the right separator

The Separator dropdown offers Detect automatically, Comma, Semicolon, Period, Space and Custom. Choose the character that really sits between your values. Look at the cell itself, not at what you expect to see.

- Detect automatically: Google says it helps fix how columns spread after the split.
- Comma: the usual choice for lists of names, places and CSV-style text.
- Semicolon: use it when your values are separated by semicolons.
- Period: use it for values with dots between their parts, such as a code.
- Space: splits every word, so a full name splits too. Check the result.
- Custom: any other character, such as a pipe or a slash. Type it in the box.

Watch for spaces after commas. Most lists write a comma and then a space. The split keeps that space at the start of each new piece. You can remove it with TRIM, which is covered later on this page.

A value with the separator inside it breaks apart. A name like J. Smith splits at the period. Clean those cells first, or split on a character that never appears inside the names.

## Split with a formula instead: the SPLIT function

The SPLIT function gives the same result with a formula. Google's syntax is SPLIT(text, delimiter, [split_by_each], [remove_empty_text]). The delimiter characters do not appear in the results.

For the example above, type =SPLIT(A2, ",") in cell B2. The first piece lands in B2, and the rest spill to the right. The cells to the right must be empty, the same rule as the menu.

By default, consecutive delimiters count as one. Two commas in a row produce one split, not an empty cell. Set remove_empty_text to FALSE if you want the empty cells kept.

The menu command changes the cells once. A formula stays linked to its source cell, so the split updates when the source text changes. Pick the tool that fits how often your source text changes.

> **Keep the result, drop the formula:** Copy the split cells, then paste with ⌘⇧V to paste values only. The text stays and the formula goes.

## Fixes for the problems people hit most

Most failed splits come from a short list of causes. Each one has a clean fix. None of them needs a second tool.

- Wrong or missing separator: choose Custom and type the character you see.
- Partial selection: select the full range before you open the command.
- Extra spaces: use TRIM in a helper column, then paste values only.
- Merged cells: choose Format > Merge cells > Unmerge, then split again.
- Not enough empty columns: insert empty columns or clear the cells to the right.

Merged cells deserve a closer look. A merged cell spans several cells, so the split has no clean place to put the pieces. Unmerge first, then check that the text is still in the cell you expect.

Partial selections are easy to miss. If you drag across only part of a column, the rows below stay whole. Click the column letter to select everything at once.

## Mistakes that cost people their data

The first mistake is skipping the empty columns. The second is splitting a column that holds formulas. The split works on the values in those cells, so check what each cell contains first.

Undo is your safety net. Press ⌘Z right after the split. Undo works best straight after the change, so do not make other edits before you check the result.

Decimal values break in the same way. If your column holds prices with decimal points, a Period split pulls each number apart. Use Custom only when you know the separator is safe in that column.

Watch the header row too. If you select the whole column, the header splits along with the data. Your first row then holds the piece names, which may be what you want. Check it before you move on.

## Shortcuts, and what Google does not offer

Google's keyboard shortcut page lists ⌘Z for undo, ⌘C for copy, ⌘V for paste and ⌘⇧V for paste values only. It also lists ⌘/ for the shortcut list and ⌥/ for the tool finder.

The same page has no shortcut for Split text to columns. The fastest route is Ctrl+Option+D to open the Data menu, then one click on the command. The command itself is a mouse action.

If you cannot find a command, use the tool finder. The guide on [how to use the tool finder in Google Sheets on Mac](https://www.lazur.app/how-to/use-the-tool-finder-in-google-sheets) covers it step by step.

![Person working on a laptop at a desk, reviewing a spreadsheet of text rows before splitting text into columns](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/howto/split-text-into-columns-in-google-sheets/how-to-split-text-into-columns-in-1-4d887e.jpg)

## After the split: tidy up and keep working

Check every row after the split. Sort the new columns with [sort data by column in Google Sheets](https://www.lazur.app/how-to/sort-data-by-column-in-google-sheets) if the order matters. Remove doubled rows with [remove duplicate rows](https://www.lazur.app/how-to/remove-duplicate-rows-in-google-sheets).

If the text came from a CSV file, read the [CSV import steps](https://www.lazur.app/how-to/import-a-csv-file-in-google-sheets) before you split by hand. A clean import can save you a cleanup pass later.

Find and replace can clear stray characters before a split. The [find and replace guide](https://www.lazur.app/how-to/find-and-replace-text-in-google-sheets) walks through the steps in Chrome on Mac.

## Checklist before you split

- Confirm the separator by looking at the cell, not at your guess.
- Insert empty columns to the right of the text.
- Select the full range, including every row with text.
- Unmerge any merged cells inside the range.
- After the split, check the longest row. Press ⌘Z if anything looks wrong.

## Version and update notes

Google does not publish version numbers for the Sheets web app, so these steps do not name one. Sheets Bootcamp says its guide was updated May 20, 2026, and lists no version-specific behavior.

If your Data menu looks different from these steps, look for the same command name. The menu label Split text to columns is what Google's help page uses.

![Man typing on a Mac keyboard while reviewing data columns in a browser spreadsheet on a desk](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/howto/split-text-into-columns-in-google-sheets/how-to-split-text-into-columns-in-2-e89c20.jpg)

## Shortcuts

- Undo the last change: ⌘Z
- Copy: ⌘C
- Paste: ⌘V
- Paste values only: ⌘⇧V
- Open the Data menu: ⌃⌥D
- Show the shortcut list: ⌘/
- Open the tool finder: ⌥/

## If it does not work

- **Only some rows split, and the rest stay whole.** Select the full range before you open the command. A partial selection leaves the rows you did not select unsplit.
- **My existing data was replaced by the split.** Press ⌘Z right after the split. Insert empty columns to the right of the text, then split again. Google warns that the menu overwrites columns to the right with no warning.
- **The pieces landed in the wrong places or the wrong character was used.** Undo, then check the character in the cell. Pick the matching option in the Separator dropdown, or choose Custom and type the character.
- **The split fails on merged cells.** Choose Format > Merge cells > Unmerge, then split again. Check that the text is still in the cell you expect.
- **The new cells have extra spaces at the start or end.** Use TRIM. Type =TRIM(B2) in a free cell, copy it down the column, then paste values only with ⌘⇧V if you need plain text.
- **A value splits where it should not, such as initials or decimals.** Clean those cells first, or split only the columns where the separator is safe. Undo right after a bad split.

## With Lazur

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ and ask; it sees your screen, answers out loud, points at buttons and walks you through apps. Hold fn to dictate. Free for 3 days, then $18/month: https://www.lazur.app/download

- “Walk me through splitting column A by comma in Google Sheets.”: You ask how to split the column. Lazur guides you one click at a time, pointing at each control and waiting for you to click it. Lazur does not click for you. (Walks you through it)

## FAQ

### Is there a Google Sheets app for Mac?

Google Sheets runs in your browser. Google's product page says Sheets works on phones, tablets and desktops, and can be used offline. It does not describe a separate Mac app, so the split steps here work in any browser on your Mac.

### Why did my data disappear after I split a column?

The menu method overwrites data in the columns to the right, and Google's help page says it does so with no warning. Insert empty columns before you split. If you already split, press ⌘Z right after to undo.

### Can I undo a text split in Google Sheets on Mac?

Yes. Undo works right after the split, so press ⌘Z straight away. If you made other edits first, the original text may not come back, so copy the sheet before your next split.

### Is there a keyboard shortcut for Split text to columns?

Google's keyboard shortcut page does not list one. Press Ctrl+Option+D to open the Data menu on Mac, then click Split text to columns. The shortcut list itself opens with ⌘/.

### What separator should I pick for a pipe or a slash?

Choose Custom in the Separator dropdown and type the character. Check one cell first to confirm the exact character, since a similar symbol can look the same at a glance.

### Does a SPLIT formula update when the source changes?

Yes. A SPLIT formula stays linked to its source cell, so the pieces update when the source text changes. The menu command changes the cells once and does not keep a link to the source.

### Why does a piece start with a space?

Most lists put a space after each comma. The split keeps that space, so the new cell starts with it. Use TRIM on the cell, such as =TRIM(B2), to remove the leading space.

## Sources

1. [Split text, remove duplicates, or trim whitespace - Computer - Google Docs Editors Help](https://support.google.com/docs/answer/6325535?hl=en&co=GENIE.Platform%3DDesktop), Google, checked 2026-11-07
2. [Keyboard shortcuts for Google Sheets - Computer - Google Docs Editors Help](https://support.google.com/docs/answer/181110?hl=en&co=GENIE.Platform%3DDesktop), Google, checked 2026-11-07
3. [SPLIT function - Google Docs Editors Help](https://support.google.com/docs/answer/3094136?hl=en), Google, checked 2026-11-07
4. [Google Sheets - Google Workspace](https://workspace.google.com/products/sheets/), Google, checked 2026-11-07
5. [Split Text to Columns in Google Sheets - Sheets Bootcamp](https://www.sheetsbootcamp.com/text-functions/text-to-columns/), Sheets Bootcamp, checked 2026-11-07
6. [How to Use Split Text to Columns in Google Sheets - Guiding Tech](https://www.guidingtech.com/how-to-use-split-text-to-columns-in-google-sheets/), Guiding Tech, checked 2026-11-07
7. [Google Sheets Text to Columns Not Working? Here's What To Do - Analysis Fix](https://analysisfix.com/google-sheets-text-to-columns-not-working-heres-what-to-do/), Analysis Fix, checked 2026-11-07