Create or Insert a table in InDesign

by Stefano Bernardi 5 minutes to read

Intro - working with InDesign tables ...

For years I was convinced that InDesign was a great software if you only had to create beautiful layouts but that it was really bad if you wanted a little bit of automation. No thought ever turned out to be so wrong! InDesign has many features that allow you to automate certain tasks or automatically set styles to your content. And working with tables in InDesign is beautiful when you learn how to do so.

In this post we will see:

  • How to create a table in InDesign
  • How to convert text to table in InDesign
  • How to link a file Excel to InDesign - part 2
  • Editing tables in InDesign from Excel - part 2
  • How to create table styles in InDesign - part 3 (with a template you can download)
  • Useful shortcuts (summarised in every post)

How to create a table in InDesign

There are essentially three ways to create a table in InDesign.
You can:

  1. Convert text to table in InDesign
  2. Create a text frame and insert a table into InDesign
  3. Import Excel into InDesign — and also import a linking spreadsheet that you can update from Excel

Method 1: Convert text to table in InDesign

These instructions are especially useful when you:

  • copy table from Word to InDesign
  • copy table from Excel to InDesign

The simplest way to import a table from Word to InDesign is by copying the table from Word and then pasting it into InDesign (the same goes for Excel).Import table from word to InDesign: copy table from Word to InDesign

Immediately, when you import the Excel/Word table to InDesign, the software converts the table into text and separates columns by tabulations and rows by paragraph returns.
Import table from Word to InDesign: copy table from Word to InDesign

To convert the text to table, you need to use the feature in InDesign “Convert text to table”:

Select the entire text you just copied.
Import table from Word to InDesign: select the text to convert to table

Click on Table in the main menu bar and click on “Convert Text to Table”.
Import table from Word to InDesign: convert text to table

Set Column Separator, Row Separator, and Table Style (more about InDesign Table Styles later - in part 3). In this case, the default is just fine. Click OK.
Import table from Word to InDesign: column and row separator

Here you have imported a Word table to InDesign, and you are ready to set the layout of your table.
Import table from Word to InDesign: Word table to InDesign

Method 2: Create a text frame and insert a table into InDesign

Of course, you can also draw a table in InDesign directly. This is probably the most common method to create a table in InDesign. Be aware, though, that you can also link a table in Excel to InDesign (I’ll show you that in part 2 of this series, after we’ve seen how to import an Excel file into InDesign).

Follow these instructions to draw a table in InDesign:

Create a text-frame in InDesign.
How to draw a table in InDesign: create the text-frame

Click on Table in the main menu bar and click on Insert Table...
How to draw a table in InDesign: Click on Insert Table

In the Insert Table windows, set the number of rows and columns you want in your table and click OK.
How to draw a table in InDesign: Click on Insert Table
As you see in the screenshot, you can also set the number of header rows, footer rows, and the Table Style. Header rows and footer rows are useful when you have a Table Style (more about this later - in part 3) or long tables that span over different text-frames.

This is how to draw a table in InDesign inside a frame-box. Of course, once you drew the table you can add or delete rows and columns (more on this below); you can drag and drop them to change their order; and you can assign a style to its cells.
How to draw a table in InDesign: InDesign Table created

Want to get better at InDesign?

Sign up today for free and be the first to get notified on new tutorials and tips about InDesign. Immediately get a useful InDesign Shortcut Cheat Sheet sent to your inbox.

Method 3: Import an Excel file into InDesign

You can import a spreadsheet directly from a file Excel into InDesign.

One of the advantages of using this method to create a table in InDesign is that your table comes formatted inside the InDesign document as it is in the Excel file. Then, of course, you can change its properties or assign a style in InDesign to make it more appealing.

Also, you can link the spreadsheet so that your document updates when there is a change in the Excel file (more on this later - part 2).

Follow these instructions to import an Excel file into InDesign:

Click on File in the main menu bar and click on Place...
Import an Excel file into InDesign: click on Place...

Check Show Import Options in the import window, select the file and click Open to import the Excel file into InDesign.
Import an Excel file into InDesign: Check Show Import Options

In the import, you can select many different variables, such as the Sheet to import, the Cell range, How to Format the Table, and so on. However, InDesign is smart enough to import your table correctly even if you don’t select anything and just click OK.
Import an Excel file into InDesign: select the file and click OK

Click OK and then draw a text-frame in InDesign to place your table.
Import an Excel file into InDesign: create the text-frame

This is how to import an Excel file into InDesign. Of course, once you have imported the table you can change the layout and styles of your table.
How to draw a table in InDesign: Excel into InDesign

Must-know InDesign Keyboard Shortcuts

Command  OS X Windows
Insert a table in InDesign Alt + Cmd + Shift + T Alt + Ctrl + Shift + T
Place a file (image, spreadsheet, etc) into InDesign Cmd + D Ctrl + D

In the next post (part 2)

Let’s say that you have a product catalogue or a price list and sometimes you need to apply changes to the product prices listed in a table.

In Part 2 we will use that example to see how to import a linking spreadsheet that you can update from Excel.

Be sure to subscribe to our newsletter to keep up with future posts or major updates. If you liked the post, I'd really appreciate you sharing it!

Stefano Bernardi
Stefano Bernardi

Stefano has worked on numerous mid to large–sized InDesign projects for Alstom, DeLonghi, Philips, and many others before starting Redokun in 2015.
As Redokun’s Co-Founder, Stefano spends most of his time helping customers to optimize their InDesign work-flow. He also holds in-house InDesign courses for companies in the Venice, Italy area.

19 Tips To Optimize Your InDesign File For Translation (Free eBook)

Free InDesign eBook
A short guide for InDesign users who work on multilingual projects. It'll give you an exhaustive look into the issue of creating an InDesign document ready for translation.

Get your multilingual projects done faster with Redokun. Free for 14 days.