Cryptosheets: Cryptocurrency Add-in for Microsoft Excel (2024)

PRICING PLAN

Choose the right plan for you

Please contact us directly for custom subscriptions and plans.

Free Forever

Just starting out? Try for free.

$0

Per Month, USD

Premium

For personal projects and solo research.

$49

Per Month, USD

Team

Discounted plans & custom features for multi-seat teams.

$1499

Per Quarter, USD

COMPARE ALL PLANS

Compare Plan Features

CoreFreePremiumProfessionalTeam
Monthly Requests50025,000100,000500,000
Web Console
Excel
Google Sheets
Endpoints5,5005,5005,5009,000
Providers207207207450
Templates
Custom Functions
Request Concurrency11005001000

Data RefreshFreePremiumProfessionalTeam
Real Timeinquire
1 minute
60 minute
Custom

CoverageFreePremiumProfessionalTeam
Supported Crypto Assets495,188495,188495,188700,000
Supported Crypto Exchanges340340340875
Supported Non-Crypto Assets648,000648,000648,000750,000+
Derivatives

Custom FunctionsFreePremiumProfessionalTeam
ADDRESS
ATH
CHAIN
CLUSTERS
ENDPOINTS
EXCHANGES
EXRATE
HEALTHCHECK
IDEAS
LOGIN
METRICS
OHLCV
ORDERBOOKS
PARAMETERS
PRICE
PROVIDERS
QUERY
SOCKETHEALTHTEST
STATUS
TA
TIME
TRADES
TAHIS
PRICEA
ORDERBOOKSL3A
OHLCVA
FIELDS
SYMBOLS
QUERYA
TRADESA
ORDERBOOKSA

Technical IndicatorsFreePremiumProfessionalTeam
ADX
ATR
BBANDS
BETA
CORREL
DEMA
EMA
MA
MACD
MACDEXT
MACDFIX
MOM
OBV
ROC
ROCP
ROCR
ROCR100
RSI
SAR
SAREXT
SMA
STOCH
STOCHF
STOCHRSI
TRANGE
TSF
VAR
AD
ADOSC
APO
AROON
AROONOSC
CCI
CDLINNECK
CDLMARUBOZU
DX
EXP
FLOOR
LINEARREG
LINEARREG_ANGLE
LINEARREG_INTERCEPT
LINEARREG_SLOPE
LN
MFI
NATR
T3
TEMA
TRIX
ULTOSC
WCLPRICE
WILLR
WMA

FeaturesFreePremiumProfessionalTeam
Templates
Content
Charts
Scenario Clusters

AdvancedFreePremiumProfessionalTeam
GraphQLinquire
Custom Endpoints & Functions
Experimental Features
API Library
Hosted Cloud Sheets

SupportFreePremiumProfessionalTeam
White Label
Conference Calls
Custom Builds & Consulting
SLA
Webhooks
Advanced Usage Reporting
Cryptosheets Docs (Portal)
Cryptosheets Help Center
Chatlimitedlimitedprioritylive
Group Teach-In Sessionsinquireinquire

TemplatesFreePremiumProfessionalTeam
Public Templates (Excel & Googlesheets)
Template Designer
Template Engine (Team)inquire

Advanced IntegrationsFreePremiumProfessionalTeam
CryptoCompare
Cointracking.info
ParadigmAPI
CoinGecko
Vantage Crypto
CryptoQuant
Coinigy
Kaiko
Glassnode
Messari
Bloxy
IEX Cloud
Covalent
Deribit
Coinmetrics
Amberdata
GenesisVolatility
Token Terminal

FREQUENTLY ASK QUESTION

Have a question?

Cryptosheets: Cryptocurrency Add-in for Microsoft Excel (2024)

FAQs

How do I add Cryptosheets to Excel? ›

Excel Online
  1. Login with your Microsoft credentials.
  2. Choose New Blank Workbook.
  3. Go to Insert > Office Add-ins.
  4. In the popup window, choose Store.
  5. Type Cryptosheets in the search box.
  6. Choose Cryptosheets.
  7. Take a moment to look at the Store page to familiarize yourself with the add-in.
  8. Choose Add to install the add-in.

How to get crypto data into Excel? ›

In Excel, use the "DATA" tab and select 'From Web' to import data from the API. Follow the prompts to connect to the API and retrieve live price data for your chosen cryptocurrencies.

How to make a crypto Excel spreadsheet? ›

Step 1: Install Cryptosheets: Get the add-in from their website. Step 2: Connect Data: Launch Excel, go to Cryptosheets, and connect to your data source. Step 3: Retrieve Data: Use Cryptosheets' functions to get specific cryptocurrency data. Step 4: Organize and Analyze: Organize and visualize data using Excel's tools.

Is Cryptosheets free? ›

Can I get started for free? Yes! All accounts receive 1000 free queries per month that reload automatically.

