Import Excel records into an Outlook Calendar

[@EnderXeno1983]

I followed your steps exactly and it doesn't load anything into my calendar. Additionally, when i go to map it, the names of the headers are jacked up. Any advice?

[@karennaessens7941]

So you were able to do the entire import procedure? Then perhaps you did not open the calendar you imported your stuff in. About the other issue, what do you mean with jacked up?

[@Just_a_girl_in_a_new_city]

Try correcting / changing date format.. It worked for me

[@flblegh]

Is it possible to CC people using the excel table?

[@PArk-db4ij]

Hi, thank you. It’s very useful. Would you be able to advise how to set or turn on a reminder?

[@FHPHRprinter]

the map custom field isn't clickable, my calendar is setup exactly like a calander could that be the reason?

[@CoachStove]

Can i add tags to the calander events?

[@vishnuoctane-lf8ev]

Sir I want to Do the Same in.. . ics format... I have an Excel data converted to CSV also but I cant make it to convert to ics file.... To add as an internet calendar in outlook

[@AccountingHubbyDrScarpin]

You can import a csv file to your outlook.

[@manuelantoineasselin5220]

DO you know why my csv file only separates my data in '' ; '' instead of '' , ''? Because of this issue I can't proceed with the mapping in outlook.

[@AccountingHubbyDrScarpin]

You need to setup your configuration of date, time and number format.

[@karennaessens7941]

Had that too. I cannot select the appropriate csv type to save my list under in Excel. A real comma seperated file is not an option. There is only the ";" seperated type. But that's close enough. You can go open your csv file in Notepad. Don't forget to select "all files" in the opening dialogue window, otherwise you will only be able to open txt files. Then when your csv is open: select all, and replace all ";" by ",". Then register again and make sure to keep the file in a csv format. Choose "all types of documents" in the registration dialogue window, and just type ".csv" next to the name you are choosing. Now you will be able to use it properly in Outlook. If this sounds complicated, there is a seperate video on this somewhere on youtube (another person who explains how to import data in outlook and he includes this additional step).

[@karennaessens7941]

It's even the case with the right date format @@AccountingHubbyDrScarpin. Thanks a lot for this video by the way!

[@gordonjackson1567]

Won't work on New Outlook

[@Just_a_girl_in_a_new_city]

I added req. Attendees in excel but it cant be seen in the calender.. Other details are visible very well

[@istasyoninsani]

I don't why but when I choose csv file, "next" button is flu, cannot choose ;/

[@karennaessens7941]

I had the same thing. I now discovered you have to tick the box next to the file (on the left there is a box you can tick). As soon as you do that the button becomes clickable. In the video that box is already ticked by default... Perhaps Outlook changed settings on this. Now you have to tick the box manually

[@murielmoyahabo6078]

Where to put the meeting links?

[@karennaessens7941]

Perhaps make a column "location" and put the link there. Or a "comment" column. Don't know if comment is the right name (my version is in Dutch), but you can then match the fields later on in the wizard.