How to Create Tables in Adobe InDesign: The Ultimate Guide

As a designer, you know that tables are a pivotal tool for presenting certain types of information in a clear, organized way. From simple price lists to complex financial data, tables allow us to communicate large amounts of content within a structured, visually digestible format.

While many people‘s go-to software for building tables is Microsoft Excel, savvy designers understand the importance of crafting tables within the same program that will house the final design. And when it comes to desktop publishing and layout, Adobe InDesign is the undisputed industry standard. In fact, over 79% of design professionals report using InDesign regularly (source: 2019 Creative Pro User Survey).

Thankfully, InDesign offers very robust tools for creating and customizing tables directly within your documents. Whether you‘re designing a product catalog, annual report, research paper, or magazine, knowing how to expertly work with tables in InDesign is essential.

In this article, we‘ll break down the three easiest ways to create a table in InDesign:

1. Creating a table from scratch
2. Converting text to a table
3. Importing tables from Microsoft Excel

We‘ll walk through the steps for each method and share pro tips and keyboard shortcuts to streamline the process. We‘ll also dive into advanced techniques for editing and formatting tables, including using InDesign‘s powerful Table and Cell Styles.

By the end of this article, you‘ll be able to confidently build and format beautiful tables in InDesign that elevate your document designs. Let‘s jump in!

Method 1: Create a Table from Scratch in InDesign

Building a table from the ground up in InDesign is quick and easy. Here‘s how:

1. Select the Type Tool (T) and click an insertion point on the page, or create a new text frame using the Type Tool or Frame Tool (F).

2. Go to Table > Insert Table (or Table > Create Table if the cursor is not already inside a text frame).
   Pro Tip: Memorize the handy keyboard shortcut Command + Option + Shift + T (use Ctrl instead of Command on PC).

3. In the Insert Table dialog box, specify the number of Body Rows and Columns, plus any Header, Footer, or Left/Right columns if desired. You can also choose to apply a Table Style at this stage (more on that later!).

4. Click OK. The table will now be loaded in your cursor. Click once to insert the table at its default size, or click and drag to customize the table dimensions. Clicking inside the page margins will create a table that automatically fills the available space.

That‘s it! In just a few clicks you‘ve created a no-frills table ready for your content. But what if you‘ve already typed out the table data? Our next method will show you how to convert plain text into a table in seconds.

Method 2: Convert Text to a Table

Let‘s say you have a chunk of text that‘s formatted as a pseudo-table using tabs, commas, or other separators between each cell‘s data. Instead of retyping it all as a new table, you can simply convert the text to a table!

Fun Fact: Converting text to tables is a common task in the publishing world. Manuscripts submitted by authors often contain "tabular" data formatted with makeshift separators. Being able to quickly convert these sections to proper tables is a huge time-saver for editors and designers.

Follow these steps to turn text into a table:

1. Using the Type Tool (T), select the text you want to convert, including any separator characters.
   Pro Tip: Tables can be created from text in any linked or embedded text file, not just from text in the layout. So you can convert text in an imported Word or RTF document too!

2. Go to Table > Convert Text to Table.

3. In the dialog box, choose the Column and Row Separator characters that match your text. InDesign will automatically detect the most common separators (like tabs and commas), but you can select any single character.
   Important: The Column and Row separators must be different characters, or InDesign won‘t be able to parse the text correctly.

4. If you‘ve already created Table or Cell Styles (see below), you can choose to apply them here.

5. Click OK to instantly transform your text into a table! The table will adopt the basic text formatting of the converted text.

So easy, right? This trick is a favorite among book and magazine designers who often have to wrangle large amounts of unformatted tabular text.

But what if your data is already living in a spreadsheet? No worries – InDesign can import Microsoft Excel tables in a snap!

Method 3: Import Tables from Microsoft Excel

Many designers prefer to organize and edit large data sets in Microsoft Excel before building their tables in InDesign. Luckily, InDesign plays very nicely with Excel and can import spreadsheets seamlessly with just a few clicks.

To place an Excel table into your InDesign layout:

1. Go to File > Place, or use the keyboard shortcut Command + D (Ctrl + D on PC). Browse to locate your Excel (.xls or .xlsx) file.

2. In the Place dialog box, make sure "Show Import Options" is checked, then click Open.
   Pro Tip: You can also drag and drop an Excel file directly from your computer folder into InDesign. Just hold Shift before dropping to open the Import Options!

3. In the Microsoft Excel Import Options dialog box:

   • Choose the Sheet and Cell Range you want to import. InDesign will automatically detect the range of cells that contain data.
   • Select either "Formatted Table" to preserve the Excel formatting, or "Unformatted Table" to apply InDesign formatting later (recommended if you plan to use Table or Cell Styles).
   • Select any other desired options, like whether to import column/row dimensions or maintain links to the Excel file (more on that in a sec). Then click OK.

4. Your Excel data will now be loaded into InDesign as a table! Click once to place it at the default size, or click and drag to create a custom-sized text frame containing the table.

The beauty of this method is that you can choose to link the imported table to the original Excel file. That way, if the data gets updated in Excel, you can simply update the link in InDesign and the table will automatically sync!

To enable this option:

