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 May 11, 2013)

4

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

Adjusting Column Width from the Keyboard

It's easy to adjust the width of table columns using the mouse, but what if you don't want to use the mouse? Adjusting column ...

Discover More

Using Multiple References to a Single Comment

Find yourself repeating the same comment over and over? Here's a couple of ways you can save some typing by simply referring ...

Discover More

Deleting a Range of Pages

Need to delete a range of pages out of the middle of your document? It's easy to do using editing techniques you already know ...

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)

Adding Table Columns to Columns with Merged Cells

Word's table editor allows you to modify the structure of tables in a wide variety of ways. If you want to add columns to a ...

Discover More

Selecting Individual Cells in a Table

Many times before applying formatting or doing another operation, you need to select an individual cell in a table. Here's ...

Discover More

Using Outline Numbering in a Table

Can you put a numbered outline in a table? Yes, you can. But Word is rather prickly when it comes to using the keyboard to ...

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 8Mpixels. 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 three more than 5?

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.