![\"excel-import-blog-1\"](\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/05\/excel-import-blog-1.png\")
<\/a><\/p>\n2. When Manage Import Jobs dialog box appears, click Create New Import Job.<\/p>\n
3. In Import Excel Spreadsheet from Remote Server dialog box, enter the Excel file URL which is stored in a document library. And click Next.<\/p>\n
4. And then Import Excel Spreadsheet from Remote Server dialog appears. In this dialog, configure these settings.<\/p>\n a. In Import Job Name section, type a unique name.<\/p>\n b. In Sheet Section, select shee1 where stores the sale data.<\/p>\n c. In Column Mapping section, select the columns and map them to list columns.<\/p>\n d. To import all rows of this Excel sheet, I do not select the \u201cImport from\u2026\u201d option in Filter section.<\/p>\n e. In Import Options section, select \u201cCheck duplicate records when importing option\u201d and specify Order No. column as key.<\/p>\n And select \u201cSkip duplicate records\u201d option. This is because once sale data are recorded in Excel file, it is immutable.<\/p>\n f. In Recurring Schedule section, specify the import job run on Daily. And the sale data will be updated from Excel to a SharePoint list daily.<\/p>\n \u00a05. After an import job created, it appears as following.<\/p>\n 6. Wait the import job run, the sale data will import or update to SharePoint list as following.<\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n