--- title: Connecting Excel to the Kudurru Stone API description: 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. --- [Skip to content](https://kb.kudurrustone.com/connecting-excel-to-the-kudurru-stone-api#main-content) English Show submenu for translations [Customer portal](https://kb.kudurrustone.com/tickets-view?hsLang=en) ![kudurrustone-logo.png\]](https://kb.kudurrustone.com/hs-fs/hubfs/kudurrustone-logo.png?height=40&name=kudurrustone-logo.png) Open main navigation Close main navigation - English Show submenu for translations - [Customer portal](https://kb.kudurrustone.com/tickets-view) - Go to kudurrustone.com Go to kudurrustone.com Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Kudurru Stone Knowledge Base](https://kb.kudurrustone.com/?hsLang=en) 2. [Company](https://kb.kudurrustone.com/company?hsLang=en) 3. [API](https://kb.kudurrustone.com/company?hsLang=en#api) # 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](https://kb.kudurrustone.com/creating-an-api-key-in-kudurrustone?hsLang=en) 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**. ![](https://kb.kudurrustone.com/hs-fs/hubfs/image-png-Apr-02-2026-02-33-29-2971-PM.png?width=670&height=462&name=image-png-Apr-02-2026-02-33-29-2971-PM.png) --- ### 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](https://kudurrustone.com/ApiReference) ![](https://kb.kudurrustone.com/hs-fs/hubfs/image-png-Apr-02-2026-02-32-55-0507-PM.png?width=670&height=584&name=image-png-Apr-02-2026-02-32-55-0507-PM.png)   --- ### 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 - [Creating an API Key](https://kb.kudurrustone.com/creating-an-api-key-in-kudurrustone?hsLang=en) - [KudurruStone API Reference](https://kudurrustone.com/ApiReference) - [Getting started](https://kb.kudurrustone.com/getting-started?hsLang=en#main-content) - [Onboarding](https://kb.kudurrustone.com/getting-started?hsLang=en#onboarding) - [Company](https://kb.kudurrustone.com/company?hsLang=en#main-content) - [Settings](https://kb.kudurrustone.com/company?hsLang=en#settings) - [User Settings](https://kb.kudurrustone.com/company?hsLang=en#user-settings) - [Email Settings](https://kb.kudurrustone.com/company?hsLang=en#email-settings) - [Billing](https://kb.kudurrustone.com/company?hsLang=en#billing) - [Automation](https://kb.kudurrustone.com/company?hsLang=en#automation) - [API](https://kb.kudurrustone.com/company?hsLang=en#api) - [Quotes](https://kb.kudurrustone.com/quotes?hsLang=en#main-content) - [Quote Pages](https://kb.kudurrustone.com/quotes?hsLang=en#quote-pages) - [Quote Tasks](https://kb.kudurrustone.com/quotes?hsLang=en#quote-tasks) - [Mapping](https://kb.kudurrustone.com/quotes?hsLang=en#mapping) - [PDF Layout](https://kb.kudurrustone.com/quotes?hsLang=en#pdf-layout) - [Communication](https://kb.kudurrustone.com/quotes?hsLang=en#communication) - [Integrations](https://kb.kudurrustone.com/integrations?hsLang=en#main-content) - [QuickBooks Online](https://kb.kudurrustone.com/integrations?hsLang=en#quickbooks-online) - [Time Off](https://kb.kudurrustone.com/time-off?hsLang=en) - [Client](https://kb.kudurrustone.com/client?hsLang=en#main-content) - [Emails](https://kb.kudurrustone.com/client?hsLang=en#emails) - [Projects](https://kb.kudurrustone.com/projects?hsLang=en#main-content) - [Dashboard](https://kb.kudurrustone.com/projects?hsLang=en#dashboard) - [Mapping](https://kb.kudurrustone.com/projects?hsLang=en#mapping) - [Project Tasks](https://kb.kudurrustone.com/projects?hsLang=en#project-tasks) - [Schedule](https://kb.kudurrustone.com/projects?hsLang=en#schedule) - [Invoicing](https://kb.kudurrustone.com/projects?hsLang=en#invoicing) - [Task Scheduler](https://kb.kudurrustone.com/task-scheduler?hsLang=en#main-content) - [Map](https://kb.kudurrustone.com/task-scheduler?hsLang=en#map) - [Invoicing](https://kb.kudurrustone.com/invoicing?hsLang=en) - [Reports](https://kb.kudurrustone.com/reports?hsLang=en) - [Custom Views](https://kb.kudurrustone.com/custom-views?hsLang=en) - [Survey Points](https://kb.kudurrustone.com/survey-points?hsLang=en) - [Employee Time](https://kb.kudurrustone.com/employee-time?hsLang=en) - [Custom Reporting](https://kb.kudurrustone.com/custom-reporting?hsLang=en#main-content) - [Employee Time Entries](https://kb.kudurrustone.com/custom-reporting?hsLang=en#employee-time-entries) - [Client Portal](https://kb.kudurrustone.com/client-portal?hsLang=en#main-content) - [Request Form](https://kb.kudurrustone.com/client-portal?hsLang=en#request-form) - [Home Dashboard](https://kb.kudurrustone.com/home-dashboard?hsLang=en) - [Project Dashboard](https://kb.kudurrustone.com/project-dashboard?hsLang=en) [![Chill listening crop-3](https://kb.kudurrustone.com/hs-fs/hubfs/New%20Color%20Rope%20Outline%20Sans%20Text%20No%20Background.png?width=55&height=55&name=New%20Color%20Rope%20Outline%20Sans%20Text%20No%20Background.png "Chill listening crop-3")](http://kudurrustone.com) kudurrustone.com Help Center Copyright © 2026, Kudurru Stone LLC