Excel in Indesign

Question

Wir erstellen mit Indesign 2022 einen Katalog mit ca 400 Produktfotos. Unter jedes Foto soll Art.Nr, Größe und Preis.

Frage: Ist es möglich und sinnvoll diese 3 Angaben (Nummer, Größe, Preis) aus Excel zu importieren. Grund für den Excel-Import: 1. Können dann Preise via Excel für den kompletten Katalog geändert werden? 2. Kann das Feld "Preis" via Excel für den kompletten Katalog gelöscht werden?( Katalogversion ohne Preise, nur Art.Nr. und Größe)?

Danke.

Kasyan Servetsky · Accepted Answer

Everything is possible to do by script.It is even possible to read data directly from Excel. Alternatively, a script can read data from CSV file exported from Excel.From your screenshot, I can't see -- invisibles are hidden -- if it's a table or tab-delimited lines of text.In any case, if Art. number is already present in the doc, it's fairly easy to find them by GREP and add/update prices/sizes which are in the same line/row taking the data from Excel.— Kas

Rishabh_Tiwari · Answer

Hi @Sebastian254108508ejg ,

Thanks for reaching out. I found a similar discussion which you can refer to here https://community.adobe.com/t5/indesign-discussions/link-and-update-excel-table-in-indesign/m-p/11434236#M395957

Let us know if this helps or if you need any further assistance.

Regards

Rishabh

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded