Link Excel Table Image Names to OneDrive Files
Question details
Create clickable links from image file names in an Excel table to matching files in a OneDrive folder.

- Product
- Microsoft Excel and OneDrive
- Device & OS
- not provided
- Scenario
- An Excel table contains image names that match files stored in a OneDrive folder.
- Observed behavior
- Each image name should open its corresponding OneDrive file when clicked.
Check that the table names match the OneDrive file names, including extensions. Identify a direct folder URL ending in a slash and confirm that intended recipients can access the files.
Create a calculated hyperlink column in Excel
Use this formula when the files share a direct OneDrive folder path and their names match the table entries.
A OneDrive sharing link containing a token or query string is not necessarily a direct folder path and may not work when a file name is appended. Test the resulting URL before filling the column.
In the Excel table, add a column next to the image-name column and give it a heading such as Image Link.
In the first data cell of the new column, enter =HYPERLINK("https://yourcompany-my.sharepoint.com/personal/user/Documents/Images/"&[@ImageName],[@ImageName]). Replace the example URL with your direct folder path and ImageName with your actual table column name.
Press Enter and check that Excel fills the calculated column. If it does not, copy the formula down, then click several links to verify that they open the correct files.
In OneDrive, select a file and use Share or Manage access to confirm that the intended recipients have permission to open it.

Insert individual OneDrive sharing links
Use individual links when you cannot identify a direct folder path or appending file names does not work.
Create OneDrive image links in WPS Spreadsheets
Use the HYPERLINK function in WPS Spreadsheets to combine a direct OneDrive folder path with image names, then fill the formula down your worksheet.
- 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
- 2. Enter a hyperlink formula: If the first image name is in A2, select an empty cell in row 2 and enter =HYPERLINK("https://yourcompany-my.sharepoint.com/personal/user/Documents/Images/"&A2,A2), replacing the example path with your direct folder URL.
- 3. Fill the formula down: Drag the formula cell's fill handle down alongside the remaining image names.
- 4. Test and save: Click the generated links to verify the paths and permissions, then use File > Save As to save the workbook in XLSX format.

Frequently Asked Questions
Why doesn't my OneDrive folder sharing link work in the formula?
A sharing link may contain a token or query string rather than a direct folder path. Test a direct file URL, or use OneDrive's Share > Copy link for each file instead of appending names to the sharing link.
Do the image names need file extensions?
Yes. The names used in the formula should match the actual OneDrive file names, including extensions such as .jpg or .png.
Does creating a hyperlink give other people access to the image?
No. In OneDrive, use Share or Manage access to give recipients the appropriate permission. They may also need to sign in.
What should I check if a generated link opens the wrong page?
Check the folder path, trailing slash, file name, and extension. If the name contains spaces or special characters, compare the generated URL with a working direct file URL and check whether URL encoding is needed.




