Participant

Answered

Importing Excel Cells Into Existing InDesign Tables?

Forum|Forum|8 years ago
July 18, 2017
3 replies
6707 views

Hello

I'm trying to convert a product catalog (made in InDesign CC) into a price list, by adding a column at the end of each table with the price.

For this column, I want to import data from a linked excel file with the prices, so that updating the pricing will be easy.

I know you can create tables from excel files but can you add excel data to an existing InDesign table?

Any help would be much appreciated!

This topic has been closed for replies.

Correct answer JonathanArias

bring the table in, and apply your table style next. in the table styles set up all of your character styles for header, footer and body.

You than can select the rows and columns and convert to header, rows and body. now that is all set up, when you update the linked excel sheet things will sync. You have to tell indesign which are the headers, body and footers so it knows going forward.

Everything you will ever want to know about tables is here ( Diane Burns goes over everything):

InDesign: Tables

JonathanAriasCorrect answer

Legend

bring the table in, and apply your table style next. in the table styles set up all of your character styles for header, footer and body.

You than can select the rows and columns and convert to header, rows and body. now that is all set up, when you update the linked excel sheet things will sync. You have to tell indesign which are the headers, body and footers so it knows going forward.

Everything you will ever want to know about tables is here ( Diane Burns goes over everything):

InDesign: Tables

JonathanArias

Legend

how about if you set your excel document first. bring in all of the tables and rows content from the indesign document in to that excel table, add the column and pricing to it the way you want it to match. now you have the excel document you will use going forward.

Go back to indesign, and import that in replacing everything. now you have the updated indesign document and an working excel document to link and just update when needed. you will have to adjust your styles, but now everything matches.

D

dougs82250006Author

Participant

Thanks! That's what I'm planning on doing, I'm just trying to find the most efficient way to import the data so I don't have to make a million style changes every time I place a new table.

BobLevine

Community Expert

Unfortunately, there’s no way I know of to do this. You could try aligning a second table to the first and doing it that way, but it’s probably more efficient to do the entire table in Excel. Without seeing the layout and how large the file is it’s really difficult to recommend one over the other.

D

dougs82250006Author

Participant

Thanks for the response!

It's a 130 page catalog with most pages having at least 5 tables on it, so it's not exactly a small task.

So do you feel the best way to it is to just redo all the tables in excel and place them into the file?

I'm also having some trouble when I import tables, the style isn't the same as what I already have in the file.

Where would the setting be for the text styles when you place the table, I can choose a table style, but the font isn't what I want.

Thanks for the help!

BobLevine

Community Expert

Paragraph and character styles are included in the table/cell styles.

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