Importing Grid Data from Microsoft SharePoint Using Microsoft Office 365

1. Access an application with a grid.
2. Click Import Grid Data icon.
3. On Import Assistant, under the Define Import File section, select Cloud Storage.
4. Select one of these options:
   • Import from Excel

     Use this option to import grid data from an XLS file. By default, Sheet1 is imported from the workbook. Enter the specific sheet name in the Worksheet name field if you want to import data from a different sheet.

   • Import from Comma Separated Values (CSV)

     Use this option to import the grid data from a CSV file. Use the drop-down to select the text encoding for the CSV file.

5. Click the Browse button to access the list of folders in the Microsoft SharePoint location defined in the soft coding record. Navigate the folders to locate the file you want to import.

6. Select the file and click Continue.

7. In Import Assistant, enter the values for Starting Cell and Ending Cell under Define Cell Range. Use the Paste option if you want to overwrite the existing data that resides in the grid. With this option, you can paste the new rows anywhere in the existing grid. Enter the values for the Col and Row.

   Under Define Import Location in Grid, Insert (Import new rows at column A, row 0 of the grid) is selected by default. Use the Paste option if you want to overwrite the existing data that resides in the grid. With this option, you can paste the new rows anywhere in the existing grid. Enter the values for the Col and Row.

8. Click Continue.