# Excel Connector
## Overview
This flow can be used to Migrate data into IFS Cloud as an example of how to Read and Write data to Microsoft Office 365 Excel documents.
You can use the content of this component as an example or template to create your own Apps with embedded Excel functionality.
Within this example, you can migrate data from an Excel document into projections inside IFS Cloud. The projections used in this example are: Create Customer, Create Supplier, Create Work Order, and Create Part.
{% hint style="info" %}
Download the Excel migration demo file below.
{% endhint %}
{% file src="" %}
## **Launching the app**
### **Login**
You will be prompted to log in to Microsoft Graph using OAuth to access your Excel documents.
* Log in using your Microsoft Active Directory credentials
* Once successfully select Continue to sign in to Microsoft Graph
### Select IFS method
This screen allows to to choose the destination for the data migration. The options here are limited for this example, but you can add your own methods as required.
### Select Excel document
You can enter an Excel file path (Office Cloud) or select from your recently used files.
### Select data within the Excel document
Select the data within the Excel document, Available choices are Excel worksheets and named Tables.
Worksheets show as green, and any named tables will show as Yellow with the table identifier under each associated worksheet.
{% hint style="info" %}
Selecting a worksheet will set the data range to the worksheet used range. using a table will limit the data range to the table's defined range.
{% endhint %}
### Colum Mapping
The App will automatically assign any Excel columns to the IFS object name if they match.
The Colored Yellow rows (sorted to the top in alphabetical order) are required IFS fields. You can map columns or set default values (dropdown list) or strings. The same applies to Optional IFS objects. Records will turn Green when a value is chosen.
{% hint style="info" %}
IFS fields like CreationDate can be left empty as these are populated by the IFS system automatically.
{% endhint %}
### Review
You can review the created IFS objects on this screen, and end the workflow here, or continue to write a summary of the created IFS objects back to the same document as a new sheet.
### Write to Excel
Select any IFS columns to **exclude** from the export.
### Enter Worksheet name
By default, the IFS projection name and current date/time are used.
When you create the summary a new worksheet will be created with data representing the newly created objects within IFS.
