SharePoint Custom List - New Interface - Export to CSV

Robert Sawyer 40

We are experiencing issues when exporting the contents of a SharePoint List to CSV format (default functionality) where some of the columns are left empty. Is anyone else seeing this?

This feature was working fine in the modern interface.

1 answer

RaytheonXie_MSFT 35,866 Reputation points Microsoft Vendor

2024-09-17T03:09:03.6566667+00:00

Hi @Robert Sawyer,

The problem might caused by view parameters. If a view had filter parameters, it'll try to use those in the spreadsheet as well. However csv won't be able to access any HTML/ASP.NET controls (which it won't embed in the spreadsheet), and it also won't be able to read from the querystring because there is none to read from. I suggest you use the "All Items" view instead of any other view.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Robert Sawyer 40 Reputation points

2024-09-17T11:11:14.5333333+00:00

The odd thing about this issue, it works fine when exporting the same view to a standard Excel format. This is the workaround atm, to do this and save as CSV. It just means extra steps.

RaytheonXie_MSFT 35,866 Reputation points Microsoft Vendor

2024-09-18T00:59:30.4866667+00:00

Hi @Robert Sawyer,

Are you working with SharePoint classic experience and could share the type of the empty column?

RaytheonXie_MSFT 35,866 Reputation points Microsoft Vendor

2024-09-23T01:02:32.27+00:00

Hi @Robert Sawyer,

Would you tell me whether your issue has been resolved or have any update? If you have any questions or progress, you can contact me in time.

Robert Sawyer 40 Reputation points

2024-09-25T08:40:02.0233333+00:00

@RaytheonXie_MSFT this issue has appeared after the modern interface changed to the new Microsoft Lists interface. It worked fine in the modern interface. We have logged a ticket with Microsoft.

Robert Sawyer 40 Reputation points

2024-09-25T09:05:02.1033333+00:00

@RaytheonXie_MSFT the point here is that this worked fine before the Microsoft List update. Our users use this feature of a regular basis and now have you follow extra steps to get the output they require. This is quite impactful and has a negative effect on the software confidence. A Microsoft ticket has been raised.

RaytheonXie_MSFT 35,866 Reputation points Microsoft Vendor

2024-09-26T02:39:49.9+00:00

Hi @Robert Sawyer,Currently there is some issue on SharePoint Online classic site pages. Here is the offical report

https://admin.microsoft.com/adminportal/home?#/servicehealth

Since our forum doesn't have access to sharepoint backend, I would recommend you to report your issue in service health. Thanks for your understanding.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

SharePoint Custom List - New Interface - Export to CSV

1 answer

Your answer