We've got a problem trying to get data from InDesign over to Excel.
There's this pricelist in InDesign, with images and small "icons" (also images) that indicate which item is displayed as the main image for each row in the table. Each "table row" can contain a number of items, separated by Carriage Return + Line Feed or similar combination.
The problem is that we can't get good data and images to appear in any other editable format. Copying and Pasting directly into Excel has yet been the most successful, but there the images are lost. Exporting to PDF and from Acrobat Pro exporting to other formats always seem to fail in one way or another (tables are put on top of each other, images lost and so on, different for different export formats).
The data copied to OpenOffice Calc (then saved as an excel format file). Yellow areas added to show where the images were in InDesign.
Prices blurred in the illustrating image above.
Are there any good ideas how to copy the InDesign table to another editable format (that doesn't require Adobe licenses...)?
I think RTF is the only text-based export format from InDesign that supports inline/anchored images. (Err, other than IDML/IDMS/ICML/ICMA, which I think do not count.) Have you tried it?
I see it's in your thread title, but it is not mentioned in your narrative.
I had not noticed the direct export from InDesign to RTF. You had to put the cursor inside the story to make that option appear!
It looks really good, and I've sent the result on, to the ones who are going to use it, for them to check whether it's good enough, and if they can take it on to excel or work with it in the RTF format as it is.
Thank you so much for pointing out this option!