'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Connect a SharePoint Subfolder to Excel on Mac
Question details
The user needs to connect a specific SharePoint or OneDrive subfolder to Excel for Mac to consolidate shared data.
- Product
- Excel for Mac
- Device & OS
- Mac
- Scenario
- Consolidating data from shared files hosted on OneDrive or SharePoint.
- Observed behavior
- Required subfolders in OneDrive or SharePoint do not appear when attempting to connect from Excel for Mac.
Ensure you are connected to the internet and have the correct root SharePoint site URL ready. Avoid using direct links to specific files or folders, and verify that your account has the necessary access permissions.
Connect via 'From SharePoint List' in Excel Data Settings
Use the built-in data connection tool with the root site URL to properly link your Excel workbook to a SharePoint site on a Mac.
When connecting Excel for Mac to a cloud location, using the exact file or folder path often results in an empty directory display. Connecting to the base SharePoint site first allows Excel to authenticate properly and map the folder hierarchy.
Launch Excel for Mac, open your workbook, and navigate to the 'Data' tab located on the top ribbon.
Click on 'Get Data' or 'From Other Sources', then choose 'From SharePoint List' from the dropdown menu.
Input the base SharePoint site URL. Do not paste the direct URL of the subfolder or the specific file.
Log in with your Microsoft account credentials when prompted. Once authenticated, browse through the directory structure to locate and select your required subfolder.
Try WPS Office for Seamless Spreadsheet Management on Mac
If you frequently encounter data connection issues or missing folders in Excel for Mac, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for managing spreadsheets and collaborating on Mac without heavy resource usage.
- 1. Download WPS Office: Visit the official WPS website and download the Mac installer.
- 2. Install and launch: Follow the installation prompts and open WPS Spreadsheets.
- 3. Open your files: Import your existing .xlsx files directly into WPS Office with full compatibility.
Frequently Asked Questions
Why are my SharePoint subfolders not showing up in Excel for Mac?
This usually happens if you enter a direct file URL instead of the base SharePoint site URL in the data connection wizard, or if your Microsoft account lacks the necessary permissions to view the folder structure.
Can I use a direct folder link to connect data in Excel for Mac?
No, Excel for Mac's data connection tool requires the root SharePoint site URL. Once connected to the site, you can manually navigate through the directories to reach the specific subfolder.
How do I check my SharePoint permissions?
You can verify your access permissions by logging into the SharePoint site via your web browser. If you cannot view or access the subfolder through the web interface, you will need to request access from the site administrator.
