How To Connect a SharePoint List To Excel

🔔SIGN UP FOR MY SHAREPOINT LIST FUNDAMENTALS COURSE🔔: bit.ly/3XQq45i

7:25 most imporant information, thank you, for me pointless then, I wanted to update the list via Excel because it would be much faster ... thank you microsoft for again complicating possibly good thing

Found this video helpful? Say thanks by "Buying Me a Coffee": bit.ly/4bgKxE3 PART 2 OF THIS TUTORIAL WHERE I DEMONSTRATE HOW TO DISPLAY THE NAMES AND EMAILS OF PERSON COLUMNS AND VALUES OF LOOKUP COLUMNS: https://youtu.be/dJbwDTMXt74 GET YOUR FREE COPY OF MY THREE SHAREPOINT TIPS TO SUPERCHARGE YOUR PRODUCTIVITY HERE: bit.ly/3Q921sH OTHER SHAREPOINT NEWS TUTORIALS: How To Add a News Web Part To a SharePoint Online Site: https://youtu.be/QtwiGCdw2rM How To Delete a Post in a SharePoint Online News Web Part: https://youtu.be/ZrwjhHW_17k WATCH NEXT: How To Connect a SharePoint List To Excel: youtu.be/cz9xAaUD4Cc How To Add Email Notifications To A SharePoint List: https://youtu.be/qrD1tleQepM How To Add A Calendar To A SharePoint Online Site: https://youtu.be/0dMwNZrOLN4 How To Create A Status Column In A SharePoint List: https://youtu.be/b3taSCzzEpU CHECK OUT MY HOW TO USE SHAREPOINT PLAYLIST - 40+ TUTORIALS: youtube.com/playlist?list=PLmE7KGV9-I4uibXaJ7ZqTXb…

thanks for the very well structured video. And also for your cristal clear accent. Your English is really easy to understand. Much appreciated !

Thanks so much, this tutorial had exactly what I was looking for. Good stuff

Very clear, excellent! Thank you very much.

CHECK OUT MY HOW TO USE SHAREPOINT PLAYLIST - 40+ TUTORIALS: youtube.com/playlist?list=PLmE7KGV9-I4uibXaJ7ZqTXb…

This was a life saver for me. Thank you!

This has been so helpful

Thanks 🙏

This is great but how can we actually enter data in Excel and have it updated in SharePoint and MS Lists? Really appreciate the help and will subscribe. Very clear and concise; just doesn't fit my exact use case. Thanks a bunch.

Great video.. thanks

This is a fantastic tutorial that very concisely explained what I needed and was looking for instructions on for longer than I care to admit. Thank you! Subscribing and following.

Hi,I was exactly looking for this video, thanks for video. I have a question, I don’t want this share pony info to be displayed and viewed by any other person and just want to use SharePoint master file for searching the values in another xl file

Hi Lui, Nice video and very good information. I want to ask what version of excel are you using? Enterprise? I am using business but I can't access the online services button.

How do I make some of the columns in excel not populate as "[List]," but rather the data selected in that column in SharePoint? I noticed some of your columns populated the same way. Great video! Thanks for your help.

Great video! Thank you! One question, my SP list has LOOKUP columns and when I create the connection and it pulls the data in, for any LOOKUP column, the value is [Table]. Is there a way to have that data pulled in from the other list? Will it work if I have a connection to that list created? I also have column values of [List] referenced from another list on the same site that doesn't import the values.

Thanks for sharing, what about updating the Sharepoint list from excel

Hi, great videos! I have a column where the user can select multiple options, when these feed through to power query/excel, each option creates a new row with the same data but that different column entry. E.g it’s a failure reason and they can select multiple reasons but instead of 1 list entry it shows as 5 in line with the reasons, whereas I just want all reasons separated by a comma in one cell. Can you help please?

Hello, @Lui Thank you for posting this tutorial I have a query similar to this example some of the columns show up as lists instead of names - I have Employee Name, Created By, and Modified by how to fix this please share any solutions