All Collections
Googlesheets
Using Cryptosheets in Googlesheets
Using Cryptosheets in Googlesheets

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

C
Written by Chris Ware
Updated over a week ago

OVERVIEW

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

(click to enlarge)

TOPICS COVERED

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

Our GOAL:

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 GOOD NEWS:

  • 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

▶︎  BOTTOM LINE: THIS IS ALL VERY POSITIVE FOR CRYPTOSHEETS 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 

FEATURE COMPARISON (OVERVIEW)

▶︎  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: https://developers.google.com/apps-script/guides/services/quotas)

"(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 gmail.com) 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

ADDITIONAL RESOURCES

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

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

Did this answer your question?