How to export folder and files names from a SharePoint site into Excel.

Gordon Yusko 40 Reputation points
2026-07-07T18:27:55.9366667+00:00

I have tried and failed to export the folder names and file names, while retaining the hierarchy, from SharePoint to Excel. None of the procedures described online work for me.

One possible reason could be that I don't have the appropriate permission, but I don't even know how to determine that.

Microsoft 365 and Office | SharePoint | For business | Windows
0 comments
Answer accepted by question author
Virendra Kumar 80 Reputation points
2026-07-07T21:33:37.2433333+00:00

SharePoint's Export to Excel typically exports metadata from a list, not a hierarchical folder/file structure from a document library. That's why many online procedures don't produce the folder hierarchy you're expecting.

You would need to write custom code or use a third-party tool to export the exact folder and file structure while preserving the hierarchy. SharePoint's built-in export options typically do not provide this capability. Permissions may also be a factor, depending on the method being used.

Was this answer helpful?

1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.