Monday, April 09, 2007

Updating InDesign tables with new text

If you frequently use InDesign tables, you've probably encountered the need to update the data in a table without losing the table formatting. Here are two great solutions:

1. For InDesign CS and CS2, get the clever PopTabFmClip script from PDS Associates. Only $25, this handy script makes it effortless to copy a range of cells from an Excel spreadsheet, a Word table, or another InDesign table, and paste these the data from these cells into an existing InDesign table. All the cell, table and paragraph formatting of the destination table is faithfully preserved.

2. InDesign CS3 has much of this same capability built-in. It doesn't preserve merged cells and paragraph styles as nice as the PopTabFmClip script, but works well otherwise. For this to work, first choose Preferences > Clipboard Handling, and select When Pasting Text and Tables from Other Applications, Paste: Text Only. Then, copy a range of cells from an Excel spreadsheet, a Word table, or another InDesign table, select the table cell in the upper-left corner of where you want the new data to be pasted, and then choose Edit > Paste. The cell, table and paragraph formatting of the destination table is preserved.

(A quick way to select a single InDesign table cell is to click inside the table cell with the Type tool, and then hit the Esc key)

3 comments:

Scott said...

Hi Keith:

Just to add to your tip about using the Esc key to select a cell, double clicking with the Esc key toggles to select the text in the cell. Both are very handy when working with tables.

Meanwhile, congratulations on this blog and looking forward to stopping by now and then!

Scott

The Viper Design Studio said...

Thanks Keith, just found this post and it seems like they have a lot of nice scripts for Indesign now.

Unknown said...

I know this is a very old post but I just wanted to say thank you! I have been combing through the internet to find a solution to this problem and you method worked!

Thank you that you thank you