{"id":2883,"date":"2026-01-07T09:38:11","date_gmt":"2026-01-07T09:38:11","guid":{"rendered":"https:\/\/tokenmetrics.com\/blog\/?p=2883"},"modified":"2026-06-14T17:09:17","modified_gmt":"2026-06-14T17:09:17","slug":"how-to-get-crypto-price-data-in-excel-and-google-sheets-in-2026","status":"publish","type":"post","link":"https:\/\/tokenmetrics.com\/blog\/how-to-get-crypto-price-data-in-excel-and-google-sheets-in-2026\/","title":{"rendered":"How to Get Crypto Price Data in Excel and Google Sheets in 2026?"},"content":{"rendered":"<p class=\"dream-post-content-paragraph j6zgbu1\"><span>Cryptocurrencies have become increasingly popular over the past few years, and more people are now investing in them. As a result, there is a growing need for tools and methods that can help investors track their cryptocurrency holdings and monitor market trends.<\/span><\/p>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>One such tool is the use of an API to pull crypto data into an Excel spreadsheet. This method allows investors to easily analyze and manipulate data in a familiar format. In this article, we will explore the steps involved in pulling crypto data into an Excel and Google spreadsheet using Token Metrics Crypto Data API.\u00a0<\/span><\/p>\n<h2 class=\"hynlcx1 hynlcx3\" translations=\"[object Object]\"><span>Token Metrics API Overview<\/span><\/h2>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>The Token Metrics Data API is a comprehensive data solution that offers both real-time and historical <\/span><span><a href=\"https:\/\/app.tokenmetrics.com\/market\" rel=\"noopener\" target=\"_blank\">market data<\/a><\/span><span> for cryptocurrencies. Its purpose is to aid developers and businesses in accessing and analyzing data promptly to make informed decisions.<\/span><\/p>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>Regardless of whether you&#8217;re a seasoned developer or just starting in the cryptocurrency world, you can maximize your crypto portfolio using the end-points provided by Token Metrics.\u00a0<\/span><\/p>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>The Data API provides a stream of <\/span><span><strong>14 endpoints<\/strong><\/span><span>, including exclusive grades, analytics, and indicators, that can be utilized to empower your bots, models, and platforms. The data provided by the API can assist you in:<\/span><\/p>\n<ul class=\"_1ao94nj1\" translations=\"[object Object]\">\n<li>\n<div>\n<p><span>Validating<\/span><\/p>\n<\/div>\n<\/li>\n<li>\n<div>\n<p><span>Back-testing, and\u00a0<\/span><\/p>\n<\/div>\n<\/li>\n<li>\n<div>\n<p><span>Refining your investment decision-making process.\u00a0<\/span><\/p>\n<\/div>\n<\/li>\n<\/ul>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>Let\u2019s check the process of pulling the crypto data into an Excel sheet in the 7-step breakdown below\u2026<\/span><\/p>\n<h2 class=\"hynlcx1 hynlcx3\" translations=\"[object Object]\"><span>Import Crypto Data in Google Sheets and Excel<\/span><\/h2>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>Here\u2019s the step-by-step breakdown of extracting crypto data into an Excel Sheet using Token Metrics:<\/span><\/p>\n<h3 class=\"hynlcx1 hynlcx4\" translations=\"[object Object]\"><span>1. Register on Token Metrics Platform<\/span><\/h3>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>First, head over to <\/span><span><a href=\"https:\/\/tokenmetrics.com\/\" rel=\"noopener\" target=\"_blank\">www.tokenmetrics.com\/crypto-data-api<\/a><\/span><span> and login\/signup using your credentials.<\/span><\/p>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span><strong>Note:<\/strong><\/span><span> If you are new to Token Metrics, then click on <\/span><span><strong>Register<\/strong><\/span><span>, and sign-up for a 7-day free trial. One Bonus: You can pay with NFT.<\/span><\/p>\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/media.beehiiv.com\/cdn-cgi\/image\/fit=scale-down,quality=80,format=auto,onerror=redirect\/uploads\/asset\/file\/797f35a9-5f85-49f5-be4b-1538c1fa00f9\/64254d2825e3e4f799aeb03c_7kOC67vR-zGtwM-vkVTR4qTrtxS_5E3oebtb1UDFNA9mrAXabeBRclp6uJbsNJm1eqylIWklzDZxJDDGzIHJ65hWU2J5ff88dsHRdlNQsfwIYeUmOkReym8qG6GphvFXTgWYXU_J2cQnvJULVYTeiOg.png\" alt=\"\" title=\"\"><\/figure>\n<h3 class=\"hynlcx1 hynlcx4\" translations=\"[object Object]\"><span>2. Go to Homepage<\/span><\/h3>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>Once you are in, you will be guided to the homepage, where you will have all rating of crypto assets, as shown below:\u00a0\u00a0<\/span><\/p>\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/media.beehiiv.com\/cdn-cgi\/image\/fit=scale-down,quality=80,format=auto,onerror=redirect\/uploads\/asset\/file\/35e05414-3133-47ce-85c4-b3a8b6b0ed8e\/64254d28afde374e58ee05f8_yrV029XVzIWWJSTd1XLmo220pAROBNgNfFEun9wQ63CBPC6Beg2Z6KVXHWwvhf-JGxV8nDot94f8Ttgq4yxHIRKXhAYJtLejH5Z4H1DqgGEJPgsR4_J-Hpjzj0469JMDlXWVbyDa_oSPEZumzqN21P4.png\" alt=\"\" title=\"\"><\/figure>\n<h3 class=\"hynlcx1 hynlcx4\" translations=\"[object Object]\"><span>3. Click on the DATA API<\/span><\/h3>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>Now, click on the \u201cDATA API\u201d from the Menu Bar on the top. [Refer to the image below]<\/span><\/p>\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/media.beehiiv.com\/cdn-cgi\/image\/fit=scale-down,quality=80,format=auto,onerror=redirect\/uploads\/asset\/file\/5dd7ceaa-c2b4-4851-aebe-2e83f541e699\/64254d28384515312606b34d_XCkJlTBiYsBdZMDbF-nqMIdBpYjrKssZKP4M6_jTf7RzSFLRGziUL-Lk1pSIMat7nLBuAcja1Z3ntMSchwslTD0Xp8D4p5VOkOOZXoynwAojkfgJRhOTF8jafHUt5yMlkAxgVg6wwgqbZip_2rSuoMI.png\" alt=\"\" title=\"\"><\/figure>\n<h3 class=\"hynlcx1 hynlcx4\" translations=\"[object Object]\"><span>4. Generate Access Key<\/span><\/h3>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>From here, you need to generate your access key using the &#8220;Generate Access Key&#8221; button [as seen on the top-right corner of the image below].\u00a0<\/span><\/p>\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/media.beehiiv.com\/cdn-cgi\/image\/fit=scale-down,quality=80,format=auto,onerror=redirect\/uploads\/asset\/file\/1735443c-fc58-4863-9172-d7c4f3789fd4\/64254d28654f2a987f60df4f_HufO8iff4-yCRLnNIBs95ak7bo1tXnNji40c2jD8YwN7Rwr5YEH0W1EL71p6O6JcuGEUMyC784DAP3rSuNwUtyjfC9_UJGR_KGAWxUHOl7t2-JG2fWicytJGdMsMnHLNoWw1p1PEAhdk8Wdiq59aqEY.png\" alt=\"\" title=\"\"><\/figure>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>\u200d<\/span><span><strong>Important Note:<\/strong><\/span><\/p>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>Copy and save the access key shown on the next page as it will not be made visible again.<\/span><\/p>\n<h3 class=\"hynlcx1 hynlcx4\" translations=\"[object Object]\"><span>5. Open Google Sheets<\/span><\/h3>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>It\u2019s now time to open <\/span><span><a href=\"https:\/\/docs.google.com\/spreadsheets\" rel=\"noopener\" target=\"_blank\">Google Sheets<\/a><\/span><span> and create a new spreadsheet.<\/span><\/p>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>In this new spreadsheet, enter some crypto assets under Column 1 and their symbol in Column 2 like this.<\/span><\/p>\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/media.beehiiv.com\/cdn-cgi\/image\/fit=scale-down,quality=80,format=auto,onerror=redirect\/uploads\/asset\/file\/2c82dcc3-0d3d-4b68-b410-1e5077255d95\/64254d28aeb35318a6af1323_xKnEDIkL806WWQMkp4qvvfMhX11yfqv7w3J4fCq3FH0ber5sk6eo4Of2fSbH95dKS8mYY2dPIMPMgcTdEIfQUwn5ylvt47cHd7_35IYiRKYEyHs7pFxAXk4Mi3dWB7zdtYh7sqYLfvDgieuHHxnBwoE.png\" alt=\"\" title=\"\"><\/figure>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>Here, we have put TM Token ID in Column 3, a unique identifier associated with each token in the TM Data API ecosystem. This will make your life easier once you become familiar with our interface on a daily basis.<\/span><\/p>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>In Column 4 and Column 5, we have put TM Investor Grade and TM Trader Signal, respectively, which will be fetched from TM Data API in the following steps.<\/span><\/p>\n<h3 class=\"hynlcx1 hynlcx4\" translations=\"[object Object]\"><span>6. Go to Extensions and click Apps Script<\/span><\/h3>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>Now, hover over to the &#8220;Extensions&#8221; tab under the menu bar and click &#8220;Apps Script&#8221; where we will write scripts to automate the fetching of the above metrics in the Google Sheets.\u00a0<\/span><\/p>\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/media.beehiiv.com\/cdn-cgi\/image\/fit=scale-down,quality=80,format=auto,onerror=redirect\/uploads\/asset\/file\/2290310f-0912-413f-92dd-07b798ac2d0e\/64254d28dcaff43010d33509_npd8CQ6_KfCtLy34VgL_cm3vTRR3He1TZhW6lGapRuXB6XOejOy76FgMQeKO9gz3RtWYqsmeOVgb2dCcjsw8auCRPYcY5H4SIXRSIdYLhswem1H3LldEQ_Ok0NsveKBZXhI4iVBzDj8Q-YpoVDzCFWQ.png\" alt=\"\" title=\"\"><\/figure>\n<h3 class=\"hynlcx1 hynlcx4\" translations=\"[object Object]\"><span>7. Apps Script IDE<\/span><\/h3>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>Now, our powerful \u2018Apps Script IDE\u2019 will be opened, where we will write the code to the script and later deploy as necessary.\u00a0<\/span><\/p>\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/media.beehiiv.com\/cdn-cgi\/image\/fit=scale-down,quality=80,format=auto,onerror=redirect\/uploads\/asset\/file\/5cb1ac27-f576-4574-b423-48990e4ff827\/64254d29dd0d324f35e29661_U3FifjbkydwBiDWyNcN7ewS0mdW-5BGwlNJF21R56wHET2eXVXyVP4PyS_9vPiV6R3XCR0_PY-XtZYLW1D_4DfYBxdYRA6Fgz0iub0qNDbu-NXc9_0DlGLFqTalp4WgOh0zPAkuwJvngOYd2nTY0rEY.png\" alt=\"\" title=\"\"><\/figure>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span><strong>The Code Format:\u00a0<\/strong><\/span><\/p>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>We will start writing the script in <\/span><span><a href=\"https:\/\/Code.gs\" rel=\"noopener\" target=\"_blank\">Code.gs<\/a><\/span><span> file.<\/span><\/p>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>The following part will be focused on the actual code that will be written in the script file.<\/span><\/p>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>Run the Open() function once using the above command, and you will see a menu &#8220;Update Metrics&#8221; in the spreadsheet menu bar with the following options:<\/span><\/p>\n<ul class=\"_1ao94nj1\" translations=\"[object Object]\">\n<li>\n<div>\n<p><span>TM Token Ids<\/span><\/p>\n<\/div>\n<\/li>\n<li>\n<div>\n<p><span>TM Investor Grade<\/span><\/p>\n<\/div>\n<\/li>\n<li>\n<div>\n<p><span>TM Trader Signal\u00a0<\/span><\/p>\n<\/div>\n<\/li>\n<\/ul>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>You can click on all the three options, one at a time, to see the results displayed on the spreadsheet.<\/span><\/p>\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/media.beehiiv.com\/cdn-cgi\/image\/fit=scale-down,quality=80,format=auto,onerror=redirect\/uploads\/asset\/file\/e4474e48-c4f6-40e1-b500-a38e119741c4\/64254d29df847150d1afed5b_4q1Q2OhZdsdreK73zmd3ZimzWFNDn9YpbiHcNCtIMmBmd5QYmYgbetavB8kfK0fybtQeZopQxDaZSDvs5Rw-Ka_RX1II9yR9cAwsajs8OLmleFP3_Axb_ACPcnfGpkwZG98Bb60P0M3WFRkPqG3JdQo.png\" alt=\"\" title=\"\"><\/figure>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>Also, you can update the metrics whenever required by pressing the above buttons in the menu bar, so that you get the accurate data for your investments.\u00a0<\/span><\/p>\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/media.beehiiv.com\/cdn-cgi\/image\/fit=scale-down,quality=80,format=auto,onerror=redirect\/uploads\/asset\/file\/c6c08374-aa5c-433f-8e35-ae2c0a594495\/64254d29e353046b4f3a3084_6GVJISiVyc-ZZGRc-G5-Rc1roapZt21pawkylglEbPFwlPKY3LFKd94Q4ZZyUwFFDmUjMrd5kPKtuIwttjzedhVJDbevPlGEJfF8qcrw0AKh96bhDJhHKs1XZSZJ6fwQY1AIZkUCxszwBICaxagO26c.png\" alt=\"\" title=\"\"><\/figure>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span><strong>Interested?<\/strong><\/span><\/p>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>Looking to learn more about our Crypto data API?<\/span><\/p>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>Just head over here &#8211; <\/span><span><a href=\"https:\/\/tokenmetrics.com\/\" rel=\"noopener\" target=\"_blank\">developers.tokenmetrics.com<\/a><\/span><\/p>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>Having explained all this, let the truth be told. Token Metrics does not personally favor or vouch for any particular cryptocurrency in the market.\u00a0<\/span><\/p>\n<h2 class=\"hynlcx1 hynlcx3\" translations=\"[object Object]\"><span><strong>The Bottom Line<\/strong><\/span><\/h2>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span><strong>In conclusion<\/strong><\/span><span>, pulling crypto data into an Excel spreadsheet using an API can be a useful and efficient way to keep track of market trends and analyze cryptocurrency performance.\u00a0<\/span><\/p>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>By following the steps outlined in this process, one can easily integrate an API into Excel and retrieve real-time data on various cryptocurrencies.\u00a0<\/span><\/p>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>Additionally, with the vast array of features available on Token Metrics API, one can tailor their data retrieval to specific preferences and easily manipulate the data in Excel for further analysis.\u00a0<\/span><\/p>\n<p class=\"dream-post-content-paragraph j6zgbu1\"><span>With the growing importance of cryptocurrencies in the financial world, utilizing APIs to pull crypto data into Excel can provide a valuable tool for traders, investors, and researchers alike.<\/span><\/p>\n<p><!-- Migrated draft from Beehiiv source: https:\/\/blog.tokenmetrics.com\/p\/how-to-get-crypto-price-data-in-excel-and-google-sheets-in-2026 --><\/p>\n","protected":false},"excerpt":{"rendered":"Cryptocurrencies have become increasingly popular over the past few years, and more people are now investing in them.","protected":false},"author":1,"featured_media":3199,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_tm_paid_cta_tier":"","_tm_paid_cta_heading":"","_tm_paid_cta_body":"","csco_display_header_overlay":false,"csco_singular_sidebar":"","csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_reading_time":"","csco_page_toc_navigation":"","csco_post_video_location":[],"csco_post_video_location_hash":"","csco_post_video_url":"","csco_post_video_bg_start_time":0,"csco_post_video_bg_end_time":0,"csco_post_video_bg_volume":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[664],"tags":[665],"sections":[],"entities":[],"class_list":["post-2883","post","type-post","status-publish","format-standard","has-post-thumbnail","category-crypto-basics","tag-token-metrics-blog","cs-entry","cs-video-wrap"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/tokenmetrics.com\/blog\/wp-content\/uploads\/2026\/06\/how-to-get-crypto-price-data-in-excel-and-google-sheets-in-2-regen-1781456952951.webp","_links":{"self":[{"href":"https:\/\/tokenmetrics.com\/blog\/wp-json\/wp\/v2\/posts\/2883","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tokenmetrics.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tokenmetrics.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tokenmetrics.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tokenmetrics.com\/blog\/wp-json\/wp\/v2\/comments?post=2883"}],"version-history":[{"count":2,"href":"https:\/\/tokenmetrics.com\/blog\/wp-json\/wp\/v2\/posts\/2883\/revisions"}],"predecessor-version":[{"id":3201,"href":"https:\/\/tokenmetrics.com\/blog\/wp-json\/wp\/v2\/posts\/2883\/revisions\/3201"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tokenmetrics.com\/blog\/wp-json\/wp\/v2\/media\/3199"}],"wp:attachment":[{"href":"https:\/\/tokenmetrics.com\/blog\/wp-json\/wp\/v2\/media?parent=2883"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tokenmetrics.com\/blog\/wp-json\/wp\/v2\/categories?post=2883"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tokenmetrics.com\/blog\/wp-json\/wp\/v2\/tags?post=2883"},{"taxonomy":"section","embeddable":true,"href":"https:\/\/tokenmetrics.com\/blog\/wp-json\/wp\/v2\/sections?post=2883"},{"taxonomy":"entity","embeddable":true,"href":"https:\/\/tokenmetrics.com\/blog\/wp-json\/wp\/v2\/entities?post=2883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}