Google Sheets, CSV Upload, and Excel (coming soon)
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.
Causal supports three data formats for spreadsheet files, click into each below to learn more about the ingestion formats Causal requires.
- Make sure dates are formatted as Numbers, not Text. The
=ISDATE()function in Google Sheets can be used to check that.
- It is best to format dates in
YYYY-MM-DDformat (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.
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].
[date]to force Causal to interpret the column as date values.
[number]to force Causal to interpret the column as numbers.
[category]to force Causal to interpret the column as a Category.