SharePoint Document Issues

How to Convert Local OneDrive Paths to SharePoint URLs

Kushani Nimanthika Oct 21, 2026 870 views

Question details

The user needs to convert local file paths from synced OneDrive or SharePoint folders into valid online web URLs so that files can be accessed by other users via a SharePoint list.

How to Convert Local OneDrive Paths to SharePoint URLs

Product: SharePoint and OneDrive
Device & OS: not provided
Scenario: A user is trying to add file links to a SharePoint list, but pasting the local synced file path results in an unclickable or inaccessible link for other collaborators.
Observed behavior: Local OneDrive or synced SharePoint paths act as invalid web links in a SharePoint list, preventing team members from opening the shared documents online.

Before you start

Ensure that your local files are successfully synchronized to the cloud and that you have the correct sharing permissions enabled for your SharePoint document library.

Solution 1Recommended

Copy the SharePoint Link Manually

This is the most straightforward method for converting a few local paths into accessible web URLs directly from the SharePoint interface.

When dealing with a small number of files, manually generating the link from the SharePoint web interface is the fastest approach. This guarantees that the URL has the proper HTTPS format and includes necessary sharing permissions.

Open the SharePoint Document Library

Navigate to your SharePoint site in a web browser and open the Document Library where the synchronized file is stored.

Select the Target File

Locate the file you want to share, hover over it, and click the checkmark circle on the left side to select it.

Copy the Link

Click the 'Copy link' button in the top toolbar or from the context menu. This will generate a valid web URL.

Update the SharePoint List

Navigate back to your SharePoint list and paste the generated URL into the appropriate hyperlink column.

Permission Check: The 'Copy link' feature also allows you to define who can access the file, ensuring secure collaboration.

Solution 2

Automate URL Conversion with Power Automate

Use this solution if you have a large batch of files and need to retrieve multiple SharePoint URLs automatically.

Free Microsoft Office alternative

Looking for a Simpler Way to Collaborate? Try WPS Office

If managing SharePoint URLs, syncing issues, and complex Microsoft Office environments is slowing you down, WPS Office provides a lightweight, highly compatible alternative. With built-in WPS Cloud, sharing files securely with your team takes just one click—no path conversions required.

1. Download and Install: Get WPS Office for free and install it on your PC, Mac, or mobile device.
2. Save to WPS Cloud: Open your document and save it directly to the integrated WPS Cloud for immediate syncing.
3. Share with One Click: Click the Share button in the top right corner to instantly generate a valid web link that anyone can open.

Free and lightweight alternative to the traditional Microsoft Office suiteFully compatible with Microsoft Word, Excel, and PowerPoint formatsBuilt-in WPS Cloud for effortless file syncing and instant link generationFamiliar, tabbed user interface ensuring a seamless migration for your entire team

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't my local C: drive path work in a SharePoint list?

Local paths (like C:\Users\Name\OneDrive\Document.docx) point directly to your computer's personal hard drive. When you paste this into a SharePoint list, other users' browsers cannot access your local drive over the internet. A valid web URL (HTTPS) is required.

Can I get the SharePoint URL directly from Windows File Explorer?

Yes. If your files are synced via OneDrive, you can right-click the file in Windows File Explorer and select 'Share' or 'Copy link' (with the OneDrive cloud icon). This will copy the valid web URL directly to your clipboard without needing to open the web browser.

Is there a formula to convert local paths to URLs in Excel?

If you are managing the list in Excel before importing to SharePoint, you can use the SUBSTITUTE and HYPERLINK functions to replace the local directory path (e.g., 'C:\Users\...') with your SharePoint tenant's root URL. However, this relies on strict folder structures and may break if the library mapping changes.

Document & File Issues