List a task in Microsoft To Do using Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-355524%22%20slang%3D%22en-US%22%3EList%20a%20task%20in%20Microsoft%20To%20Do%20using%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355524%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20pre%20owned%20dealership%20and%20I%20am%20using%20Excel%20spreadsheets%20to%20manage%20my%20reconditioning%20process%20(mechanical%20inspections%2C%20detailing%2C%20mechanical%20repairs%2C%20etc.)%20With%20my%20team%20we%20use%20Microsoft%20To-Do%20to%20schedule%20the%20tasks%20and%20sub%20tasks.%20I%20like%20this%20option%20as%20everyone%20has%20their%20days%20listed%20on%20their%20device.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20there%20a%20way%20to%20program%20a%20button%20in%20excel%20that%20would%20automatically%20list%20a%20task%20on%20microsoft%20to-do%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-355524%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355685%22%20slang%3D%22en-US%22%3ERe%3A%20List%20a%20task%20in%20Microsoft%20To%20Do%20using%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355685%22%20slang%3D%22en-US%22%3E%3CP%3EI%20think%20this%20%3CA%20href%3D%22https%3A%2F%2Ftodoist.com%2Fdownloads%2Fwindows%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Eapp%3C%2FA%3E%20has%20a%20feature%20to%20%3CA%20href%3D%22https%3A%2F%2Fget.todoist.help%2Fhc%2Fen-us%2Farticles%2F208821185-Importing-Exporting-Project-Templates%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Eimport%2Fexport%20CSV%20files%3C%2FA%3E.%3C%2FP%3E%3CP%3EYou%20can%20convert%20your%20Excel%20file%20to%20CSV%20file%20then%20import%20it%20to%20this%20app.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355586%22%20slang%3D%22en-US%22%3ERe%3A%20List%20a%20task%20in%20Microsoft%20To%20Do%20using%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355586%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20any%20alternative%20that%20I%20could%20use%20to%20schedule%20tasks%20for%20my%20team%20%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355537%22%20slang%3D%22en-US%22%3ERe%3A%20List%20a%20task%20in%20Microsoft%20To%20Do%20using%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355537%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Jimmy%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20my%20knowledge%2C%20there%20is%20no%20way%20to%20list%20a%20task%20in%20Microsoft%20To-Do%20using%20Excel.%3C%2FP%3E%3CP%3EMicrosoft%20To-Do%20team%20should%20update%20the%20app%20to%20make%20it%20integrate%20with%20Excel%20by%20introducing%20a%20feature%20in%20it%20to%20allow%20the%20users%20to%20import%20Excel%20data%20and%20convert%20them%20into%20To-Do%20tasks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20there%20are%20some%20ideas%20asking%20for%20such%20a%20feature%20in%20the%20Microsoft%20To-Do%20UserVoice%20website.%3C%2FP%3E%3CP%3EThis%20is%20one%20of%20them%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftodo.uservoice.com%2Fforums%2F597175-feature-suggestions%2Fsuggestions%2F35340487-allow-import-excel-and-outlook%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAbility%20to%20import%20simple%20lists%20from%20either%20Excel%20or%20Outlook%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EHaytham%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2103337%22%20slang%3D%22en-US%22%3ERe%3A%20List%20a%20task%20in%20Microsoft%20To%20Do%20using%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2103337%22%20slang%3D%22en-US%22%3E%3CP%3EI%E2%80%99ve%20solved%20it!%20I%E2%80%99ve%20long%20had%20a%20frustration%20with%20the%20fact%20that%20MS%20To-do%20does%20not%20have%20the%20ability%20to%20import%20mass%20tasks%20from%20excel%20like%20Wunderlist%20did%2C%20and%20every%20attempt%20to%20search%20up%20a%20solution%20just%20led%20me%20to%20posts%20with%20the%20same%20complaint%2C%20and%20no%20solution.%20However%2C%20there%20is%20a%20way%20to%20do%20it%20%E2%80%93%20through%20Outlook%20instead.%20To%20do%20this%2C%20you%20must%20be%20signed%20in%20to%20Outlook%20on%20a%20desktop%20%E2%80%93%20as%20far%20as%20I%20know%20this%20will%20not%20work%20on%20the%20web%20version.%20On%20the%20bottom%20left%20there%20is%20a%20tab%20to%20navigate%20to%20the%20%E2%80%9CTasks%E2%80%9D%20page%20%E2%80%93%20click%20on%20this.%20If%20you%20are%20signed%20in%20to%20the%20correct%20MS%20account%2C%20your%20To-do%20list%20should%20be%20synced%20to%20this%20page.%20Find%20the%20list%20you%20want%20to%20upload%20to%2C%20and%20make%20sure%20there%20is%20at%20least%20one%20filler%20task%20in%20their%20for%20the%20time%20being%20so%20that%20you%20have%20a%20template%20to%20work%20from.%20Then%2C%20go%20to%20file%20%26gt%3B%20Open%20and%20export%20%26gt%3B%20Import%2FExport%20%26gt%3B%20Export%20to%20a%20file%20%26gt%3B%20Comma%20Separated%20Values%20%26gt%3B%20select%20your%20desired%20folder%2Flist%20%26gt%3B%20save%20the%20file.%20Then%20you%20can%20go%20in%20and%20open%20that%20file%2C%20and%20add%20your%20tasks%20according%20to%20the%20template%20that%20was%20downloaded.%20Remember%20to%20save%20this%20as%20a%20CSV!%20After%20you%20have%20edited%20and%20saved%20your%20CSV%2C%20go%20to%20file%20%26gt%3B%20Open%20and%20export%20%26gt%3B%20Import%2FExport%20%26gt%3B%20Import%20from%20another%20program%20or%20file%20%26gt%3B%20Comma%20Separated%20Values%20%26gt%3B%20Select%20your%20file%20%26gt%3B%20select%20your%20desired%20folder%2Flist%20%26gt%3B%20**Check%20that%20the%20box%20is%20clicked**%20%26gt%3B%20import%20your%20tasks!%20**if%20the%20box%20is%20not%20clicked%2C%20click%20it%2C%20and%20it%20will%20(Likely)%20bring%20you%20to%20a%20page%20to%20%E2%80%9Cmap%20custom%20fields%E2%80%9D.%20Don%E2%80%99t%20just%20skip%20past%20this%2C%20if%20it%20is%20showing%20up%20it%20probably%20means%20that%20something%20about%20your%20template%20got%20a%20little%20messed%20up%20and%20its%20not%20quite%20sure%20what%20to%20import%2C%20and%20to%20where.%20Verify%20that%20every%20category%20on%20the%20right-hand%20%E2%80%9Cto%E2%80%9D%20column%20has%20the%20correct%20column%20header%20connected%20to%20it%2C%20and%20if%20not%2C%20fix%20it%20by%20dragging%20and%20dropping%20from%20the%20left%20hand%20column.%20NOTE%3A%20I%20am%20not%20a%20MS%20expert!%20I%20just%20found%20a%20solution%20that%20works%2C%20and%20this%20is%20the%20sequence%20of%20events%20that%20got%20me%20there.%20Hopefully%20it%20works%20for%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

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? 

4 Replies

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

Is there any alternative that I could use to schedule tasks for my team ? 

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.

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!