Excel Import

The REST Api data can be imported directly in Excel.

1. 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.

2. 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"