Power Query: Get data from SharePoint lists | Excel Off The Grid

Показать описание

★ Want to automate Excel? Check out our training academy ★

★ Check out the blog post★

★ About this video ★
SharePoint lists are becoming a common data source for Excel users. In this video, we show you how to import these lists into Excel with Power query (and without)

0:00 Introduction
0:38 Get the SharePoint site URL
5:37 Using the SharePoint list connector
7:13 Connecting to a SharePoint list without Power Query
8:55 Conclusion

★ Download 30 most useful Excel VBA Macros ebook for FREE ★

★ Where to find Excel Off The Grid ★

#MsExcel

Excel Off The Grid

Рекомендации по теме

Комментарии

Thank you so much for creating this video!! It has simplified my work😁.

flashwade

I just didn't even know about Sharepoint lists at all! Going to look into them too :)

leechinhhua

Thanks for the Video. I want to use all files from a specific folder. I found the foulder in sharepoint but couldnt get to the colums from the file itself. can you help me with that? thanks in advance

LeonartEder

Hi Mark. What's PQ Example ? A site that contains files, or records? It looks like an excel table. Thank you for this video!!!

IvanCortinas_ES

I have over 15, 000 records in my SP list; can I filter - using PowerQuery - the data before it all comes into my Excel file? Out of those 15, 000 lines, I may only need 5 records most of the time.

HeyJack

Hello there, i have been using the power query for quite sometime, can you please tell how to extract if the sharepoint list have more than 5000lines in it? it throws error

deepakn

Are there limited rows that are allowed to download using this method?

abhisham

Nice sharing! But with my office 365 business version, it does not have option for Sharepoint or similar 😂😂😂

dangliemvo

When clicking export in sharepoint, I get "Export to CSV" and "Export to PowerBI". Could you help me find out why I'm not able to "Export to Excel"?

AhmedThahir

Is there an easy way to write data back to a Sharepoint List from Excel using a connector vs overwriting with copy n paste / PowerAutomate?

rjwatwork

If I keep this file in SharePoint folder will it autorefresh ?

ArunKumar-nzun

Why this doesn't work for Excel online is idiotic. MS seems to have such frustrating holes in what their platforms can do online.

xxczerxx

Power Query: Get data from SharePoint lists | Excel Off The Grid

Get Data From SharePoint or OneDrive with Power Query - Demystified!

Combine Files from a Folder with Power Query the RIGHT WAY!

Power Query: Get data from SharePoint lists | Excel Off The Grid

Advanced Power Query - Get Data from Web

Easily Extract Data from Power Query Lists and Records

Scrape Data from Multiple Web Pages with Power Query

How to use Microsoft Power Query

Scrape Data From Multiple Web Pages into Excel (with Power Query)

Marathon Day 1: A-Z of Power Query

08 - Getting Data from Current Excel Workbook to Power Query

Get Multiple Files Containing Multiple Sheets with Power Query

Getting data from current workbook with Power Query | Excel Off The Grid

How Power Query Will Change the Way You Use Excel

Power Query: Get data when sheet/Table names change (2 ways) | Excel Off The Grid

Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder)

Getting Started with Power Query APIs - It's surprisingly easy!

07 - Import Data from an Another Excel Workbook using Power Query

How to Scrape Data from the Web with Power Query

Extract a column of data from a Power Query table

Beginner's Guide to Excel Get & Transform / Power Query

INSANE AMAZING Power Query tip to quickly change data sources in Power BI and Excel

Master Data Cleaning with Power Query in Excel in 9 Minutes

Easily Import Data from Web to Excel (2 Practical Examples)

Power Query - Data from many folders with Single Query