Skip navigation
williambub
williambub Calculating status...
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

419 Views   8 Replies   Latest reply: williambub, Jan 23, 2013 10:39 AM
 
Replies
  • Peter Spier
    Currently Being Moderated
    1. Peter Spier,
    Jan 23, 2013 9:22 AM   in reply to williambub
    Report

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

     
    |
    Mark as:
  • williambub
    Currently Being Moderated
    2. williambub,
    Jan 23, 2013 9:23 AM   in reply to Peter Spier
    Report

    Yes. the times are in one column and the name in the next

     
    |
    Mark as:
  • williambub
    Currently Being Moderated
    3. williambub,
    Jan 23, 2013 9:25 AM   in reply to williambub
    Report

    Also, the elipse needs to span the space between, to fill the whole width of the column

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

    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:
  • Peter Spier
    Currently Being Moderated
    5. Peter Spier,
    Jan 23, 2013 9:37 AM   in reply to SRiegel
    Report

    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:
  • Michael Witherell
    Currently Being Moderated
    6. Michael Witherell,
    Jan 23, 2013 9:54 AM   in reply to Peter Spier
    Report

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

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

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

     
    |
    Mark as:
  • williambub
    Currently Being Moderated
    8. williambub,
    Jan 23, 2013 10:39 AM   in reply to SRiegel
    Report

    The unformatted tabbed text option is incredibly helpful

     
    |
    Mark as:
Actions

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