Skip to content
Text To Table Converter

How to Convert a Employee Name List to a Table in Google Docs™, Slides™ or Sheets™ - The Easy Way

Manually reformatting jumbled text name lists into tables in Google Docs™, Sheets™, or Slides™ is time-consuming. Our free Text To Table Converter Add-On automates this within your Google Workspace™ applications.

Example of Badly Formatted Text

Section titled “Example of Badly Formatted Text”

Often, you might encounter data like this:

Alice Johnson (HR) alice.johnson@example.com Bob Smith (IT) bob.smith@example.com Clara Lee (FIN) clara.lee@example.com David Kim (MKT) david.kim@example.com Emma Davis (OPS) emma.davis@example.com Frank Miller (ENG) frank.miller@example.com Grace Chen (R&D) grace.chen@example.com Henry Walker (QA) henry.walker@example.com Irene Scott (SALES) irene.scott@example.com Jack Turner (CS) jack.turner@example.com

This guide shows how to convert it quickly.

How to Convert Text to a Table

Section titled “How to Convert Text to a Table”

  1. Prepare Your Text
    Copy the badly formatted text and paste it into your Google Doc, Sheet, or Slide.

    User selecting data in a PDF document, highlighting text to be copied.
    Paste the text without formatting

  2. (Optional) Define Column Headers
    For clearer results, type your desired column headers (e.g., Name, Department, E-Mail) on a new line directly above the messy text. The Add-On will use these for the table’s first row.

    Line with 'Name, Department, E-Mail' typed above the unstructured text data in Google Docs. (Headers help the Add-On structure your data)

  3. Run the Conversion
    Select the pasted text (including headers, if you added them). Then, navigate via the menu:
    Extensions > Text To Table Converter > 🔤 ➜ 📋 Text to Table.

    Google Docs menu showing Extensions > Text To Table Converter > 'Text to Table' option highlighted.

The Result: A Structured Table

Section titled “The Result: A Structured Table”

The Add-On will instantly create a table from your selected text.

A neatly formatted table in Google Docs showing columns for Name, Department, and E-Mail, successfully converted from the example text.

Same Example in Google Sheets™ A neatly formatted table in Google Docs showing columns for Name, Department, and E-Mail, successfully converted from the example text.

Get the Add-On

Section titled “Get the Add-On”

Install the free Text To Table Converter to simplify this task.

Install from Google Workspace Marketplace

Next Step: Unlock Data from PDFs

Section titled “Next Step: Unlock Data from PDFs”
Copy Tables from PDF to Google Sheets™ Learn how our Add-on helps you effortlessly extract structured data from PDF documents and import it directly into Google Sheets for analysis.

Get the Add-On

Section titled “Get the Add-On”

Supercharge your Google Docs™ experience even further! If you work with tables and text frequently, our Add-On can save you countless hours.

Install the Text To Table Converter

Next Step: Organize Documents on the Go

Section titled “Next Step: Organize Documents on the Go”
How to Create Document Tabs on Mobile? Learn about the current limitations of creating document tabs on mobile and a clever workaround to keep your files organized even when you're away from your desktop.