Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next


  1. In the menu bar, click Library for Data
  2. In the Library for Data page, click click Import Data. Select the Google Sheets connection. 


    Tip: You can paste links that you gather from Google to select spreadsheets. To access a Google Sheet, edit the path and paste the link. Use this method for publicly available Google Sheets, too.

    D caption
    Import Google Sheets spreadsheet
  3. After you select the spreadsheet, it is uploaded and converted to CSV format and stored. Depending on the size of the spreadsheet, this process may take a while.

  4. By default, all sheets in the spreadsheet are imported as individual datasets. To change how the data is imported, click Edit in the right panel.

    D caption
    Import settings for Google Sheets datasets
  5. Dataset creation:
    1. 1 dataset per sheet: (Default) Each selected sheet in the spreadsheet is imported as a separate dataset. 
      Specify the base name of the datasets that you are creating. If you are creating a single dataset, the name of the spreadsheet is used. 
    2. Selected sheets into 1 dataset: All selected sheets in the spreadsheet are combined and imported as a single dataset.


      NOTE: The schemas of each dataset must match. Columns must be listed in the same order in each dataset. The column headers are taken from the first selected dataset.

    3. All and future sheets into 1 dataset: If the spreadsheet is updated periodically with new sheets that you would like to add in the future, select this option. After initial selection of sheets, all sheets that are added to the spreadsheet in the future are automatically added as part of the imported dataset.


      NOTE: When an imported dataset based on this option is first loaded into the Transformer page, the data grid displays an initial sample taken from rows in the first sheet only. When you take another sample from the Samples panel, data is collected from other sheets.

  6. Selected sheets: 
    1. You can select the sheets to import. 


      NOTE: Special characters in sheet names are filtered out.

    2. To preview the data of an individual sheet, mouse over a dataset and click Jump to.

  7. Remove special characters from column names: Select this option to remove any special characters from the inferred column headers during import.
  8. You can apply the column headers to your datasets during import. Select the required option from the drop-down list:

    • Infer header: (default) When selected, the 
      D s webapp
       infers the header based on the data in the import. 
    • Use first row as header: When selected, the first row is used as the column headers.

    • No header: When selected, the inference is ignored and column headers are defined using generic names with no headers. 

  9. To save changes, click Save.
  10. After your datasets have been added, you can edit the name and description information for each in the right navigation panel.
  11. Optionally, you can assign the new dataset(s) to an existing flow or create a new one to contain them.