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)
Is there a way to do this with datamerge? Or is there another preffered method?
Please ask any questions you need to
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.
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.
Europe, Middle East and Africa