'%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 List to Excel 2021
Question details
The user wants to connect Excel 2021 to a SharePoint list for automatic row updates but is missing the 'From SharePoint List' option in the Get Data menu.
- Product
- Microsoft Excel 2021
- Device & OS
- not provided
- Scenario
- Attempting to sync SharePoint list data with an Excel workbook using Power Query for automated updates.
- Observed behavior
- The 'From SharePoint List' option is missing under the Get Data menu; only options like 'From Web', 'OData Feed', and 'ODBC' are visible.
Verify your exact Excel 2021 edition (e.g., Home and Student, Professional Plus) by navigating to File > Account, as data connector availability varies significantly by edition.
Verify Excel Edition for SharePoint Connector Availability
The 'From SharePoint List' connector is not available in all Excel 2021 editions and is typically restricted to Office Professional Plus and Microsoft 365 subscriptions.
Microsoft restricts certain Power Query data connectors based on the specific Office license installed. Standard, Home, or Student editions of Excel 2021 might lack direct native SharePoint integration.
If you do not have a supported version, you will need to rely on alternative methods such as OData feeds or direct exports from the SharePoint web interface.
Open Excel 2021, click on 'File' in the top-left corner, and select 'Account' at the bottom of the left-hand menu to view your exact Office edition.
Confirm if your edition is Office Professional Plus or a Microsoft 365 Enterprise subscription. Only these premium versions officially support the 'Get Data > From Online Services > From SharePoint List' feature.
If you don't have the required edition, navigate to your SharePoint site in a web browser, open your list, and click the 'Export to Excel' button at the top of the page as a workaround.
Try WPS Office for Seamless Spreadsheet Management
If your current Excel version limits your data import capabilities, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet tool that handles complex data and traditional Excel files with ease, without the confusion of feature-restricted editions.
- 1. Download and Install: Visit the official WPS Office website and click 'Download WPS Office Free' to get the lightweight installer.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and seamlessly open any existing .xlsx or .csv files exported from your databases or lists.
- 3. Manage Data Freely: Use WPS Office's intuitive data tools to sort, filter, and clean your datasets effortlessly.
Frequently Asked Questions
Why does my Excel 2021 only show 'From Web' and 'OData Feed'?
Standard and Home editions of Excel 2021 do not include the full suite of Power Query connectors. The 'From SharePoint List' connector is a premium feature reserved for Office Professional Plus and Microsoft 365 enterprise subscriptions.
Can I use the OData Feed option to connect to SharePoint?
Yes, you can use 'Get Data > From Other Sources > From OData Feed' and input your SharePoint list API URL (e.g., https://[domain]/sites/[site]/_vti_bin/listdata.svc) as a manual workaround for missing native connectors.
How do I export a SharePoint list to Excel without Power Query?
Navigate to your specific list in SharePoint online, click the 'Export' drop-down in the top command bar, and select 'Export to Excel'. This downloads a web query file (.iqy) that your spreadsheet software can open to load the data.
