Export all tables in a document in a csv file through batch script

[EON | Business Agency]

Hello everyone,

I'm working on a large catalog in Adobe InDesign that contains numerous tables, and I need to export all of these tables into optimized and formatted CSV file. Given the volume of tables, doing this manually is not feasible.

I’m looking for a way to automate this process using a batch script. Ideally, the script should:

1. Identify and export all tables in the InDesign document.
2. Ensure the CSV files are well-formatted and optimized.
3. Handle multiple tables efficiently within the same document.

Has anyone tackled a similar task or could provide guidance or a sample script to achieve this? Any help or pointers to relevant resources would be greatly appreciated!

Thank you in advance for your assistance!

Best regards,

[TᴀW]

What have you tried so far?

And, if the target is CSV, how do you intend to handle any cells that already have commas in them?

[EON | Business Agency]

Hi, I'm actually studying the scenario and not tried anything so far because I'd like to start with some guidance or suggestion. The aim is to export in csv but in reality the requested need (requested by my Client) was originally in Excel format...

[TᴀW]

CSV is probably similar. But again, how will you handle cells that have a comma in them already? There are quite a lot of suprising complications: https://en.wikipedia.org/wiki/Comma-separated_values

[Robert at ID-Tasker]

@EON | Business Agency

If you work on a PC - not a problem at all - with my ID-Tasker tool - but it's not free.

You can export any table(s) - in full or any part of it - in any way you wish - only specific "size" - number of columns / rows, from a specific layer(s), specific language, only right pages, wathever. 

You can also sort them before exporting. 

You can process a whole server full of INDD files - or only specific INDD files - in any order, etc. 

https://youtu.be/A_SMA3u7Lig?si=jblHl35078NXfJEi

[Robert at ID-Tasker]

@EON | Business Agency

Transferring data directly to Excel - also isn't a problem at all - as long as you have Excel installed on the same machine.

[EON | Business Agency]

Nope, Apple workstation here sorry