OneDrive File Issues

How to Create a OneDrive File List with Links Without Coding

Natalie Taylor Oct 9, 2026 869 views

Question details

The user wants to generate a complete catalog of file names and corresponding shareable links from a large OneDrive collection without writing code or using PowerShell.

How to Create a OneDrive File List with Links

Product: Microsoft OneDrive
Device & OS: not provided
Scenario: Organizing and sharing a large directory of files stored in OneDrive for external users or cataloging purposes.
Observed behavior: OneDrive Personal and Family accounts lack a native, one-click export feature to generate a bulk list of files and their shareable web links.

Before you start

Verify your OneDrive sharing permissions before creating links, ensuring that your intended recipients will have the necessary access rights (such as 'Anyone with the link can view') to open the files.

Solution 1Recommended

Manually Copy Shareable Links via OneDrive Web

Since personal OneDrive accounts do not offer an automated export feature, the most straightforward no-code method for smaller collections is generating and copying links manually into a spreadsheet.

This method is best suited for personal or family accounts where you need to share a select number of files. While it can be tedious for large collections, it guarantees that the correct sharing permissions are applied to each file.

Log in to OneDrive

Navigate to the OneDrive website and sign in with your Microsoft account credentials.

Generate a Share Link

Hover over the file or folder you want to list, click the 'Share' icon (a swooping arrow), and click 'Copy link'.

Adjust Permissions

If needed, click on the permission settings (e.g., 'Anyone with the link can edit') and change it to 'View only' to prevent unauthorized edits.

Paste into a Spreadsheet

Open a spreadsheet application, type the file name in one column, and paste the copied URL into the adjacent column.

Manually Copy Shareable Links via OneDrive Web

Third-Party Automation Tools: If you have thousands of files, manual copying is impractical. You may need to explore third-party directory listing tools or reconsider using PowerShell scripts, as they are the only way to fully automate this on personal accounts.

Solution 2

Use Export to Excel (For OneDrive for Business / SharePoint)

If you are using a corporate or educational OneDrive account, it is built on SharePoint, which natively allows you to export file directories straight to an Excel file.

Free Microsoft Office alternative

Manage Your File Directories Easily with WPS Office

Whether you are manually pasting OneDrive links or exporting a massive document library from SharePoint, organizing that data requires a robust spreadsheet tool. WPS Office is a free, lightweight suite that handles large datasets seamlessly, offering a perfect environment to sort, filter, and format your file links.

1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
2. Open WPS Spreadsheet: Launch the application and select 'Spreadsheet' to create a new blank workbook.
3. Organize Your Links: Paste your copied OneDrive file names and URLs, and use built-in tools like 'Hyperlink' and table formatting to finalize your directory list.

Fully compatible with Microsoft Excel (.xlsx) and CSV formatsLightweight and fast, easily handling thousands of rows of file linksRich formatting tools to organize and highlight your shared directoriesFree to use with a familiar, user-friendly interface for quick adoption

microsoft office alternative - wps office

Frequently Asked Questions

Can I export a list of files directly from OneDrive Personal?

No, OneDrive Personal and Family accounts do not feature a built-in 'Export to Excel' or 'Export List' button. Generating a list of web links currently requires manual copying or utilizing advanced tools like PowerShell scripts.

Will the exported links require users to sign in to a Microsoft account?

It depends on the sharing settings applied when the link was generated. If you select 'Anyone with the link', recipients can open the file without signing in. If you select 'Specific people' or 'People in your organization', a sign-in will be required.

Is there a way to get local file paths instead of shareable web URLs?

Yes. If you sync your OneDrive to your PC using the desktop client, you can open the Command Prompt, navigate to your OneDrive folder, and type 'dir /b /s > filelist.txt' to generate a text file containing all local file paths.

Why can't I see the 'Export to Excel' button in my OneDrive web portal?

The 'Export to Excel' feature is exclusive to OneDrive for Business and SharePoint document libraries. It is completely absent from the user interface of standard Microsoft 365 Personal or free tier accounts.

Document & File Issues