Excel to JSON through Indesign

[Asuvath]

Hi,

Basically I am an Indesign script developer. I have an Excel content (attached), that content should be import into the Indesign Document. Excel document have multiple sheets. I have a code for import the JSON conent into the Indesign. So I plan to convert this Excel document into JSON and I will plan use my code to import the content into Indesign.
Can anyone help me to suggest Javascript code for convert the Excel to JSON.

Thanks
Asuvath

[Mike Bro]

Hello @Asuvath,

you can try one of these two free online Excel to JSON converters for your needs...

https://products.aspose.app/cells/conversion/excel-to-json

https://beautifytools.com/excel-to-json-converter.php

Regards,

Mike

[Asuvath]

Thanks Mike,
Actually I expect to develop the script for complete the task instead of the user go and upload the files in browser everytime.

Thanks

[Mike Bro]

Hello @Asuvath,

Take a look at the links below...

http://kasyan.ho.ua/snippets/get_data_from_excel.html

https://lesterbanks.com/2019/11/how-to-read-and-write-json-files-with-extendscirpt/

Regards,

Mike

[Asuvath]

Hi Mike,
Thanks for the information. Actually we need to extract the content from Excel document and that content shoud be in JSON format. This is my requirement (see below screenshot). But in the given link, I unablet get required information, can you please advise?

 

[Charu Rajput]

Hello @Asuvath ,
May be you can try following if you are using the javascript.

https://stackoverflow.com/questions/27979002/convert-csv-data-into-json-format-using-javascript

[Asuvath]

Hi Charu,

I have an excel document instead of CSV, so the script holding in the given link is not working for me. Can you please guide us bit more relavent to Excel to JSON conversion.

Thanks
Asuvath