Need help parsing a excel doc to create separate tables.

Forum|Forum|6 years ago
January 8, 2020
1 reply
626 views

First time posting here so any help would be greatly apprecaited.

I have an excel doc that has over 7000 lines of data. The excel sheet contains data from multiple districts that need to be grouped together and placed inside a table in InDesign. Manually selecting each districts data (which ranges anywhere between 2 - 12 lines of data) and importing the data into InDesign is taking forever.

I know scripts are a powerful way to automate a task like this, but I am not very JavaScript savvy and have no idea where to start. Does anybody know what I should do?

This topic has been closed for replies.

brian_p_dts

Brainiac

Can you post an example of the spreadsheet with varying districts? Have you looked into using DataMerge? Are all the columns the same across the districts, or do some districts have different columns?