Skip to main content
R
Ramona2504
Participant
January 9, 2020
Question

Export product numbers and descriptions to Excel

  • January 9, 2020
  • 1 reply
  • 213 views

Hi everybody!

I just started to create a new catalogue and would like to export all the product numbers and descriptions to a list, preferably Excel. I've formatted these fields in the paragraph styles and I can create an Index, but for this I don't need text and a page number, but 2 texts without a page number. Is there any way to create a list like this or a script? 

 

I know I could create 2 lists using the Index function and then merge them in Excel afterwards, but maybe there is a faster solution... 

 

Thanks!

This topic has been closed for replies.

1 reply

S
S Hopkins
Inspiring
January 14, 2020

Hi, 

You can definitely do it with a script. But if that's not your thing, you can do something with creative use of Table of Contents. Although I write scripts, just for testing I created a table of contents for two paragraph styles in a recipe document. After doing a search and replace I exported the result to a plain text file. The result was tab/paragraph delimited text having a tab between the first and second entries of a set and a paragraph return after the set. Imported the text file into Numbers on a Mac (similar to Excel). Worked like a charm. You might like to try it. 

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices