I'm from the future where Microsoft created a tool that does this automatically but it's behind a paywall and having to learn a custom scripting language (I'm looking at you, power automate). So glad to find this OG Office trick! Sometimes simpler is better!
Question, even though I made all the steps exactly as you suggested, my appointment is not visible in Outlook. Do you have any advices what is the reason for that?
This is a great tutorial. Almost exactly what I need, but I need to do the opposite. When working in my Outlook calendar, I am able to gather all the data (subject, location, start, end and category) and put it into Excel. However, all of the appointments on my Outlook calendar are color coded by the categorize feature. How do I have the color associated with each appointment populate into Excel? I am creating a graph and need the colors from the appointments to populate into Excel. Thanks for any advice you can give me.
hi, i tried the exact same steps. but while custom maping csv file values are shown in a single line separated by semicolons. please advise how to get it right
Hello Jason, very useful video, thank you very much. I’m trying to find out how to do exactly opposite thing: I need to transfer appointments from my calendar to excel into table like shown in your video: I need table with columns: start date, start time, finish time, subject, category. When I’m trying to save CSV to excel and open file, I don’t see this table with columns mentioned above, I see just lines with text, devided by comma.
This was very helpful. Thank you. I followed your steps to a T, with no issues. However, the import didn't work. nothing showed up in my calendar. Do you have any ideas as to why it may not have worked?
Did you use the exact same column headers, and order as in the video? I've found that Google Calendar prefers different column headers and order than MS Office 365's Calendar
Question, assuming that all mapping is perfect, any way to have data automatically be imported with one click? maybe VBA Script or some sort of MSI or EXE file?
How do you set up an Excel spreadsheet, with data that changes, to sync/import into Outlook calendar? Cannot find on Training in Microsoft tutorials. Thank you.
Hi there, in the part "Map custom fields" I don't get the list as shown in the video only all the columns headlines in one row like : "Start date;Start time;End Time;Subject" Could you please help me why is that? Thanks, P.
Seems to be a regional setting issue. In my region, the standard separator used in Excel is ";" Whereas in the US and most other regions, the standard separator is ",". Outlook expects it to be ",", hence it's not able to interpret the .csv file. Excel has a method for changing the separator to a different character, however I still didn't manage to get it to work. Solution: Once saved as shown in the above tutorial, open your .csv file in notepad, and do a search and replace on all your separators, changing it to a ",". In my case from a ";" to "," and then save the file. Now it's possible for outlook to interpret it.
Hi, good video! thanks men. I'm triying to fill the categories between my document and the outlook but only apears one categorie to fill whit the outlook and it's like: start time; finish time; start hour (see that the categories apear separated whit a semicolon) Do you know how I could separate the categories?
Thank you, the system is working properly. I have another question; since i want these events to be shared with my workteam, I set up the calendars as shared, but the reminders aren't firing up as expected, they only appear to me (the creator of the calendar). Do you have any advice on how to manage this? I want everyone to see the reminders. Thank you.
I've done exactly what Jason shows in his video, however when i go to import the data and the map custom fields shows up, the date and name for the date are in one line, making it impossible to clearly map what is the date and what is its name. Any tipps?
Excelent. Now, is there a way I can get and email when new appointments are added to my Calendar? I have reports that I don´t modify but contain meeting dates that I need. However, often times it is a large report and I don´t want to waste time looking through it, just be notified and the appointment created in an automated way. I know with VBA I can create the email. I wonder if there is a way to do all at once.
hello, I tried ur method and it worked with my 2007 excel, but I have a question , how do u activate the reminders for each appointment?? I saw on the customizing map something related to the reminder , but don't know what to put on my excel from columns to activate it, also I have used the 98-2007 format not CSV to keep the data linked to the original excel :) it worked and I can see the appointments on my calendar but with no reminders
In my excel download it’s like that: just one column, many lines, each line contain: “date start, date finish, start time, start finish, subject, Description, category “ - just lines with this text divided by comma. I need the same but in separate columns. Could please kindly help how to do it? Thank you very much, Irina
also, if needed, how do you reverse this? delete all the data you just imported. i understand this is a test calendar and one can easily delete the calendar. what if it were in a real calendar? is there a way to reverse an import somehow? thanks
I followed the exact instructions with the same column names. When I started the import, it just hung my Outlook. It said it would take a few minutes but after 20minutes I had to reboot
gail mindy singer From memory I had already used those category names in my calendar and had assigned colours to them. If you click on any appointment and then go to calendar tools--> categorize--> all categories it gives you the option to name your categories. Make sure that they are the same as in your spreadsheet and you're set
Tom Phan no it won't. If you're worried create a new calendar with a couple of fake events in Outlook and try importing to there. They should happily coexist.
Does anyone know how to import Excel into a shared calendar? My research found that it is not possible but there is supposed to be workaround that I can't figure out.
I only get the option: Import events from an .ICS file to your existing calender There is no option to choose from an CSV file (although) there is a csv file on my desk.
This is so frustrating. The video looks simple, but in my case I can't map the fields. Everytime I save my excel file to CSV comma separated, I have ";" and not "," so I cannot map. I have looked for a solution, but still cannot find it. :(
88colleen88 If you are using Outlook 2013 it won't work with IMAP accounts. The workaround is to make an empty calendar in a Pop3 account. Import the CSV schedule there and drag this data to your main calendar.
Is it possible to edit the dates once you've imported your calendar? i.e. update the excel sheet with the same subjects with different dates and then import into outlook, with it replacing the old ones.
I was surprised at how difficult it was to find a simple explanation of this process. Very clear and concise instructions. Good on ya m8!
I'm from the future where Microsoft created a tool that does this automatically but it's behind a paywall and having to learn a custom scripting language (I'm looking at you, power automate). So glad to find this OG Office trick! Sometimes simpler is better!
Excellent presentation. Short and sweet with very precise, accurate and pertinent information.
Jolly good show. This will make my office work less sucky and I can concentrate on more pleasurable duties. Thank you.
Thank you so much. who knew a nearly decade old video is still relevant today.
Question, even though I made all the steps exactly as you suggested, my appointment is not visible in Outlook. Do you have any advices what is the reason for that?
This is a great tutorial. Almost exactly what I need, but I need to do the opposite. When working in my Outlook calendar, I am able to gather all the data (subject, location, start, end and category) and put it into Excel. However, all of the appointments on my Outlook calendar are color coded by the categorize feature. How do I have the color associated with each appointment populate into Excel? I am creating a graph and need the colors from the appointments to populate into Excel. Thanks for any advice you can give me.
Thanks for sharing! I used your process and it worked great!
Woah.. 7 years and your video is still very helpful.. 😊
I still find this so relevant thank you
hi, i tried the exact same steps. but while custom maping csv file values are shown in a single line separated by semicolons. please advise how to get it right
Holy shit in the bucket, that is so gonnae save me a lot of time, thank you!!!!!
Hello Jason, very useful video, thank you very much. I’m trying to find out how to do exactly opposite thing: I need to transfer appointments from my calendar to excel into table like shown in your video: I need table with columns: start date, start time, finish time, subject, category. When I’m trying to save CSV to excel and open file, I don’t see this table with columns mentioned above, I see just lines with text, devided by comma.
Open the file from window explorer, instead of launching excel and then opening. Hope this makes sense
@@deniseglezer-jones9721
Thank you! I’ve already found solution.
@@ИринаПотапова-ч2ж can you please share how that's possible
This was very helpful. Thank you.
I followed your steps to a T, with no issues. However, the import didn't work. nothing showed up in my calendar. Do you have any ideas as to why it may not have worked?
Did you use the exact same column headers, and order as in the video? I've found that Google Calendar prefers different column headers and order than MS Office 365's Calendar
Question, assuming that all mapping is perfect, any way to have data automatically be imported with one click? maybe VBA Script or some sort of MSI or EXE file?
Russell Sabella Hi Russell, have you found an answer for your question? I'm looking the same
Jura1704 No, I have not. Do you know?
Good Q Russell. This was my reason to look into this post. Any news?
Thank you so much. It is so useful for my new assisgnement.
How do you set up an Excel spreadsheet, with data that changes, to sync/import into Outlook calendar? Cannot find on Training in Microsoft tutorials. Thank you.
Did you ever find an answer?
How do I set the reminders? For example, if I want all of the dates to have 1 week reminders. Thanks in advance for your help!
Hi there,
in the part "Map custom fields" I don't get the list as shown in the video only all the columns headlines in one row like : "Start date;Start time;End Time;Subject"
Could you please help me why is that?
Thanks,
P.
I have the same problem, can somebody help us? :)
me too
same
Seems to be a regional setting issue. In my region, the standard separator used in Excel is ";"
Whereas in the US and most other regions, the standard separator is ",". Outlook expects it to be ",", hence it's not able to interpret the .csv file.
Excel has a method for changing the separator to a different character, however I still didn't manage to get it to work.
Solution: Once saved as shown in the above tutorial, open your .csv file in notepad, and do a search and replace on all your separators, changing it to a ",". In my case from a ";" to "," and then save the file. Now it's possible for outlook to interpret it.
@@Pixisvin GENIOOOOOOO
Just trying to test this out.....if you want to make it an all day event, what do you enter?
Explained well..thank you. Very helpful.
Is there a way to import a Meeting Invite? or add Attendees to the event? Thank you!
Thanks this is just what I needed!
Hi, good video! thanks men. I'm triying to fill the categories between my document and the outlook but only apears one categorie to fill whit the outlook and it's like: start time; finish time; start hour (see that the categories apear separated whit a
semicolon) Do you know how I could separate the categories?
Open the csv with notepad or similar and replace all semicolons with a comma.
Thank you, the system is working properly. I have another question; since i want these events to be shared with my workteam, I set up the calendars as shared, but the reminders aren't firing up as expected, they only appear to me (the creator of the calendar). Do you have any advice on how to manage this? I want everyone to see the reminders. Thank you.
Hello, did you found the Solution for that?? Y have the same problem :-(
@@aleciramcotero7293 unfortunately no, but I haven’t tried since. Maybe in the future they’ll fix this issue.
@@nutbastet5595 i hope that. Thanks for answer 🙂
I've done exactly what Jason shows in his video, however when i go to import the data and the map custom fields shows up, the date and name for the date are in one line, making it impossible to clearly map what is the date and what is its name. Any tipps?
Excelent. Now, is there a way I can get and email when new appointments are added to my Calendar? I have reports that I don´t modify but contain meeting dates that I need. However, often times it is a large report and I don´t want to waste time looking through it, just be notified and the appointment created in an automated way. I know with VBA I can create the email. I wonder if there is a way to do all at once.
Can we add reminders as well?
Is there a way to link a single spreadsheet of dates to multiple MS outlook accounts?
Is it possible to import attachments as well? For example, all appointments in schedule imported in CSV format should have the same attachment.
Elegantly simple - LOVE IT!
InstaBlaster
Thank you. I missed the define name step in the past and my categories wouldn't show up but not they do. Love the accent!
hello, I tried ur method and it worked with my 2007 excel, but I have a question , how do u activate the reminders for each appointment?? I saw on the customizing map something related to the reminder , but don't know what to put on my excel from columns to activate it, also I have used the 98-2007 format not CSV to keep the data linked to the original excel :) it worked and I can see the appointments on my calendar but with no reminders
In my excel download it’s like that: just one column, many lines, each line contain: “date start, date finish, start time, start finish, subject, Description, category “ - just lines with this text divided by comma. I need the same but in separate columns. Could please kindly help how to do it? Thank you very much, Irina
this was very helpful. thank you. can you address how to add a yearly recurring field and an all day event? i tried a couple of things unsuccessfully.
also, if needed, how do you reverse this? delete all the data you just imported. i understand this is a test calendar and one can easily delete the calendar. what if it were in a real calendar? is there a way to reverse an import somehow? thanks
To delete all the events you imported, delete the new calendar you created to. So in the example here, delete the "Test" calendar.
I followed the exact instructions with the same column names. When I started the import, it just hung my Outlook. It said it would take a few minutes but after 20minutes I had to reboot
I followed the steps and for about a second the green color for file transfer appears, however no files transfer. I have attempted this several times.
How were you able to import with the various colors already set?
gail mindy singer From memory I had already used those category names in my calendar and had assigned colours to them. If you click on any appointment and then go to calendar tools--> categorize--> all categories it gives you the option to name your categories. Make sure that they are the same as in your spreadsheet and you're set
Thanks, you saved me major loads of typing ... :-D
Thank you, very helpful!
How can I indcate that the event while last the hole day? Thanks
Thanks for very useful video
Will this erase all my current calendar appointments/meetings?
Tom Phan no it won't. If you're worried create a new calendar with a couple of fake events in Outlook and try importing to there. They should happily coexist.
Could you please help me and coach how to make in the table format? Thank you, Irina
Excellent. Thank you so much.
It seems not working on Outlook 2010. "Microsoft Excel" is not on the list after selecting " import from another program or file".
Does anyone know how to import Excel into a shared calendar? My research found that it is not possible but there is supposed to be workaround that I can't figure out.
2021. Still helpful. Gracias!
Thank you so much! It was simple and clear.
I only get the option: Import events from an .ICS file to your existing calender
There is no option to choose from an CSV file (although) there is a csv file on my desk.
This is so frustrating. The video looks simple, but in my case I can't map the fields. Everytime I save my excel file to CSV comma separated, I have ";" and not "," so I cannot map. I have looked for a solution, but still cannot find it. :(
Nice video... I also run outlook videos using Excel Vba...
How to extract "other calendars" schedules from outlook to excel
Just tried to do this-All went well until my Outlook crashed. I think this is too savvy for my poor computer! Very good tutorial though!
error message popped out ''could not complete the operation because the service provider does not support it'' when i try to import it
88colleen88 If you are using Outlook 2013 it won't work with IMAP accounts. The workaround is to make an empty calendar in a Pop3 account. Import the CSV schedule there and drag this data to your main calendar.
This was awesome! thank you :)
thanks guy, you da man
Perfect! Thank you.
3:00 define name
Thanks you very helpful
gracias por el aporte!!
Thanks!!
Lovely
te cuento que no puedo... no me separa las opciones
Lo mismo me pasa a mí en estos momentos ¿Lograste saber cómo?
Is it possible to edit the dates once you've imported your calendar? i.e. update the excel sheet with the same subjects with different dates and then import into outlook, with it replacing the old ones.