{"id":129,"date":"2023-05-15T12:46:08","date_gmt":"2023-05-15T16:46:08","guid":{"rendered":"https:\/\/kb.tiingo.com\/kb\/?post_type=ht_kb&#038;p=129"},"modified":"2023-05-15T12:46:08","modified_gmt":"2023-05-15T16:46:08","slug":"how-to-use-tiingo-data-with-google-sheets","status":"publish","type":"ht_kb","link":"https:\/\/www.tiingo.com\/kb\/article\/how-to-use-tiingo-data-with-google-sheets\/","title":{"rendered":"How to use Tiingo Data with Google Sheets"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"introduction\">Introduction<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Google sheets are a convenient way to view and manipulate data for analysis. It can be helpful to have financial data imported into your spreadsheets for analysis. As such, this article will guide you on how to use Tiingo API Data with Google Sheets<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"using-tiingo-api-data-with-google-sheets\">Using Tiingo API Data with Google Sheets<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 1: You will need your Tiingo API Token<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">For this article, you will need your Tiingo API Token. For information on how to obtain this token, please visit this article first:\u00a0<a href=\"\/kb\/article\/where-to-find-your-tiingo-api-token\/\" target=\"_blank\" rel=\"noreferrer noopener\">Where to find your Tiingo API Token<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once you have this token, come back to this article.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2: Use our Google Spreadsheet Example<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">We recommend using our example Google Sheets document here:&nbsp;<a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1UbSFuRqnBWoBvJeoSP3csMTL6jG-DpF88bMCHUqG-SY\/edit?usp=sharing\">https:\/\/docs.google.com\/spreadsheets\/d\/1UbSFuRqnBWoBvJeoSP3csMTL6jG-DpF88bMCHUqG-SY\/edit?usp=sharing<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">On the first tab, you can paste your Tiingo API Token, then use that spreadsheet for examples on how to import Tiingo Data into the Google Sheet. You may want to make a copy of the spreadsheet first so you can edit it.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Google sheets are a convenient way to view and manipulate data for analysis. It can be helpful to have financial data imported into your spreadsheets for analysis. As such, this article will guide you on how to use Tiingo API Data with Google Sheets Using Tiingo API Data with&#8230;<\/p>\n","protected":false},"author":1,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"ht-kb-category":[20,6],"ht-kb-tag":[],"class_list":["post-129","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-tiingo-api-integrations","ht_kb_category-tiingo-api"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.8 (Yoast SEO v20.8) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to use Tiingo Data with Google Sheets - Tiingo Knowledge Base<\/title>\n<meta name=\"description\" content=\"This articles guides you on how to import Tiingo Data directly into Google Sheets, using the Tiingo API. Create your own financial spreadsheets.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.tiingo.com\/kb\/article\/how-to-use-tiingo-data-with-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to use Tiingo Data with Google Sheets\" \/>\n<meta property=\"og:description\" content=\"This articles guides you on how to import Tiingo Data directly into Google Sheets, using the Tiingo API. Create your own financial spreadsheets.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.tiingo.com\/kb\/article\/how-to-use-tiingo-data-with-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Tiingo Knowledge Base\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/tiingofinance\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@tiingofinance\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.tiingo.com\/kb\/article\/how-to-use-tiingo-data-with-google-sheets\/\",\"url\":\"https:\/\/www.tiingo.com\/kb\/article\/how-to-use-tiingo-data-with-google-sheets\/\",\"name\":\"How to use Tiingo Data with Google Sheets - Tiingo Knowledge Base\",\"isPartOf\":{\"@id\":\"\/#website\"},\"datePublished\":\"2023-05-15T16:46:08+00:00\",\"dateModified\":\"2023-05-15T16:46:08+00:00\",\"description\":\"This articles guides you on how to import Tiingo Data directly into Google Sheets, using the Tiingo API. Create your own financial spreadsheets.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.tiingo.com\/kb\/article\/how-to-use-tiingo-data-with-google-sheets\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"\/#website\",\"url\":\"\/\",\"name\":\"Tiingo Knowledge Base\",\"description\":\"\",\"publisher\":{\"@id\":\"\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"\/#organization\",\"name\":\"Tiingo.com\",\"url\":\"\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.tiingo.com\/kb\/wp-content\/uploads\/2023\/05\/purple-for-light-bg.svg\",\"contentUrl\":\"https:\/\/www.tiingo.com\/kb\/wp-content\/uploads\/2023\/05\/purple-for-light-bg.svg\",\"width\":\"1024\",\"height\":\"1024\",\"caption\":\"Tiingo.com\"},\"image\":{\"@id\":\"\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/tiingofinance\/\",\"https:\/\/twitter.com\/tiingofinance\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to use Tiingo Data with Google Sheets - Tiingo Knowledge Base","description":"This articles guides you on how to import Tiingo Data directly into Google Sheets, using the Tiingo API. Create your own financial spreadsheets.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.tiingo.com\/kb\/article\/how-to-use-tiingo-data-with-google-sheets\/","og_locale":"en_US","og_type":"article","og_title":"How to use Tiingo Data with Google Sheets","og_description":"This articles guides you on how to import Tiingo Data directly into Google Sheets, using the Tiingo API. Create your own financial spreadsheets.","og_url":"https:\/\/www.tiingo.com\/kb\/article\/how-to-use-tiingo-data-with-google-sheets\/","og_site_name":"Tiingo Knowledge Base","article_publisher":"https:\/\/www.facebook.com\/tiingofinance\/","twitter_card":"summary_large_image","twitter_site":"@tiingofinance","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.tiingo.com\/kb\/article\/how-to-use-tiingo-data-with-google-sheets\/","url":"https:\/\/www.tiingo.com\/kb\/article\/how-to-use-tiingo-data-with-google-sheets\/","name":"How to use Tiingo Data with Google Sheets - Tiingo Knowledge Base","isPartOf":{"@id":"\/#website"},"datePublished":"2023-05-15T16:46:08+00:00","dateModified":"2023-05-15T16:46:08+00:00","description":"This articles guides you on how to import Tiingo Data directly into Google Sheets, using the Tiingo API. Create your own financial spreadsheets.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.tiingo.com\/kb\/article\/how-to-use-tiingo-data-with-google-sheets\/"]}]},{"@type":"WebSite","@id":"\/#website","url":"\/","name":"Tiingo Knowledge Base","description":"","publisher":{"@id":"\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"\/#organization","name":"Tiingo.com","url":"\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"\/#\/schema\/logo\/image\/","url":"https:\/\/www.tiingo.com\/kb\/wp-content\/uploads\/2023\/05\/purple-for-light-bg.svg","contentUrl":"https:\/\/www.tiingo.com\/kb\/wp-content\/uploads\/2023\/05\/purple-for-light-bg.svg","width":"1024","height":"1024","caption":"Tiingo.com"},"image":{"@id":"\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/tiingofinance\/","https:\/\/twitter.com\/tiingofinance"]}]}},"_links":{"self":[{"href":"https:\/\/www.tiingo.com\/kb\/wp-json\/wp\/v2\/ht-kb\/129","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tiingo.com\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.tiingo.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.tiingo.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tiingo.com\/kb\/wp-json\/wp\/v2\/comments?post=129"}],"version-history":[{"count":1,"href":"https:\/\/www.tiingo.com\/kb\/wp-json\/wp\/v2\/ht-kb\/129\/revisions"}],"predecessor-version":[{"id":130,"href":"https:\/\/www.tiingo.com\/kb\/wp-json\/wp\/v2\/ht-kb\/129\/revisions\/130"}],"wp:attachment":[{"href":"https:\/\/www.tiingo.com\/kb\/wp-json\/wp\/v2\/media?parent=129"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.tiingo.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=129"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.tiingo.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}