Excel Tool for SharePoint
With this SharePoint solution, you can import the data in your Excel/CSV files into SharePoint lists.
Installation
You can search this product on Microsoft AppSource, and then install it from there.
When you enable this app during installation, it is recommended to select Enable this app and add it to all sites.
Entry Point
To access this tool, you need to find its entrance on the list menu for the list into which you want to import data.
Select a file to import
- After launching the solution, you'll be presented with the list name and item count. Below this, there's an area for selecting the Excel/CSV file you wish to import, either by dragging and dropping the file or by clicking on the reactangle area.
- If the file has multiple sheets, you may need to select one of them before going forward.
- After you selected a file, it would start reading it and the data would be presented on a table.
Map the columns
-
In the area of "Columns Mapping", you can create a map between columns from the Excel/CSV file and the columns from your SharePoint list.
And here is a list of the column type we support,
- Single Line of Text
- Multiple Lines of Text
- Number
- Yes/No
- Person or Group (Need to use valid email addresses)
- Lookup
- Date
- Choice
- Hyperlink
- Currency
Data Import
- After all the configuration is set up, you may start importing.
- After the data import is finished, you can click on the area other than the dialog to go back to your SharePoint List.
Data Export (Working on it...)
- Export data from multiple SharePoint lists into a single Excel/CSV file
- Choose the columns you want to export
- Customize the data format during the export process
Purchase
Click the following button to pay. After you have paid, please send your payment info with SharePoint Site URL to [email protected].
