Number my columns – Converting a list to a table

InDesign contains a cool feature that allows us to convert tabulated (or otherwise separated) text into a table format. David Blatner describes this feature (and a little more) in his Massaging Text with InDesign post.

Converting text to table

A quick recap on how this feature works. To convert tabulated text to tables:

  • Start by displaying the Hidden Characters (Type menu > Show Hidden Characters). This will allow you to see the hidden tab characters in your text, as well as paragraph returns.
  • Using the Type tool select the text that you’ll convert up to the last paragraph return.
  • From the Table menu > Convert Text to Table.

Convert Text to Table dialog with Column Separator set to Tab and Row Separator set to Tab.

In the dialog that appears:

  • Set Tab for the Column Separator and Paragraph for the Row Separator.
  • If your document contains a table style you’d like to apply as part of the conversion, select that style from the Table Stylemenu.
  • Click OK

Table with three columns and three rows.

The feature works really well when there are clearly defined separators for columns and rows in your text. But what happens when all you’ve received from a customer is a list of paragraphs that need converting to a multi-column table?

Setting the Number of Columns

This is when the Number of Columns feature in the Convert Text to Tables dialog comes is handy.

  • As previously select the text, excluding the last paragraph return character, that you’d like to convert to a table.
  • Tables > Convert Text to Table.

Convert Text to Table dialog box with Column and Row Separator set to Paragraph and Number of Columns set to 3

In the Convert Text to Table dialog our column and row separators are identical this time:

  • Set Column and Row Separator to Paragraph.

Because the separators are identical, you must now provide some additional information to InDesign. InDesign wants to know is after how many lines (paragraphs), must it start a new row. In other words: How many columns will the table have?

  • Set the Number of Columns value.
  • Once again if your document contains a table style you’d like to apply as part of the conversion, select that style from the Table Style menu.
  • Click OK.

Table with three columns and three rows.

There are quite a few cool uses for the Convert Text to Table feature. Share with us in the comments how you’ve found yourself using this feature. Are you missing particular settings that you’d like to see added to the feature?

Tags
Related Articles
Comments

7 Comments on “Number my columns – Converting a list to a table

  1. @Eugene Thanks :) always nice to discover something ‘new’ ;-) mind you… I might be an InDesign wiz… I still discover and learn new stuff about this beautiful application (and other Adobe apps) regularly :) never a dull moment in InDesign :)

  2. This is a Very Cool Trick! I wonder why I never saw that before??!! Now I have a solution looking for a problem… Can’t wait to use it…

  3. @Joshua ‘now I have a solutions looking for a problem’ ROFL :) :) Let us know how you’ve used it once you find yourself the problem for this solution ;-)

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>