Excel Import

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 URL:

• 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"