InDesign Excel Table Imports

Question

I am using InDesign to try and create a Price List for the Business I work for - because of this I exported our price list from PDF to an XML file and then tried to import the tables into InDesign. However, it didn't come out like I wanted it to, the price list is about 64 pages long and takes a while to import but when it finally imports it comes out really weird. I need help on this - like is there anyway to only import certain tables or make new tables from these tables?

I know this is very confusing but any help is appreciated.

Cari Jansen · Answer

Just verifying:

You have an Excel spreadsheet that is a pricelist? As long as you have a continuous cell range that needs to be imported into InDesign this should work. You don't need to export to XML and import XML, you can use File > Place and select a cell range, then import this into InDesign (see steps below).

With the Type tool click in the text insertion point (a text frame in which you want to import the table)
Choose File > Open.
Select the Excel file, press Shift and click Open while pressing the Shift key.
In the Excel Import Options dialog that appears you can now select which cell range to import and also how you want to format the table on import.
Click OK, the table will be imported.

You might need to adjust column widths and specific cell formatting etc. You can use Table and Cell Styles for that in InDesign.

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