Convert Text to Table

With Text To Table Converter, you can quickly transform plain text into a well-organized table in Google Docs™, Google Slides™, and Google Sheets™.

Convert Text to a Table

1. Select your text

Name,Coffee Type,Milk Preference
Emily,Latte,Oat Milk
James,Americano,Black
Sophie,Cappuccino,Almond Milk

Tip

Your text doesn’t need strict delimiters like commas! The add-on intelligently detects and structures your text into a table.



2. Convert the Text to a Table
1. Click Extensions
2. Click Text to Table Converter
3. Click 🔤 ➜ 🔡 Selected Text to Table



3. Result

The table will be inserted below your text selection.

Handling Delimiters Within Your Data

What if your text data naturally contains the character you intend to use as a delimiter? For instance, you might be using a comma (,) as your delimiter, but one of your data cells needs to include "Almond Milk, Extra Foam, Cinnamon powder".

The recommended approach, following standard CSV conventions (RFC 4180), is to enclose the entire data field containing the delimiter in double quotes ("). This way the text within the quotes will be handled as a cell value instead of being misinterpreted for a column delimiter.

Example:

Consider this text where the comma is the intended delimiter:

Name,Coffee Type,Milk Preference
Emily,Latte,Oat Milk
James,Americano,Black
Sophie,Cappuccino,"Almond Milk, Extra Foam, Cinnamon powder"