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

Data Merge from Excel

New Here ,
Aug 12, 2022 Aug 12, 2022

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
1.3K
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 , 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/

 

Translate
LEGEND ,
Aug 12, 2022 Aug 12, 2022

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

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

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 (ACI and ACE 1995-2023)
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
Engaged ,
Aug 12, 2022 Aug 12, 2022
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
LEGEND ,
Aug 13, 2022 Aug 13, 2022
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. 

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 ,
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/

 

David Creamer: Community Expert (ACI and ACE 1995-2023)
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 ,
Oct 24, 2022 Oct 24, 2022

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. 

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

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 (ACI and ACE 1995-2023)
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 ,
Oct 24, 2022 Oct 24, 2022

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.

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

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

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

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

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

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

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

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

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

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

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