Docs Portal

Help Resources

Help Center

Documentation

Guides

Tutorials

Troubleshooting

Contact Us

Changelog

Billing

Get started

Overview

Setup your account

Supported platf...

Using the add in

Navigation & la...

Get data

Explore examples

Start with our ...

Find more examp...

Tools

Glossary / Expl...

Timezones & For...

Support

Additional Reso...


Find resources for the **six main areas** of the Cryptosheets platform

### [Docs Portal](https://docs.cryptosheets.com) | [Excel Add-in](https://appsource.microsoft.com/en-us/product/office/WA104381695) | [Googlesheets Add-on](https://gsuite.google.com/u/2/marketplace/app/cryptosheets/898843532532?hl=en&pann=sheets_addon_widget) | [WebApp](https://app.cryptosheets.com) | [Help Center](https://intercom.help/cryptosheets/en/) | [Website](https://cryptosheets.com)

[![img](https://res.cloudinary.com/cryptosheets/image/upload/v1573690653/cryptosheets-docs/graphics/excel-cube-help-450x450.png)](https://res.cloudinary.com/cryptosheets/image/upload/v1573690653/cryptosheets-docs/graphics/excel-cube-help-450x450.png)

**REMINDER**

You can always **click the [green & white Intercom chat button](https://intercom.help/cryptosheets/en)** ![help center](https://res.cloudinary.com/cryptosheets/image/upload/c_scale,w_25/v1573737236/cryptosheets-docs/intercom/intercom-chat-green-transparent.png) in the **lower right hand corner** of your screen at any time to immediately access **live chat** with the team, our **entire help center** including **tutorials**, **support articles** and more.

---

1. [**Help Resources**](https://app.cryptosheets.com/#/resources/Help-Resources)
   1. [**Get started**](https://app.cryptosheets.com/#/resources/get-started)
      - [Overview](https://app.cryptosheets.com/#/resources/overview)
      - [Setup your account](https://app.cryptosheets.com/#/resources/setup-your-account)
      - [Supported platforms & Requirements](https://app.cryptosheets.com/#/resources/supported-platforms--requirements)
   2. [**Using the add in**](https://app.cryptosheets.com/#/resources/using-the-add-in)
      1. [Navigation & layout](https://app.cryptosheets.com/#/resources/navigation--layout)
   3. [**Get data**](https://app.cryptosheets.com/#/resources/get-data)
      1. [Explore _examples_](https://app.cryptosheets.com/#/resources/explore-_examples_)
      2. [Start with our easy to use one click autoTemplates](https://app.cryptosheets.com/#/resources#start-with-our-easy-to-use-one-click-autotemplates)
      3. [Find more examples in our help center](#find-more-examples-in-our-help-center)
2. [**Tools**](#tools)
   1. [Timezones & Formatting](https://app.cryptosheets.com/#/resources/timezones--formatting)
3. [**Support**](https://app.cryptosheets.com/#/resources/support)
   1. [Changelog](https://app.cryptosheets.com/#/resources/changelog)
   2. [Contact Us](https://app.cryptosheets.com/#/resources/contact-us)
   3. [FAQ](https://app.cryptosheets.com/#/resources/faq)
   4. [Guides](https://app.cryptosheets.com/#/resources/guides)
   5. [Troubleshooting](https://app.cryptosheets.com/#/resources/troubleshooting)
   6. [Additional Resources](https://app.cryptosheets.com/#/resources/additional-resources)

---

## **Help Resources**

Explore additional help & support resources across the Cryptosheets platform

- #### [Help Center](https://intercom.help/cryptosheets)

- #### [Documentation](https://docs.cryptosheets.com)

- #### [FAQ](https://app.cryptosheets.com/#/resources/faq)

- #### [Guides](https://app.cryptosheets.com/#/resources/guides)

- #### [Tutorials](https://app.cryptosheets.com/#/resources/tutorials)

- #### [Troubleshooting](https://app.cryptosheets.com/#/resources/troubleshooting)

- #### [Contact Us](https://app.cryptosheets.com/#/contact)

- #### [Changelog](https://app.cryptosheets.com/#/resources/changelog)

- #### [Billing](https://cryptosheets.com/pricing)

---

### **Get started**

#### Overview

Cryptosheets is designed to make crypto data easier to access, manipulate and analyze. Rendering new data types often requires additional special configuration of resources and additional resources

#### Setup your account

- Register for a new account **[here](https://app.cryptosheets.com/#/register)**
- Select your **[billing](https://cryptosheets.com/pricing)**
- Use our quick start **[tutorials](https://intercom.help/cryptosheets/en/collections/995066-tutorials)** and **[templates](https://app.cryptosheets.com/#/templates)** and **[tutorials about using the templates](https://intercom.help/cryptosheets/en/articles/3469879-templates-custom-functions)**
- Add your **API keys**

#### Supported platforms & Requirements

Certain (new) features often have minimum requirements for your version of either Microsoft Office or Excel software that may change as updates are released. Many users need to:

- Update their license to **insiders** for access to new features
- Update their software for the latest **build**

  - **[Office versions and requirement sets](https://docs.microsoft.com/en-us/office/dev/add-ins/develop/office-versions-and-requirement-sets)**
  - **[How to check your Office version](https://docs.microsoft.com/en-us/office/dev/add-ins/develop/office-versions-and-requirement-sets#how-to-check-your-office-version)**
  - **[Install the latest version of Office](https://docs.microsoft.com/en-us/office/dev/add-ins/develop/install-latest-office-version)**

![https://res.cloudinary.com/cryptosheets/image/upload/v1573684047/cryptosheets-docs/excel/excel-update-latest-version.png](https://res.cloudinary.com/cryptosheets/image/upload/v1573684047/cryptosheets-docs/excel/excel-update-latest-version.png)

![https://res.cloudinary.com/cryptosheets/image/upload/v1572377588/cryptosheets-docs/excel/excel-user-version-license-build.png](https://res.cloudinary.com/cryptosheets/image/upload/v1572377588/cryptosheets-docs/excel/excel-user-version-license-build.png)

---

### **Using the add in**

Cryptosheets is a dynamic multi-purpose web app and add-in. Because it can be used across many surfaces including Excel (desktop, Windows, Mac OSX, Excel online), Googlesheets, Power BI, web browser, GraphQL, API and others - certain features may be limited to specific environments.

See the additional resources and help links below for more information. Stay up to date with chanegs by following our **[changelog page.](https://app.cryptosheets.com/#/resources/changelog)**

- **Example**: Microsoft Excel may support certain features (like Cryptosheets **explorer**) that GoogleSheets does not

#### Navigation & layout

**New Excel ribbon and side panel menu navigation**

![https://res.cloudinary.com/cryptosheets/image/upload/v1568644717/appsource/1.0.0.9/1_dpqhjm.png](https://res.cloudinary.com/cryptosheets/image/upload/v1568644717/appsource/1.0.0.9/1_dpqhjm.png)

**Flexible side panels to compare dozens of data providers**

![https://res.cloudinary.com/cryptosheets/image/upload/v1568644717/appsource/1.0.0.9/2_ontnjg.png](https://res.cloudinary.com/cryptosheets/image/upload/v1568644717/appsource/1.0.0.9/2_ontnjg.png)

**New generation Excel custom functions (aka formulas)**

![https://res.cloudinary.com/cryptosheets/image/upload/v1568660834/appsource/1.0.0.9/3b_gryzca.png](https://res.cloudinary.com/cryptosheets/image/upload/v1568660834/appsource/1.0.0.9/3b_gryzca.png)

**New workspace dashboard area w/ customizable widget panels**

- Content
- Charts
- Explorer
- Exchange Rates
- Parameters
- Symbols
- Symbol Summary
- Trading View
- Web

![https://res.cloudinary.com/cryptosheets/image/upload/v1568644717/appsource/1.0.0.9/4_sdky3s.png](https://res.cloudinary.com/cryptosheets/image/upload/v1568644717/appsource/1.0.0.9/4_sdky3s.png)

---

### **Get data**

There are **two primary ways to get data** into your worksheet using Cryptosheets:

1.  **API Console**
2.  **Custom Functions (aka formulas)**

Read this tutorial on** [Using the Cryptosheets API Console, Query and Function Formula Builder for Excel & Googlesheets](https://intercom.help/cryptosheets/en/articles/3472916-using-the-cryptosheets-api-console-query-and-function-formula-builder-for-excel-googlesheets)** to get started

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

---

#### Explore examples

- ##### Start with our easy to use [one click autoTemplates](https://app.cryptosheets.com/#/templates)

- ##### Find more examples in our [help center](https://intercom.help/cryptosheets/en/collections/995066-tutorials)

![img](https://downloads.intercomcdn.com/i/o/160835285/279c320a8ae4e494bb05adf0/templatesCustomFunctions%5B1%5D.png)

## **Tools**

---

#### Glossary / Explorer

Find **definitions and examples** for specific terminology about crypto assets, concepts, APIs and data analysis.

![img](https://res.cloudinary.com/cryptosheets/image/upload/v1570711458/cryptosheets-docs/workspace/explorer-metrics_a7jj1p.gif)

In Excel, open the **Explorer** from the ribbon by clicking on "Glossary" in the Resources section or in the side panel navigation by clicking on the **magnifying glass icon (smart lookup)** then **simply highlight the cell containing the term** you want to look up and it will automagically appear

![img](https://paradigmas.blob.core.windows.net/paradigmas-content/sharex/EXCEL_474x578.png)

#### Timezones & Formatting

Tools, tips and tricks to help you convert back and forth between common and international timezone or timestamp conventions like UNIX/UTC.

- UNIX timestamp conversion tutorial **[here](https://intercom.help/cryptosheets/en/articles/1832053-how-to-convert-between-unix-timestamp-to-readable-date)**
- Use the **formatDates** argument in custom functions to save significant time and effort reformatting and converting datetime data and columns **[read the article here](https://help.cryptosheets.com/en/articles/3577487-date-formatting-with-custom-functions)**
- Create a **programmatic date column** with one formula:
- `=TEXT(SEQUENCE(30,1,TODAY()),"MM/DD/YY")` OR `=SEQUENCE(30,1,TODAY())` and format the cells from the ribbon as **date**

![img](https://paradigmas.blob.core.windows.net/paradigmas-content/sharex/create-date-column.png)

- Create a **quick calendar** with one formula:

![img](https://paradigmas.blob.core.windows.net/paradigmas-content/sharex/create-quick-calendar.png)

## **Support**

---

### Changelog

We are constantly improving the platform, adding new data providers, resources and functionality. See the latest updates **[here](https://app.cryptosheets.com/#/resources/changelog)**

![img](https://paradigmas.blob.core.windows.net/paradigmas-content/sharex/chrome_684x925.png)

### Contact Us

Contact Cryptosheets support directly about specific or account related issues

> **E-mail:** support@cryptosheets.com
>
> **[Terms of Service](https://cryptosheets.com/tos)**
>
> **[Sign Up](https://app.cryptosheets.com/#/register)**
>
> [Twitter](https://twitter.com/Cryptosheets_RT) | [Medium](https://medium.com/cryptosheets) | [Linkedin](https://www.linkedin.com/company/cryptosheets/about/)

### FAQ

Have a question? See if we already answered it in **[this section.](https://intercom.help/cryptosheets/en/collections/995077-frequently-asked-questions)**

### Guides

_Coming Soon_

### Troubleshooting

Having issues? take a look at our extensive **[troubleshooting section](https://intercom.help/cryptosheets/en/collections/995077-frequently-asked-questions).**
_More troubleshooting help, tips and tricks coming soon._

### Additional Resources

_For Microsoft Excel_

- **Web browsers used by add-ins:** <https://docs.microsoft.com/en-us/office/dev/add-ins/concepts/browsers-used-by-office-web-add-ins>
- **Office versions and requirement sets:** <https://docs.microsoft.com/en-us/office/dev/add-ins/develop/office-versions-and-requirement-sets>
- **How to check your Office version:** <https://docs.microsoft.com/en-us/office/dev/add-ins/develop/office-versions-and-requirement-sets#how-to-check-your-office-version>
- **Install the latest version of Office:** <https://docs.microsoft.com/en-us/office/dev/add-ins/develop/install-latest-office-version>
- **Custom Function Requirements:** <https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-architecture>
- **Official Excel Blog:** <https://techcommunity.microsoft.com/t5/Excel-Blog/bg-p/ExcelBlog>
- **Excel for the Web:** <https://docs.microsoft.com/en-us/office365/servicedescriptions/office-online-service-description/excel-online>
- **Excel features desktop vs. Web:** <https://support.office.com/en-us/article/differences-between-using-a-workbook-in-the-browser-and-in-excel-f0dc28ed-b85d-4e1d-be6d-5878005db3b6?ui=en-US&rs=en-US&ad=US>
- **Share & embed Excel on a web page (like Googlesheets)** <https://support.office.com/en-us/article/share-it-embed-an-excel-workbook-on-your-web-page-or-blog-from-onedrive-804e1845-5662-487e-9b38-f96307144081?ocmsassetID=HA102029502&CorrelationId=9db27f15-5454-46bc-a67d-957c3816a552&ui=en-US&rs=en-US&ad=US>
- - **Microsoft Excel Official Help Center:** <https://support.office.com/en-us/excel>

_For Microsoft Office_

- **Searchable Roadmap:** <https://www.microsoft.com/en-us/microsoft-365/roadmap?>
- **Update history for Microsoft Office 365:** <https://docs.microsoft.com/en-us/officeupdates/update-history-office365-proplus-by-date>
- **Overview of Office 365 update channels:** <https://docs.microsoft.com/en-us/DeployOffice/overview-of-update-channels-for-office-365-proplus>
- **When do I get new Office features?** <https://support.office.com/en-us/article/when-do-i-get-the-newest-features-in-for-office-365-da36192c-58b9-4bc9-8d51-bb6eed468516>

Check out the <a href="https://intercom.help/cryptosheets/en/articles/3600077-cs-query-pull-any-data-available-on-the-cryptosheets-platform-into-your-worksheets-with-formulas" rel="noopener noreferrer" target="_blank">latest tutorial documentation and examples for CS.QUERY</a> in the Cryptosheets Help Center

Visit the <a href="https://cryptosheets.com" rel="noopener noreferrer" target="_blank">website</a>

Visit the <a href="https://app.cryptosheets.com" rel="noopener noreferrer" target="_blank">webapp</a>

Visit the <a href="https://docs.cryptosheets.com" rel="noopener noreferrer" target="_blank">docs portal</a>


Get instant answers to the most common questions and learn how to use Cryptosheets like a pro.

Resources