Sign in

Convert text to a table or vice versa

What do you want to do?

Convert text to a table

Convert a table to text

Convert text to a table

  1. Insert separator characters — such as commas or tabs — to indicate where you want to divide the text into columns. Use paragraph marks to indicate where you want to begin a new row.

    For example, in a list with two words on a line, insert a comma or a tab after the first word to create a two-column table.

  2. Select the text that you want to convert.

  3. On the Insert tab, in the Tables group, click Table, and then click Convert Text to Table.

    Word Ribbon Image

  4. In the Convert Text to Table dialog box, under Separate text at, click the option for the separator character that is in your text.

  5. In the Number of columns box, check the number of columns.

    If you don't see the number of columns that you expect, you may be missing a separator character in one or more lines of text.

  6. Select any other options that you want.

Top of Page

Convert a table to text

  1. Select the rows or table that you want to convert to paragraphs.

  2. Under Table Tools, on the Layout tab, in the Data group, click Convert to Text.

  3. Under Separate text at, click the option for the separator character that you want to use in place of the column boundaries.

    Rows are separated with paragraph marks.

Top of Page



Was this information helpful?

How can we improve it?

How can we improve it?

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!