How to export SharePoint list to excel with attachment column


You can attach documents to a SharePoint List Item. To check if an item has any files attached or not, you can add the "Attachments" column in the view. This will show attachment icon for all entries which have a file attached.

SharePoint attachments
SharePoint attachments

Another great feature of SharePoint - you can export the entire list data into excel for analyzing or may be even creating pivots and reports on it. But the "export to excel" has a limitation and does not indicate if the list item has attachments, like it shows in the view.

A simple solution if you want to include attachment column while exporting to excel, is to not export into excel and instead export to csv. Option shown in below image.

This will export the attachments column too and the value will be 1 or 0.

1 = has attachments
0 = no attachments

SharePoint export to excel
SharePoint export to excel



Recent Posts:




Code2care is an initiative to publish and share varied knowledge in programming and technical areas gathered during day-to-day learnings and development activities.

Students and Software Developers can leverage this portal to find solutions to their various queries without re-inventing the wheel by referring to our easy to understand posts. Technical posts might include Learnings, Video Tutorials, Code Snippets, How Tos, Blogs, Articles, etc.