👉 Method 1 - 

👉 Method 2 - 

Need More Help?

Cryptosheets makes it easy for anybody to pull a wide variety of crypto data into their Excel or Googlesheets. This tutorial will show you two different ways to do this.

> ⚠️ Before you do, make sure you have:

- [registered](https://intercom.help/cryptosheets/en/articles/1764650-first-time-install-and-login-for-cryptosheets)
- [verified your email](https://intercom.help/cryptosheets/en/articles/1764650-first-time-install-and-login-for-cryptosheets)
- [installed the add-in](https://intercom.help/cryptosheets/en/articles/1764650-first-time-install-and-login-for-cryptosheets)
- [logged in using the Cryptosheets side panel ](https://intercom.help/cryptosheets/en/articles/1764650-first-time-install-and-login-for-cryptosheets)

**There are 2 primary ways to do this:**

- [Custom Functions](https://docs.cryptosheets.com/functions) (aka formulas)*
- [API Console in the Side Panel](https://www.youtube.com/playlist?list=PLBg8GR5ao-azkVyW-optnK7tILh9vecrn)

### 👉 Method 1 - [Custom Functions](https://docs.cryptosheets.com/functions)

- Custom functions are a type of formula you can use in either Excel or Googlesheets. 
- All Cryptosheets custom functions begin with "CS" and can be accessed once you have logged into the side panel.

**To get data with a custom function follow these steps...**

1. In any cell **type the following then press enter**:
  - Excel: `=CS.PRICE("BTC","USD")`
  - Googlesheets: `=CSPRICE("BTC","USD")`
 


That's it!

![img](https://cryptosheets.intercom-attachments-1.com/i/o/198199074/e9a08e55c10f1ab0ad549277/csPRICE-syntax-example.gif)

![img](https://downloads.intercomcdn.com/i/o/198198206/c1a774486adcd51374e7787b/cryptosheets-docs_functions_excel-vs-googlesheets%5B1%5D.png)




### 👉 Method 2 - [API Console in the Side Panel](https://www.youtube.com/playlist?list=PLBg8GR5ao-azkVyW-optnK7tILh9vecrn)

The [side panel API console & function builder](https://docs.cryptosheets.com/cryptosheets-concepts/api-console/) allows you to quickly query data for any provider or endpoint and will send the data directly to your sheet as a refreshable formula, dynamic template or flat data. The below example uses an endpoint from [Cryptocompare](https://docs.cryptosheets.com/providers/cryptocompare) to pull in historical trading data for Bitcoin (BTC)

**To get data using the API console in the side panel follow these steps...**
  1. Search for **Cryptocompare** under the providers tab in the browse section
  2. Find the endpoint called **V2 Histoday**
  3. Select the **endpoint**
  4. **Press the green button** called "make request"

That's it!

  > **[Watch the YouTube Tutorial on how to use the API Console](https://www.youtube.com/playlist?list=PLBg8GR5ao-azkVyW-optnK7tILh9vecrn)**

![img](https://cryptosheets.intercom-attachments-1.com/i/o/198199075/7331a93a80e446160f9d6808/v2-histoday.gif)


**To navigate to the API console from the home/landing screen follow these steps**

  1. Click on the **Browse Data button**
  2. Select the **endpoints tab**
  3. Click on any **endpoint**
  4. That's it! ➡️ you've arrived at the **API console!**

![](https://downloads.intercomcdn.com/i/o/293622743/d6a5f2a4a3dec446063fe975/image.png)

**The console is broken out into 6 major parts:**

1. [Make Request](https://www.youtube.com/playlist?list=PLBg8GR5ao-azkVyW-optnK7tILh9vecrn)
2. [Scenario Search Bar](https://intercom.help/cryptosheets/en/articles/4571225-how-to-use-cryptosheets-scenarios)
3. [Query Builder (Request & function builder)](https://www.youtube.com/playlist?list=PLBg8GR5ao-azkVyW-optnK7tILh9vecrn)
4. [Global Parameters](https://docs.cryptosheets.com/functions/common)
5. [Endpoint Parameters](https://www.youtube.com/playlist?list=PLBg8GR5ao-azkVyW-optnK7tILh9vecrn)
6. [Output Inspector](https://www.youtube.com/playlist?list=PLBg8GR5ao-azkVyW-optnK7tILh9vecrn)

👉 [click here to see the YouTube tutorials](https://www.youtube.com/playlist?list=PLBg8GR5ao-azkVyW-optnK7tILh9vecrn)

[![](https://res.cloudinary.com/cryptosheets/image/upload/v1611929157/cryptosheets-docs/console/console-v2-diagram.png)](https://res.cloudinary.com/cryptosheets/image/upload/v1611929157/cryptosheets-docs/console/console-v2-diagram.png)

### Need More Help?

You can always [access our entire help center](https://intercom.help/cryptosheets/en/) directly from within the add-in side panel or the website

![img](https://res.cloudinary.com/cryptosheets/image/upload/v1573086234/cryptosheets-docs/tutorials/tutorials-quickhelp.gif)



Cryptosheets makes it easy for anybody to pull a wide variety of crypto data into their Excel or Googlesheets. This tutorial will show you two different ways to do this

Beginner Tutorial