Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Indesign data merge complete row from excel file

New Here ,
Jun 06, 2022 Jun 06, 2022

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? 

329
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Community Expert , Jun 07, 2022 Jun 07, 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 t

...
Translate
Community Expert ,
Jun 06, 2022 Jun 06, 2022

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

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jun 07, 2022 Jun 07, 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?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jun 07, 2022 Jun 07, 2022
LATEST

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.

 

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines