How to export your data from Rill

Rill lets you export the results shown in any Explore dashboard or dimension table as CSV, XLSX, or Parquet, either as a one-off download or as a recurring scheduled report delivered automatically.

Formats: CSV, XLSX, ParquetPlan: Not stated in Rill's docs as plan-gated — export appears available wherever Explore dashboards and reports are availableRole: Not specified in Rill's docs; use whatever role can view the Explore dashboard/dimension table you want to export from

✓ Verified against Rill's official documentation, September 2026

Step by step

  1. 1Open the Rill Cloud project and navigate to the Explore dashboard containing the data you want
  2. 2Expand a dimension table by clicking on the dimension name to view the underlying rows
  3. 3Click the Export button on that table or chart
  4. 4Choose an export format: CSV, XLSX, or Parquet, for a one-time download
  5. 5Alternatively, click Export and select 'Create scheduled report' to have the same export generated and delivered on a recurring schedule
  6. 6Configure the report's schedule and delivery settings, then save it
  7. 7Repeat per dashboard/dimension table, since exports are scoped to the view you're currently in rather than a whole-project bulk export

What the export includes

  • ✓The rows and columns currently visible/filtered in the Explore dashboard or expanded dimension table
  • ✓Query results in your chosen format (CSV, XLSX, or Parquet)

What it doesn't include

  • ✗A single bulk export of the entire underlying warehouse/database (Rill queries your connected source — ClickHouse, DuckDB, BigQuery, etc. — rather than storing a separate copy you export in bulk)
  • ✗Project configuration such as source, model, and dashboard YAML/SQL definitions (these live as code files in your Rill project repo, not as a downloadable 'account data export')
  • ✗Dashboard visual layout/styling — exports are the underlying data, not the chart itself

Before you start

  • ⚠Exports are per-dashboard/per-dimension-table, not a single 'export my whole workspace' action
  • ⚠Scheduled reports re-run the export on a recurring basis rather than exporting historical/archived versions
  • ⚠Because Rill queries your own connected data source live, the real system of record for your data is that source (ClickHouse, DuckDB, Snowflake, BigQuery, etc.) — back that up directly rather than relying solely on Rill's dashboard exports

Where to take your data

Free and cheaper tools that can take a Rill export. See all Rill alternatives →

Upload the exported CSV as a file-based question source, or load the CSV/Parquet into the same underlying database (ClickHouse, Postgres, etc.) and connect Metabase to that database directly

Apache Superset

Connect Superset to the same underlying warehouse via SQLAlchemy, or upload the CSV using Superset's 'Upload a CSV' data source feature

Point Grafana at the same underlying data source (ClickHouse, Postgres, etc.) using its native data source plugin; Grafana does not natively import flat CSV/Parquet files, so route through the database

Exporting from Rill: common questions

Can I export my entire Rill project in one click?+

No. Rill's export feature works per dashboard or dimension table, producing CSV, XLSX, or Parquet for that specific view — there's no single bulk 'export everything' action documented.

Does exporting from Rill back up my actual data?+

Not fully. Rill queries your connected source (ClickHouse, DuckDB, BigQuery, Snowflake, etc.) live, so the export only contains the rows/columns currently shown in a dashboard — your real data of record stays in that underlying source.

What happens to my scheduled reports if I cancel my Rill account?+

Scheduled reports run within Rill Cloud, so they stop once the project/account is removed. Export or reconfigure any reports you rely on before canceling.

Are my dashboard/model definitions included in a data export?+

No. Dashboards and models are defined as YAML/SQL files in your Rill project's code repository, not as part of the CSV/XLSX/Parquet data export — you retain those simply by keeping the project's git repo.

Which format should I export for loading into another BI tool?+

Parquet or CSV are the most portable — CSV imports directly into tools like Superset's file upload feature, while Parquet is efficient for reloading into a database that Metabase, Superset, or Grafana then connect to.

Sources

This guide was written from Rill's own documentation and checked against it in September 2026. If a step has changed, the official page wins.