Skip to main content
Joe90galaxy
New Participant
June 6, 2022
Answered

Indesign data merge complete row from excel file

  • June 6, 2022
  • 1 reply
  • 563 views

I want to import a complete row from my excel file with data merge into indesign with the correct fonts and spacing setup in indesign?

 

Is this possible? 

This topic has been closed for replies.
Correct answer Peter Spier

The way DataMerge works is you creat a text frame into which you add the fields for the data you want to merge. Only one record (row of your data file) is added per text frame.

There are two types of merges, one record per page, and multiple records per page. For a multiple record, you create one instance of your merge fields in the upper left position, set up margins and spacing parameters, and InDesign duplicates the merge fields according to the spacing as many times as they will fit inside the margins you defined. A large frame will not duplicate because there is insufficent room. Other content on the page may also interfere with a multiple record merge.

All this makes DataMerge a pretty basic function and not particularly good for complex layouts such as I think you are trying to produce.

I'm not familar withthe script you mention, but I googled it and it looks like it might be a better bet, if it still works in your version of InDesign. The writers are legendary, and it's had good write-ups in reliable places.

For really complex catalog work there are also commercial catalog plugins available.

 

1 reply

Peter Spier
Adobe Expert
June 6, 2022

Not sure waht the question is here -- your screen shot looks like you've already got this figured out.

Joe90galaxy
New Participant
June 7, 2022

It only imports the first row of information. I need it to import the hole column. Is this possible?

 

Can I use a script like CSV2TABLES.jsx to import complete table columns?

Peter Spier
Peter SpierCorrect answer
Adobe Expert
June 7, 2022

The way DataMerge works is you creat a text frame into which you add the fields for the data you want to merge. Only one record (row of your data file) is added per text frame.

There are two types of merges, one record per page, and multiple records per page. For a multiple record, you create one instance of your merge fields in the upper left position, set up margins and spacing parameters, and InDesign duplicates the merge fields according to the spacing as many times as they will fit inside the margins you defined. A large frame will not duplicate because there is insufficent room. Other content on the page may also interfere with a multiple record merge.

All this makes DataMerge a pretty basic function and not particularly good for complex layouts such as I think you are trying to produce.

I'm not familar withthe script you mention, but I googled it and it looks like it might be a better bet, if it still works in your version of InDesign. The writers are legendary, and it's had good write-ups in reliable places.

For really complex catalog work there are also commercial catalog plugins available.