OmniDocConvert Text to a Table in Word and Back
Learn how to turn tab- or comma-separated text into a Word table and convert a table back to text, with checks for common errors.
You have a list of names, prices or measurements pasted as one long block, and you need it in a proper grid. Maybe the data came from a spreadsheet, an email or a log file, and every line has tabs or commas where the columns should be. Converting that text to a table in Word takes a few minutes if the separators are clean. If they are not, the table comes out with shifted columns and half-filled rows.
This guide covers both directions: turning separated text into a Word table (the text to table Word workflow many readers search for), and turning a table back into plain text. It also explains the checks that catch common mistakes, such as a comma inside a number creating an extra column.
The short answer is that you pick the right separator, clean the text, select it, and let Word's built-in text-to-table conversion split it into cells.
How do you turn text into a table in Word? The short answer
Select the text, make sure each row sits on its own line with one consistent separator, and run Word's text-to-table conversion with that same separator chosen.
| Your situation | What to do | Why |
|---|---|---|
| Fields are separated by tabs, often copied from a spreadsheet | Choose tabs as the separator | Word splits each line at every tab, so each field lands in its own cell. |
| Fields are separated by commas, like a simple CSV list | Choose commas as the separator | Word splits at each comma, so commas inside numbers or quoted text must be cleaned up first. |
| One item per line, with no separators | Convert to a single column | Each line becomes one row. You can add separators later and convert again to create more columns. |
| You need the table as plain text again | Select the whole table and convert it to text | Each row becomes a line, and the separator you pick sets how the cells are joined. |
| The text sits inside a PDF | Get the text into Word first, then convert | Word can only convert text it can treat as normal, selectable text. |
Before you start
A few checks before you select anything will save you from fixing a broken table later.
- Look for stray separators. A comma in "1,250" or a tab inside a description adds an extra column for that row. Search the text for the separator character and see whether it appears where you do not expect it.
- Remove blank lines. Each blank line becomes an empty row in the table, and those rows are hard to spot once the table is built.
- Decide what the first line is. If the first line holds column names, plan to bold or shade it as a header row after conversion, so readers can tell it apart from the data.
- Keep a copy of the original text. If a conversion goes wrong, you can start again without retyping anything.
- Check whether a PDF text is selectable. Try selecting one line of text in the PDF. If the cursor selects the words, the text can be copied. If the page behaves like a picture, the PDF is scanned and needs OCR first. The PDF editor in the OmniDoc desktop client includes OCR for scanned PDFs.
Converting text to a table in Word, step by step
- Put each row on its own line. Use a normal paragraph break between rows, and keep the separator inside each row. Every row should have the same number of separators.
- Select the full block of text. Start at the first character of the first row and end after the last row. Leave out any extra blank lines.
- Find Word's built-in text-to-table command. It is part of Word's table tools, and its exact location depends on your Word version. Look for the option that converts selected text into a table.
- Check the column count. Word estimates the number of columns from the separators in the first line. Compare that number with your data, because a single extra separator in the first line changes the result.
- Choose the separator that matches your text. Pick tabs, commas, paragraph marks or another character. The option must match what you prepared in the earlier steps.
- Confirm the conversion. Word builds the table from the selected lines. The table appears where the text was.
- Format the header row. Bold the first row or apply a table style so readers can tell the column names from the data.
Turning a table back into text
Converting a table to text is the reverse operation, and it is useful when you need to paste the data into a plain text file, a code snippet or another program.
- Select the whole table. Click inside the table and use Word's selection tools so that all rows and cells are included.
- Run the table-to-text command. It is in the same table tools area as the text-to-table command.
- Choose the output separator. Tabs suit spreadsheet pasting, commas suit simple CSV-style lists, and paragraph marks put each cell on its own line.
- Check the output. Paste the result into a plain text editor and confirm that each row has the expected separators.
Check the result
Once the table or text is in place, check it against your source before you use it. A quick comparison catches many problems.
| Check | How to see it | If it's wrong |
|---|---|---|
| Column count | Count the cells in the first row and compare with your source | Undo the conversion, look for extra separators in the source, and convert again. |
| Numbers split across cells | Look for a value such as 1250 that now sits across two cells | Remove the thousands separator from the source, or switch to tabs as the separator. |
| Empty rows | Scroll through the table for blank rows | Remove the blank lines from the source and convert again. |
| Uneven rows | Check that every row has the same number of cells | Find the lines with extra separators and fix them in the source text. |
| Line breaks in the plain-text output | Paste the converted text into a plain text editor | Pick a different separator, such as paragraph marks, and convert again. |
If your table starts as a PDF, the desktop client's PDF editor can export to Word, Excel or PowerPoint. Export to Word, then run the steps above on the exported file. If you want to keep editing the converted .docx in a browser, the UniDoc web editor at app.unidoc.top offers Word-compatible editing. Check any table you export, since layout and cell boundaries can differ from the original PDF.
❓ FAQ
1. Can I convert text to a table online instead of in Word?
Yes, many online converters do this. Before you paste sensitive data into one, check the file or text size limits, whether the service keeps your data private, and whether the output keeps your column structure. For confidential content, editing in a desktop program keeps the text on your own computer.
2. Why does Word split my text into the wrong columns?
Word counts the separators it finds, so a stray comma, tab or extra character in a row creates an extra column. Search the source for the separator and fix the lines that have too many or too few. Then convert the text again.
3. Can I convert a table back to text without losing data?
Yes, as long as you choose a separator that does not appear inside the data. If a cell contains a comma and you export with commas, that cell will look like two cells when you read the text back. Tabs or paragraph marks are safer in that case.
4. Why do my numbers look wrong after converting?
Thousands separators, decimal commas and currency symbols can interact with the separator you chose. If you use commas and the numbers contain commas, the values split. Remove the thousands separators from the source, or use tabs as the separator, and compare the result against the original.
📝 Summary
Converting text to a table in Word depends on the separator you choose and how clean the source text is. Clean the separators, select the full block, and let Word's built-in command build the table. Use the same steps in reverse when you need the table as plain text again.
