Mobile app version of vmapp.org
Login or Join
Angela777

: How to import a Microsoft table into InDesign without editing? I am creating a wine portfolio in InDesign and have been given an Excel .doc file with various columns filled with data (name,

@Angela777

Posted in: #AdobeIndesign #ParagraphStyles #Tables

I am creating a wine portfolio in InDesign and have been given an Excel .doc file with various columns filled with data (name, description, country of origin) and want to know the quickest way to import all these, without them being in a table. Then I need to be able to apply paragraph and character styles to it, as the various columns will need to be editable as separate paragraphs. How can I import a table from an Excel document into InDesign with little editing needed?

10.02% popularity Vote Up Vote Down


Login to follow query

More posts by @Angela777

2 Comments

Sorted by latest first Latest Oldest Best

 

@Turnbaugh909

The way we do this here is to:


have matched paragraph and character styles between the MS product and InDesign
write an Applescript which will then clear overrides and set the table formatting to match the desired appearance

10% popularity Vote Up Vote Down


 

@Welton168

Well, you can import external objects into InDesign in a easy way. If I remember correctly, you can do it with the shortcut Ctrl+D (Cmd + D on Mac). When you do that, there is a window with options for the Import features where you can customize the way you do it. There are options for tables, where you can keep the original format, or use plain text, or csv, etc. In fact I only import text from MS Word, not from excel, but perhaps is the same way.

But remember it's fair to say that the design and implementation of informative and visually appealing tables is one of the most difficult and time-consuming pieces of document creation for any word processing, desktop publishing, or professional typesetting system.

So, the easy or the lazy way of import a table perhaps won't be the best.

10% popularity Vote Up Vote Down


Back to top | Use Dark Theme