How to Automate Price Import from Excel into InDesign for a Simple Catalog

[Dalbo36171778rodn]

Hi. 
I have a pricelist which is set up in Indesign with item no. 
In a separate Excel file, I have the prices which I wish to match up with the correct item no.
The list of prices is not sortet chronologically so that it matches the layout of the indesign file. 

Is there any way that I can do this automatically, or do I need to type in the prices manually?

Thank you.

<Title renamed by MOD>

[Abhishek Rao]

Hi @Dalbo36171778rodn,

Thank you for reaching out! I understand how time-consuming it can be to manually match up prices with item numbers. 

Could you let me know which version of InDesign and operating system you’re using? That will help me tailor the solution for you.

One potential option is to use Data Merge in InDesign, which allows you to import data from an Excel file and automatically match it with corresponding fields in your layout. To do this, you’ll need to ensure that the item numbers in both InDesign and Excel match, so they can be aligned correctly. Sorting your Excel file by item number before merging will help with the process.

Reference article: Merge data to create form letters, envelopes, or mailing labels in Adobe InDesign

If you need any further guidance on setting this up, feel free to ask!

Thank you, 
Abhishek Rao

[Robert at ID-Tasker]

@Dalbo36171778rodn

Everything depends ion the layout / design - can you post some screenshots? With edges of the frames visible and where all the data should go.