Forum Discussion
List a task in Microsoft To Do using Excel
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?
- sandeeprokdeCopper Contributor
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 🙂
- jslabargeCopper Contributor
sandeeprokde GENIUS!!! Works like a charm.
- BleauhausCopper ContributorOh $#17 wow i really should have just tried copy past from the start - another lost hour of my life...
- Frosty64Copper ContributorBrilliant!!
- Richard1500Copper ContributorWorked as described..web version....copy and paste list from Excel...creates list in "to do"...
- Sofia_MelchertBrass Contributor
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!
- CjosakCopper ContributorHey, thanks for the input. Any chance you could tell me if this method can import and set reminders on the tasks with date and time of when they need to be done or it just gives a plain to do list?
Kind regards,
Miljan
- Haytham AmairahSilver Contributor
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
- Deleted
Is there any alternative that I could use to schedule tasks for my team ?
- Haytham AmairahSilver Contributor
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.
- jasneem01Copper ContributorCan you make a shortcut key to open and close calculator.