File Format & Compatibility

How to Fix Partial SharePoint Hyperlinks in macOS CSV Exports

Huda Qurayshi Sep 27, 2026 869 views

Question details

Users exporting SharePoint lists to CSV format on macOS encounter an issue where hyperlink and picture columns produce incomplete URLs.

How to Fix Partial SharePoint Hyperlinks in macOS CSV Exports

Product: SharePoint, Excel
Device & OS: macOS
Scenario: Exporting a SharePoint list containing hyperlink or picture columns to a CSV file using a Mac.
Observed behavior: The exported CSV file contains partial URLs for links and pictures, omitting the SharePoint domain (e.g., https://xxx.sharepoint.com), whereas exports on Windows preserve the full URL.

Before you start

Ensure you know the exact SharePoint domain name used by your organization (e.g., https://xxx.sharepoint.com) before applying the formula workaround.

Solution 1Recommended

Reconstruct the Full URL Using a Spreadsheet Formula

Since this is a platform-specific behavior on macOS, the most effective workaround is to manually append the missing domain using the HYPERLINK formula.

macOS omits the root domain when generating the CSV file from SharePoint. By inserting a conditional formula in your spreadsheet, you can automatically rebuild the full clickable URLs for the entire column without manually editing each row.

Open the CSV File

Launch your spreadsheet application (like WPS Spreadsheet or Microsoft Excel) and open the downloaded CSV file containing the partial SharePoint links.

Insert a New Column

Right-click the column header next to your incomplete URLs and select 'Insert' to create a blank column for the new full URLs.

Enter the HYPERLINK Formula

In the first cell of the new column, type `=IF(ISBLANK(H4),"",HYPERLINK("https://xxx.sharepoint.com"&H4))`. Replace 'https://xxx.sharepoint.com' with your actual SharePoint domain and 'H4' with the cell reference of the partial link.

Apply Formula to the Entire Column

Select the cell containing your new formula, then click and drag the fill handle (the small square at the bottom right of the cell) down to apply the formula to all remaining rows.

Reconstruct the Full URL Using a Spreadsheet Formula

Submit Feedback to Microsoft: Because this missing domain issue is a known platform-specific behavior on macOS with no direct settings toggle, it is highly recommended to submit feedback through the Microsoft Feedback Portal.

Free Microsoft Office alternative

Edit CSV Files and Manage Formulas Easily with WPS Office

While SharePoint's macOS export behavior requires a manual formula workaround, you don't need an expensive Microsoft Office subscription to fix it. WPS Office provides a fully featured, lightweight spreadsheet tool that easily handles CSV files, complex formulas, and data management on your Mac.

1. Download WPS Office: Download and install the free WPS Office suite for macOS from the official website.
2. Open Your CSV Export: Launch WPS Spreadsheet and open the SharePoint CSV file containing the partial links.
3. Apply the Formula: Use the HYPERLINK formula to quickly reconstruct your URLs and save the file in your preferred format.

Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formats.Lightweight and fast, perfect for opening large CSV exports on macOS.Supports advanced formulas like HYPERLINK, IF, and ISBLANK for quick data fixing.Familiar user interface makes it incredibly easy to migrate from Microsoft Office.

microsoft office alternative - wps office

Frequently Asked Questions

Why do SharePoint links export correctly on Windows but not on Mac?

This is a platform-specific discrepancy in SharePoint's export function. On macOS, the CSV generation engine omits the root domain for hyperlink and picture columns, resulting in partial URLs, whereas the Windows export includes the full path.

Can I permanently change the macOS SharePoint CSV export settings?

Currently, there is no direct setting or toggle in SharePoint or macOS to change this default export behavior. You must manually reconstruct the URLs using a spreadsheet formula or submit a feature request to Microsoft.

Will the HYPERLINK formula work in WPS Spreadsheet?

Yes, WPS Spreadsheet is fully compatible with standard Excel formulas. You can use the exact same IF, ISBLANK, and HYPERLINK combination to reconstruct your SharePoint URLs quickly and efficiently.

Document & File Issues