Skip to content

Google Sheets

This page does not apply to the environment you selected. It covers: Google Sheets.

In Google Sheets, Datama is an add-on: it analyses a range of your spreadsheet, without exporting it to another tool. Use it to analyse operational data where it lives, or to prototype an analysis before moving it to a BI tool.

In Google Sheets, click Extensions › Add-ons › Get add-ons, and search for Datama.

If your Google Workspace is managed by your organisation, your administrator may need to install it for you.

Datama needs an aggregated table, like a pivot table: dimensions first, the dimension to compare on in first position, then the metrics of your market equation. See Data requirements.

Open the add-on, then check in its side panel that the right range is selected. Datama detects the dimensions and metrics; adjust them if needed.

  • Paste your licence key in the Editor settings tab.
  • With a paid licence, click Save in the header of Datama: your settings come back when you or others reopen the spreadsheet.
  • Turn Edit mode off in the Editor settings tab so others only see the analysis.

See Environments for the trial and the licence.