How do I put an excel spread sheet in

I have a lot of info I would like to put into an array from a spreadsheet but not sure how to.

I have tried Rex's plug ins but can't get them to work it just downloads as a 7z file.

Any help would be great, cheers.

Try looking up "parsing", and see if there are any examples.

A method I've used before is as follows:

Export the spreadsheet as a .csv

Import it as a project file and read the contents with AJAX (or alternatively load it from disk via nw.JS)

Parse the values you need by using the tokenat expression, using newline and commas as your token separators

(You may also want to use the replace() system expression to take out all the quotations marks in your file if you have them).

I have a Java program that parses all of our spreadsheets from csv files into a nice Json file.

But "parsing" is the short answer.