Excel

Google Sheets

> The COVID Tracking Project obtains, organizes, and publishes high-quality data required to understand and respond to the COVID-19 outbreak in the United States.

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/Covidtracking">Covidtracking</a>** endpoint using **Cryptosheets** through:

- `side panel console`
- `custom functions` (Excel & Googlesheets)
- `templates`

## Excel

<div class="markdown">

| App Url                                                                                 | Docs Url                                                                                 | Name                        | Example                                             | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | --------------------------------------------------- | --------   | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/Covidtracking/States%20Current%20Values" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/covidtracking/states-current-values) | **States Current Values** | <inline-code functionvalue='=CS.QUERY("Covidtracking","States Current Values")'>=CS.QUERY("Covidtracking","States Current Values")</inline-code> | <inline-code>=CS.PARAMETERS("Covidtracking","States Current Values")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Covidtracking/States%20Historical%20Data" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/covidtracking/states-historical-data) | **States Historical Data** | <inline-code functionvalue='=CS.QUERY("Covidtracking","States Historical Data",{"state","NY";"date","20200316"})'>=CS.QUERY("Covidtracking","States Historical Data")</inline-code> | <inline-code>=CS.PARAMETERS("Covidtracking","States Historical Data")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Covidtracking/States%20Information" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/covidtracking/states-information) | **States Information** | <inline-code functionvalue='=CS.QUERY("Covidtracking","States Information")'>=CS.QUERY("Covidtracking","States Information")</inline-code> | <inline-code>=CS.PARAMETERS("Covidtracking","States Information")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Covidtracking/US%20Current%20Values" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/covidtracking/us-current-values) | **US Current Values** | <inline-code functionvalue='=CS.QUERY("Covidtracking","US Current Values")'>=CS.QUERY("Covidtracking","US Current Values")</inline-code> | <inline-code>=CS.PARAMETERS("Covidtracking","US Current Values")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Covidtracking/US%20Historical%20Data" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/covidtracking/us-historical-data) | **US Historical Data** | <inline-code functionvalue='=CS.QUERY("Covidtracking","US Historical Data")'>=CS.QUERY("Covidtracking","US Historical Data")</inline-code> | <inline-code>=CS.PARAMETERS("Covidtracking","US Historical Data")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Covidtracking/Counties" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/covidtracking/counties) | **Counties** | <inline-code functionvalue='=CS.QUERY("Covidtracking","Counties")'>=CS.QUERY("Covidtracking","Counties")</inline-code> | <inline-code>=CS.PARAMETERS("Covidtracking","Counties")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Covidtracking/Tracker%20URLs" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/covidtracking/tracker-urls) | **Tracker URLs** | <inline-code functionvalue='=CS.QUERY("Covidtracking","Tracker URLs")'>=CS.QUERY("Covidtracking","Tracker URLs")</inline-code> | <inline-code>=CS.PARAMETERS("Covidtracking","Tracker URLs")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Covidtracking/State%20Website%20Screenshots" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/covidtracking/state-website-screenshots) | **State Website Screenshots** | <inline-code functionvalue='=CS.QUERY("Covidtracking","State Website Screenshots")'>=CS.QUERY("Covidtracking","State Website Screenshots")</inline-code> | <inline-code>=CS.PARAMETERS("Covidtracking","State Website Screenshots")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Covidtracking/In%20the%20press" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/covidtracking/in-the-press) | **In the press** | <inline-code functionvalue='=CS.QUERY("Covidtracking","In the press")'>=CS.QUERY("Covidtracking","In the press")</inline-code> | <inline-code>=CS.PARAMETERS("Covidtracking","In the press")</inline-code> | 0 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/Covidtracking/States%20Current%20Values" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/covidtracking/states-current-values) | **States Current Values** | <inline-code functionvalue='=CSQUERY("Covidtracking","States Current Values")'>=CSQUERY("Covidtracking","States Current Values")</inline-code> | <inline-code>=CSPARAMETERS("Covidtracking","States Current Values")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Covidtracking/States%20Historical%20Data" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/covidtracking/states-historical-data) | **States Historical Data** | <inline-code functionvalue='=CSQUERY("Covidtracking","States Historical Data",{"state","NY";"date","20200316"})'>=CSQUERY("Covidtracking","States Historical Data")</inline-code> | <inline-code>=CSPARAMETERS("Covidtracking","States Historical Data")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Covidtracking/States%20Information" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/covidtracking/states-information) | **States Information** | <inline-code functionvalue='=CSQUERY("Covidtracking","States Information")'>=CSQUERY("Covidtracking","States Information")</inline-code> | <inline-code>=CSPARAMETERS("Covidtracking","States Information")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Covidtracking/US%20Current%20Values" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/covidtracking/us-current-values) | **US Current Values** | <inline-code functionvalue='=CSQUERY("Covidtracking","US Current Values")'>=CSQUERY("Covidtracking","US Current Values")</inline-code> | <inline-code>=CSPARAMETERS("Covidtracking","US Current Values")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Covidtracking/US%20Historical%20Data" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/covidtracking/us-historical-data) | **US Historical Data** | <inline-code functionvalue='=CSQUERY("Covidtracking","US Historical Data")'>=CSQUERY("Covidtracking","US Historical Data")</inline-code> | <inline-code>=CSPARAMETERS("Covidtracking","US Historical Data")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Covidtracking/Counties" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/covidtracking/counties) | **Counties** | <inline-code functionvalue='=CSQUERY("Covidtracking","Counties")'>=CSQUERY("Covidtracking","Counties")</inline-code> | <inline-code>=CSPARAMETERS("Covidtracking","Counties")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Covidtracking/Tracker%20URLs" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/covidtracking/tracker-urls) | **Tracker URLs** | <inline-code functionvalue='=CSQUERY("Covidtracking","Tracker URLs")'>=CSQUERY("Covidtracking","Tracker URLs")</inline-code> | <inline-code>=CSPARAMETERS("Covidtracking","Tracker URLs")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Covidtracking/State%20Website%20Screenshots" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/covidtracking/state-website-screenshots) | **State Website Screenshots** | <inline-code functionvalue='=CSQUERY("Covidtracking","State Website Screenshots")'>=CSQUERY("Covidtracking","State Website Screenshots")</inline-code> | <inline-code>=CSPARAMETERS("Covidtracking","State Website Screenshots")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Covidtracking/In%20the%20press" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/covidtracking/in-the-press) | **In the press** | <inline-code functionvalue='=CSQUERY("Covidtracking","In the press")'>=CSQUERY("Covidtracking","In the press")</inline-code> | <inline-code>=CSPARAMETERS("Covidtracking","In the press")</inline-code> | 0 |

</div>

[Signing up for Cryptosheets is free](https://app.cryptosheets.com/#/register) get crypto data in 30 seconds or less

**<a href="https://appsource.microsoft.com/en-us/product/office/WA104381695?src=docs-Covidtracking">Get Cryptosheets for Microsoft Excel</a>**

**<a href="https://gsuite.google.com/u/2/marketplace/app/cryptosheets/898843532532?hl=en&pann=sheets_addon_widget?src=docs-Covidtracking">Get Cryptosheets for Googlesheets</a>**

\*Note: you must have one of the [supported versions](https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-architecture) of Microsoft Office or Excel for custom functions to work

**<a href="https://covidtracking.com/api">Click here</a>** for additional documentation from Covidtracking

Learn more [here](https://intercom.help/cryptosheets/en/)

---

Tags: `Covidtracking` `provider` 


How to pull Covidtracking data into Excel and Google Sheets