Connect with us

Crypto

How to Import Cryptocurrency Prices Into Google Sheets

Published

on

How to Import Cryptocurrency Prices Into Google Sheets

Do you want to keep on top of the latest crypto price rises (and falls)? Learn how to import cryptocurrency prices into Google Sheets using this guide.

If you own any cryptocurrency or you’re thinking about buying some, you’ll want to keep track of the current prices. That way, you’ll know if it’s the right time to buy or sell. There are plenty of websites that can provide this information, but you might prefer to use a spreadsheet to keep track of prices over time, or to do other calculations.

If you’re a fan of Google Sheets, it’s possible to get cryptocurrency price data into your spreadsheets and then use them how you wish. Learn how to import cryptocurrency prices into Google Sheets below.

How to Import Cryptocurrency Prices using GOOGLEFINANCE in Google Sheets

The GOOGLEFINANCE function allows you to pull live information on a wide range of traditional currencies directly from Google. It also allows you to pull prices for some of the most popular cryptocurrencies, including Bitcoin, Ethereum, Litecoin, Cardano, and Binance Coin, but it doesn’t work with others such as Dogecoin.

Advertisement

To import cryptocurrency prices using GOOGLEFINANCE:

  1. Open a Google Sheets document.
  2. Select the cell where you want the price to appear.
  3. For the price of Ethereum, enter the following formula:
    =GOOGLEFINANCE(“ETHUSD”)

    googlefinance formula

  4. For the price of Ethereum, enter the following formula:
    =GOOGLEFINANCE(“BTCUSD”)
  5. If you want to import other cryptocurrencies, you’ll need to include CURRENCY in the formula. For example, for Litecoin, enter the following formula:
    =GOOGLEFINANCE(“CURRENCY:LTCUSD”)
  6. You can replace LTC with many of the more popular cryptocurrency codes, such as ADA and XRP, but it won’t work with four-letter codes such as DOGE and LINK.
  7. Press Enter and the price will calculate.
    googlefinance result
  8. Your spreadsheet will automatically update periodically as the price of your selected cryptocurrency changes. This usually happens after 20 minutes or so.

How to Import Cryptocurrency Prices Using IMPORTXML in Google Sheets

If you want to import cryptocurrency prices that the GOOGLEFINANCE function doesn’t handle, then one option is to scrape the data directly from a cryptocurrency website. The IMPORTXML function allows you to pull the data from the webpage and bring it into your Google Sheets document.

