All Collections
Using Cryptosheets in Googlesheets
Using Cryptosheets in Googlesheets

How to use Cryptosheets in Google including availability and compatibility of specific platform features

Written by Chris Ware
Updated over a week ago


The original add-on for Googlesheets was called and since early 2020 has re-branded to become part of the unified platform. 

(click to enlarge)


This article covers how to get setup with Cryptosheets in Googlesheets so you can start using the app right now. It also covers some of the primary differences across Excel and Googlesheets to help get you started including:

  1. General setup and integration

  2. Custom Functions

  3. Data Limitations

  4. Templates


Is and always has been to create a single unified experience for users across both Excel and Googlesheets. We are ultimately limited in certain areas re: specific functionality given the respective restrictions and capabilities of each platform, respectively. 


  • The reality is both platforms continue to backfill eachothers flagship features more and more every day from macros to pivot tables to online sharing, autosaving and pretty much everything else. 

  • The flexibility to leverage the best features of Excel and Googlesheets from within Cryptosheets at anytime provides a powerful tool set for users



▶︎  General setup and integration (Googlesheets)

Follow the normal steps to install a Google add-on:

  1. Going to the add-ons menu from your Googlesheet 

  2. Get add-ons 

  3. Type "cryptosheets" in the search bar in GSuite Marketplace 

  4. Install 

  5. Go back to the add-ons menu

  6. Select Launch Sidebar from the Cryptosheets menu

*Note: you may need to refresh your browser window if you don't see the Launch Sidebar option the first time 


▶︎  Custom Functions

Using Cryptosheets custom functions in Excel vs Googlesheets is almost exactly the same with a few very slight differences. The most important one is that in Excel there is a "." (period) between the CS  and the functionName  so =CS.QUERY().

In Googlesheets there is NO "." (period) after the CS so the formula is simply =CSQUERY()

As of January 2020 - Googlesheets also does not yet support full streaming real time data through =CS.EXRATE like Excel does. We expect this to change in the near future so stay tuned to our changelog and join our mailing list a for a coming announcement...

▶︎  Data Limitations

Most data limitations in Cryptosheets are set by:

  • Your subscription level

  • Your local hardware, software and internet connection

Googlesheets also imposes additional restrictions in daily user data usage that Excel does not.
(excerpt from:

"(Google) Apps Script services impose daily quotas and hard limitations on some features. If you exceed a quota or limitation, your script throws an exception and execution terminates.

Quotas are set at different levels for users of consumer accounts (such as and G Suite free edition (discontinued), or different G Suite editions.

Daily quotas are refreshed at the end of a 24-hour window; the exact time of this refresh, however, varies between users."

▶︎  Templates

Cryptosheets uses next generation template protocol from Microsoft that allows Excel users to instantly load entire complex models, dashboards, charts and templates with one click from the side panel --- without having to download any files, workbooks or scripts! 

You can access Googlesheets versions of these templates which will be continuously rolled out in the near term

Beginning in February 2020, Googlesheets users will be able to access a limited number of Cryptosheets templates directly through customary shared Googlehseet links. They can then save their own copies and adjust them however they like.


Cryptosheets is free to sign up and start using now. What are you waiting for?

Signing up for Cryptosheets is free --> Get crypto data in 30 seconds or less


Website  |  WebApp  |  Excel  |  Googlesheets  |  Help Center  | Blog  | Twitter

TAGS : excel, googlesheets, spreadsheet, crypto data, bitcoin, blockchain, tutorial, help, support

Did this answer your question?