Skip to main content

Bulk importing and exporting data to and from databases

Bulk importing columnar data into a database​

You can easily import columnar data into a database using the "Import from CSV" tool. This tool allows you to add new rows and/or update existing rows using a Comma-Separated Values (CSV) file. Follow these instructions to import data into a database.

  1. Prepare your data for importing
    1. Download a template
      1. Navigate to the data grid for the database that you'd like to import into.
      2. Click the actions (…) button at the top-right of the data grid and select the "Import from CSV" option.
      3. In the popup window that opens, click the link in the instructions to download a template CSV file.
    2. Enter your data into the template: Fill the template with data, maintaining the column headings.
      1. Creating new rows: Use this paradigm to bulk import new data.
        1. Leave the ID column blank in the CSV file.
        2. Once uploaded, a new database row will be created for each CSV row.
      2. Updating existing rows: Use this paradigm to bulk update data.
        1. The CSV file must include an ID column.
        2. Once uploaded, each CSV row will be used to update the values of the database row with the same ID.
  2. Import your data
    1. Navigate to the data grid for the database that you'd like to import into.
    2. Click the actions (…) button at the top-right of the data grid and select the "Import from CSV" option.
    3. In the popup window that opens, drag and drop your CSV file or open your file explorer and select your CSV file.
    4. Click the "Import from CSV" button.

Importing references​

Reference columns enable you to capture relationships among your rows. Follow these instructions to prepare reference columns for importing.

  • Columns that are limited to a single reference: Enter the ID of the related row, such as row-1.
  • Columns that can capture multiple reference: Enter a comma-separated list of the IDs of the related rows, such as row-1,row-2.

Bulk exporting columnar data from a database​

Reference export coming soon

Currently, the values of reference columns are exported as their system IDs. We plan to export the values of reference columns using the human-readable IDs users experience in our platform. For immediate assistance, contact support.

Follow these instructions to export the columnar data of a database to a CSV file.

  1. Select the database: Navigate to the data grid for the database that you'd like to export.
  2. Export the database: Click the actions (…) button at the top-right of the data grid and select the "Export to CSV" option. A CSV file will be downloaded to your local machine.

Bulk importing and exporting notebooks and files​

Please contact support for assistance bulk importing and exporting notebooks and files.