Excel

Google Sheets

> Cryptocurrency related events/ICO dates at your fingertips

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/Kryptocal">Kryptocal</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/Kryptocal/categories" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/kryptocal/categories) | **categories** | <inline-code functionvalue='=CS.QUERY("Kryptocal","categories")'>=CS.QUERY("Kryptocal","categories")</inline-code> | <inline-code>=CS.PARAMETERS("Kryptocal","categories")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Kryptocal/timezones" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/kryptocal/timezones) | **timezones** | <inline-code functionvalue='=CS.QUERY("Kryptocal","timezones")'>=CS.QUERY("Kryptocal","timezones")</inline-code> | <inline-code>=CS.PARAMETERS("Kryptocal","timezones")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Kryptocal/events" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/kryptocal/events) | **events** | <inline-code functionvalue='=CS.QUERY("Kryptocal","events",{"fromDate","2019-09-01";"toDate","2019-10-01"})'>=CS.QUERY("Kryptocal","events")</inline-code> | <inline-code>=CS.PARAMETERS("Kryptocal","events")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Kryptocal/events%20by%20category" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/kryptocal/events-by-category) | **events by category** | <inline-code functionvalue='=CS.QUERY("Kryptocal","events by category",{"categoryId","1"})'>=CS.QUERY("Kryptocal","events by category")</inline-code> | <inline-code>=CS.PARAMETERS("Kryptocal","events by category")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Kryptocal/events%20by%20symbol" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/kryptocal/events-by-symbol) | **events by symbol** | <inline-code functionvalue='=CS.QUERY("Kryptocal","events by symbol",{"symbol","btc"})'>=CS.QUERY("Kryptocal","events by symbol")</inline-code> | <inline-code>=CS.PARAMETERS("Kryptocal","events by symbol")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Kryptocal/past%20events%20by%20symbol" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/kryptocal/past-events-by-symbol) | **past events by symbol** | <inline-code functionvalue='=CS.QUERY("Kryptocal","past events by symbol",{"symbol","btc"})'>=CS.QUERY("Kryptocal","past events by symbol")</inline-code> | <inline-code>=CS.PARAMETERS("Kryptocal","past events by symbol")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Kryptocal/coin%20search" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/kryptocal/coin-search) | **coin search** | <inline-code functionvalue='=CS.QUERY("Kryptocal","coin search",{"query","hack"})'>=CS.QUERY("Kryptocal","coin search")</inline-code> | <inline-code>=CS.PARAMETERS("Kryptocal","coin search")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Kryptocal/coin" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/kryptocal/coin) | **coin** | <inline-code functionvalue='=CS.QUERY("Kryptocal","coin",{"symbol","btc"})'>=CS.QUERY("Kryptocal","coin")</inline-code> | <inline-code>=CS.PARAMETERS("Kryptocal","coin")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Kryptocal/contribution%20addresses" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/kryptocal/contribution-addresses) | **contribution addresses** | <inline-code functionvalue='=CS.QUERY("Kryptocal","contribution addresses")'>=CS.QUERY("Kryptocal","contribution addresses")</inline-code> | <inline-code>=CS.PARAMETERS("Kryptocal","contribution addresses")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Kryptocal/announcements" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/kryptocal/announcements) | **announcements** | <inline-code functionvalue='=CS.QUERY("Kryptocal","announcements",{"coinid","1"})'>=CS.QUERY("Kryptocal","announcements")</inline-code> | <inline-code>=CS.PARAMETERS("Kryptocal","announcements")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Kryptocal/coins" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/kryptocal/coins) | **coins** | <inline-code functionvalue='=CS.QUERY("Kryptocal","coins")'>=CS.QUERY("Kryptocal","coins")</inline-code> | <inline-code>=CS.PARAMETERS("Kryptocal","coins")</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/Kryptocal/categories" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/kryptocal/categories) | **categories** | <inline-code functionvalue='=CSQUERY("Kryptocal","categories")'>=CSQUERY("Kryptocal","categories")</inline-code> | <inline-code>=CSPARAMETERS("Kryptocal","categories")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Kryptocal/timezones" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/kryptocal/timezones) | **timezones** | <inline-code functionvalue='=CSQUERY("Kryptocal","timezones")'>=CSQUERY("Kryptocal","timezones")</inline-code> | <inline-code>=CSPARAMETERS("Kryptocal","timezones")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Kryptocal/events" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/kryptocal/events) | **events** | <inline-code functionvalue='=CSQUERY("Kryptocal","events",{"fromDate","2019-09-01";"toDate","2019-10-01"})'>=CSQUERY("Kryptocal","events")</inline-code> | <inline-code>=CSPARAMETERS("Kryptocal","events")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Kryptocal/events%20by%20category" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/kryptocal/events-by-category) | **events by category** | <inline-code functionvalue='=CSQUERY("Kryptocal","events by category",{"categoryId","1"})'>=CSQUERY("Kryptocal","events by category")</inline-code> | <inline-code>=CSPARAMETERS("Kryptocal","events by category")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Kryptocal/events%20by%20symbol" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/kryptocal/events-by-symbol) | **events by symbol** | <inline-code functionvalue='=CSQUERY("Kryptocal","events by symbol",{"symbol","btc"})'>=CSQUERY("Kryptocal","events by symbol")</inline-code> | <inline-code>=CSPARAMETERS("Kryptocal","events by symbol")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Kryptocal/past%20events%20by%20symbol" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/kryptocal/past-events-by-symbol) | **past events by symbol** | <inline-code functionvalue='=CSQUERY("Kryptocal","past events by symbol",{"symbol","btc"})'>=CSQUERY("Kryptocal","past events by symbol")</inline-code> | <inline-code>=CSPARAMETERS("Kryptocal","past events by symbol")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Kryptocal/coin%20search" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/kryptocal/coin-search) | **coin search** | <inline-code functionvalue='=CSQUERY("Kryptocal","coin search",{"query","hack"})'>=CSQUERY("Kryptocal","coin search")</inline-code> | <inline-code>=CSPARAMETERS("Kryptocal","coin search")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Kryptocal/coin" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/kryptocal/coin) | **coin** | <inline-code functionvalue='=CSQUERY("Kryptocal","coin",{"symbol","btc"})'>=CSQUERY("Kryptocal","coin")</inline-code> | <inline-code>=CSPARAMETERS("Kryptocal","coin")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Kryptocal/contribution%20addresses" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/kryptocal/contribution-addresses) | **contribution addresses** | <inline-code functionvalue='=CSQUERY("Kryptocal","contribution addresses")'>=CSQUERY("Kryptocal","contribution addresses")</inline-code> | <inline-code>=CSPARAMETERS("Kryptocal","contribution addresses")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Kryptocal/announcements" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/kryptocal/announcements) | **announcements** | <inline-code functionvalue='=CSQUERY("Kryptocal","announcements",{"coinid","1"})'>=CSQUERY("Kryptocal","announcements")</inline-code> | <inline-code>=CSPARAMETERS("Kryptocal","announcements")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Kryptocal/coins" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/kryptocal/coins) | **coins** | <inline-code functionvalue='=CSQUERY("Kryptocal","coins")'>=CSQUERY("Kryptocal","coins")</inline-code> | <inline-code>=CSPARAMETERS("Kryptocal","coins")</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-Kryptocal">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-Kryptocal">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="">Click here</a>** for additional documentation from Kryptocal

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

---

Tags: `Kryptocal` `provider` 


How to pull Kryptocal data into Excel and Google Sheets