TutorialsTutorial

Load the gold price into Excel without a key

Use Power Query to load the keyless price feed.

2 Nov 2026 · 1 min read

Get the gold price into Excel with Power Query, without writing code or getting an API key. Prices are 15 minutes late without a key and on Free.

1. Open the web connection

In Excel for Windows, choose Data → Get Data → From Web. Paste the keyless URL shown below. If Excel asks how to connect, choose Anonymous.

URL
https://api.goldprice.dev/v1/prices?symbol=XAU-USD-SPOT

2. Convert the JSON to a table

Power Query parses the JSON. Choose To Table to continue.

3. Keep the price and timestamp

Expand symbols, then keep price and computed_at.

4. Load the result

Change price to a decimal number, then choose Close & Load.

5. Refresh the price

Use Refresh All to fetch the price again. Keyless access allows 10 requests a minute and 100 an hour per IP.

Questions

Do I need an API key?

No. The keyless URL works without a key, with limits of 10 requests a minute and 100 an hour per IP.

Does this work in Excel for the web or on a Mac?

Excel for the web cannot use Get Data → From Web this way. Excel for Mac can refresh a connection made in Excel for Windows, so create it in Windows first.

What if I need more requests?

A free key sent in the X-API-Key header gives you 5,000 requests a month. Our [Excel tutorial](/tutorials/excel) shows the keyed setup and includes a template workbook; prices are still 15 minutes late on Free.

Keep reading

Need more requests?

Get a free API key for 5,000 requests a month, with no card needed.

Get a free key