If you need your spreadsheet to update automatically without manual downloads, use to pull data from the web. Open Excel and go to the Data tab. Select Get Data > From Web .
For advanced users needing consistent, programmatic access, Alpha Vantage provides a free API key that integrates directly into Excel. Register for a free API key on their website.
For one-off analysis, the easiest method is downloading pre-formatted CSV files that open directly in Excel. download gold price data excel
This method allows you to pull spot prices and historical data with higher reliability than standard web scraping. Download historical data in Yahoo Finance
Use the "From Web" function in Power Query with a specialized URL that includes your API key and the symbol for gold (XAU). If you need your spreadsheet to update automatically
In the Navigator window, select the table containing prices and click .
Navigate to the Gold Futures page (GC=F), select the Historical Data tab, choose your date range, and click "Download". Note: Some historical data may be behind a Yahoo Finance Gold subscription paywall . This method allows you to pull spot prices
To update the price later, simply right-click the table and select . 3. Using Free API Services (Alpha Vantage)