Know-HowGoogle Docs™TablesTips

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

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:

text
Item, Quantity, Price
Notebook, 12, 3.50
Stapler, 4, 8.90
Whiteboard marker, 30, 1.20

Each 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

  1. Select the delimited lines in your Doc.
  2. Go to Extensions > Text To Table Converter > 🔤 ➜ 🔡 Selected Text to Table.
  3. 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:

  1. Copy the lines and paste them into a blank Google Sheets™ file.
  2. 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.
  3. 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

Отримати додаток безкоштовно

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