Outlook: Import a schedule from Excel into Outlook Calendar

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.

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!

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.

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

How can I indcate that the event while last the hole day? Thanks

Thank you so much. who knew a nearly decade old video is still relevant today.

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.

Thanks for sharing! I used your process and it worked great!

Thank you so much. It is so useful for my new assisgnement.

Excellent presentation. Short and sweet with very precise, accurate and pertinent information.

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

Is there a way to link a single spreadsheet of dates to multiple MS outlook accounts?

Lovely

Excellent. Thank you so much.

Thanks for very useful video

Thank you, very helpful!

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

Could you please help me and coach how to make in the table format? Thank you, Irina

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.

Thanks this is just what I needed!

Jolly good show. This will make my office work less sucky and I can concentrate on more pleasurable duties. Thank you.

2021. Still helpful. Gracias!

Explained well..thank you. Very helpful.

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.

Just trying to test this out.....if you want to make it an all day event, what do you enter?

Woah.. 7 years and your video is still very helpful.. 😊

Elegantly simple - LOVE IT!

Thank you so much! It was simple and clear.

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?

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 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?

Will this erase all my current calendar appointments/meetings?

Nice video... I also run outlook videos using Excel Vba...

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.

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.

شرح مميز ، وكنت ابحث عنه ..


شكر jasondenys@

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 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.

Is there a way to import a Meeting Invite? or add Attendees to the event? Thank you!

Thanks you very helpful

Perfect! Thank you.

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

Thanks!!

Thanks, you saved me major loads of typing ... :-D

How were you able to import with the various colors already set?

This was awesome! thank you :)

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.

gracias por el aporte!!

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?