Feb 22 2019 11:51 AM
Feb 22 2019 11:51 AM
Hello everyone,
I have a pre owned dealership and I am using Excel spreadsheets to manage my reconditioning process (mechanical inspections, detailing, mechanical repairs, etc.) With my team we use Microsoft To-Do to schedule the tasks and sub tasks. I like this option as everyone has their days listed on their device.
Is there a way to program a button in excel that would automatically list a task on microsoft to-do?
Feb 22 2019 12:11 PM
Hi Jimmy,
To my knowledge, there is no way to list a task in Microsoft To-Do using Excel.
Microsoft To-Do team should update the app to make it integrate with Excel by introducing a feature in it to allow the users to import Excel data and convert them into To-Do tasks.
However, there are some ideas asking for such a feature in the Microsoft To-Do UserVoice website.
This is one of them:
Ability to import simple lists from either Excel or Outlook
Regards,
Haytham
Feb 22 2019 01:58 PM
Is there any alternative that I could use to schedule tasks for my team ?
Feb 22 2019 10:31 PM
I think this app has a feature to import/export CSV files.
You can convert your Excel file to CSV file then import it to this app.
Jan 27 2021 11:44 AM
I’ve solved it! I’ve long had a frustration with the fact that MS To-do does not have the ability to import mass tasks from excel like Wunderlist did, and every attempt to search up a solution just led me to posts with the same complaint, and no solution. However, there is a way to do it – through Outlook instead. To do this, you must be signed in to Outlook on a desktop – as far as I know this will not work on the web version. On the bottom left there is a tab to navigate to the “Tasks” page – click on this. If you are signed in to the correct MS account, your To-do list should be synced to this page. Find the list you want to upload to, and make sure there is at least one filler task in their for the time being so that you have a template to work from. Then, go to file > Open and export > Import/Export > Export to a file > Comma Separated Values > select your desired folder/list > save the file. Then you can go in and open that file, and add your tasks according to the template that was downloaded. Remember to save this as a CSV! After you have edited and saved your CSV, go to file > Open and export > Import/Export > Import from another program or file > Comma Separated Values > Select your file > select your desired folder/list > **Check that the box is clicked** > import your tasks! **if the box is not clicked, click it, and it will (Likely) bring you to a page to “map custom fields”. Don’t just skip past this, if it is showing up it probably means that something about your template got a little messed up and its not quite sure what to import, and to where. Verify that every category on the right-hand “to” column has the correct column header connected to it, and if not, fix it by dragging and dropping from the left hand column. NOTE: I am not a MS expert! I just found a solution that works, and this is the sequence of events that got me there. Hopefully it works for you!
Oct 31 2021 06:18 AM - edited Oct 31 2021 06:19 AM
Hello
Follow the steps below -
1. Go to the web version of the Microsoft To do - https://todo.microsoft.com/tasks/
2. Sign in with your account - credentials
3. Create a new list (or the old one where you want to add the tasks)
4. Go To The Excel and Select the rows you want to add to the To-Do List
5. Copy the rows
6. Paste it in "Add a Task" Text box in the browser...
and Bammm you have all the list in To Do from your excel 🙂
Oct 31 2021 06:24 AM
Jan 19 2022 02:02 PM
@sandeeprokde GENIUS!!! Works like a charm.
Jun 08 2022 12:47 PM
Sep 14 2022 07:55 PM
Oct 31 2022 06:23 AM
Yes it does work but not entirely. It does import the list of tasks but not the reminders on the date and time of the task which is the information I have in the excel list. I want my team to automatically have set reminders for when they need to have a task done. So this option does work as a plain to do list, but not for mass reminders import. So I need to keep on looking 😔
Oct 31 2022 06:25 AM
Aug 13 2023 06:47 PM
Aug 24 2023 09:51 AM - edited Aug 24 2023 09:52 AM
@sandeeprokde It won't smart detect dates when paste. Any solution for that?
Mar 30 2024 10:38 AM