Converting Text Into A Table format can help you better organise your data for people reading it.

It also allows you to easier transfer your data between Word and Excel, making it great for any user of both.

If you are learning either software you can view our Excel Course Offerings or Word Course Offerings here.

 

Converting Your Text To A Table – Simple Example

When Converting your text to a table, you need to first have some text in Word. Here you can see my text, under the title “Alpheius Global Enterprises”.

To convert text into a table the text needs to be in columns using some sort of separator – for example a tab, hyphen, comma or other symbol. My text specifically is seperated by tabs and has 4 columns (this will be important later).

 

Screenshot of the original data in Word

  • Highlight the piece of text to be converted into a table format.
  • In the Insert ribbon there is a table button.
  • Click on the table button and convert text to table.

 

Where to find the Convert Text To Table button

 

  • A dialog box will appear asking how many columns you want, how you want the text to fit and what are the separators used in your document
  • Choose the number of columns required, fixed column width and our document has tabs which are separating the text then click OK.
  • Your document will now be in a table format.

 

Shows the conversion Dialog Box and the options appropriate for our example

 

After selecting your options hit OK. For this example I chose 4 columns as you can see from the inital data, as well as that they are seperated by tabs. For your data you will want to specify differently based on your own data. After hitting OK you should see the results immediately. Below you can see my data changed into a table!

 

Shows the new data after being put into a table

 

If you want to learn more about Tables and how they can be formatted, read our guide on  columns for a newsletter in Word.

 

Why Convert Between Table And Text?

Going between tables and texts allows you simply to have different types of visual representation.

Ultimately the choice will be up to your discretion but follow these brief guidelines!

If you are doing a presentation based more on raw statistics and important facts maybe a table is more suitable. Tables are more analytical in nature and tend to lend themselves more to situations that are more formal and possibly educational (for example sending your coworker a plan for your business).

 

If you want to do a more graphically appealing layout maybe the raw text with some formatting is more appropriate (more on Font Formatting In Excel here). Text tends to be better for more informal presentations, and in general for a more casual audience (for example just sending a friend over some information found).

 

 

Converting From Table To Text

You can now also convert your table back to text if need be!

  • First off just highlight the table using the table highlight option in the top right corner of the table
  • Go to the Table Tools and select the layout ribbon
  • In the data group at the end of the ribbon you will find the command convert to text

 

Where to find the convert table to text option to revert the changes

 

  •  The convert to text dialog box will appear.  Use the tab option as this will keep your text in similar columns to your table

 

Shows the dialog box for converting table to text

 

This will take your text back to it’s original form. Whichever you decide, Table or Text, you can save either for later use – read our guide here on How to Create and Use Building Blocks in Word.

 

Conclusion:

This guide has given you the tools on how to convert text into a Word table and a Word table back into text. Becoming proficient in these simple tools will help greatly when presenting your work, as well as when trying to move your work between Word and Excel. Try and experiment with these different types of representation to see what fits you best – but follow our rough guidelines if you are in need of guidance.