Import CSV & Google Sheets
This feature is under development and will be released soon!
If you're interested in an early access, let us know via this Beta Request form.
Upon release, only Admins and Data Analysts can import CSV and Google Sheets data in the Development workspace.
We will work to support such a capability for Viewers and Explorers later.
Introduction
Sometimes you might need to quickly analyze data from CSV files or Google Sheets for temporary reporting needs. It can be an analysis on some customer survey data, or a CRM export.
This process can be frustrating, as it typically includes waiting for data engineers, navigating complex ETL setups, and dealing with access issues — resulting in hours or even days of waiting for what should be simple, temporary data analysis.
To aid this, Holistics will soon support a seamless way to load spreadsheet data directly into your connected data warehouse, and create a data model ready to use.
Note: CSV and Google Sheets import is designed for you to quickly get started with your reporting needs, and does NOT intend to replace full-fledged data integration solutions.
How To Use
- Simply choose a local CSV file or a Google Sheets URL for upload
- From there, preview the data and configure further if necessary
You will have a new data model ready for exploration within seconds.
How It Works
- Under the hood, your CSV files or Google Sheets are loaded directly into your existing data warehouse through Holistics.
- Admins can designate which database schema for your files to be imported from Holistics, too.
Supported Data Sources
Holistics currently supports the following data warehouses as CSV and Google Sheets import destination:
- PostgreSQL
- Amazon Redshift
- MySQL
- Google BigQuery
- Microsoft SQL Server
- PrestoDB
- Amazon AWS Athena
- Snowflake
- Clickhouse
This feature is not yet available for other data warehouses, such as Databricks or MotherDuck.