CommunityProduct updatesTemplatesCommon Formulas
Search…
Getting Started
What is Causal?
Quickstart
The Causal interface
Tutorials & practice
The Causal Startup Suite
Variables
Creating variables
Formatting variables
Organizing variables
Variable types
Time
Time settings
Working with time
Formulas
Creating formulas
Variable modifiers in formulas
Functions
Helper variables
If statements
Common formulas
Troubleshooting
Visuals & Dashboards
Creating visuals
Comparing versions & scenarios on visuals
Importing visuals
Embedding visuals
Creating dashboards
Categories
What are categories?
Working with categories
Managing categories
Data
What is data?
Connecting data sources
Working with data
Integrations
Spreadsheets
Time-series
Transactions
Table
Accounting / ERP
Payroll
CRM
BI / Data Warehouse / Database
Analytics / Ads
Other
Subscription / Billing
Views
What is a view?
Filter types
Sharing views
Versions
What is a version?
Comparing versions in charts/tables
Scenarios
Creating scenarios
Comparing scenarios in charts/tables
Managing models and collaboration
Managing models
Collaboration
Resources
Security
Terms of Service
Privacy Policy
Data Protection Addendum
Powered By GitBook
Spreadsheets
Google Sheets, CSV Upload, and Excel (coming soon)

File formats

Causal can connect to the following spreadsheet file formats:
  • Google Sheets (sync)
  • CSV (upload)
  • Excel (coming soon!)
The key thing to note is that Google Sheets is a sync (i.e. you can hit refresh in Causal and it will pull in the latest data automatically), whereas CSV (and soon, Excel) works via manual upload.

Data formats

Causal supports three data formats for spreadsheet files:

Google sheets formatting

  • Make sure dates are formatted as Numbers, not Text. The =ISDATE() function in Google Sheets can be used to check that.

CSV formatting

  • It is best to format dates in YYYY-MM-DD format (e.g. 2020-02-01) because it is unambiguous, but you can configure Causal to recognise day/month/year or month/day/year formats when uploading your CSV file.
  • Numbers should be plainly formatted (e.g. 120.99) without punctuation or symbols.

Column type detection

Causal tries to guess the type of your columns based on the data in that column. If it guesses incorrectly, you can force the type by adding an annotation to the column header. Annotations are in square brackets and come after the column name, e.g. start date [date].
  • Use [date] to force Causal to interpret the column as date values.
  • Use [number] to force Causal to interpret the column as numbers.
Data - Previous
Integrations
Next
Time-series
Last modified 30d ago
Copy link
Outline
File formats
Data formats
Google sheets formatting
CSV formatting
Column type detection