Excel Import - usnistgov/NEMO GitHub Wiki

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