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

Data Merge from Excel

New Here ,
Aug 12, 2022 Aug 12, 2022

Copy link to clipboard

Copied

Working on the price catalog for approximately 2000s items from the excel sheet. Is there a feature that would link InDesign to a spreadsheet or comma delimited file to pull in pricing based on an item number(like vlookup)?

TOPICS
How to , Import and export , Scripting

Views

443

Translate

Translate

Report

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 , Aug 13, 2022 Aug 13, 2022

Em Software was already mentioned. 

Here are the websites for the companies I mentioned:

 http://emsoftware.com/

https://www.65bit.com/

https://www.teacupsoftware.com/

 

Votes

Translate

Translate
Community Expert ,
Aug 12, 2022 Aug 12, 2022

Copy link to clipboard

Copied

No. Only through script. What platform - PC or Mac? 

ID-Tasker - most powerful tool ever created for InDesign

Votes

Translate

Translate

Report

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 ,
Aug 12, 2022 Aug 12, 2022

Copy link to clipboard

Copied

I would look at database plug-ins such as Em software, 65-bit software,, teacup software, and others. They will do what you want and can even hook directly into the main database if desired.

David Creamer: Community Expert, Adobe Certified Instructor, and Adobe Certified Expert (since 1995)

Votes

Translate

Translate

Report

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
Contributor ,
Aug 12, 2022 Aug 12, 2022

Copy link to clipboard

Copied

Votes

Translate

Translate

Report

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 ,
Aug 13, 2022 Aug 13, 2022

Copy link to clipboard

Copied

quote

InCatalog at http://emsoftware.com/products/emcatalog/.


By @Olivier Beltrami

 

If it's one time job and simple price update - custom script will be much cheaper. 

ID-Tasker - most powerful tool ever created for InDesign

Votes

Translate

Translate

Report

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 ,
Aug 13, 2022 Aug 13, 2022

Copy link to clipboard

Copied

Em Software was already mentioned. 

Here are the websites for the companies I mentioned:

 http://emsoftware.com/

https://www.65bit.com/

https://www.teacupsoftware.com/

 

David Creamer: Community Expert, Adobe Certified Instructor, and Adobe Certified Expert (since 1995)

Votes

Translate

Translate

Report

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 ,
Oct 24, 2022 Oct 24, 2022

Copy link to clipboard

Copied

Hello David, Do you know of any newer software plugin's? These seem very outdated, or maybe it'a just all of their Tutorial videos are old. I'm currently exploring Catalog data merge and stubbled upon this thread. 

Votes

Translate

Translate

Report

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 ,
Oct 24, 2022 Oct 24, 2022

Copy link to clipboard

Copied

I'm assuming they are updated but Em Software is the only one listing the current ID version (2022, not 2023 yet). 

I did notice that 65bit's YouTube demos are about 8 years old but I assume the process hasn't changed much. 

 

David Creamer: Community Expert, Adobe Certified Instructor, and Adobe Certified Expert (since 1995)

Votes

Translate

Translate

Report

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 ,
Oct 24, 2022 Oct 24, 2022

Copy link to clipboard

Copied

Thanks David. I will contact Emsoftware. This is really helpful. I'm kind of amazed that there's not more information on this solve. Everyone must be holding tight to their workflow secrets. LOL.

Votes

Translate

Translate

Report

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
Explorer ,
Jan 23, 2023 Jan 23, 2023

Copy link to clipboard

Copied

If you are on Mac then give MyDataMerge a try. Does a pretty good job, is up to date and we use it for years

Votes

Translate

Translate

Report

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
Explorer ,
Jan 23, 2023 Jan 23, 2023

Copy link to clipboard

Copied

Votes

Translate

Translate

Report

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
People's Champ ,
Jan 24, 2023 Jan 24, 2023

Copy link to clipboard

Copied

Wow @johnathanFrakes That's an amazing solution that you built. Congrats.

Votes

Translate

Translate

Report

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
Explorer ,
Jan 25, 2023 Jan 25, 2023

Copy link to clipboard

Copied

Its not my solution ... its a solution we use and that does the Job ... 

Votes

Translate

Translate

Report

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
Engaged ,
Oct 24, 2022 Oct 24, 2022

Copy link to clipboard

Copied

I think it is possible to place xml after converting excel data to xml.
Look it up in InDesign and XML.

Votes

Translate

Translate

Report

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 ,
May 24, 2023 May 24, 2023

Copy link to clipboard

Copied

LATEST

Hi, did you manage to solve your issue? If so, which method did you end up using? I have a similar problem..

Votes

Translate

Translate

Report

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