Sharepoint List - Grid View Adding/Updating records from Copy/Paste Excel

Question

To whom it may concern,

We have been utilizing a SharePoint list since May 2024, adding new items through the grid view from Excel for bulk import purposes.

The list comprises three columns:

Data, Venue ID (which is a lookup value), and Carrier Name (which is a dropdown).

Today, I realized that when we attempt to copy the Venue ID value, for example, MM001 from Excel, the SharePoint list no longer recognizes the value, compelling us to use the item ID instead.

Could you please inform me if there has been a recent change? Or could you advise which setting I should check to resolve this issue?

Best regards,

VT

Answer 1

Dear Vural Tuysuz,

Good day! Thank you for posting in our community. Your question is "Grid View Adding/Updating records from Copy/Paste Excel".

Per testing from my end, it still supports copy pasting from Excel. Here is my testing process:

First check the lookup column supported values:

Copy from Excel

Paste it to list in grid edit view, it got pasted correctly and the other lookup columns based on this one are auto-filled.

To have further trouble shooting, could you please check:

1. double click a cell under "Venue ID" column from "grid view", check if the value you copied from Excel is included in the supporting list. Or you can go to the source list to check if the Excel value is contained in the source list source column. You can check the source list and source column from list settings >> find the "Venue ID" column and click inside.

2. Check if there is other lookup columns based on "Venue ID" and see if you were trying to paste value in these columns. These columns are 'read=only' and the values are auto entered based on "Venue ID".

3), Kindly create a new "lookup" column and check if copy paste works in the new column.

Thank you for your cooperation and have a nice day!

Best Regards,

Answer 2

Hi Sophia,

I encountered the same issue with VT and I've checked all the setting in the SP list. Everything seems fine. Not sure where the issue is from...

Best regards,

Shimin