Updated December 21, 2023
SharePoint is a file storage and collaboration service. Fivetran supports syncing files your SharePoint folder to your destination. You can sync multiple files either as unique tables or as a single table in to your destination.
|All tables and fields
|Fivetran data models
Follow our step-by-step SharePoint setup guide to connect your SharePoint account with your destination using Fivetran connectors.
The SharePoint connector offers dual mode sync strategies. You can opt to:
- sync each file as a unique table in your destination (Magic Folder Mode)
- sync multiple files into a single destination table that you specify (Merge Mode)
We sync all files in the SharePoint folder to your destination, even if someone without a Fivetran account uploaded them. Anyone with write access to that folder can drop files into the folder; Fivetran automatically syncs the files from your SharePoint folder to your destination.
Magic Folder Modelink
We retrieve all the files from the folder that you specify into your destination.
Each file is synced as a separate table in the destination. For spreadsheet files, we sync each worksheet in the spreadsheet as a unique table in your destination.
We don't sync empty worksheets. We don't sync an Excel worksheet if the entire first row of the worksheet is empty. We don't sync a column if its first row is empty.
We only sync the files inside the specified folder. We ignore nested folders.
Magic Folder Mode doesn't support incremental syncs. To detect changes in the files of your cloud folder, we use the last modified date of the files. After the initial historical sync, we re-import only the recently modified files in every sync. For information about the sync strategy, see our Magic Folder connectors documentation.
We retrieve all the files from each folder and its subfolders into a single table into your destination.
We don't support syncing spreadsheets.
Merge Mode supports incremental syncs.
Magic Folder Modelink
If you select the Magic Folder Mode, we use the file name (without the extension) as the destination table name. For example, we sync a
sample.csv file as
For spreadsheet files, we use a combination of the file name and worksheet name as the destination table name. For example, two worksheets called
Sheet2 in a spreadsheet
My Workings are synced as
MY_WORKINGS_SHEET_2 tables. We use the values present in the first row of the worksheet as the column names in the destination table.
For more information about the schema and table naming rule set, see our naming conventions documentation.
If we find files of the same name but with different extensions in the folder, we check the last modified dates of the files and sync only the least recently modified file.
If you select the Merge Mode, we use the table name that you specify as the destination table name.
We don’t support syncing all Microsoft Excel file formats. You can sync files with .xls, .xlsx, and .xlsm formats.
We don’t sync hyperlink values from a worksheet.
We don't sync worksheets with pivot tables.