Skip to content
English
Customer portal
Go to kudurrustone.com
  • There are no suggestions because the search field is empty.

Connecting Excel to the Kudurru Stone API

This article walks you through pulling your Kudurru Stone data directly into Microsoft Excel using Power Query (Get & Transform). Once connected, you can refresh the data at any time with a single click, no manual exports required.

Before You Begin

  • Your firm must have an active Premier Package subscription to use the Kudurru Stone API. If you are unsure, contact your account administrator.
  • You will need an API key. If you have not generated one yet, see Creating an API Key before continuing.
  • This guide requires Microsoft Excel for Microsoft 365. Power Query is built in — no additional software or downloads are needed.

Step 1 — Open the Power Query Web Connector

  1. Open a new or existing Excel workbook.
  2. Click the Data tab in the ribbon.
  3. Click Get Data → From Other Sources → From Web.

Note: If you do not see Get Data in your ribbon, your organization may have restricted this feature. Contact your IT administrator to enable Power Query.

Step 2 — Enter the API URL and Your Key

  1. When the dialog opens, select Advanced at the top (not Basic).
  2. In the URL parts field, enter:
    1. https://api.kudurrustone.com/api/v1/quotes
  3. Scroll down to HTTP request header parameters and click Add header.
  4. In the left box, type exactly: X-Api-Key
  5. In the right box, paste your API key.
  6. Click OK.

Step 3 - Filters and All Pages

  1. Click on Advanced Editor
  2. Paste in the Power Query code from above.  This code will allow all pages to load and allow you to add filters to the data.

Tip:  Be sure to replace the "YOUR_API_KEY_HERE" with your actual API Key

  • Follow the Filtering section above on how to add filtering and refer to our API reference for the available filters.  API Reference

 

Step 3 — Navigate to the Quote Data

Power Query will open and display the raw API response as a single record. Your quote records are nested inside the data field.

  1. In the Power Query editor, locate the row labeled data. You will see the word List to the right of it.
  2. Click List to drill into the quote records.
  3. In the ribbon, click the Transform tab, then click To Table.
  4. Leave the default settings in the dialog that appears and click OK.

Step 4 — Expand the Quote Fields

  1. Click the expand icon (the double-headed arrow) in the Column1 column header.
  2. Select the fields you want to bring into Excel.  Please see the API Reference for available fields.
     
  3. Uncheck Use original column name as prefix to keep your column headers clean.
  4. Click OK.

Step 5 — Load the Data into Excel

  1. Click Close & Load in the Home tab of the Power Query editor.
  2. Excel will load your quotes into a new worksheet as a formatted table.

Your data is now live and connected to KudurruStone.

Refreshing Your Data

To pull the latest data from KudurruStone at any time:

  1. Click anywhere inside the table.
  2. Click the Data tab → Refresh All.

Excel will re-query the API and update the table automatically. You can also right-click the table and select Refresh.

Note: Your API key is stored inside this workbook's connection. Do not share workbooks containing API keys with people outside your firm.

Working With Large Data Sets

Utilize the available filters to filter your API calls to ensure faster data fetches.

Related Articles