-
Notifications
You must be signed in to change notification settings - Fork 64
Excel Import
Mathieu Rampant edited this page Sep 14, 2020
·
7 revisions
The REST Api data can be imported directly in Excel.
- Find the data you want in NEMO, then:
- click
GET
and choosejson
. - right click and
Save as
to save the file. - open Excel and create a new blank workbook
- navigate to
Data
and clickGet Data
>From File
,JSON
and select the previously saved file.
- Open Excel and create a blank workbook
- Navigate to the
Data
tab and chooseFrom 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
, thenok
- 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