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

Knowing the scope of the project will certainly help determine what method may be more appropriate.

If this is a 2 page price-list with not many SKUs then a data merge solution or linked excel file solution may be workable.

If this is a 180pp catalogue then something like a catalogue plug-in such as

• Em Software's InCatalog;
• Cacidi Extreme;
• 65bit's EasyCatalog;
• Meadows PS' Designmerge Catalog;
• Teacup Software's Datalinker

These are paid plug-ins but they bridge the gap required to make full-fledged price/parts catalogues in InDesign

@Dalbo36171778rodn

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

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