How do I download Excel addons? ›

Get an Office add-in for Excel
  1. Click File> Get Add-ins. You can directly install an add-in on the page or click More Add-ins to explore. ...
  2. In the Office Add-ins box, select My Add-ins to view your add-ins. ...
  3. Click an add-in to read more about it, including a longer description and customer reviews, if available.

How do I add addons to Excel? ›

Add or remove an Excel add-in
  1. Click File > Get Add-ins. Alternatively, you can click Home > Add-ins.
  2. You can directly install add-ins from this page or select More Add-ins to explore.
  3. In the Office Add-ins, dialog select My Add-ins tab.
  4. Select the add-in you wish to activate and right click to see option to activate.

Does Excel have cryptocurrency? ›

If you have a Microsoft 365 subscription, you can use Excel's stocks functionality to pull in cryptocurrency prices. Currently, Excel supports the following cryptocurrencies. Excel allows you to see the price of cryptocurrency in the fiat currency of your choice — USD, EUR, CAD, and more!

How do you automatically populate crypto price in spreadsheet? ›

Identify the ticker symbol for Bitcoin on Google Finance, which is usually in the format of 'BTC-USD' for Bitcoin priced in US dollars. In your Google Sheet, type the formula '=GOOGLEFINANCE("BTC-USD")' where you want the live Bitcoin price to appear.

How do I get crypto com CSV? ›

  1. Open your Crypto.com app.
  2. Select accounts at the bottom of the screen.
  3. Select the clock icon (transaction history) in the top right corner.
  4. Select the export icon in the top right corner.
  5. Select fiat wallet or crypto.com visa card.
  6. Select a start and end date (maximum of 3 years). ...
  7. Select export to CSV.

What is crypto sheets? ›

Cryptosheets simplifies the process of accessing, aggregating, manipulating, and processing cryptocurrency API data.

How to create a crypto dashboard? ›

How to Build a Cryptocurrency Dashboard
  1. Set Crypto Goals. ...
  2. Make a List of Your Crypto Assets and Accounts. ...
  3. Build a Dashboard to Track Crypto Changes (Tutorial and HTML Required) ...
  4. Build Another Dashboard to Track the Other, Non-Cryptocurrency Assets in Your Portfolio.

How do I use crypto sheets in Google Sheets? ›

▶︎ General setup and integration (Googlesheets)
  1. Going to the add-ons menu from your Googlesheet.
  2. Get add-ons.
  3. Type "cryptosheets" in the search bar in GSuite Marketplace.
  4. Install.
  5. Go back to the add-ons menu.
  6. Select Launch Sidebar from the Cryptosheets menu.

Is Cryptofinance free? ›

Under the hood, Cryptofinance is powered by the Cryptowatch API. For higher usage rates, historical, data, and derivative data, users will need to create a free Cryptowatch account.

Which crypto app is free? ›

Comparison table between 20 Top-Rated Crypto Exchanges And Apps
App NameAvailable CryptocurrenciesFees
Krypto100+Free
Kraken India200+Maker: 0.00-0.16% Taker: 0.10-0.26%
Giottus100+Maker: 0.3% Taker: 0.5%
MEXC1700+Sport Trading: Maker and Taker: 0% Future Trading: Maker: 0% and Taker: 0.02%
16 more rows
Apr 8, 2024

Does Excel have crypto? ›

The easiest way to import live crypto prices is by using Excel's "Data from Web" feature, and connecting it with CoinGecko's crypto API endpoint /coins/markets.

How do I add Smart View plugin to Excel? ›

  1. Click on Smart View in the Disabled Items panel.
  2. Click on Enable.
  3. Go back to File > Options > Add-Ins.
  4. Select Com Add-Ins in the Manage drop-down list.
  5. Select Go.
  6. In the COM Add-Ins pop-up, select Oracle Smart View for Office.
  7. Click OK.
  8. Close Excel.

How to import JSON into Excel? ›

To do this:
  1. Navigate to the Data tab.
  2. Click on Get Data.
  3. From the drop-down menu, choose From File and then select From JSON.
Apr 12, 2024

Top Articles
Latest Posts
Article information

Author: Maia Crooks Jr

Last Updated:

Views: 5945

Rating: 4.2 / 5 (43 voted)

Reviews: 90% of readers found this page helpful

Author information

Name: Maia Crooks Jr

Birthday: 1997-09-21

Address: 93119 Joseph Street, Peggyfurt, NC 11582

Phone: +2983088926881

Job: Principal Design Liaison

Hobby: Web surfing, Skiing, role-playing games, Sketching, Polo, Sewing, Genealogy

Introduction: My name is Maia Crooks Jr, I am a homely, joyous, shiny, successful, hilarious, thoughtful, joyous person who loves writing and wants to share my knowledge and understanding with you.