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:Identify and export all tables in the InDesign document.Ensure the CSV files are well-formatted and optimized.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,

Participant

Question

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

Forum|Forum|1 year ago
August 7, 2024
2 replies
991 views

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:

Identify and export all tables in the InDesign document.
Ensure the CSV files are well-formatted and optimized.
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,

This topic has been closed for replies.

Robert at ID-Tasker

Legend

@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

Legend

@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.

TᴀW

Legend

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?

Visit www.id-extras.com for powerful InDesign scripts that save hours of work — automation, batch tools, and workflow boosters for serious designers.

E

EON | Business AgencyAuthor

Participant

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

Legend

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

Visit www.id-extras.com for powerful InDesign scripts that save hours of work — automation, batch tools, and workflow boosters for serious designers.

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