Please Note: This article is written for users of the following Microsoft Word versions: 2007, 2010, and 2013. If you are using an earlier version (Word 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Word, click here: Converting Text Into a Table.

Converting Text Into a Table

by Allen Wyatt
(last updated October 12, 2017)

5

There are two major ways you can create tables in Word. One way is to create a blank table by any of the various methods provided by Word (such as drawing the table or using the Insert Table tool). The other method is to convert existing text into a table. To convert text into a table, follow these steps:

  1. Make sure the text that is to be converted into the table contains only a single tab character between each column.
  2. Select the text you want converted into a table.
  3. Display the Insert tab of the ribbon.
  4. Click the Table tool and then click Convert Text to Table. Word displays the Convert Text to Table dialog box. (See Figure 1.)
  5. Figure 1. The Convert Text to Table dialog box.

  6. Make sure all the table settings in the dialog box are correct.
  7. Click OK.

The selected text is immediately converted into a table. In some instances, the width of columns in the resulting table may need to be adjusted. You will know if this is the case because the table will look very strange. Sometimes you can get files from programs such as a spreadsheet that use commas to separate columns. Word will also convert this comma-separated text to a table.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (7725) applies to Microsoft Word 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Word here: Converting Text Into a Table.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Converting Cells to Proper Case

When storing text in a worksheet, you may have a need to change the case of that text so that the initial letter in each ...

Discover More

Converting Numbers to Strings

When creating macros, it is often necessary to change from one type of data to another. Here's how you can change from a ...

Discover More

Getting Rid of Blackheads

Blackheads and skin blemishes are unsightly and frustrating. You can get rid of them if you understand what causes them ...

Discover More

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!

More WordTips (ribbon)

Overriding Automatic Numbering of Tables

Word lets you add automatic numbering to different elements of your document. It does not, however, allow much ...

Discover More

Splitting a Table

Table getting too long? Need to move part of a table to somewhere else in your document? You can easily split an existing ...

Discover More

Clearing the Contents of a Table

Want to get rid of information within a table, but not the table itself? Here's a guide to understanding the effects that ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 9 - 6?

2017-10-12 17:28:32

Peter Kirkpatrick

@MTB Lisa, The general steps to get your result might be this:
1. Create only one column instead of two. (I am assuming that "a. john" is planned to be in a single cell.)
2. Convert text to Table.
3. Add a second column to the right.
4. Cut and paste the second half of column 1 into the first half of column 2.
5. Delete non-required rows.

Another option might be to convert text to a single column table and then format the page as two or more columns.


2016-10-01 09:51:09

husseim

thanks a million for your comprehensive and concise explanation. it really helped me.


2015-07-07 22:25:24

MTB Lisa

when converting text to table, the text gets put in the order of horizontal instead of vertical. For example,
Text is
a. john
b. susan
c. katie
d. Lou
when this is converted to table, I want it to be:
a. john c. katie
b. susan d. Lou
However, it does this instead:
a. john b. susan
c. katie d. Lou

Aarrgghh!


2014-09-04 15:46:23

April Christian

I recently purchased Microsoft Office 2013 Home and student version and The "convert text to table" option is shaded in (unavailable). I can't click on it at all.... why is that? I really need this option and I'm wondering how I can use this.


2013-05-11 07:30:49

Cindy Bertaut

One more "tip" for this Converting Text Into a Table tip.
This is a lot of words to describe a simple idea; if you have ever made a table from text and the data didn't line up in each column like you expected to, it is probably from some rows not having the same number of columns. For example you may have a table with 4 or 5 rows, but in the middle of a table, there may be a "subcategory" title that runs across that entire row.
Here is how to fix that:
In your original text you want to make sure you enter enough tabs after that "subcategory" title to invent "blank" cells across the rest of the row, creating blank columns, only for that row.
Voila! All your text will line up in the proper columns now!


This Site

Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.