Data Export
Row Zero supports multiple methods for exporting data:
File export
Row Zero supports CSV exports of a range or sheet and XLSX exports of the full spreadsheet.
To export the full file or a single sheet:
- Go to File > Download.
- Choose the file type.
- CSV downloads will include the current sheet.
- XLSX downloads will include all sheets, but will exclude data tables.
To export a range to CSV:
-
Right click on a selected range or data table.
-
Select Export to > CSV

Details of file export
- File export is available to Pro, Business, and Enterprise customers.
- File exports will not include data tables. CSV exports cannot include both a range and a data table — select just one to download at a time. XLSX exports will exclude data tables.
- As a security feature, file export can be disabled for enterprise customers, which more securely keeps data in the cloud and off of people's laptops.
Writeback
Row Zero can write data from the spreadsheet into a data warehouse, including full table writes and cell-level updates.
Before you start:
- To write data, you must already have a connection to a data warehouse and that connection must have writeback enabled. Follow instructions for your specific data warehouse in our connection documentation.
- Like with queries, connection credentials determine which writes are allowed. In order to write from Row Zero, the user or service account must have the appropriate permissions in your data warehouse.
- Writeback is available to Business and Enterprise customers.
Full table export
Full table export creates a new table or replaces an existing one with the selected dataset. The new table will overwrite any table with the same name.
To create or replace a table in your data warehouse from Row Zero:
-
Select a range of data or data table
-
Right click and select Export to >
data warehouse
-
Choose your database and schema.

-
Name your table. Row Zero will create a new table with the data in your range or data table. All exported table names must be prefaced with
rz_to prevent overwriting a core table that wasn't meant to be overwritten.
Best practices for data teams
- It's common to create a separate schema where users put their exported
rz_tables. This ensures these tables are segregated from the pristine fact tables managed by the data team. - This schema functions similarly to a shared drive that teams use to share files. You can have multiple such schemas if you need more granular control over permissions (even one per user).
- If you find one of these
rz_tables is becoming heavily depended on, consider lifting it into your ETL pipeline. But until this happens, your users aren't blocked and can participate in your data lake in self-service fashion.
Granular writeback
Row Zero also supports cell-level updates to existing tables in your warehouse.
To update cells in an existing table:
- Import the table as a connected table using query builder. See Data Import for details.
- In the Writeback tab, toggle Enable writeback on. Note that tables must meet certain eligibility requirements. See details below.
- When writeback is enabled, cells in your connected table will be editable. Notes:
- Row Zero will enforce column data types, when applicable. For example, a user cannot overwrite a date field with text.
- Hover over cells to view the original values and, if needed, revert changes.
- Unique key columns cannot be overwritten.
- To save your updates to your date warehouse, open the Configure connected table pane, and click Begin writeback in the Writeback tab.
- Review your changes and click Apply writeback to export.
Requirements for granular writeback
- As with queries and full table export, granular writeback respects the permissions of the connection credential used. In this case, the connection credentials must have permission to update the writeback table.
- The relation must be an updatable table. Views, materialized views, read-only tables, and federated or external tables are ineligible.
- In Databricks, the table must be a Unity Catalog Delta table,
MANAGEDorEXTERNAL. - In Athena, the table must be Iceberg table at format version 2, registered in the Glue Data Catalog. Hive, CSV, Parquet-external and Iceberg v1 tables are ineligible.
- In Snowflake, the table must be a permanent or transient table.
- In Databricks, the table must be a Unity Catalog Delta table,
- The writeback table must declare a unique key. This is what Row Zero uses to match workbook rows to the warehouse table.
- In Databricks and Snowflake, the table must declare a
PRIMARY KEY. - In Athena, it must declare iceberg identifier fields and must be partitioned by at least one column that isn’t part of the key. Rows are matched on the identifier fields plus the partition columns together, so the key only needs to be unique within a partition.
- In Databricks and Snowflake, the table must declare a
Sync to Google Slides
With the Row Zero Add-On, you can insert Row Zero charts and tables directly into your Google Slides presentations and sync them with your Row Zero workbooks with a single click.
When your data changes, refresh an individual chart or table, or update all linked objects in your presentation at once. No re-exporting, no copying and pasting screenshots, and no wondering which slide has the latest numbers.
Install the Add-On
Start by installing the Row Zero Add-on from the Google Workspace Marketplace. You can install the add-on for yourself individually, or, if you are an admin of your Google workspace, you can install the add-on for everyone in your Google workspace.

Add Row Zero charts and tables to a Google Slides presentation
Open a presentation in Google Slides. The first time you open a presentation you may need to allow the add-on to access the file.
There are two ways you can add content to a presentation:
-
Copy and paste charts: Copy a chart or table from Row Zero and paste it into your slide.
-
Import charts or tables from the add-on: You can also select the chart(s) you would like to import from the Add-On directly. Open the add-on, select your workbook, and then select the desired charts.
Sync Row Zero charts and tables in Google Slides
To sync the slides in your presentation, open the Row Zero Add-on and choose the charts or tables you’d like to sync, or select “Sync all”.