How to Import Data From Excel

1. Create and name a new Synchronizer by clicking 'New' in the Home ribbon.
   
   
   
2. Double click the new Synchronizer to open the Mapping tab.
3. Double click ‘Add data from Excel’ to select the Excel Spreadsheet
4. Use the Microsoft Excel Synchronization Activator Wizard to select the layout, data range, and data type for the spreadsheet
5. Click ‘Finish’ to create the table in the source area
6. Double click one of the targets from the Target area of the Add tab to create the target table. If prompted, select the container Element
7. Open the Connect tab
8. Use the connect tools to map the fields
9. Use the field modifiers in the field modifier tab to alter the field values
10. Execute Synchronizer 

The short video clip below demonstrates how to import data from Excel: