--- title: How to use the Foundry USA Pool and API Keys/Personal Access Tokens with Microsoft Excel? description: Connecting your Group Accounts or Sub-Account's API Keys to Microsoft Excel --- [Skip to content](https://pool-faq.foundrydigital.com/how-to-use-foundry-usa-pool-and-api-keys-with-microsoft-excel#main-content) English Show submenu for translations ![Foundry-USA-Pool-inverse (1).png\]](https://pool-faq.foundrydigital.com/hs-fs/hubfs/Foundry-USA-Pool-inverse%20(1).png?height=40&name=Foundry-USA-Pool-inverse%20(1).png) - [Foundry Home](https://foundrydigital.com/) Open main navigation Close main navigation - [Foundry Home](https://foundrydigital.com/) - English Show submenu for translations Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Foundry USA Pool Knowledge Base](https://pool-faq.foundrydigital.com/?hsLang=en) 2. [Statistics](https://pool-faq.foundrydigital.com/statistics?hsLang=en) # How to use the Foundry USA Pool and API Keys/Personal Access Tokens with Microsoft Excel? ## Connecting your API credentials to Microsoft Excel You can connect to the Foundry USA Pool API from Excel with either type of API credential: \- API keys, which are scoped to a specific Group Account or Sub-Account \- Personal access tokens (PATs), which are read-only credentials tied to your user account and available to Owner and Accountant roles The steps in Excel are the same for both. The only difference is the request header you enter in step 2. For details on creating and managing personal access tokens, see [this article](https://pool-faq.foundrydigital.com/personal-access-tokens-pats?hsLang=en).   Click "Data" tab → "Get Data" → "From Other Sources" → "From Web" ![](https://pool-faq.foundrydigital.com/hs-fs/hubfs/from%20web%201-png.png?width=510&height=589&name=from%20web%201-png.png) Select the "Advanced" radio button. - Fill in the other details like in the screenshot below. - The first URL part is the API endpoint. - For example: [https://api.pool.foundrydigital.com/subaccount\_hashrate\_day/{subAccountName}](https://api.pool.foundrydigital.com/subaccount_hashrate_day/{subAccountName}) - The second URL part is the first parameter and should start with question mark. - For example: ?coin=BTC - The rest of the URL parts are the rest of the parameters and must start with &. - For example: &start=2025-06-24 - In the "HTTP request header parameters" section, enter the header for the credential you are using: - If you are using an API key: enter X-API-KEY in the first field, then your actual API key in the second field. - If you are using a personal access token: enter Authorization in the first field, then Bearer followed by a space and your token in the second field. For example: Bearer fdpat\_XXXXXXXXXXXXXXXX - Click OK ![](https://pool-faq.foundrydigital.com/hs-fs/hubfs/from%20web%202%20v2-png.png?width=670&height=453&name=from%20web%202%20v2-png.png) Select “Anonymous” on the left, then click “Connect”. ![](https://pool-faq.foundrydigital.com/hs-fs/hubfs/from%20web%203%20v2-png.png?width=670&height=269&name=from%20web%203%20v2-png.png)   Click “To Table” ![](https://pool-faq.foundrydigital.com/hs-fs/hubfs/from%20web%204-png.png?width=393&height=156&name=from%20web%204-png.png) Leave the settings default (shown below) and click ok. ![](https://pool-faq.foundrydigital.com/hs-fs/hubfs/from%20web%205-png.png?width=670&height=244&name=from%20web%205-png.png) Click the expand button (circled in red), then click “OK”, then click “Close & Load”. ![](https://pool-faq.foundrydigital.com/hubfs/Untitled%20design%20(14)-png.png)   Result are shown below. Please note that hashrates are in GH/s and time zones are in UTC. ![](https://pool-faq.foundrydigital.com/hs-fs/hubfs/Screenshot%202025-09-19%20013001-png.png?width=670&height=283&name=Screenshot%202025-09-19%20013001-png.png) - [Getting started](https://pool-faq.foundrydigital.com/getting-started?hsLang=en) - [Alerts](https://pool-faq.foundrydigital.com/alerts?hsLang=en) - [API](https://pool-faq.foundrydigital.com/api?hsLang=en) - [Controls and Security](https://pool-faq.foundrydigital.com/controls-and-security?hsLang=en) - [Feedback](https://pool-faq.foundrydigital.com/feedback?hsLang=en) - [Hashrate](https://pool-faq.foundrydigital.com/hashrate?hsLang=en) - [Mining](https://pool-faq.foundrydigital.com/mining?hsLang=en) - [Payouts](https://pool-faq.foundrydigital.com/payouts?hsLang=en#main-content) - [FPPS Calculations](https://pool-faq.foundrydigital.com/payouts?hsLang=en#fpps-calculations) - [Pool Fees](https://pool-faq.foundrydigital.com/payouts?hsLang=en#pool-fees) - [Statistics](https://pool-faq.foundrydigital.com/statistics?hsLang=en#main-content) - [Shares](https://pool-faq.foundrydigital.com/statistics?hsLang=en#shares) - [Stratum](https://pool-faq.foundrydigital.com/stratum?hsLang=en#main-content) - [Proxy](https://pool-faq.foundrydigital.com/stratum?hsLang=en#proxy) - [Sub-accounts](https://pool-faq.foundrydigital.com/sub-accounts?hsLang=en) - [Users](https://pool-faq.foundrydigital.com/users?hsLang=en) - [Workers](https://pool-faq.foundrydigital.com/workers?hsLang=en) - [Foundry USA Pool Onboarding](https://pool-faq.foundrydigital.com/foundry-usa-pool-onboarding?hsLang=en) - [FAQs](https://pool-faq.foundrydigital.com/faqs?hsLang=en) - [Reports](https://pool-faq.foundrydigital.com/reports?hsLang=en) - [Foundry Home](https://foundrydigital.com/) [![Chill listening crop-3](https://pool-faq.foundrydigital.com/hs-fs/hubfs/Foundry-USA-Pool.png?width=52&height=24&name=Foundry-USA-Pool.png "Chill listening crop-3")](http://foundrydigital.com) foundrydigital.com Help Center Copyright © 2026, Foundry Digital LLC