Data Export

Row Zero supports a number of different methods for exporting data from a Row Zero spreadsheet. Data export from Row Zero can either be exported to a CSV or written to a data warehouse. The details of each export option are explained below.

CSV Export

Once you've analyzed or transformed your data in Row Zero, you can export it to a CSV.

To Export a CSV:

  1. Select a range of data or data table
  2. Right-click
  3. Select 'Export To CSV' Export range to CSV
  • You can export to CSV with a data table by right-clicking a data table and selecting Export to CSV. Export datatable to CSV

Details of export to CSV

  • Export to CSV is not available in free accounts. If you are on a free account and want to share your dataset, you can use the 'Share' button in the upper right-hand corner. Export CSV is available on Pro, Business, and Enterprise accounts.
  • Export to CSV can also be accessed by going to File > Download to CSV for any sheet in a workbook that does not contain a data table.
  • Exporting a range that includes both cells and data tables will not work. Data tables must be exported to their own CSV because they are independent datasets
  • As a security feature, the ability to export data to a CSV can be disabled for enterprise customers, which more securely keeps data in the cloud and off of people's laptops.

Write-back to Data Warehouse

Row Zero can write data from the spreadsheet into a data warehouse. To use the write-back feature, a workbook must already have a connection to a data warehouse. To connect a data warehouse, follow instructions for your specific data warehouse on our Data Import page. Once a data warehouse is connected follow these steps to write spreadsheet data into the data warehouse.

Write back to data warehouse:

  1. Select a range of data or data table
  2. Right-click
  3. Select 'Export To <data warehouse>' Spreadsheet range save to database Data table save to database
  4. Choose your database and schema. Enter table database and scheme for export to data warehouse
  5. 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. Enter table name for export to data warehouse

Details of Write-back to Data Warehouse

  • Write-back to a data warehouse must be preceded by connecting a data connection. Instructions for connecting data sources can be found in Data-Import.
  • An individual user must have 'Write' access to the conncted Data Warehouse in order to use the 'write-back to data warehouse' feature.
  • Write-back to data warehouse is available to Business Tier customers.
  • Each time data is saved to the data warehouse Row Zero will create a new table with the selected dataset. The new table will overwrite any table with the same name. Under the hood we're issuing a CREATE OR REPLACE table statement.

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.