Features to Import Data into SharePoint Online / 2016 / 2013 / 2010
Import external dataImport External Data Source objects (tables / worksheets) into SharePoint as List Items and vice versa.
Populate external metadataApply metadata from external data sources to documents in SharePoint library.
Combine data from multiple sourcesImport data from multiple databases and store under a common List.
Column MappingMap columns in Data Sources with SharePoint columns to update with the original metadata.
Query BuilderUse the built-in Query Builder wizard to build queries on tables in databases without having to write complex SQL queries.
Customize importEdit import preferences using Connection Strings and Query Builder to customize your import.
Data PreviewCheck previews to ascertain the availability and accuracy of data being imported in and out of SharePoint.
Customize column mappingAutomatically map SharePoint columns with Data source columns. Or use Column Mapping Conditions to map according to your preferences.
Avoid data duplicationUse reference columns to avoid adding duplicate Items in SharePoint and Data Source.
Create ListsAutomatically create new Lists if necessary while importing DB objects for easy management in SharePoint.
Publish as documents to libraryImport and move data into SharePoint Library as Documents storing them in CSV / XLSX / HTML file format.
Export to driveImport and move data to any networked storage including Drives, Web folders etc. as documents storing them in CSV / XLSX / HTML file format.
Automate tasksSchedule Data integration tasks to run at a convenient period.
Synchronize dataAuto Synchronization to remove data records from SharePoint or Data Source which are not available in subsequent runs.
Exchange Recipient PickerSelect mailboxes from the list of available mailboxes to fetch mail items.
Exchange Folder Type selectionUse the folder types selection window, to fetch mail items from the list of folder types selected.
Exchange Folder SelectionSelect folders to move data from the selected folders to SharePoint list / library.
Exchange Item SearchSpecify search queries to filter items from the list of folders / folder types selected.