The easiest way to fetch cryptocurrency prices into Google Sheets and Excel.

Using price2sheet in Microsoft Excel

Unlike Google Sheets, Microsoft Excel does not provide a simple way to fetch live cryptocurrency prices. Fortunately, you can use the Price2Sheet API to get real-time data with built-in Excel functions.

Why use Price2Sheet for Excel?
- No need for external plugins or add-ins
- Works with built-in Excel functions
- Supports multiple currencies and formats
- 100% free API access

Fetching Prices with WEBSERVICE

The simplest way to fetch crypto prices in Excel is using WEBSERVICE:

=WEBSERVICE("https://api.price2sheet.com/raw/btc/usd")

This will return the price as plain text.

Using FILTERXML for Structured Data

If you need to fetch prices in XML format and extract the value, use:

=FILTERXML(WEBSERVICE("https://api.price2sheet.com/xml/eth/usd"), "//price")

Fetching JSON Data with Power Query

Since Excel does not support JSON natively, you can use Power Query:

  1. Open Excel and go to Data > Get Data > From Other Sources > From Web.
  2. Enter the URL: https://api.price2sheet.com/json/sol/usd
  3. Click "Transform Data" and extract the "price" field.
  4. Load the data into your spreadsheet.

Handling Decimal Separators

If your Excel settings use a comma (,) instead of a period (.) for decimals, use:

=NUMBERVALUE(WEBSERVICE("https://api.price2sheet.com/raw/btc/eur"), ".")