SharePoint Connector

Sync structured files from SharePoint Online and OneDrive for Business folders, or deliver pipeline output as CSV files and Excel workbooks.

SourceDestinationBronze

Start for Free Source Documentation Destination Documentation

Evaluating against Fivetran? See how Supaflow handles SharePoint pricing, connector quality, and Snowflake deployment side-by-side.

Supaflow vs Fivetran

Why Supaflow

All connectors included

Every connector is available on every plan. Pricing does not increase with connector count.

Pay for compute, not rows

Credit-based pricing. Usage scales with your pipelines, not with row counts.

One platform

Ingestion, dbt Core transformation, reverse ETL, and orchestration in a single workspace.

Capabilities

Delegated Microsoft OAuth

Connect with a Microsoft work or school account. Supaflow can access SharePoint document libraries and OneDrive for Business content available to the signed-in user.

Source Reads for Files and Workbooks

Read CSV, TSV, and Excel (.xlsx) files from a selected folder. CSV and TSV files can be combined by folder, while each Excel worksheet becomes a separate table.

Automatic Schema Inference

Infer columns and data types from file content. Files grouped into the same CSV or TSV table can contribute different columns, with missing values represented as null.

Incremental Changed-File Reads

After the initial sync, re-read files changed since the previous sync. An optional lookback window helps include late file modifications.

CSV and Excel Destination Writes

Write row-bearing pipeline output as CSV files or Excel workbooks. Both formats support append and truncate-and-load behavior, and Excel can use one workbook per object or one workbook for the pipeline.

Supported Objects

Source File Types

CSV

Comma-separated values files with configurable delimiter, quote character, encoding, header, and null settings.

TSV

Tab-separated values files with the same configurable parsing controls as CSV files.

Excel (.xlsx)

Excel workbooks from SharePoint Online or OneDrive for Business, with each worksheet exposed as a table.

Destination Output

CSV files

Row-bearing pipeline output written as CSV files with append or truncate-and-load behavior.

Excel (.xlsx)

Pipeline output written to Excel workbooks using a per-object or shared-workbook layout.

How It Works

Choose a folder

Select a SharePoint Online document-library folder or OneDrive for Business folder that the connecting user can access.

Connect Microsoft

Sign in with a Microsoft work or school account and approve delegated Microsoft Graph access. The folder URL then selects the content Supaflow reads or writes.

Configure the source or destination

For a source, choose CSV, TSV, or XLSX and set any parsing options. For a destination, enable Allow Write Access and choose CSV files or Excel workbooks.

Test and save

Click Test & Save to verify the folder URL, Microsoft sign-in, and the read or write permissions required for the configured role.

Use Cases

Shared document-library ingestion

Load operational CSV and Excel files maintained in SharePoint Online into your warehouse on a schedule.

OneDrive for Business reporting

Sync team-managed files from OneDrive for Business so analysts can combine spreadsheet data with other business systems.

Spreadsheet delivery to business teams

Publish curated pipeline output to SharePoint Online or OneDrive for Business folders as CSV files or Excel workbooks for teams that work in Microsoft 365.

Frequently Asked Questions

Which Microsoft accounts can connect?

Use a Microsoft work or school account with access to the selected SharePoint Online or OneDrive for Business folder. Personal Microsoft accounts are not supported.

How does incremental sync work?

The first run reads the selected files. Later runs re-read files changed since the previous sync, with an optional lookback window for late modifications.

Can SharePoint be used as a destination?

Yes. Supaflow writes row-bearing batches as CSV files and Excel workbooks with append and truncate-and-load behavior. Excel output can use one workbook per object or one workbook for the pipeline. A zero-row truncate-and-load run does not clear existing SharePoint output.

Does the connector read SharePoint lists?

No. The connector reads supported files in SharePoint document libraries and OneDrive for Business folders; SharePoint lists are not supported.