Discussion Locked

Import calendar from excel to outlook

0 helpful
12 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have information in an Excel document that I want to import into an Outlook calendar. Any idaes on how I can go about this? I am using Office XP. Here are the fields that the Excel doc have that should map to the Outlook calendar.
Excel Outlook
Name Subject
SubD Location
Walk-thruD StartDate
Walk-thruT StartTime
Lot Description
Not sure how I have to format the Excel doc.

I get a message that says to use excel to name the ranges but i treid to export a calendar into Excel and the manually enter the data and import that into outlook and it said that it completed but the calendar was blank. Thanks for your help.

12 replies

by bfilmfan

Open Outlook.
File.
Choose Import and Export.
This will open the wizard.
Follow the steps.

by sgt_shultz

i'd try it with a range named and see if that fixed it. to name a range, in excel pick Insert/Name/Define

by jmoody76

I tried naming the ranges and I get no error message when it completes but it does not populate the calendar with any info.

by rindi1

If possible, rename the fields in Excel to correspond to your outlook fieldnames. Then you should be able to import your excel file int outlook by opening "File, Import/Export, Import from other programs or files", then select "Excel" and now you should be able to select the file you want to import from. Another possibility is first to export your excel data to a text file (tab or , delimited), then again use import/Export from outlook, but this time find a menu corresponding to the file you just exported from excel. You should now be able to tell outlook which fields from your exported file correspond to which fields in outlook.

by jmoody76

I renamed the ranges the same as Outlook names them and same thing it acts like it finishes and then they don't show up in the calendar.

by kinetechs

How about working backwards. In Outlook, create a fake calendar item with all the info you want included. Now EXPORT your calendar to Excel. You now have the exact format that Outlook wants to use...a template Open your exported Calendar AND the one you want imported. Copy the information from the real file into the template file and import back into Outlook. Sometimes Outlook won't process a row if a required field is missing.

Cheers!
~Sean

by kinetechs

I just tried it in my Outlook and it worked great. Did you make sure that every field that was populated in the template was also populated in the imported file? And that the field names were exactly the same?

by rindi1

Have you made sure that you are looking at the correct folder in Outlook? You can have more that one calendars and also mailboxes etc. Maybe you have imported your data to some other place?

by jmoody76

Thanks everyone for your help. It was not going to a different folder at least not that I can find. It would not do it from Excel but it did import from a csv which you mentioned eariler.

by ross mack

Hi,

I would like to take a long list of names and birthdays from an excel sheet and "dump" them into my outlook calender. (I dont want to have to click on each contacts name and update the birthday individually) How would I do this? I am using Windows 7 and microsoft 2010.

Ross.

This discussion is closed to new replies.