Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

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

New Here ,
Aug 07, 2024 Aug 07, 2024

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,

 

TOPICS
How to , Import and export , Scripting
736
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
People's Champ ,
Aug 07, 2024 Aug 07, 2024

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?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 07, 2024 Aug 07, 2024

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

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
People's Champ ,
Aug 07, 2024 Aug 07, 2024

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

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Aug 08, 2024 Aug 08, 2024

@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

 

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Aug 08, 2024 Aug 08, 2024

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

 

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 08, 2024 Aug 08, 2024
LATEST

Nope, Apple workstation here sorry 

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines