Excel for Mac: Import SharePoint Files with Power Query
Question details
The user needs to import files stored in SharePoint into Excel for Mac through Power Query.
- Product
- Microsoft Excel for Mac and Power Query
- Device & OS
- macOS
- Scenario
- The user wants to connect to a SharePoint site, select a file or data range, and load the data into Excel.
- Observed behavior
- The SharePoint connector may be available under the Data tab, but its name and availability vary by Excel for Mac version and Office updates.
Copy the SharePoint site URL and confirm that you can sign in with the Microsoft 365 account that has access to the files. Update Office for Mac before troubleshooting a missing SharePoint connector.
Use Excel for Mac Power Query to connect to SharePoint
Use this method when your Excel for Mac version includes the SharePoint Online or SharePoint Folder connector.
Power Query connector names and availability differ between Excel for Mac versions. If the SharePoint option is missing, install the latest Office updates and check your version's supported connectors.
Open Excel for Mac, select the Data tab, and choose Get Data or Get External Data.
Select From SharePoint Online or From SharePoint Folder, if either connector is available.
Enter the SharePoint site URL in the connection dialog and select Sign In. Use the Microsoft 365 account that can access the site.
In the navigator, select the required SharePoint file, table, or data range. Choose Transform Data to open Power Query Editor if you need to filter or reshape the data.
Select Load to import the selected data into a worksheet, or use Load To to choose a specific destination.
Use WPS Office as a lightweight alternative for SharePoint data workflows
WPS Office provides a free, lightweight spreadsheet alternative with a familiar interface and strong Microsoft Office format compatibility. While it does not replace Excel's Power Query SharePoint connector, you can use it to open, review, edit, and share exported SharePoint data in common spreadsheet formats, making migration straightforward.
- 1. Export SharePoint data: In Excel or SharePoint, save or export the queried results as an XLSX or CSV file.
- 2. Open the file in WPS Office: Launch WPS Spreadsheet and select Open from the Home screen, then choose the exported XLSX or CSV file.
- 3. Review and edit the data: Use the spreadsheet tools to filter, format, calculate, and organize the imported SharePoint data.
- 4. Save in a compatible format: Select Menu or File, choose Save As, and save the workbook as XLSX when you need Microsoft Excel compatibility.
Frequently Asked Questions
Where is the SharePoint connector in Excel for Mac?
Open Excel and select Data, then choose Get Data or Get External Data. Look for From SharePoint Online or From SharePoint Folder; the available option depends on your Excel for Mac version and Office updates.
What SharePoint URL should I enter in Power Query?
Enter the SharePoint site URL that contains the document library or files, rather than only a local file path. Sign in with the Microsoft 365 account authorized to access that site.
Why can’t I find From SharePoint Folder in Excel for Mac?
The connector may not be supported in your Excel release or may be hidden because Office is out of date. Update Office for Mac and review the available Get Data connectors for your version.
Can I transform SharePoint data before loading it?
Yes. After selecting the SharePoint file or table in the navigator, choose Transform Data to open Power Query Editor. Apply filters or other transformations, then select Close & Load or Load.
Can WPS Office connect directly to SharePoint through Power Query?
No. WPS Office does not provide Excel’s Power Query SharePoint connector. Use Excel or another supported Microsoft 365 tool to create the connection, then open the exported XLSX or CSV data in WPS Spreadsheet.
