Indesign BACK to Excel?

[FreefallJones]

Hi -- my office is switching to InDesign and I got to be the guinea pig and put together an entire magazine of nothing but InDesign charts converted from Excel tables. (which worked out perfect -- InDesign made the process very easy)

But now my editors want the final versions of the tables back in Excel form since they don't have InDesign.

Is there a way to convert tables in InDesign back to Excel?

 

[jimoblak]

There is a script somewhere on

http://studio.adobe.com

that might help here but I believe it simply exports the table data, not any styling that you have applied.

Why not return the original Excel tables?

- - picklefish - -
Why is everyone in this forum responding to me as picklefish?

 

[FreefallJones]

Hey all -- I actually found the answer to this if anyone ever runs into this situation. I give total credit to this answer to Russell Viers at

http://www.digiversity.tv.

Thanks, bro!

First the reason I needed to convert the InDesign tables back into Excel was because this was for a magazine and the InDesign table had final corrections to the data.

Our editors needed the final corrected data in an Excel format to re-input into our company database. So it's a big mess.

The process is ugly but kind of easy.

In Indesign you need to select all the data in the table. Then convert the table to text. After that, select all the text and then export it in Text Only format.

Then launch Excel and open the Text Only file you just created. A window should pop up -- select "Delimited" and then hit "Next" ...on the next window, check the "Tab" box and then hit "Finish."

All the information should be back in your basic Excel spreadsheet form.

I should note that when you open the Text Only file in Excel there are other options you can choose for formatting, but I gave the basic info.

 

[robiNETpl]

but,

if you have merged cells - InDesign doing bad conversion ...

... see my script - TableEdit I ...

robin

Scripts for InDesign

http://www.suwalski.pl/dtp

gg 3753393
Skype: indesignscripts