1. Go to InDesign > Preferences > File Handling (PC: Edit > Preferences > File Handling).
2. Under "Create Links When Placing Text and Spreadsheet Files", select "Always".
3. Click OK.

Now when you place an Excel file, the Link icon will appear in the Links panel. Anytime you update the Excel file, InDesign will prompt you to update the link.

With linked tables, your team can delegate spreadsheet editing to the Excel experts while the design team focuses on making the tables look amazing in InDesign. It‘s a win-win!

Speaking of making tables look amazing, let‘s explore how to use InDesign‘s powerful editing and formatting features to take your tables to the next level.

Editing Tables in InDesign

Once you‘ve created a table using one of the above methods, you‘ll likely need to make some tweaks to the content and structure. Here are some of the most common editing tasks and how to perform them:

Edit Cell Content

To edit the content of a table cell, simply double-click the cell with the Type Tool. You can also tab through cells or use the arrow keys to navigate. Edit the cell text using the same methods you‘d use with any other text in InDesign.

Customize Row/Column Size

To change the width of a column or height of a row, hover your mouse over the right edge of a column or bottom edge of a row. When the cursor changes to a double arrow icon, click and drag to resize. Hold Shift while dragging to resize all rows/columns simultaneously.

Insert/Delete Rows & Columns

Need to add or remove rows or columns? Right-click inside the table and choose "Insert" or "Delete" from the contextual menu. You can also go to Table > Insert or Table > Delete.

Pro Tip: To quickly add rows, place your cursor in a cell, then press Tab to jump to the next cell. When you reach the last cell and press Tab, a new row will be added automatically!

Merge/Split Cells

To merge multiple cells into one, select the cells with the Type Tool, right-click, and choose "Merge Cells". To split a cell, right-click it and choose "Split Cell Vertically" or "Split Cell Horizontally".

Customize Strokes and Fills

Jazz up your table with custom strokes (lines) and fills (background colors). Use the Stroke and Fill tools in the Toolbox or Control Panel to select colors and stroke weights. You can apply these to individual cells or to the entire table.

Using Table and Cell Styles

To save time and ensure consistency when formatting tables, turn to InDesign‘s Table and Cell Styles. Think of them like Paragraph and Character Styles, but for tables! You can define attributes like fonts, strokes, fills, cell insets, and more, then apply them to any table with a single click.

To create a new Table or Cell Style:

1. Open the Table Styles or Cell Styles panel (Window > Styles > Table Styles / Cell Styles).

2. Click the Create New Style button at the bottom of the panel.

3. Double-click the new style to open the Style Options dialog box.

4. Configure the formatting settings you want to include in the style. You can even create different formatting for alternating rows or columns!

5. Click OK to save the style.

To apply a style to a table, simply click inside the table and then click the style name in the Table or Cell Styles panel. You can also choose to apply the style when you first create a table.

The real magic of Table and Cell Styles is how easy they make it to change formatting across multiple tables. Just edit the style definition and all tables using that style will instantly update!

Imagine you‘ve used a Table Style to format 25 tables in a catalog layout. Your client asks you to change the header row background color from blue to orange. Instead of manually reformatting each table, you simply edit the Table Style – and voila! All 25 tables are updated with the new header color. That‘s the power of styles!

Sharing Table and Cell Styles

Here‘s a cool InDesign feature you may not know about: you can export Table and Cell Styles to share with colleagues or use in other documents. This is a huge advantage for creative teams who need to maintain design consistency across projects.

To export a Table or Cell Style:

1. Open the Table or Cell Styles panel flyout menu and choose "Save Style".
2. Choose a location, give your style file a name, and click Save. The style will be saved as a .itas (InDesign Table Style) file.

To import a Table or Cell Style into another InDesign document:

1. Open the Styles panel menu and choose "Load Styles".
2. Navigate to the .itas file and click Open.

The imported Table or Cell Style will now appear in your Styles panel, ready to be applied to any table.

By sharing and syncing styles, your team can create cohesive, branded tables across all your documents, even when working with a large group of designers.

Level Up Your Table Skills

We‘ve covered the essentials for creating and formatting tables in InDesign, but there‘s always more to learn! Here are some resources for diving deeper into advanced table tools and techniques:

• Adobe‘s official InDesign Tables tutorial: https://helpx.adobe.com/indesign/using/creating-tables.html
• InDesign Secrets article on table tips and tricks: https://indesignsecrets.com/tips-for-editing-tables-in-indesign.php
• Lynda.com course on InDesign Tables In Depth: https://www.lynda.com/InDesign-tutorials/InDesign-Tables-Depth/533180-2.html

Remember, the best way to master InDesign tables is to practice, experiment, and continuously challenge yourself to create more complex table designs. Don‘t be afraid to tinker with settings and explore all the panels and dialog boxes. The creative possibilities are endless!

Conclusion

We‘ve explored the three easiest ways to create tables in InDesign: from scratch, from converted text, and imported from Excel. We‘ve also walked through essential editing tasks and discovered how to harness the power of Table and Cell Styles.

With your newfound table expertise, you can design impressive tables for everything from scientific reports to retail catalogs to financial statements. Your clients and colleagues are sure to be wowed by your proficiency and attention to detail!

So get out there and start building some beautiful tables. And don‘t hesitate to share your own tips, tricks, and questions in the comments below.

Happy table making!