As an engineer, but not a programmer, I am looking for a simple way to import ICP Connection Data into Excel.
It appears there are two available data sources:
1 - For one off queries (which is typically me) -> http://www.ea.govt.nz/consumers/your-power-data-in-your-hands/my-meter
Once I query an ICP once via the website form, the data is downloadable at http://www.ea.govt.nz/assets/csv/(enter icp here).csv
Once this CSV is available online, import into Excel is simple. However it appears this is only generated once the ICP has been run through form at least once.
2 - API
The API appears cool, but I have no experience with these data sources and have has little luck online. Do you know if I can get Excel to query API and return data?
Maybe there is another option that I am not aware of that might work also?
Thanks a lot,