To import cryptocurrency prices using IMPORTXML:

  1. In an empty cell, paste the URL for the webpage containing your cryptocurrency price data. For example, for the Ethereum page of CoinMarketCap.com, you would paste the URL https://coinmarketcap.com/currencies/ethereum/
  1. Navigate to that page in Chrome, and right-click on the price you want to import.
  2. Select Inspect.
    website inspect element
  3. The value you selected should be highlighted. If not, click on the price in the left-hand pane.
  4. Just above the price, you should see a div name.
    website div class
  5. Right-click on this line and select Copy Element.
  6. Paste this somewhere into your spreadsheet and highlight and copy just the class name, such as class=”priceValue “
  7. In the cell next to the URL, type:
    //div[@
  1. Paste the class name that you just copied and type a closed square bracket. Your cell should now read something like:
    //div[@class="priceValue "]

    google sheets div code

  2. Now select the cell where you want your cryptocurrency price data to appear and type the following:
    =IMPORTXML(
  3. Click in the cell containing your URL, type a comma, click in the cell containing your div class, and finally type a closed bracket. Your formula should look something like this:
    =IMPORTXML(G10,H10)

    google sheets importxml

  4. Press Enter and the cryptocurrency price data should be scraped from the website.

How to Refresh Scraped Cryptocurrency Prices in Google Sheets

The data you have scraped will update once per hour. To keep the value updated more frequently, you can force the cell to recalculate. One fairly simple way to do so is to create a macro that copies the cell, deletes it, and pastes it back in again. This will cause the cell to recalculate which should pull the most recent data from the cryptocurrency website.

To refresh scraped cryptocurrency prices using a macro:

  1. Open the Google Sheets spreadsheet containing your scraped data.
  2. In the menu, click Extensions.
     google sheets extensions
  3. Hover over Macros and select Record Macro.
    google sheets record macro
  4. Once the macro is recording, click the cell with your scraped data.
  5. Press Ctrl+C on Windows or Cmd+C on Mac to copy the cell.
  6. Press Delete or Backspace to delete the cell.
  7. In the same cell, press Ctrl+V on Windows or Cmd+V on Mac to paste the formula back into the cell.
  8. Click Save at the bottom of the screen to save your macro.
    google sheets save macro
  9. Give your macro a name. If you wish, you can also add a keyboard shortcut.
    google sheets name macro
  10. Click Save.
  11. To run your macro, press your keyboard shortcut, or go to Extensions > Macros and click on your macro name.
    google sheets run macro
  12. Your cell should now refresh and the data inside it should update.

How to Import Cryptocurrency Prices Using IMPORTDATA

You can also import cryptocurrency data using a website specifically designed for this purpose. The IMPORTDATA function allows you to pull price information directly from this website. The data will refresh once an hour.

To import cryptocurrency prices using IMPORTDATA:

  1. Click in the cell where you want the price data to appear.
  2. Enter a formula in the following format:
    =IMPORTDATA(https://cryptoprices.cc/ETH/)

    importdata formula

  3. You can change ETH to the code of a variety of different cryptocurrencies. See https://cryptoprices.cc/sitemap.txt for the full list of options.
  4. Press Enter and you should see the current price.

How to Import Cryptocurrency Prices Using the CoinMarketCap API

Another way to get cryptocurrency prices from CoinMarketCap is to use its API. By creating an account and generating your own API key, you can poll the site directly and import a huge amount of cryptocurrency information into your Google Sheets document.

In order to get the data into Google Sheets, you’ll need to use an add-on called API Connector.

Advertisement

To import cryptocurrency prices using the CoinMarketCap API:

  1. Open your Google Sheets document and click the Extensions menu.
     google sheets extensions
  2. Hover over Add-ons and click Get Add-ons.
    google sheets get add ons
  3. In the search field, type API Connector and press Enter.
    google sheets search add ons
  4. Select API Connector in the search results.
    google sheets api connector
  5. Click Install.
    google sheets install api connector
  6. Sign in to your Google account and allow the required permissions.
  7. To set up your CoinMarketCap API, navigate to https://coinmarketcap.com/api/
  8. Click Get Your API Key Now.
    coinmarketcap get api key
  9. Enter your details, select Basic as your plan type, and click Create My Account.
    coinmarketcap create account
  10. You’ll be emailed to verify your account. Click the link, and you’ll be redirected to the API dashboard.
  11. Hover over the API Key and click Copy Key.
    coinmarketcap copy key
  12. Return to your Google Sheets document and click Extensions.
     google sheets extensions
  13. Hover over API Connector and click Open.
    google sheets open api connector
  14. Click Create Request.
    api connector create request
  15. Under Application select CoinMarketCap from the drop-down box.
    api connector appllication
  16. Click in the API Key field and paste your copied API key.
    api connector authorization
  17. Under Endpoint, select /v2/cryptocurrency/quotes/latest from the drop-down.
    api connector endpoint
  18. Click the Plus (+) symbol next to Aux and select any of the options from the drop-down—the request won’t run without a selection in this field.
    api connector aux
  19. Click the Plus (+) symbol next to Slug and select the coin or coins you want to pull data for.
    api connector slug
  20. Select a cell in your spreadsheet where you want the first cell of the pulled data to appear, and click Set Current.
    api connector set current
  21. Give your request a name and click Save.
    api connector name
  22. Click Run and your request will run.
    api connector run
  23. The column USD.price contains the current price information.
    quote usd price

How to Update Cryptocurrency Prices Using API Connector

The price generated by the CoinMarketCap API will not automatically update. However, it is possible to get API Connector to refresh your data at regular intervals from once an hour up to once a month. This will help you to ensure that your cryptocurrency prices are up-to-date.

To update cryptocurrency prices using API Connector:

  1. Click the Extensions menu.
     google sheets extensions
  2. Hover over API Connector and select Open.
    google sheets open api connector
  3. Select the Schedule tab.
    api connector schedule tab
  4. Click Create Trigger.
    api connector create trigger
  5. Under API Request, select the name of the request you created in the section above.
    api connector request name
  6. Under Run Request, select your refresh time.
    api connector run request frequency
  7. Enter a name under Trigger Name and click Save.
  8. Your cryptocurrency data will now refresh at the frequency that you selected.

Checking Your Portfolio in Google Sheets

Learning how to import cryptocurrency prices into Google Sheets means you can use that price data in whatever calculations you wish. You’ll be able to monitor prices, and even set up some conditional formatting to alert you when the cryptocurrency hits a certain price.

There are plenty of other useful Google Sheets tricks you can learn. You might want to learn how to use timestamps in Google Sheets, for example. Or you may want to know how to remove dollar signs in Google Sheets if some of your scraped data has included them. You might also want to learn how to merge sheets in Google Sheets to help you organize your data.

Continue Reading
Advertisement
Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Crypto

Top Cryptocurrency Stocks To Add to Your Watchlist

Published

on

Top Cryptocurrency Stocks To Add to Your Watchlist
Robinhood Markets, Galaxy Digital, Bit Origin, Bitdeer Technologies Group, HIVE Digital Technologies, Bitfarms, and Bitcoin Depot are the seven Cryptocurrency stocks to watch today, according to MarketBeat’s stock screener tool. Cryptocurrency stocks are shares of publicly traded companies whose co
Continue Reading

Crypto

Adecoagro Partners With Tether to Pioneer Renewable Energy Use for Bitcoin Mining in Brazil – Mining Bitcoin News

Published

on

Adecoagro Partners With Tether to Pioneer Renewable Energy Use for Bitcoin Mining in Brazil – Mining Bitcoin News
decoagro is partnering with Tether to explore the use of its renewable energy generation for bitcoin mining in Brazil. This initiative will enable Adecoagro to redirect excess energy, currently sold at spot market prices, into a new revenue stream: bitcoin. Tether and Adecoagro Partner to Establish Green Energy Bitcoin Mining Operation in Brazil Tether, one […]
Continue Reading

Crypto

Cryptocurrency Live News & Updates : Cardano Price Surge Signals Potential Risks – The Economic Times

Published

on

Cryptocurrency Live News & Updates : Cardano Price Surge Signals Potential Risks – The Economic Times
04 Jul 2025 | 03:30:11 AM IST

Cryptocurrency News & Live Updates

Synopsis

Cardano’s price has increased for two consecutive days, reaching $0.60, driven by a significant development in its Bitcoin integration efforts. However, the coin’s price action suggests a potentially bearish pattern ahead.

Cardano (ADA) has seen a notable price increase, rising over 17% to $0.60, largely due to the first on-chain transaction proving Bitcoin’s state on its network, marking the start of a Cardano-Bitcoin bridge. Despite this bullish narrative, Cardano faces challenges, including a relatively inactive ecosystem and low total value locked in DeFi. Meanwhile, Dogwifhat (WIF) has also experienced a price surge, rising 43% to $0.92, with increased whale accumulation indicating potential for further gains. The token is forming a cup-and-handle pattern, suggesting a projected breakout target of $2.37. In regulatory news, concerns persist regarding stablecoin frameworks in the EU and Switzerland, with calls for clearer guidelines to support industry growth. Additionally, Fitch predicts the U.S. deficit will exceed 7% of GDP next year, highlighting broader economic challenges. Lastly, Amber International raised $25.5 million to expand its Crypto Ecosystem Reserve, reflecting a trend among crypto firms to bolster their balance sheets amid cautious funding cycles.

Show more

03:30:04 AM IST, 04 Jul 2025

Advertisement

Cardano Price Surge Signals Potential Risks

Cardano’s price has increased for two consecutive days, reaching $0.60, driven by a significant development in its Bitcoin integration efforts. However, the coin’s price action suggests a potentially bearish pattern ahead.

03:25:05 AM IST, 04 Jul 2025

Dogwifhat (WIF) Price Surges: 155% Potential Upside

Dogwifhat (WIF) token has seen a 43% increase, reaching around $0.92, driven by whale accumulation and bullish market indicators, suggesting further growth ahead.

03:05:03 AM IST, 04 Jul 2025

EU and Switzerland Face Stablecoin Regulation Issues

Peter Märkl of Bitcoin Suisse highlights ongoing regulatory ambiguities for stablecoins in the EU and Switzerland, stressing the need for clearer frameworks under MiCA and addressing challenges like KYC requirements.

Advertisement

03:00:05 AM IST, 04 Jul 2025

U.S. Deficit Expected to Exceed 7% of GDP

Fitch’s Richard Francis forecasts that the U.S. government deficit will surpass 7% of GDP next year, with the debt ratio nearing 120% of GDP by 2026, despite anticipated tax cuts.

02:55:03 AM IST, 04 Jul 2025

Amber International Secures $25.5M for Crypto Reserve Growth

Amber International Holding has raised $25.5 million to enhance its $100 million Crypto Ecosystem Reserve, aimed at supporting blockchain networks and product development.

02:50:03 AM IST, 04 Jul 2025

Advertisement

Bitcoin (BTC) Hits 110,000 USDT with 0.80% Rise

As of July 3, 2025, Bitcoin has reached the 110,000 USDT mark, reflecting a modest 0.80% increase over the past 24 hours.

02:45:05 AM IST, 04 Jul 2025

IMF Cautions Trump’s Tax Proposal Could Hinder Debt Reduction

The IMF warns that President Trump’s proposed tax legislation may obstruct efforts to lower fiscal deficits and debt levels, potentially increasing the deficit by $3.3 trillion.

02:40:04 AM IST, 04 Jul 2025

Treasury Secretary Foresees Trade Agreements by July

U.S. Treasury Secretary Besant predicts that numerous trade agreements will be finalized by July 9, impacting around 100 countries with at least a 10% reciprocal tariff.

Advertisement

02:35:07 AM IST, 04 Jul 2025

Ondo and Pantera Capital Launch $250M Initiative

Ondo Finance, in partnership with Pantera Capital, is initiating a $250 million fund to invest in projects focused on real-world asset tokenization.

02:30:07 AM IST, 04 Jul 2025

Erebor Targets Financial Needs with Stablecoin Strategy

Erebor, a new crypto bank backed by notable figures, aims to fill the financial void left by Silicon Valley Bank’s collapse by focusing on stablecoin transactions and services for tech companies.

02:25:04 AM IST, 04 Jul 2025

Advertisement

ETH Steady as U.S. Jobs Data Boosts Markets

ETH rose 0.55% to $2,584.90 following strong U.S. jobs data, which indicated labor market resilience and pushed the S&P 500 and Nasdaq to record highs.

02:20:05 AM IST, 04 Jul 2025

Bitcoin Surpasses $110K Ahead of Jobs Report

Bitcoin’s market dominance has decreased slightly, now at 65%, as the U.S. jobs report is set to be released today, with expectations of a modest increase in nonfarm payrolls and a rise in unemployment.

02:15:04 AM IST, 04 Jul 2025

OpenAI Disavows Robinhood’s Stock Tokens

OpenAI has denied any connection to Robinhood’s stock tokens, emphasizing that these tokens do not represent actual equity and warning users to exercise caution.

Advertisement

02:10:03 AM IST, 04 Jul 2025

IMF Rejects Pakistan’s Electricity Subsidy for Crypto Mining

The IMF has turned down Pakistan’s request for subsidized electricity for crypto mining, despite plans to allocate 2,000 megawatts of surplus power to the sector.

02:05:04 AM IST, 04 Jul 2025

SEC’s Grayscale Fund Delay Expected to Be Brief

The SEC has temporarily paused the launch of Grayscale’s Digital Large Cap Fund (GDLC) ETF for commissioner review, citing the need for standard-setting rather than political reasons.

02:00:04 AM IST, 04 Jul 2025

Advertisement

Tether Mints 1 Billion USDT on Ethereum

Tether has minted an additional 1 billion USDT on the Ethereum network, as reported by Whale Alert, to manage liquidity and meet market demand.

01:55:09 AM IST, 04 Jul 2025

Trump’s Budget Lacks Crypto Focus, Yet Market Gains

Despite no crypto provisions in Trump’s budget, the liquidity boost may positively impact crypto assets.

01:50:04 AM IST, 04 Jul 2025

Binance Enhances Pay Send for Crypto Transfers

Binance has launched two key upgrades to its Pay Send service, introducing features that allow users to send cryptocurrencies via phone contacts and on-chain transactions, enhancing speed, security, and convenience.

Advertisement

01:45:04 AM IST, 04 Jul 2025

U.S. Employment Data to Shape Dollar’s Future

Analyst Turner from ING emphasizes the importance of the upcoming U.S. non-farm employment report in assessing the dollar’s downward trend, with potential implications for interest rates.

01:40:04 AM IST, 04 Jul 2025

Bitcoin (BTC) Falls Below 109,000 USDT

As of July 3, 2025, Bitcoin is trading at 108,959.99 USDT, reflecting a modest 1.55% increase over the past 24 hours, according to Binance Market Data.

01:35:06 AM IST, 04 Jul 2025

Advertisement

BNB Falls Below 660 USDT with Minor Gains

As of July 3, 2025, BNB is trading at 659.69 USDT, reflecting a modest 0.46% increase over the past 24 hours.

01:30:05 AM IST, 04 Jul 2025

Federal Reserve Expected to Keep Rates Unchanged

The CME’s FedWatch tool shows a 76.7% chance that the Federal Reserve will not alter interest rates in July, with a 23.3% possibility of a 25 basis point cut.

01:25:09 AM IST, 04 Jul 2025

YZi Labs Joins $135M Investment in Digital Asset

YZi Labs has announced its participation in Digital Asset’s $135 million Series E funding round, joining major financial institutions to support the growth of the Canton Network, which facilitates on-chain asset tokenization for regulated institutions.

Advertisement

01:20:04 AM IST, 04 Jul 2025

Why the U.S. Lacks a Bitcoin Reserve

Despite initial excitement from President Trump’s directive to establish a Bitcoin reserve, legislative hurdles and a lack of public plans have stalled progress.

01:15:03 AM IST, 04 Jul 2025

Telegram’s Blockchain Developer Achieves Unicorn Status

The Open Platform has reached a $1 billion valuation after securing $28.5 million in funding, marking a significant step for the TON ecosystem in integrating crypto with Telegram’s vast user base.

01:10:04 AM IST, 04 Jul 2025

Advertisement

Beijing North Fonda Partners with Guofu Quantum

Beijing North Fonda has formed a strategic alliance with Guofu Quantum Innovation Co., Ltd., focusing on virtual assets and digital currency to enhance their global fintech presence.

01:05:04 AM IST, 04 Jul 2025

USD Faces Historic Challenges Ahead

Analysts report that the dollar has experienced its worst start to a year since 1973, with a significant decline in value against other currencies amid waning confidence in U.S. policies.

01:00:04 AM IST, 04 Jul 2025

Michael Saylor’s Firm Faces Class-Action Lawsuit

A class-action lawsuit has been filed against Strategy and its executives, including Michael Saylor, over a reported $5.9 billion loss in Bitcoin holdings due to new accounting rules.

Advertisement

12:55:05 AM IST, 04 Jul 2025

Pepe Coin Price Targets 70% Increase Amid Whale Activity

Pepe Coin (PEPE) surged to $0.0000107, driven by whale accumulation and a broader crypto market rally, with large holders increasing their stakes by 5% over the past month.

12:50:03 AM IST, 04 Jul 2025

Treasury Secretary Addresses Dollar Decline Concerns

U.S. Treasury Secretary Besent has downplayed worries regarding the dollar’s recent depreciation, asserting that its value is not tied to the strong dollar policy, which focuses on long-term measures to maintain its global reserve status.

12:45:12 AM IST, 04 Jul 2025

Advertisement

U.S. Unemployment Claims Increase Amid Job Market Focus

Despite a decrease in initial jobless claims, U.S. continuing unemployment claims have risen to 1.964 million, the highest since November 2021, with significant contributions from the Deep Tristate area.

12:40:04 AM IST, 04 Jul 2025

Nano Labs Expands Holdings with BNB Acquisition

Nano Labs Ltd has acquired 74,315 BNB in an OTC deal, totaling around $50 million, raising its cryptocurrency reserves to approximately $160 million.

12:35:06 AM IST, 04 Jul 2025

Tether Teams Up with Adecoagro for Bitcoin Mining

Tether has partnered with Adecoagro to explore renewable energy Bitcoin mining in Brazil, utilizing surplus energy from Adecoagro’s facilities.

Advertisement

12:30:10 AM IST, 04 Jul 2025

U.S. House Passes Key Tax and Spending Legislation

On July 3, the U.S. House of Representatives voted to approve President Trump’s major tax reduction and spending bill, known as the ‘Big and Beautiful’ bill, with all Democrats and two Republicans opposing it.

12:25:03 AM IST, 04 Jul 2025

Senator Lummis Proposes New Crypto Tax Legislation

Senator Cynthia Lummis has introduced a standalone cryptocurrency tax bill to reform the U.S. tax code for digital assets, including a $300 transaction threshold and tax parity with traditional financial assets.

12:20:06 AM IST, 04 Jul 2025

Advertisement

Ripple Labs’ Banking License Bid Fuels XRP Speculation

Ripple Labs’ application for a U.S. banking license has sparked considerable speculation regarding XRP’s price, with analysts observing bullish momentum and potential resistance levels.

12:15:05 AM IST, 04 Jul 2025

Sui Surges to $3 Amid Lion Group’s Treasury Plans

Sui (SUI) has reached around $3 following a week-long rally driven by Lion Group’s $600 million crypto treasury plan, marking a 15% increase over the past week.

12:10:07 AM IST, 04 Jul 2025

Stablecoin Regulations May Boost Crypto Market to Trillions

Bo Hines, Executive Director of Trump’s Digital Asset Advisory Committee, predicts that stablecoin legislation could drive the cryptocurrency market’s growth to between $15 trillion and $20 trillion.

Advertisement

12:05:12 AM IST, 04 Jul 2025

Nano Labs Invests $50M in BNB Acquisition

Nano Labs has initiated its strategy to acquire up to $1B in BNB by purchasing 74,315 tokens for $50 million in an OTC deal, signaling a shift in its business model amid declining hardware revenues.

12:00:15 AM IST, 04 Jul 2025

Binance Enhances Pay Send for Crypto Transfers

Binance has rolled out two major upgrades to its Pay Send service, introducing features that improve the speed, security, and convenience of cryptocurrency transfers.

Advertisement
Continue Reading

Trending