- BoostSolutions
-
Products
-
- Microsoft Teams
- HumanLike Alert Reminder
- View All Apps
- Pricing
- Support
- Company
When using BoostSolutions’ Excel Import to import data from an Excel spreadsheet into a SharePoint list, you can specify to import all data or only some subsets of data.
In this article, we will demonstrate how to import part of data from an Excel spreadsheet.
The specified rows of Excel spreadsheet are imported to the SharePoint list
And there is an Excel file named as Sales Data, the Excel file contains these information as following. In this article, we plan to import row 13 to 15 into the SharePoint list.
Firstly, download the trial version of Excel Import and install it to your SharePoint server.
Navigate to the Sales Data list.
Under ITEMS tab, click Import Spreadsheet command in Import & Export group.
When the Import from Spreadsheet dialog appears, click Browse… button to choose the Customer file already prepared.
Click Next button.
In the Import from Spreadsheet dialog, configure these import options.
In the Sheet section, select USA sheet to import. And select Skip header row in Excel option to skip importing header row into the list.
In the Column Mapping section, select these columns (Order No., Customer, Product, Country, Purchased Date, Unit Price, Quantity and Ext Price) to import to the list.
In the Filter section, select the checkbox next to Import from row [] to [] option, and specify the data range as from row 13 to 15.
Keep other settings as default and click Import button.
After importing process finished, click Close button to exit.
Then in the Sales Data list, you will find that the specified rows of Excel are imported into the list as following.
