How do i get a large amount of text & table imported from excel to Indesign?

Posted on 2008-11-11
Last Modified: 2013-12-02
I have a directory of real estate listing's on an excel spreadsheet. Our printer uses Indesign to place the information onto our brochures. The proofing system we have is a nightmare and I rather do it myself. What do I need to know about Indesign to learn how to import all that data & tables from an excel spreadsheet and be able to go back to it at any time to update changes to text & tables?
Question by:designster74
    1 Comment
    LVL 12

    Accepted Solution

    You can just cut and paste from word/excel to indesign but there are 2 catches; When you import (place) a word doc it does not link, so that if the word doc is updated, the indesign doc isn't (by default). To change the import behavior to link to the word doc you should click Edit>Preferences (PC) or InDesign>Preferences (Mac) then in the Type category check Create Links When Placing Text and Spreadsheet files.
    Also, when copy/pasting you have control over whether formatting travels with the copied data, or just the raw data gets pasted without formatting; You'll find control over that feature under Preferences > Clipboard Handling > When Pasting Text and Tables (All Info/Text Only).

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now