Turn a Comma- or Tab-Separated List into a Table in Google Docs™
Got CSV-style text — values separated by commas or tabs — sitting in a Google Doc? Here's how to turn it into a proper table, with or without an add-on.
Travis
A comma- or tab-separated list is already a table — it just doesn't look like one yet. Convert it in Google Docs™ either with the free Text To Table Converter Add-On (one step, in place) or via a paste through Google Sheets™.
Delimited text shows up everywhere: exports from other tools, lines copied from an email, data dictated into a doc, CSV snippets from a colleague. Something like:
Item, Quantity, Price
Notebook, 12, 3.50
Stapler, 4, 8.90
Whiteboard marker, 30, 1.20Each comma marks a column boundary; each line is a row. Here's how to make Google Docs™ see it that way too.
Method 1: Text To Table Converter Add-On
- Select the delimited lines in your Doc.
- Go to
Extensions>Text To Table Converter>🔤 ➜ 🔡 Selected Text to Table. - The Add-On detects the separator — commas, tabs, semicolons, multiple spaces, or Markdown pipes — and replaces the selection with a table.
Because detection is automatic, the same action works whether your data came from a CSV file, a terminal, or an AI chat.
Method 2: Round-trip through Google Sheets™
Without an add-on, borrow Sheets™' splitting powers:
- Copy the lines and paste them into a blank Google Sheets™ file.
- Tab-separated values split into columns automatically on paste. For commas or anything else, select the cells and use
Data>Split text to columns, choosing the matching separator. - Copy the resulting range and paste it back into your Doc — it arrives as a real table.
Watch out: commas inside your values
If your data contains commas *within* a value (for example "Smith, John"), splitting on commas will break that value into two cells. In that case:
- Prefer tab-separated source data when you can get it.
- Or pick a separator that doesn't occur in the data (like
;or|) before converting.
Get the Add-On
Отримати додаток безкоштовно
Text To Table Converter
Convert lists to tables for free: Use the free Text To Table Converter add-on to turn any delimited text into a clean table in Docs™, Slides™, and Sheets™.
Next Step: When There's No Delimiter at All
- Google Docs™ Has No 'Convert Text to Table' — Here Are 3 Ways to Do It - The full picture of text-to-table options in Google Docs™, including the manual route.