Home

How to query data from SharePoint Online list in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-106505%22%20slang%3D%22en-US%22%3EHow%20to%20query%20data%20from%20SharePoint%20Online%20list%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-106505%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20import%20data%20into%20Excel%20from%20a%20list%20on%20SharePoint%20Online.%20I%20am%20able%20to%20connect%20to%20the%20list%20using%20the%20standard%20data%20connections%20feature%20in%20Excel%2C%20which%20allows%20connection%20to%20various%20web%20services.%20However%2C%20when%20making%20a%20connection%2C%20all%20the%20rows%20in%20the%20list%20are%20loaded%20on%20a%20worksheet.%20I%20can%20see%20an%20option%20to%20remove%20unwanted%20columns%2C%20but%20I%20would%20like%20to%20import%20just%20some%20specific%20rows%20based%20on%20certain%20criteria%3B%20e.g.%20in%20terms%20of%20SQL%2C%20by%20using%20a%20'where'%20condition.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20here%20know%20how%20I%20can%20send%20a%20query%20to%20extract%20just%20the%20rows%20and%20columns%20that%20I%20want%20from%20the%20SharePoint%20Online%20list%3F%20Thanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-106505%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-106612%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20query%20data%20from%20SharePoint%20Online%20list%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-106612%22%20slang%3D%22en-US%22%3EHave%20you%20tried%20to%20follow%20this%20support%20article%20where%20Power%20Query%20is%20advised%3F%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FImport-data-from-external-data-sources-Power-Query-be4330b3-5356-486c-a168-b68e9e616f5a%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FImport-data-from-external-data-sources-Power-Query-be4330b3-5356-486c-a168-b68e9e616f5a%3C%2FA%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I am trying to import data into Excel from a list on SharePoint Online. I am able to connect to the list using the standard data connections feature in Excel, which allows connection to various web services. However, when making a connection, all the rows in the list are loaded on a worksheet. I can see an option to remove unwanted columns, but I would like to import just some specific rows based on certain criteria; e.g. in terms of SQL, by using a 'where' condition.

 

Does anyone here know how I can send a query to extract just the rows and columns that I want from the SharePoint Online list? Thanks in advance!

1 Reply
Highlighted
Related Conversations
Fonction si ?
LolitaG in Excel on
0 Replies
How do I do this?
moppy1234 in Excel on
2 Replies
FORMULA ASSISTANCE
Bran20 in Excel on
2 Replies
Excel formula auto complete not working
Bholeswar in Excel on
0 Replies
How to Include a Text Field in an Excel Pivot Table
tdc-studio in Excel on
2 Replies
Excel taking forever to launch and very slow
pjvilloud in Excel on
2 Replies