This is the BEST video! I wish I found it earlier in my day instead of wasting so much time trying to figure it out on my own. This was extremely helpful. Thank you so much!
@steve_smith
2 жыл бұрын
I've been looking for how to import dates without scrambling them and this totorial had the answer! Thank you Russell!
@RussellSmith
Жыл бұрын
Glad it was useful!
@pcworldonlinetelevision
5 ай бұрын
Thanks, it’s simple and easy to understand in very short period of time. Please accept my heart felted gratitude for your great public service.
@HilaryGo555
4 ай бұрын
Thank you so much for advising on importing dates. So useful!
@anechiwaa
9 ай бұрын
This saved me a ton of time shifting from an Excel spreadsheet and MS Lists! Thank you so much!!
@anitawhittaker9308
2 жыл бұрын
Brilliant video straight to the point, no bulking up of things we dont need to know. Plus it actually works
@RussellSmith
2 жыл бұрын
Thanks Anita!
@SavageGothamChess
3 жыл бұрын
The best part of your videos is the quality. The lighting is so cool. Specially that back drop. Hopefully you do a video on it on the future. 😊
@RussellSmith
3 жыл бұрын
Thanks Hovindu! Maybe I will if enough people are interested.
@Dazza6840
2 жыл бұрын
Excellent clear step, by step instruction. My only criticism is that I found the "punch" sound effect quite annoying and distracting.
@RussellSmith
2 жыл бұрын
Glad it was useful! Sorry about the effects, I know they were too loud.
@shirleya4510
2 жыл бұрын
This was very helpful and more informative than other KZitem tutorials. Thank you 🙏🏽
@RussellSmith
2 жыл бұрын
You're so welcome!
@Atrain204
Жыл бұрын
Great video! Curious to how you handled importing the CHOICE column values though. After uploading the spreadsheet, CHOICE field values don't appear under "Column settings", but are still selectable when creating new records. It doesn't make sense and makes me hesitant to use this approach for larger spreadsheets.
@AkramKhan.HR4U
3 жыл бұрын
Your videos are fabulous.. I highly recommend your videos to my colleagues
@RussellSmith
3 жыл бұрын
Thanks Akram! I really appreciate your support 😊
@AkramKhan.HR4U
3 жыл бұрын
@@RussellSmith hi Russel, if i want to grant access to only a certain columns to someone to fill information in a Microsoft List, how can I do that?
@niamhmoloney6021
Жыл бұрын
Cheers Russell, this was exactly the information I needed
@RussellSmith
Жыл бұрын
Glad it was helpful.
@nannyedias_
3 жыл бұрын
Thank you very much for such an useful and practical video! From now on, I´m following your tips, from Brasil! Blessings!
@RussellSmith
3 жыл бұрын
Thank you! I’m glad it was useful 😊
@partnersps
2 жыл бұрын
Very practical and useful presentation.! Thank you Russell!
@RussellSmith
2 жыл бұрын
Thanks Andreas!
@guychet2k8
11 ай бұрын
Very simple et helpful video, great thanks !
@DanielBradley-do9xu
3 ай бұрын
Thanks for the video! It is a great reference for creating a new list from data. Is there a way to import data to a currently existing list however? Thanks!
@marcdoliveira4906
6 ай бұрын
Outstanding. Well done. Thank you.
@pati8063
4 ай бұрын
Great video, thanks a lot! Is it also possible to import multiple Excel sheets (tables) at the same time into MS Lists? How can I do this?
@zhenliu4779
6 ай бұрын
You saved my day!! Thank you
@BBB-fe9up
Жыл бұрын
Great tips! Thank you!!
@gloriasandii
Жыл бұрын
this video is so good. thanks russell!
@RussellSmith
Жыл бұрын
Thanks Gloria!
@JL_Klean
2 жыл бұрын
Hi Russell, how would you format the names if there are multiple names coming over from the excel list to the Microsoft Lists into one field?
@goncaloribeiro1131
3 жыл бұрын
Fantastic video! Very helpful!
@RussellSmith
3 жыл бұрын
Thanks Gonçalo!
@jorgecastano2209
4 ай бұрын
Thanks , very useful
@DigiRN
Жыл бұрын
Just what i needed
@hvolt6378
Жыл бұрын
it is a useful video, thank you
@ElalacranHf
7 ай бұрын
Even after I select all the data types and see previews of my data, I will create a list and it only imports the headers?
@MAK-5891
9 ай бұрын
how to add reminder in same lists?
@Nighlune
3 ай бұрын
Is there no easy way to select a whole column for copy/paste? Sure, clicking and dragging works great when there's not a lot of rows but what about lists with 1000+ records?
@garyrowe58
24 күн бұрын
Is there any way to get european format dates?
@vanvuite7332
8 ай бұрын
How would you import into an existing List ?
@ganeshvlogs2104
3 ай бұрын
Hi.. I have some queries about Microsoft list...mostly 7-9nos.. But in last few days I am not able to resolve it. How can I connect with you for guidance?
@josecarlosnunez8782
9 ай бұрын
Is there a way of importing excel data massively (more tan 5000 rows)
@a1t0rmenta
5 ай бұрын
Awesome. Thanks.
@THANHPHAN-dw7ke
2 жыл бұрын
thank you.it helps
@DeepakKapoor-bk6sy
Жыл бұрын
How to add new rows from Excel to a pre-created Microsoft List? Also can we merge two Lists?
@ddp2049
Жыл бұрын
Hello I’m trying to use an if formula in Microsoft lists. It. It working. Will you be able to help thank.
@jayenriquez4550
Жыл бұрын
What happen if the you update something on the excel file? Are the data on micrsoft list will update too?
@RussellSmith
Жыл бұрын
No, it won't.
@user-il9zc2us1w
Жыл бұрын
Do you know how to get URL links to import correctly?
@jitendratrivedi7889
3 жыл бұрын
Very helpful
@RussellSmith
3 жыл бұрын
Thanks!
@RussellSmith
3 жыл бұрын
Thanks for watching the video! If you found the video useful and want to help Argo and his Kibble company, please consider a like and subscribe 😉🐶 And here are the timestamps if you want to skip straight to the instructions! 00:00 Intro 00:28 Import list data from Excel to Microsoft Lists
@gloriasandii
Жыл бұрын
do ms lists and power bi!
@schrottwichtel6789
2 жыл бұрын
How does lists recognize or transfer the names of the reps into active directory names?
@RussellSmith
2 жыл бұрын
There's a field called 'Person' which allows you to select names directly from Azure AD.
@bencraker
2 жыл бұрын
Is there a way to set one of the imported columns as the ID?
@RussellSmith
2 жыл бұрын
The first column is always the ID and it should be a unique value.
@TP-om8of
2 жыл бұрын
Thanks for the ideas on the workaround ideas. One additional problem is that I’ve got an Excel sheet with 500+ rows, and Lists only shows 100 rows at a time. So I have to cut and paste from Excel 5 or 6 times. Or I could waste my time trying to learn the obtuse logic of Power Automate, which MS pretends is a low-code/no-code solution. It’s ridiculous that Lists can’t recognise Excel dates. They’re both MA products, but they couldn’t manage or bother to link them up. I’m exploring Lists but I fail to see how it’s better than Excel. You can format Excel sheets extensively to make them easy to read; Lists is much less flexible. If you use the desktop app rather than clunky MS 365 online, you can create all sorts of custom userforms with VBA. In Lists, you can’t. Honestly, MS really sucks-bloated, clunky, overpriced. I don’t understand why more business don’t just switch to Linux. Is it because they feel the need to pay Billl Gates’s alimony?
@RussellSmith
2 жыл бұрын
Lists isn't perfect for sure. And I agree that Power Automate isn't easy to understand. But then neither is VBA. Recently, Lists seems to be recognizing dates from Excel with no problems at all. Lists isn't supposed to be a replacement for Excel. It's a work management and tracking solution. Excel is for number crunching primarily. Lists lets users create useful views and formatting with almost zero effort. For example, you can automatically create a calendar view. I don't believe that's possible in Excel. Similarly, you can create a gallery view in Lists that would take a lot of work to create in Excel. And you can share views with other users and input data easily using a form. It's just a different beast targeted at solving a particular problem in a simple and easy way. The new offline sync PWA functionality in Lists should make it much less clunky and perform more like a native desktop app. Although I've yet to see it appear or work in my M365 tenant. At the end of the day, pick the right tool for the job. If Lists isn't working for you, then maybe Excel is a better solution. And it also depends who is going to be using it.
@TP-om8of
2 жыл бұрын
@@RussellSmith Lists still can’t handle dates from Excel. Really, the problem is MS doesn’t make a decent tool for this purpose. Businesses remain wedded to Windows and MS 365 because it doesn’t occur to them that they can get better for cheaper. MS rolls out these half baked products and is having a laugh at our expense.
@garyrowe58
24 күн бұрын
Today I tried creating my first list in MS365. It imported the dates as dates, but decided to change them all by 1 day. How novel of it.
@davepope6456
2 жыл бұрын
Hi Russell, Great video, but I'm wondering if there is a way in which you can update the data in the excel file and automatically update the list, rather than have to re-import? Any help you can gice is much appreciated
@RussellSmith
2 жыл бұрын
Thanks Dave! You can probably do it although I've never tried. I'd look at Microsoft's Power Platform, specifically Power Automate to do that. At least it's a place to start investigating.
@ddp2049
Жыл бұрын
Enjoy your video
@RussellSmith
Жыл бұрын
Thanks!
@razakiswalehe3951
2 жыл бұрын
Can i create list with multiple lists in it like multiple sheets in a singe excel spreadsheet?
@RussellSmith
2 жыл бұрын
No. But it is possible to integrate data from different lists in a limited way. But that's probably not what you are looking for.
@jallabalaram1997
Жыл бұрын
internal names comes like field_1
@kevinperez7555
2 жыл бұрын
Hey Russel, have you had any lag issues with MS lists? I attempted to create a couple of lists where I work, but in many cases the items added to the list would disappear or the changes made to the item would never happen. Maybe it’s just our work VPN acting up as I have great internet, but I guess I just wanted to reach out and see if other people have experienced the same.
@RussellSmith
2 жыл бұрын
Hi Kevin. No, I haven't experienced that problem.
@USHCCTV
2 жыл бұрын
I cannot select cells anymore
@RussellSmith
2 жыл бұрын
I'd try clearing your browser cache and reloading Lists.
Пікірлер: 76