Skip navigation
williambub
Currently Being Moderated

Excel into InDesign

Jan 23, 2013 9:17 AM

Tags: #excel

I have an excel document that I want to put into InDesign. There are 200 entries, each in their own cells.

 

I want the InDesign formatting to end up looking like this: (all 200 entries on their own lines and all on one page)

 

<<TIME>>......<<NAME>>

<<TIME>>......<<NAME>>

<<TIME>>......<<NAME>>

<<TIME>>......<<NAME>>

<<TIME>>......<<NAME>>

<<TIME>>......<<NAME>>

<<TIME>>......<<NAME>>

 

Is there a way to do this with datamerge? Or is there another preffered method?

 

Please ask any questions you need to

 
Replies
  • Currently Being Moderated
    Jan 23, 2013 9:22 AM   in reply to williambub

    Is the spreadsheet currently arranged with the names and times in columns?

     
    |
    Mark as:
  • Currently Being Moderated
    Jan 23, 2013 9:32 AM   in reply to williambub

    Place the excel file, with import options selected.

     

    Choose to place as Unformatted Tabbed Text

     

    You can then select all the text, and add a leader of one period to the centeral tab. Adjust the placement of your tabs, and you're done.

     
    |
    Mark as:
  • Currently Being Moderated
    Jan 23, 2013 9:37 AM   in reply to SRiegel

    I don't see a reason not to do it with Data Merge, if you want to. Set the placeholder for the time, then a right indent tab (Shift + Tab) and then the placeholder for the name.  I prefer a custom underline applied to the tab over the leader -- much more flexibility for weight and positioning.

     

    Do a multiple records per page merge.

     

    The disadvantage here is that each line will be in its own text frame.

     
    |
    Mark as:
  • Currently Being Moderated
    Jan 23, 2013 9:54 AM   in reply to Peter Spier

    By his description, a Place command followed by tagging with a dot leader paragraph style would seem to make more sense.

     
    |
    Mark as:
  • Currently Being Moderated
    Jan 23, 2013 10:20 AM   in reply to Michael Witherell

    I don't see any reason not to do it that way, either.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points