Saltearse al contenido
Convertidor de Texto a Tabla

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

Esta página aún no está disponible en tu idioma.

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) [email protected] Bob Smith (IT) [email protected] Clara Lee (FIN) [email protected] David Kim (MKT) [email protected] Emma Davis (OPS) [email protected] Frank Miller (ENG) [email protected] Grace Chen (R&D) [email protected] Henry Walker (QA) [email protected] Irene Scott (SALES) [email protected] Jack Turner (CS) [email protected]

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.