Need help parsing a excel doc to create separate tables.

[OSRAMhelp]

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?

[brian_p_dts]

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? 

[OSRAMhelp]

Hi!

I tried DataMerge but it inputs everything. I'm creating a separate table for each district. The naming convention for districts isn't uniform.

[brian_p_dts]

I would just Filter by store in your Excel doc, get a Table Style setup the way you want it, hide the name/copy it intot the region section, and copy them in that way. I assume each table is on its own page? Creating the whole set of tables could be done by scripting, but it's not really a trivial task. I'd be happy to help for a nominal fee. 

[OSRAMhelp]

I wish I had a budget to ask for help, but I don't. I am right now copying and pasting like you said but there's over 7000 lines which is just taking forever. I wish there some kind of script I could write to tell it to grap data with district number # and leave the others alone.

[Jeffrey_Smith]

Untested, on this indesignsecrets article, in the comments section (5th from bottom), David posts a link to a script that splits tables.

[OSRAMhelp]

Thank you I'm gonna give it a try.