Skip to main content
helenb35342640
Known Participant
July 31, 2023
Question

creating a product price list using data merge

  • July 31, 2023
  • 1 reply
  • 923 views

I am trying to find a solution to improve work flow in the company I work for, and researching whether data merge could work in this case. There is a product price list that is updated fairly regular, the currecnt process can be a bit laborious and error prone.

So I was hoping we could set up a excel doc that they fill out with new products/ price updates then we simply export the file. I tried the a set up below with no luck. Is there a way to do this correctly? 
Thanks

 

  

This topic has been closed for replies.

1 reply

D. Schulte
Participating Frequently
July 31, 2023

You have to export the Excel sheet as tab-delimited (.txt) or comma-delimited (.csv) and import this as data source using the Data Merge panel in InDesign. Then you can set the placeholders. Should be no problem.

helenb35342640
Known Participant
July 31, 2023

This is how it comes out how its set up now, it just takes the first line of info.