Sharepoint List Exporting A Blank CSV and Excel

Question

Hello, I got an issue with a sharepoint list, it doesn't export any data when trying to download it as CSV or excel and the files are downloaded with column headers without any data.

The sharepoint is large and exceeding 400K entries with new filter applied to my view except for the last 7 day.

Answer 1

When exporting a SharePoint list to CSV or Excel, if you are receiving files with only column headers and no data, it could be due to several reasons:

1. Filtering Issues: Since you mentioned applying a filter to your view, ensure that the filter is not excluding all entries. If the filter criteria are too restrictive, it may result in no data being available for export.
2. List Size: With a large list of over 400,000 entries, there could be performance issues or timeouts during the export process. SharePoint may struggle to handle such a large dataset, especially if the view is complex or if there are many columns.
3. Export Limitations: SharePoint has known limitations regarding the export of list content. If any single cell exceeds Excel's maximum cell size limit of 32,767 characters, the information that exceeds this limit will be lost. In such cases, consider exporting to Access instead, which may handle larger datasets better.
4. Permissions: Ensure that you have the necessary permissions to view and export the data from the SharePoint list. Lack of permissions could lead to an empty export.

To troubleshoot, you might want to try:

• Adjusting or removing the filter to see if data appears.
• Exporting smaller batches of data or using a simpler view.
• Checking your permissions on the list.

If the issue persists, consider exporting the list to Access, which may provide a more reliable export for large datasets.

---

References:

• Unable to export to Excel from SharePoint
• Information about manual migration of SharePoint Online content

Answer 2

Hi @Ahmed Khaled, 

Thank you for posting your question in the Microsoft Q&A forum. 

Could you confirm which view you’re currently using? If you’re in a custom view, I suggest switching to “All Items” and trying the export again to see if that works. 

If the issue continues, I recommend creating a custom View in SharePoint that filters the list into smaller, more manageable sections. This approach makes it easier to work with and export the data. Once you’ve set up the View, please make sure to right-click and save the View before proceeding with the export.  

If you’ve tried the suggested steps and still notice that the files only show column headers without any data, please let us know by leaving a comment under this post. As a forum moderator, I don’t have access to backend tools or permissions to review your system configuration, so I’m unable to identify the root cause directly. However, depending on your situation, I’ll gladly guide you on how to reach the appropriate support team for further assistance if needed.  

Thank you for reaching out! 

---

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.