Forum Discussion
Import CSV for bulk upload (instead complete 1 by 1 forms)
Hi there,
We have a SharePoint page which show items that people need to manually add through a form. The form requieres almost 30 fields all of them mandatory and almost all of them have multiple values.
We are looking for a way to upload a CSV/Excel file into the SharePoint in order to create several items in one upload. Is there any way to upload a file that contains all the columns that the form has? Does SP support upload files with multiple values for one field?
Attached some pictures to better understand the scenario.
Form:
Excel Sample:
thanks.
3 Replies
you can try below sample pnp powershell script for bulk upload List item using csv and this script support multi value option
Connect-PnPOnline -Url https://m365x.sharepoint.com/sites/testsite $path = "C:\Users\importlistitem1.csv" $csvs = Import-Csv $path foreach($values in $csvs ) { Add-PnPListItem -List "testlist" -ContentType $values.ContentType -Values @{"Title" = $values.Title; "Multichoice"= $values.Multichoice.split(",") ; "Singleline" = $values.Singleline ; "User" = $values.User ; "Date" = $values.Date ; "Number" = $values.Number } }- To achieve this, you will need to do custom development
