👉 Method 1 - Cu...

👉 Method 2 - AP...

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.

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

- Custom Functions (aka formulas)*
- API Console in the Side Panel

### 👉 Method 1 - Custom 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!




### 👉 Method 2 - API Console in the Side Panel

- 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

![IMG](https://downloads.intercomcdn.com/i/o/161176369/9d1a7387a6ab7f5876c9829a/image.png)

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