Skip to content
Mathieu Rampant edited this page Sep 14, 2020 · 7 revisions

The REST Api data can be imported directly in Excel.

Using json file:

* Find the data you want in NEMO, then:
* click "GET" and choose "json". 
* right click and "Save as" to save the file.
* open Excel and create a new blank workbook
* navigate to "Data" and click "Get Data" > "From File", "JSON" and select the previously saved file.

Using web query:

* Open Excel and create a blank workbook
* Navigate to the "Data" tab and choose "From Web"
* Enter the full URL like https://nemo.nist.gov/api/billing?start=9/1/2019&end=9/30/2019
* Authenticate using the authentication method you set up in NEMO
* Click "Connect"
* Click "To Table", then "ok"
* Click on the expand icon next to "Column1"
* Uncheck "Use original column as prefix"
* Confirm
* Make any transformations you like, then click on "Close and load"