Link Excel data to InDesign Table

Question

I'm curious if this is possible. I want to use an existing InDesign table and populate the cells with data from Excel. Placing it causes me to edit the table afterward or create styles to match what's there and it still requires a bit of tweaking before it's perfect. There could be hundreds of rows in these tables and I don't want to do that row by row. Is there a way to link the cells from the InDesign table to Excel? Is it possible to save this InDesign table into Excel to make the arrangement of data easier on the excel side? I think I just want to understand my options. See attached image for an understanding of what the table looks like.

Laubender · Accepted Answer

Hi @Nathan25613644nu5b ,don't know if this is relevant and I really hope, it is not:Your screenshot is showing a table with a cell that contains an anchored frame with another table. A construction like that will fail in many ways if you like to update table contents! Regards,Uwe Laubender( Adobe Community Professional )

BobLevine · Answer

David is right but I will add that you can...and might want to...format the table completely in Excel and place it as a formatted table. This is particularly helpful if you're only doing one or two and don't want the hassle of setting up the table / cell styles.

Without knowing more, I can't even come close to telling you if that's the way to go for you.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded