Cryptosheets simplifies the process of accessing, aggregating, manipulating, and processing cryptocurrency API data.
Listing updated:August 21, 2024
Works with:
107K+
Overview
OVERVIEW
All your crypto data in one place (and now all your capital & conventional markets data also!). Access crypto data from hundreds of data providers using simple =CSQUERY() formulas or browse data sets and send directly to your sheet (no formulas). Browse institutional research, templates, charts, scenarios and customize your workspace with flexible dashboards. Access in Googlesheets, Excel or on the web anytime.

✔ No programming skills or scripts required, just email & password and you are good to go

[last updated 1/12/2021]

✔ Over 11,000+ crypto-assets & 200+ fiat currencies supported
✔ Over 147,000+ crypto instruments supported (derivatives, futures, options, perpetuals)
✔ Over 475,000 total crypto + capital markets instruments supported (crypto + stocks, ETFs, ADRs, bonds, commodities, economic indicators)
✔ Historical price, volume, trade & orderbook data for 309+ exchanges (1 second - 1yr resolutions), 800+ exchanges total
✔ [NEW] support for CoinGecko, CryptoCompare & Messari as default pricing sources!
✔ Hundreds of providers (Coinmarketcap, Cryptocompare, Coingecko, Messari, Coinmetrics, Nomics, Coinpaprika, Kaiko many more..)
✔ Over 250,000+ non crypto-assets supported!
✔ Stocks, ETFs, Options, OEF/CEF, commodities, bonds, interest rates, energy, economic indicators, earnings, financials, fundamentals, corporate actions and much more

✔ 84+ Custom functions =CSPRICE("BTC","USD","2/1/2019")
✔ 180+ Technical Analysis Custom functions 
✔ Powerful custom function arguments for _fields, _orderBy, _formatDates, extract JSON arrays using _path and more
✔ One click Template library
✔ DeFi, derivatives, ICO, crypto funds, volatility, taxonomy, portfolio analysis, historical scenarios
✔ On chain metrics  =CSCHAIN(), =CSMETRICS()
✔ Multi-provider ATH (All-Time-Highs) & ROI data per day, week, month, quarter, year (=CSTA)
✔ Global market data, BTC dominance, sentiment, flows

✔ Real time streaming prices (Excel version only*)
✔ Automatic custom refresh at any interval for any data using CS.TIME! (Excel version only*)

✔ Tutorials & support documentation library (over 12,250+ examples)
✔ Dedicated data provider documentation (over 6,000+ pages)
✔ Live chat support and interactive help center
✔ See your subscription quota in real time, no more surprises + one click upgrade from the side panel
---------------------------------------------------------------

EXAMPLES (TRY COPYING + PASTING AFTER YOU LOGIN)

=CSPRICE("BTC", "USD")
=CSPRICE("BTC","USD","2/1/2019")
=CSPRICE("BTC", "USDT",,"Binance","ASK")
=CSPRICE("BTC", "USD",,"Coinbase","BID")
=CSPRICEA("base","ETH","quote","USD","exchange","DERIBIT","type","OPTION","details","200828-400-C")
=CSPRICEA("symbolId","DERIBIT_OPT_ETH_USD_200828_400_C")

=CSPRICEA("base","BTC","quote","USD","source","CoinGecko")
=CSPRICEA("base","BTC","quote","USD","source","CryptoCompare")
=CSPRICEA("base","BTC","source","Messari")

=CSTA("BTC", "USD")
=CSATH("BTC", "USD")
=CSOHLCV("BTC","USD")
=CSOHLCV("BTC","USD","Coinbase","SPOT","1MIN")
=CSORDERBOOKS("BTC","USD","Coinbase","SPOT","","","1")
=CSORDERBOOKSL3A("symbolId","COINBASE_SPOT_BTC_USD")
=CSTRADES("BTC","USD","Bitmex","PERP")
=CSEXRATE("BTC","USD","1") *Excel only

=CSQUERY("Cryptunit","Earnings Auto")
=CSQUERY('Coingecko','exchanges')
=CSQUERY("Paradigm","Performance")
=CSPARAMETERS("Cryptunit","Earnings Auto")
=CSPROVIDERS("~Coin")
=CSENDPOINTS("Cryptocompare")
=CSEXCHANGES()
=CSSYMBOLS('type', 'futures')
=CSQUERYA()


=CSRSI()
=CSMACD()
=CSEMA()
=CSBBANDS()
... many more (try =CSTAMETADATA() to see over 180+ technical indicators functions)

=CSADDRESS("1KYiKJEfdJtap9QX2v9BXJMpz2SfU4pgZw","Bitfinex")
=CSADDRESS(,"~Bin")
=CSCHAIN("DASH")
=CSMETRICS("BTC") *Pro subscription for live data
=CSMETRICS("BTC,BCH") *Pro subscription for live data
=CSCLUSTERS("platform")
=CSIDEAS('~defi")


📔 Help Center: https://intercom.help/cryptosheets/en/
📔 Docs Portal: https://docs.cryptosheets.com
📔 YouTube: https://www.youtube.com/channel/UCReKkrBSlgKgNJlWHLASiPQ
📔 Medium: https://medium.com/cryptosheets
📔 Twitter: https://twitter.com/Cryptosheets_RT
📔 Excel Version: https://appsource.microsoft.com/en-us/product/office/WA104381695


GETTING STARTED

(1) Install the Cryptosheets add-on

(2) Open a spreadsheet

(3) Start the Cryptosheets add-on from your add-ons menu by selecting "Launch Sidebar"

(4) Click “Login” at the top of the side panel

(5) If this is the first time you are using Cryptosheets, you will be prompted to register and provide the necessary permissions

(6) Voila, your data is now available via Cryptosheets! You can now modify how the data gets displayed, as well as pull in your favorite endpoints.

TAGS: stocks API, crypto API, graphql API, defi API, bitcoin API, cryptocurrency API, blockchain API, altcoins, bitcoin mining

Integrated providers: 
CoinMarketCap, MercadoBitcoin, Poloniex, Block, Coinigy, CoinLayer, Livecoin, Blockchain, Cryptonator, Nexchange, Zloader, CoinRanking, Coinlore, Coinlib, CoinDesk, ICObench, Binance, BitcoinAverage, Coinbase, CryptoStandardizer, IEX, Bitfinex, Coinpaprika, BitcoinCharts, Coinbase Pro, CoinGecko, WorldCoinIndex, NiceHash, Bitmex, Bittrex, Gemini, CoinAPI, Messari, CryptUnit, WhatToMine, Nomics, CryptoCompare, Paradigm, The Block, Coinmetrics, Cointracking, Shrimpy, CCXT, Chainz, Crypto51, Earn, Etherscan, Ethplorer, OpenFIGI, Cryptowatch, FOAM, Amberdata, Cryptosheets, Bloxy, Bitwise, Kryptocal, Tokeninsight, Kaiko, Flipside Crypto, Huobi, LocalBitcoins, Kraken, Covalent, TokenAnalyst, DeFi Pulse, Compound, Alethio, Decred Data, Kyber Network, LoanScan, CryptoRank.io, CoinCodex, LedgerX, Deribit, ContractMarketCap, Dapp.review, StableCoinIndex, FTX, DEX.AG, Lunarcrush, dYdX, CryptoQuant, Coinbase Prime, GlassNode, TzStats, Binance Dex, TronScan, 1inch, XRP Ledger, 0xTracker, Radar Relay, Cryptocontrol, Binance US, Coinbase Custody, Smartable Coronavirus API, EOD Historical Data, Bybit, ByteTree, Covidtracking, Bitstamp, Bitflyer, itBit, OKEX, Paraswap, QUME, OmniAPI, Delta Exchange, CoinCodeCap, Crypto.com, 0xAPI, Blocklytics, Blockset, AdaEx, Equos, Paxful, Blockstream, CrossTower, Minerstat, The Graph, Yearn API, QTUM, Infura, IntoTheBlock, Vantage Crypto, Xangle, Iconomi, Blockcypher, Masternodes, IDEX, Uniswap, Coindar, Cryptohopper, KuCoin, DragonGlass, NeoScan, Stellar, TokenView, CryptoAPIs.io, Beaconchain, WAVES, Bonfida, OpenSea, Decentraland, GrinMint, Polkascan, TokenLists, Uniswap
Additional information
PricingNot available
Developer
Privacy policy
Terms of service
Cryptosheets will ask for the permissions shown below. Learn more
Cryptosheets will need access to your Google account
This will allow Cryptosheets to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Austin Mourot
November 1, 2023
TLDR: Not worth it, and would recommend CoinMarketCap's API instead. I tried this out after CryptoFinance was no longer an option. Works 50% of the time. I overused my credits and instead of blocking use of API endpoints it straight up disabled my account, I proceeded to pay for premium in hopes of adding credits and solving issue, took my payment but my account was still disabled. Took me almost a week to reach support, and they reactivated my account, but a week had already elapsed on my "premium" membership. I disabled future payments and my account instantly reverted back to free membership.
Is this review helpful?
Yes
No
Profile Picture
Patrick Mumford
July 18, 2023
For some reason this app keeps breaking. When I open my sheet on my desktop (I might have to refresh) but it works okay. When I open the same sheet on my android phone the same functions break with a #NAME? error. The sheet no longer knows the function call from cryptosheets.
Is this review helpful?
Yes
No
Profile Picture
an hui
January 16, 2024
nice
Is this review helpful?
Yes
No
Profile Picture
Justin White
November 20, 2023
Doesn't work on Google sheets, even their own templates. Documentation needs updated to match current Google Sheets interface.
Is this review helpful?
Yes
No
Profile Picture
Xof Michot
May 12, 2024
Not reliable, doesn't always load and when it loads, it doesn't always work...
Is this review helpful?
Yes
No
Profile Picture
LIVE IMPEX EXPORTS
December 10, 2022
nice no other, as well as excellent support. I have come here from CryptoFinance and have been VERY impressed so far. Chris even helped me via Zoom to get some problems sorted and is always sharp on support!
Is this review helpful?
Yes
No
Profile Picture
Nay Polanco
December 21, 2021
Update: Dec 21, 2021 - It appears they have updated something in the backend last week that has fixed the flaw I've complained about below. So far the prices are fetching much more consistently now, which if this performance continues it totally makes this service 5 star. Original review I agree with Gregory Stevens review. Being a paid customer I thought I'd have a more reliable experience but its just as bad. Nearly every single day I open my spreadsheet the fetched pricing disappears or reads ERROR. And when the date is not having trouble fetching it says I have to log in through the side app, after which data takes hours to reappear again. Sadly, the problem with this service seems to do with poor data reliability. My guess is, they are using cheap overrun servers which cant keep up.
Is this review helpful?
Yes
No
Profile Picture
Mesh
September 8, 2022
This product is a scam, dont fall for it. I paid for yearly subscription and it disabled my account. I tried several times to cancel the monthly payments but cant access it anymore. Buy at your own risk and headache
Is this review helpful?
Yes
No
Profile Picture
Ian Northey
February 13, 2021
Most of queries tried just don't work, asked for just 14 days of price history and got over 40 rows returned??? Dates weren't formatted in the chosen option, in fact didn't even present as a date at all - just a strange number that in no way corresponded to any date as couldn't be formatted using date options. Issue not limited to google sheets either, same issues with MS Excel. I'll go back to just grabbing a CSV file, not worth the time stuffing around with this. At least it was free to try, I now know never to go any further with this product.
Is this review helpful?
Yes
No
Profile Picture
Gregory Stevens
September 1, 2021
I'm currently using Excel with CoinGecko APIs to keep me apprised of my portfolio performance. That combo works. But for fun I thought I'd create a Googlesheets version and use Cryptosheets as an add-on. Big mistake time-wise. A reviewer below wrote, "Some users seem to leave a bad review, but that's because they have not read the instructions and not implemented properly." That's complete BS. I've read the instructions , sadly multiple times, (they're not difficult to understand even for the uninitiated). The fact is that this app is simply not ready, nor can it be relied on, for reliable active use. It's buggy as hell and is a waste of time to try to use after you've already invested the time to enter your data/configure how you want sheets to look. The main issue seems to be the app's inability to fetch source data consistently -- sometimes it works, sometimes it doesn't. This is a fundamental flaw. I tried the free version but if I had bought the paid version I'd be pissed as hell. Some other issues I've noticed: - login: sometimes you'll get an error that reads, "We had trouble logging you in. Reason: Failed to fetch". Not sure why I even have to login each time I open my Sheets but I do it because apparently that's the only way to ensure that you have a "chance" of getting data. I never have to do that when using CoinGecko's apis with Excel. Bottom line is that the ONLY benefit this Add-in is SUPPOSED to offer is an easy way to grab and pop current coin market prices into a Googlesheet so that users can keep up-to-date on their portfolio. But this app fails even in that ridiculously simple task. Taking the time to author this review was a luxury I didn't have but felt I owed it others as a warning.
Is this review helpful?
Yes
No
1-10 of 108
Search
Clear search
Close search
Google apps
Main menu