👉 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, installed the add-in & logged in](https://intercom.help/cryptosheets/en/articles/1764650-first-time-install-and-login-for-cryptosheets) using the Cryptosheets side panel

**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:*

Excel: `=CS.PRICE("BTC","USD")`

Googlesheets: `=CSPRICE("BTC","USD")`
 
2. Press enter

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 allows you to quickly query data for any provider or endpoint and will send the data directly to your sheet. The below example uses an endpoint from Cryptocompare to pull in historical trading data for Bitcoin (BTC)

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

That's it!

**The API console looks like this and is broken out into 5 major parts:**

1. Description
2. Request & function builder
3. Inspector
4. Parameters & fields
5. Help Center

  > **[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)

![IMG](https://downloads.intercomcdn.com/i/o/161176369/9d1a7387a6ab7f5876c9829a/image.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