How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Omer Your Own Question

Omer
Omer, Information Systems Manager
Category: Computer
Satisfied Customers: 282
Experience:  MCSE Certified , Degree in CMIS Computer information Systems, 7 years of work in the IT Field
Type Your Computer Question Here...
Omer is online now
A new question is answered every 9 seconds

Is there anyway to import Calendar events into Outlook from

Resolved Question:

Is there anyway to import Calendar events into Outlook from a csv or excel file?
Submitted: 2 years ago.
Category: Computer
Expert:  Omer replied 2 years ago.

Hi I am one of the experts here on Just Answer.com

 

Can you please tell me what version of outlook you are using?

 

Can you also let me know where you exported the csv file from?

Customer: replied 2 years ago.
Using version 2010. I will create and excel or csv file in any format required by Outlook
Expert:  Omer replied 2 years ago.

Do you already have the CSV file created?

 

If not create one calendar appoint in outlook 2010 if you don't have any at the moment. Basically then what you want to do is export your outlook 2010 calendar into a csv file using the steps below. The reason you want to do this is it gives you the working template to import into 2010 without any issues you could then copy your data you want to import into the appropriate columns and go through the import data steps which are below the export to import your completed csv file.

 

Then export your calendar by

 

1. Open Outlook 2010.

2. Select the File tab and choose Options.

3. In the Options dialog box, select Advanced.

4. In the right pane, scroll down to the Export section and click Export to display the Import and Export Wizard.

5. In the wizard, select Export to a file and click Next.

6. In the Create a file of type page, select Comma separated values (Windows) and click Next.

7. In the Select folder to export from page, select the Calendar folder you want to export from and click Next.


8. In the Save exported file as page, click Browse, choose a filename and a save location and click Next.

9. Confirm that you are exporting the correct folder (check box is checked) click Finish.

10. Close the Outlook Options dialog box.

 

 

1. Open Outlook 2010.

 

2. Select the File tab and choose Options.

3. In the Options dialog box, select Advanced.

4. In the right pane, scroll down to the Export section and click Export to display the Import and Export Wizard.

5. In the wizard, select Export to a file and click Next.

6. In the Create a file of type page, select Comma separated values (Windows) and click Next.

7. In the Select folder to export from page, select the Calendar folder you want to export from and click Next.


8. In the Save exported file as page, click Browse, choose a filename and a save location and click Next.

9. Confirm that you are exporting the correct folder (check box is checked) click Finish.

10. Close the Outlook Options dialog box.

To Import

 

Lets assume that we have converted the Excel sheet to the CSV format as mentioned above, now launch Outlook 2010, and click the Office button(File menu).

 

1. Then click the Open option and choose Import.

2. In the Import and Export Wizard, choose the Import from another program or file option.

3, Click the Next button and choose the file type Comma Separated Values (Windows) and then click Next.

4. Now browse and select the CSV file.

5. Hit Next and select and choose the Destination Folder In your case it would be the calendar.

6. Finally confirm the action and hit the Finish button. Here you can change the destination as well.


Omer, Information Systems Manager
Category: Computer
Satisfied Customers: 282
Experience: MCSE Certified , Degree in CMIS Computer information Systems, 7 years of work in the IT Field
Omer and 16 other Computer Specialists are ready to help you
Expert:  Omer replied 2 years ago.

Sorry just realized I pasted in the 1st steps twice

 

Let me know if you have any questions about this

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • I am very happy with my very fast response. Eric is very knowledgeable in the subject area. Thank you! RP Austin, TX
  • Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill Bill M. Schenectady, New York
  • The Expert answered my Mac question and was patient. He answered in a thorough and timely manner, keeping the response on a level that could understand. Thank you! Frank Canada
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
 
 
 

Meet The Experts:

 
 
 
  • Andy's Avatar

    Andy

    Computer Consultant

    Satisfied Customers:

    5311
    11yr exp, Comp Engg, Internet expert, Web developer, SEO
< Last | Next >
  • http://ww2.justanswer.com/uploads/EN/Engineer1010/2012-6-9_132423_jaj12a.64x64.jpg Andy's Avatar

    Andy

    Computer Consultant

    Satisfied Customers:

    5311
    11yr exp, Comp Engg, Internet expert, Web developer, SEO
  • http://ww2.justanswer.com/uploads/BA/barrenrock/2011-10-19_215925_JamesJAFinal.64x64.jpg James's Avatar

    James

    Sr. Computer Support Expert

    Satisfied Customers:

    8376
    20 years of experience building, fixing and servicing PCs and operating systems.
  • http://ww2.justanswer.com/uploads/zeyank/2009-09-26_154244_P8110079.png Ryan H.'s Avatar

    Ryan H.

    Computer Support Specialist

    Satisfied Customers:

    1741
    A+ Certified Technician - 10 Years experience working with all types of computer systems.
  • http://ww2.justanswer.com/uploads/JA/jadedangel57/2011-11-8_193134_janenewsm.64x64.jpg Jane Lefler's Avatar

    Jane Lefler

    Sr Prog Analyst / Technician

    Satisfied Customers:

    0
    Computer Programmer / Technician/ Consultant 16+ years
  • http://ww2.justanswer.com/uploads/RO/robmpreston/2013-9-23_233814_mijiFZm.64x64.jpg RPI Solutions's Avatar

    RPI Solutions

    Support Specialist

    Satisfied Customers:

    3476
    5+ Years in IT, BS in Computer Science
  • http://ww2.justanswer.com/uploads/BA/barunrath/2012-7-5_201954_Profilepic2.64x64.jpg B. Rath's Avatar

    B. Rath

    Computer Support Specialist

    Satisfied Customers:

    8671
    Certified Computer/Networking Support Specialist.
  • http://ww2.justanswer.com/uploads/FS/fszcze/2012-6-18_181848_500test.64x64.jpg Frederick S.'s Avatar

    Frederick S.

    Computer Specialist

    Satisfied Customers:

    7240
    Computer technician and founder of a home PC repair company.