Categories: Computer Support

Learnings of how to import a calendar from Excel to Outlook from computer support specialist?

Have you stored contact data in Excel workbooks or created calendar events in Excel to take advantage of formulas and fill features when creating a large number of events? You might be wondering how to import a calendar from Excel to Outlook. Well, it’s quite straightforward to move the data to Outlook.

  • Name the columns your data is in; you can use whatever name you want.
  • Map it to Outlook fields.
  • Or export to Excel format.
  • Delete the data from the workbook.
  • Enter your data.
  • You will need to name the used range of cells in Excel.

Save Excel Worksheet

If you are importing all of the data in the worksheet, save the workbook in Comma Separated Values (CSV) format. This is the easiest way to import an Excel worksheet trouble-free. And it’s recommended using CSV format when possible. Do you have data in cells that you are not going to import?

  • Create a named range.
  • Select your used data range.
  • Type a name.
  • Include the field names in your selection and press Enter.
  • Save the workbook as an Excel 97-2003 workbook.
  • Close Excel.

Import into Outlook

  • Go to File, Import and Export.
  • Select Import from a file.
  • Choose Microsoft Excel as the source.
  • Browse to the workbook file.
  • Select the Calendar (or Contact) folder.
  • Select the named range.

Do you export to Excel to get the field names? You will see two named ranges when you import. Just ensure to select the correct named range. If you are not using the field names that Outlook uses, you will need to map your fields to Outlook’s fields. Press Next when ready and finish the import.

Tips

Only Outlook 2013 and up can save as a CSV file. Outlook 2007 uses the *.xls format instead of the *.xlsx file format. Import calendar data into a calendar folder in *.pst or your mailbox. You can’t import into a public folder calendar or secondary Exchange mailbox. To import, create a calendar folder and move the appointments after the import. Use the same steps with Contacts, choosing a Contacts folder. Did you drop a field on the wrong Outlook field? Do it again on the correct field and Outlook will remove it from the other field.

You need not worry if you are not able to import a calendar from excel to outlook. You can get computer services from QuickTech. Our expert computer technician will provide computer support and computer help.

For further enquiries and queries on PC support, you can reach us at 1300 016 017.

QuickTech

Recent Posts

Why do you need to invest in computer repairs?

Are you facing issues with slower runtime or wireless internet service? These are issues that…

4 days ago

Are PC battery life estimates right? Get PC repair

Over time, a PC battery's life span shortens, and its capability to hold a charge…

4 days ago

Computer support guide to Windows 10 Pro keys

Using keyboard shortcuts is a quick way to navigate and operate the Windows 10 features.…

1 week ago

Role of small business IT support in a natural disaster

Natural disasters can strike your small business at any time. Unfortunately, not all small businesses…

1 week ago

4 easy troubleshooting tips for common computer problems

Do you panic when something goes wrong with your computer? Are you wondering how to…

1 week ago

Which Computer Is Better for Your Needs – Mac or PC?

Mac vs. PC is the Coke vs. Pepsi of the tech world. Keep reading to…

2 weeks ago