OneDrive Excel Sheets

This data source connector loads Excel sheets from Microsoft OneDrive and stores them as tables in a bucket in your current project.

Microsoft OneDrive cloud storage integrates Office365 and SharePoint sites, so with this connector, you have access to all your Excel sheets in your personal account or in your business account.


Create a new configuration of the OneDrive Excel Sheets connector.
Then click Authorize Account to authorize the configuration.

Click Add Table to configure extraction.

Screenshot - Empty configuration

Fill in the name and, optionally, the description. Then click Add Table.
These values will help you easily identify the extraction later.

Screenshot - Add table popup

Use the file picker to list accessible Excel files – workbooks.

Screenshot - Use file picker

Go through the list and select a file. Click Open to confirm the file you want to import.

Screenshot - Select file

The file is specified by a Drive ID and by a File ID. They are automatically filled in.
The file name is for your information only and changing it doesn’t affect functionality.

Screenshot - Workbook config

Click Load Worksheets to select a worksheet from the workbook you configured in the previous step.

Screenshot - Empty worksheet config

In the list that appeared, click on the name of the worksheet you want to import.

Screenshot - Select worksheet

The worksheet is specified by a Worksheet ID. It is automatically filled in.
The worksheet name is for your information only and changing it doesn’t affect functionality.

Screenshot - Save

The output table name is automatically filled in with the worksheet name.
You can manually change it to suit your needs. If the table doesn’t exist, it will be created.

Screenshot - Select worksheet

Click Save when you’re done.

Screenshot - Select worksheet

Modify Configuration

When a table is added to the connector, it is displayed in the list of tables.

Configured tables are stored as configuration rows.

Screenshot - Select worksheet

Each table has a different setting, but all tables share the same authorization to your OneDrive account.

The list shows the row name and the destination table in Storage.

You can click on the row to modify the configuration.