When using Excel Import product to upload and import an Excel to a SharePoint list, you may meet this issue "An unexpected error has occurred" as this. After digging into the SharePoint logs, there will be error message like this: "Requested registry access is not allowed." Or upload and import a .csv format file […]
Category: Excel Import
How to import columns that are Multiple Lookup fields to a SharePoint list?
We are using theExcel import in our SharePoint 2016. Can you tell me how to import columns thatare Multiple Lookup fields? Solution: Please split the values with “; ” in Excel spreadsheet and then try toimport to the lookup column. Applies for: SharePoint 2019, SharePoint 2016, SharePoint 2013, SharePoint 2010
Error “403 FORBIDDEN” occurs when using Excel Import
When I use Excel Import, after selecting the spreadsheet and clicking on“Next”, following error message pops up “403 FORBIDDEN”. Solution: Excel Import requires the end users at least have “Manage List”permission. Please check the current user’s permission and make sure the userhas proper permission. Applies for: SharePoint 2016, SharePoint 2013, SharePoint 2010
Get "Succeed: 0 items, Skipped: 0 items, Failed: 0 items" when import data from Excel to SharePoint list.
Always get this result "Succeed: 0 items, Skipped: 0 items, Failed: 0 items" when I running importing procedure, and no data is imported successfully. Why? Solution: The most possible cause is the current site is not added to Trusted sites in the IE settings. A screen should be poped up when accessing this site: Solution: Close IE […]