Google Sheets split text to columns separates clearly delimited fields inside cells. After this exercise, you can turn four fictional one-column product records into three fields, inspect their associations and reopen the saved result.
Content checked: 19 October 2026.
What does splitting text into columns actually do?
Google Sheets split text to columns separates clearly delimited fields that currently sit inside one cell. A product code, product name and unit can become three neighbouring cells without changing the order of the records. This is a layout operation, not a stock audit, a sort or a calculation. Define the input pattern before choosing a menu command.
Our practice uses four fictional stationery records in a new blank spreadsheet. It contains no customer details, live inventory or operational order data. No signed-in split, save, reopening or timing trial was performed for this article. The expected table is an answer key for the exercise, not a report that the application produced a verified result in a tested account.
A delimiter is the character that marks a boundary between fields. In this sample it is a comma, and none of the field values contains its own comma. That makes each boundary unambiguous. If your real material uses commas both between fields and inside names, it does not meet this exercise’s input condition. Do not assume the simple route below resolves that different problem.
Build a clean one-column starting point
On a computer, open sheets.google.com with an account you are permitted to use and create a blank spreadsheet. Click the untitled file name, type “Product field split 01” and press Enter. Google documents the creation and naming route. Use a separate practice file rather than an operational team sheet. Do not change sharing permissions or move real records to make this exercise possible.
Check that columns A, B and C are empty in your practice tab. The source will occupy A1:A4, while B and C remain empty for the resulting fields. Do not add a header yet: we want the selected range to contain exactly four source records. Avoid formulas, merged cells, dates, prices and identifiers with leading zeroes in this small first exercise.
S01,Marker,each S02,Paper,pack S03,Envelope,box S04,Notebook,each
Enter each complete line into its own cell in column A. A1 should contain the full line beginning S01, A2 the full line beginning S02, and so on. After pasting or entering the material, inspect the actual starting layout. If it has already spread across three columns, do not describe it as an unsplit source. Use a new blank practice area and enter the full strings individually into column A before proceeding.
Preserve the four source strings as your reference. The sample printed above can serve as the unchanged answer key; you can also retain them in your own notes. Do not rewrite that reference after viewing the output. The Sheets workflow guide discusses broader intake processes. Here the task is deliberately smaller: confirm one-column input, apply one separator and inspect the resulting field associations.
Predict the fields before running the command
Every supplied line contains two commas, so this particular input should produce three fields: code, product and unit. The correct separator is not a space or a guessed punctuation mark. Write down which product and unit belong to each code before you split anything. Keeping four visible rows is necessary but insufficient; the values must remain associated with the correct record.
| A: Code | B: Product | C: Unit |
|---|---|---|
| S01 | Marker | each |
| S02 | Paper | pack |
| S03 | Envelope | box |
| S04 | Notebook | each |
This is the expected layout, not an observed application result. S02 must remain associated with Paper and pack. There is no need to hide, delete or reorder records. The two-column range-sort walkthrough changes the order of complete records. This exercise changes where each record’s fields are displayed while leaving the record sequence alone.
If a source string is missing a comma, fix that practice input before running the command and inspect it again. If a field contains an additional comma, the input is outside the agreed simple pattern. We are not importing a CSV file or teaching quotation and escape rules. Calling the result “parsed CSV” would suggest a broader capability than this small menu exercise establishes.
Choose the separator explicitly
Select A1:A4 and confirm that all four complete source strings are included. Check once more that neighbouring output space is empty. Choose Data > Split text to columns. Google’s desktop help documents this command and the Separator menu. If the command is missing or the file is not editable, stop at that specific prerequisite instead of trying unrelated controls.
In the Separator menu, choose Comma. Do not leave your observation card saying only “automatic” when the acceptance condition concerns a known comma boundary. The intended result places codes in A, product names in B and units in C. Read your own screen before recording that result as achieved. Documented steps and expected output are not evidence of an executed account test.
If every complete string remains in A, inspect the selected range and the actual punctuation in the input. If an unexpected fourth field appears, compare the source string with the unchanged reference and look for an additional delimiter. Do not manually rearrange output values merely to make the table resemble the answer key. That would conceal what the splitting operation actually did.
This task does not require a formula, enhanced Smart Fill or an AI prompt. The Gemini in Sheets guide concerns other table and analysis jobs. Here the separator is already known, so the direct menu operation gives you a specific action to inspect. Adding another tool would introduce a second process without changing the acceptance condition.
Check associations, not just the first row
Start by confirming that S01, S02, S03 and S04 each appear once in A1:A4. Then read every complete row against the reference. S01 belongs with Marker and each; S02 belongs with Paper and pack. Check the remaining two records in the same way. One correct first row does not prove that the whole range was selected or split as intended.
A product fragment in the unit column is not fixed by renaming that column. The heading cannot make an incorrectly placed value correct. Inspect the original string and the selected delimiter before deciding what happened. If the result remains unexplained, leave the exercise unresolved and do not apply the operation to operational data.
Input: A1:A4, four fictional records Chosen delimiter: comma Expected: A code, B product, C unit Each code present once: not checked Four code-product-unit associations: not checked Unexpected extra field: not checked Saving and reopening: not checked Decision and unresolved issue:
You may keep this observation log below the result, starting at A7, rather than inside A1:A4. Keep it outside any range you split. Fill in an observation only after performing its check. “Not checked” should not become “matches” because the expected table looks straightforward. The log records this exercise; it is not an independent backup or proof that a real inventory is accurate.
Keep the distinction between source correctness and operation correctness. A faithful split can reproduce a mistaken product name exactly. This practice only checks whether the supplied fields reached their intended positions. If the business meaning of a real unit or product code is uncertain, that requires a separate source review. The menu command cannot decide the authoritative catalogue value for you.
Reopen the named spreadsheet and inspect it again
Google says edits are saved automatically while you work online. Its file guidance also tells Sheets users to click outside the cell they typed in. Check your connection and the document’s saving status before closing the file. If you cannot establish that saving has finished, leave persistence unresolved rather than assuming an online file must already contain the latest result.
Close the practice spreadsheet, return to the Sheets home screen and reopen “Product field split 01.” Compare the four rows with the original reference again. Check the observation log separately if you added it below the result. Reopening a file by name does not itself prove that every field is correct; it gives you a saved object in which to repeat the same concrete checks.
A fifteen-minute practical target is to split four simple one-column records into three fields and verify their associations. This is a planning target, not a measured completion-time promise. If the file cannot be found again, or a required control is unavailable, write down that obstacle. An honest unresolved result is more useful than a success claim without an observed output.
For a different editing-boundary task, see protecting formula cells. To select a saved subset of records rather than change their field layout, use the filter-view walkthrough. Finish this job with a smaller, traceable result: four unchanged reference strings, one specified comma delimiter, three inspected fields per record and a truthful reopening observation.
Frequently asked questions
Is this a CSV import tutorial?
No. It splits four simple practice strings whose fields contain no additional commas. It does not establish quotation, escaping or complex CSV behaviour.
Should I sort the records too?
No. This exercise changes field layout, not record order. Keep the four records in their original sequence.
What if pasting already created three columns?
Do not record that as unsplit input. In a new blank practice area, enter each complete source string into its own column-A cell and confirm the starting layout.
Is a correct first row enough?
No. Check every code together with its product and unit against the reference, then reopen the saved spreadsheet and inspect again.
