Data Connector - Sync data from multiple external data sources to SharePoint, and vice versa.
Connect to External Data Sources
Import data from a variety of external data sources to a SharePoint list, including:
Always Keep Data Up-to-Date
Data Connector works automatically in the background (via timer) and updates changes according to a scheduled plan thus always keeping data updated.
External Data Governance
End users can securely access data from SharePoint list after connecting to an external data source, then be able to add, read, update and delete external data from SharePoint list. Even better, any changes made in SharePoint can be written back to external data sources.
Excel Import - Import data from excel spreadsheet to any SharePoint list with column mapping capability.
Import Excel Data to SharePoint
Easily import data from Excel spreadsheets to a SharePoint List in just three steps: navigate to a list, upload a spreadsheet and click Import button.
Auto-Import Spreadsheets by Schedule
Create and schedule an import job to automatically import spreadsheets into any SharePoint list using Excel spreadsheet stored on a remote file share server, such as FTP or document library (incl. Office 365).
Map Fields between SharePoint and Excel
Select and map Excel headers to any SharePoint fields before importing the Excel spreadsheet to SharePoint, ensuring that the right information is quickly and accurately inserted in the right place.
Create a List from an Excel Spreadsheet
With SharePoint Excel Import, you can create a new list from an Excel spreadsheet with the field mapping function and even customize column names and column types as per your needs.
List Sync- Manually or automatically sync items between two or more lists.
Bidirectional Sync between Two Lists
Manually or automatically sync data or data changes between two lists. Real-time synchronization happens when documents or items are created, modified, deleted, checked in or approved.
Sync Specific Items Using Condition
Filter items to sync based on preset conditions so that only those columns or data that meet the criteria will be synchronized.
Sync Accurately via Column Mapping
Build connections between lists using column mapping. This also guarantees an effective and accurate synchronization. You can conveniently add or delete a mapping.
Aggregate Column Data from Different Lists
Two or more lists can be connected with a lookup column. This combines relevant column data from different lists so you can work with one aggregated list.
List Transfer - Copy/move documents or items between to lists or document libraries.
Bulk Copy/Move Documents or Items
Bulk copy or move documents, items, folders and pictures between libraries and lists. Users also can easily copy or move files via the virtual clipboard, these hotkeys are supported:
Prevent Data Loss via Column Mapping
With column mapping, metadata can be transferred safely to a destination library or list and all column types are supported for mapping.
Preserve Information during transfer
Permissions, version history, attachments and authors and timestamps can be preserved during the transfer.
Duplicate Documents or Items
The duplicate function allows for efficient item or document creation. Just duplicate an existing item or document and change the column values as needed. Even better, you can duplicate items/documents in bulk.