Knowledge Base

Creating an Excel Source

How can we help?

Browse Common Categories

Getting Started with

Creating an Excel Source


From the left side options column navigate to Data Sources > Bulk Sources > File.

File Data Source Location
  1. On the File Data Sources window click on the Create Bulk File button.
Create Bulk File Button
  1. On the New File Data Source window click on the Microsoft Excel icon.
Microsoft Excel Icon
  1. The Microsoft Excel Data Source window contains the following fields:
Excel Data Source Window
  • Description – Allows the user to enter a description of the spreadsheet being imported.
  • Select file at runtime – When this checkbox is marked, the uploaded file will be used as a template only and no data from it will be processed. The files chosen at runtime will need the same headers as the uploaded source file.
  • Source File – Click on the Select File button to select the Excel file to be used as the data source.
  • Excel Sheet – After the Source File is selected, the Excel Sheet field will become active. Use this field to select the worksheet in the Excel file to be used as the data source.

  1. Once all the fields have been populated, the Save button becomes active.
  2. Clicking on Save will save the data source and make the data source available to be selected when creating an Integration Process.
  3. After the Excel source has been saved, the Preview button will become active.
  4. Click on the Preview button will open a pop-up window that displays the first few records contained in the spreadsheet.
  5. Closing the Data Preview window and Excel Data Source window returns the user to the File Data Sources window where existing data sources can be edited or deleted by clicking on the respective icons.

Email an Expert

Start a Ticket

Chat with Us


Submit a Ticket


Call Us

  • Microsoft Dynamics 365
Get Started

SmartConnect is designed with specialty & deep experience in the core technologies we focus on.

iPAAS & on-premise integration tools that let you connect your cloud and on-premise applications.

© 2023 SmartConnect|eOneSolutions
Cloud Terms of ServicePrivacy PolicyTerms of ServiceEULA

How can we help?