Forum Discussion
Solved
Upload excel data into a SharePoint list
Hi, I have around 379 rows (3 columns) of data that I would like to import into an SharePoint list which already contains data. I've formatted the excel spreadsheet to match the current view of...
- Hi Chris_Clark1968
Yes, right. You can see more details here: https://www.youtube.com/watch?v=vVaO6xBh36s
Regards, Dave
that's right, it's possible.
Note:
- the column must be matched with your copied value (best with text 🙂 )
- you will use the grid view
- when you have mandatory fields, the need an value
Regards, Dave
Hi Dave,
Thanks for your reply.
So I can copy say 10 to 20 rows at a time into my SP list using the grid view option?
As I say the Excel spreadsheet is formatted to the same column names to my SP list headings
If I select a number of rows from a column select Ctrl C and place the cursor in the Add new item and press Ctrl V those items should be copied in that column??
Regards
Chris
Thanks for your reply.
So I can copy say 10 to 20 rows at a time into my SP list using the grid view option?
As I say the Excel spreadsheet is formatted to the same column names to my SP list headings
If I select a number of rows from a column select Ctrl C and place the cursor in the Add new item and press Ctrl V those items should be copied in that column??
Regards
Chris