External Data Connector for SharePoint

Features to Import Data into SharePoint Online / 2016 / 2013 / 2010

Import external data

Import External Data Source objects (tables/worksheets) into SharePoint as List Items and vice versa.

Import External Data into SharePoint as List Items and vice versa

Apply external data sources metadata to SharePoint library documents

Populate external metadata

Apply metadata from external data sources to documents in SharePoint library.


Combine data from multiple sources

Import data from multiple databases and store under a common List.

Import data from multiple databases to SharePoint List

Map Data Source & SharePoint columns to update original metadata

Column Mapping

Map columns in Data Sources with SharePoint columns to update with the original metadata.


Query Builder

Use the built-in Query Builder wizard to build queries on tables in databases without having to write complex SQL queries.

Built-in Query Builder for queries on tables in databases

Edit import preferences to customize your import

Customize import

Edit import preferences using Connection Strings and Query Builder to customize your import.


Data Preview

Check previews to ascertain the availability and accuracy of data being imported in and out of SharePoint.

Previews before importing data and enhance accuracy

Automate mapping of SharePoint columns with Data source columns

Customize column mapping

Automatically map SharePoint columns with Data source columns. Or use Column Mapping Conditions to map according to your preferences.


Avoid data duplication

Use reference columns to avoid adding duplicate Items in SharePoint and Data Source.

Avoid adding duplicate Items in SharePoint and Data Source

Automatically create required Lists while importing

Create Lists

Automatically create new Lists if necessary while importing DB objects for easy management in SharePoint.


Publish as documents to library

Import and move data into SharePoint Library as Documents storing them in CSV/XLSX/HTML file format.

Import and Publish data into SharePoint Library as Documents

Import and move data to any networked storage as documents

Export to drive

Import and move data to any networked storage including Drives, Web folders etc. as documents storing them in CSV/XLSX/HTML file format.


Automate tasks

Schedule Data integration tasks to run at a convenient period.

Schedule and run data integration tasks at your convenient time

Synchronize to remove not found Data in next run

Synchronize data

Auto Synchronization to remove data records from SharePoint or Data Source which are not available in subsequent runs.


Exchange Recipient Picker

Select mailboxes from the list of available mailboxes to fetch mail items.

Select Recipient mailbox to fetch mail items

Select Folder Type to fetch mail items from the list of folders

Exchange Folder Type selection

Use the folder types selection window, to fetch mail items from the list of folder types selected.


Exchange Folder Selection

Select folders to move data from the selected folders to SharePoint list / library.

Select desired folders to move to SharePoint list / library

Search queries to filter items from the selected list of folders

Exchange Item Search

Specify search queries to filter items from the list of folders / folder types selected.