Import Data into SharePoint Lists and Document Libraries

External Data Connector for SharePoint imports data into SharePoint from multiple external data sources, including Databases, SharePoint, CSV, Excel files, and Mails from Exchange Server / Exchange Online and integrates them into SharePoint Lists and Document Libraries.
It supports databases such as SQL Server, MS Access, Oracle and any ODBC compliant database, file sources such as XLSX, CSV and Mail Items from Exchange Server / Exchange Online.
The product can integrate data into SharePoint 2016, SharePoint 2013, SharePoint 2010 and SharePoint online in Office 365.

  • Bring your data from external data sources to SharePoint Lists

    • Integrate external data in SharePoint Lists and Synchronize with their external sources
    • Automate filtering and fetching data from external sources using "Query Builder"
    Import your data into SharePoint
  • Extract data from databases and Publish them as reports (documents) in SharePoint

    • Create and store reports about external data sources from within SharePoint
    • Publish these reports as SharePoint List or Library / Export them to a shared folder
    Extract Data & Publish in SharePoint
  • Extract Metadata from your disconnected Legacy / LOB Apps and apply them to documents in SharePoint

    • Synchronize SharePoint Library metadata with the file properties in external sources
    • Simplify data & content management with synchronized SharePoint metadata and source file properties
    Extract Metadata & Apply in SharePoint
  • Import Exchange mails to SharePoint Lists

    • Export mail content to SharePoint for knowledge sharing and collaboration
    • Archive business critical mails to SharePoint lists and libraries
    • Use the Exchange Query Builder to import specific, context based mails such as projects, campaigns, surveys, etc. from mailboxes to SharePoint
    Import Mails in Exchange to SharePoint



  1. Integration of external data

    Integration of external data from multiple sources into SharePoint Lists / Libraries and vice versa.

  2. Apply metadata from external data sources

    Apply metadata from external data sources to documents in SharePoint library

  3. Auto create SharePoint Lists

    Automatic creation of new SharePoint Lists using imported data.

  4. Sync SharePoint and external data

    Synchronization of SharePoint and external data through field/column mappings.

  5. Auto create new columns and mappings

    Automatic creation of new columns and mappings while creating new Lists using imported data.

  6. Create of scheduled tasks

    Creation of scheduled tasks for automatic import and synchronization of external data and SharePoint Lists and Libraries.

Import Data from external database into SharePoint Lists

  • Build queries and extract data from tables and views in external databases and import them into SharePoint Lists
  • Supports MSSQL, Oracle, My SQL, and any ODBC compliant database
  • Supports all List types
  • Smart Query Builder allows you to perform simple and complex queries (including joins) on multiple tables and copy records into SharePoint lists
  • Filter and fetch only the desired columns and values from tables to SharePoint lists
  • Automatically create lists in SharePoint when you copy new table content from database
  • Track errors and analyze records imported to lists
  • Export the SharePoint list content back to the external data source
  • Map database table column names with SharePoint list columns prior to data import
  • Allows users to collaborate using data within SharePoint; users need not connect manually to databases every time to fetch and populate list data

Import XLSX, CSV data to SharePoint

  • Import data from your CSV and Excel files that contain business and user data from other systems
  • Directly read from the CSV/XLSX files and map it to available lists and their columns or create new lists
  • Export your business application data to CSV files at regular intervals and schedule your import to lists using the CSV files

Import Data from external database into SharePoint Lists

  • Import MS Exchange mail items from Mailboxes and Public Folders into SharePoint Lists
  • Import mailboxes, contacts, tasks, calendar, and other custom folders
  • Selectively import mail items from Exchange on-premises and Exchange Office 365 into SharePoint for sharing and collaboration
  • Copy entire mail boxes in bulk into SharePoint lists – especially useful for importing mail items from shared mailboxes (say, a Customer Service mailbox)
  • Perform a granular import of mails by querying on various mail item properties such as From, To, Cc, Date range and message headers. Query mail items for keywords in Subject and Body of mails.
  • Map and bring only the required fields in mail items to SharePoint lists (such as date-time, To, subject, body etc.)

Take a tour Watch this SharePoint Information Organizer product tour to find out how it helps SharePoint administrators run their Sites efficiently and improve end-user experience.