price2sheet

Google Sheets does not have a built-in feature to fetch cryptocurrency prices, which is why you need an external service like Price2Sheet. Unlike browser extensions or complex integrations, Price2Sheet provides a free, simple, and secure API that works directly inside your spreadsheet.

Fetching Prices with IMPORTDATA

The easiest way to get crypto prices is using IMPORTDATA. Just copy and paste the formula:

This will insert the latest BTC to USD price as plain text.

Fetching Prices with IMPORTXML

If you prefer XML format, use IMPORTXML:

Fetching Prices with IMPORTJSON (via Apps Script)

Google Sheets does not support JSON natively, but you can use a simple Apps Script:

function importJSON(url) {
    var response = UrlFetchApp.fetch(url);
    var json = JSON.parse(response.getContentText());
    return [[json.price]];
}

Then use:

Handling Decimal Separators

By default, Price2Sheet returns numbers with a period (.) as the decimal separator. If your spreadsheet uses a comma (,) instead, change your locale settings or use NUMBERVALUE: