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

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

Prepare Your Text
Copy the badly formatted text and paste it into your Google Doc, Sheet, or Slide.
(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.

(Headers help the Add-On structure your data)
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.

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

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

Install from Google Workspace Marketplace

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

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

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.