Crypto Price API
Get real-time cryptocurrency prices directly in Google Sheets
A simple API designed specifically for Google Sheets users who want to track cryptocurrency prices without manual updates. Just paste a formula and get live prices.
Quick Start
Paste this formula into any Google Sheets cell:
=IMPORTDATA("https://api.cryptoapi.tech/price/BTC")Key Features
Real-time Prices
Live data from major exchanges
Weighted Average
Calculated from multiple sources
Auto-Updates
Refreshes with your sheet
No Setup
No API keys required
How It Works
Open Google Sheets
Create a new spreadsheet or open an existing one where you want to track crypto prices.
Paste the Formula
Copy the IMPORTDATA formula and paste it into any cell. Replace "BTC" with your desired crypto symbol.
=IMPORTDATA("https://api.cryptoapi.tech/price/ETH")Watch It Update
The cell will display the current price and automatically refresh when your sheet recalculates.
API Response Format
The endpoint returns a simple JSON response:
GET /price/{SYMBOL}
Response:
{
"symbol": "BTC",
"price": 43250.50
}Pricing
Free
Perfect for personal portfolios
- Single token per request
- Real-time prices
- 500 credits
- 30 requests/min
- No API key needed
Pro
For advanced tracking
- Everything in Free
- Multiple tokens in one request
- Portfolio calculation
- 25,000 monthly credits
- 1000 requests/min
- Priority support
Google Sheets Guide
Complete guide to using the Crypto Price API in your Google Sheets spreadsheets.
Basic Usage
The IMPORTDATA function fetches data from a URL and automatically updates when your sheet recalculates.
Bitcoin (BTC)
=IMPORTDATA("https://api.cryptoapi.tech/price/BTC")Ethereum (ETH)
=IMPORTDATA("https://api.cryptoapi.tech/price/ETH")Solana (SOL)
=IMPORTDATA("https://api.cryptoapi.tech/price/SOL")Pro Tips
💡 Use Cell References
Instead of hardcoding the symbol, reference another cell to make it dynamic:
=IMPORTDATA("https://api.cryptoapi.tech/price/" & A1)Put "BTC", "ETH", or any symbol in cell A1 to change the price dynamically.
📊 Build a Portfolio Tracker
Example sheet structure:
| A: Symbol | B: Amount | C: Price | D: Value |
|---|---|---|---|
| BTC | 0.5 | =IMPORTDATA(...) | =B2*C2 |
| ETH | 10 | =IMPORTDATA(...) | =B3*C3 |
Ready to Get Started?
Start tracking crypto prices in your Google Sheets today. No signup required.
Have questions?