- 3 minutes to read

Use API in Excel with Power Query

Export Nodinite Log View results directly into Microsoft Excel using Power Query. This guide walks you through downloading Power Query, obtaining the API URL from a Log View, authenticating, parsing JSON, and selecting the exact fields to import.

✅ Follow step‑by‑step, no coding required.*
✅ Preserve structured JSON data for further analysis in Excel.*
✅ Use your existing Nodinite credentials and access controls.*

Instructions

Download Power Query

Click Microsoft Power Query for Excel^{to download the installer for 64‑bit or 32‑bit, in your preferred language.

Download Power Query installer.}

Copy API URL

After you run a search in a Log View, use the Copy API URL option to get the direct request URL.

Open the Log View menu and choose "Copy API URL".

Paste the copied URL when prompted in Power Query.

Example of a copied API URL ready for Power Query.

Excel

From web

Open Excel, go to the Power Query tab, and click "From web".

Select "From web" to provide the API URL.

Paste URL

Paste the API URL you copied from the Log View.

Paste the full API URL here.

Authentication

Choose "Windows" and then "Use alternative authentication".
Log in with your Nodinite user name and password.

Authenticate using your Nodinite credentials.

Parse to JSON

Go to the "Transform" tab, click "Parse", and choose JSON to convert the response to structured records.

Parse the response to JSON to expand records and arrays.

Choose Data

If the dataset is large, filter or limit the query so the results fit in Excel. In this example we limit the selection.

Use filters or limiters to reduce the payload size.