Many users have contact data stored in Excel workbooks or created calendar events in Excel to take advantage of formulas and fill features when creating a large number of events. It's very easy to move the data to Outlook.
As with any database, you will need to name the columns your data is in. You can either use whatever name you want and map it to Outlook fields or export to Excel format and delete the data from the workbook and enter your data. You'll also 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 CSV format. This is the easiest way for most users to import an Excel worksheet trouble-free and we recommend using CSV format when possible.
- Save the workbook as Comma Separated Values (CSV).
- Close Excel.
If you have data in cells that you are not going to import, create a named range:
- Select your used data range and type a name in the field to the left of the address bar. (Include the field names in your selection.)
- 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. If you export to Excel to get the field names, you'll see two named ranges when you import. Just make sure you select the correct named range.
- If you aren't using the field names that Outlook uses, you'll need to map your fields to Outlook's fields.
- Press Next when ready and finish the import.
Tips:
- You cannot import custom fields in Outlook. You need to use a macro or a third party utility to add custom field data. (You can copy and paste from a list view to get custom fields into a spreadsheet. See The No-Export way to use Outlook data in Excel for details.)
- Outlook 2013 and up can only save as a CSV file.
- Outlook 2007 uses the Excel 97-2003 *.xls format, not the Excel 2007 *.xlsx file format
- You can import calendar data into any calendar folder in any *.pst or your mailbox.
- You cannot import into a public folder calendar or secondary Exchange mailbox. To import into either, create a calendar folder for the import and move the appointments after the import.
- Use these same steps with Contacts, choosing a Contacts folder (obviously)
- If you drop a field on the wrong Outlook field, drop it again on the correct field and Outlook will remove it from the other field.
Video Tutorial
[wpvideo jfNJo8nI w=600]
Hello, would you like to help me to solve the issue I have in the moment of mapping the columns of a source CSV file onto the columns of the target Outlook map. In fact, in the left pane, instead of displaying multiple column names one below another, Outlook importer displays just one string with all names of my columns separated by ; You can see it on the attached image. The CSV file that I'm trying to import, is also attached hereto - I've simplified as I could.
I'm using Outlook desktop v2008 build 13127.20910.
Thank you for your assistance.
Best wishes in 2021 !
Kind regards,
Vladimir
hello. I'm not sure if someone already asked this question but when I try to import my contacts from excel to outlook 2013 I get stumped at the final step. When I get to the mapping of the fields my values column is on one fixed line not in a column as I see you illustrate. Do I have to create the excel file in another way? It seems it is not separating each column. Thank you!
Hello Diane,
My case might be a little too peculiar, and I will briefly describe what I want to do.
I want to add JUST Notes to my existing contacts, i.e. last checked date, a secondary web site, etc. uploading them from an CSV file.
Mapping fields and everything else it is just fine, However, when Importing the file and picking either "Allow duplicates, Replace Duplicates or Do Not Import Duplicates" I pick the option shown in your video indeed, it duplicate the items, it does NOT update them.
I know it would be best if I download them, edit them in excel, save as CSV and upload the file. However Outlook 2013 has this annoying bug, that even when I select the option "File As" First Name, Last Name" still uploads the info as "Last Name, First Name". Aside of not being able to remove the irritating parenthesis and hyphens from the phone number field
do you think.. there is any help for me?
thank you very much in advance.
A macro would be your best option I think (but it might be slow), or do the export/import method and a macro to fix the file as.
If you don't have many to edit, you can enable in-cell editing and edit the contacts within the contacts pane, rather than opening each contact.
Hi Diane
I am trying this in 2013 - using a csv file. I notice that when I preview the entries it is not picking up the fields correctly. It is appending letters from my Subject column to the end of all other fields like start time and end time, location etc.
Any ideas what could be causing this?
Thanks
This is in field mapping? It's a bug. The fields should import correctly.
CSV was not working for me & I succeeded by using "Text (tab delimited)"
hope this thread is still monitored!
I have been successfully importing events lists from excel 97-2003 into outlook with no problem until this morning when i suddenly started getting an error message saying that the field name didnt exist. I couldn't find a way to get around this so i coped the excel sheet into a CSV sheet and it works from there. However, i can't continue to use this as CSV doesn't allow you to change the width of the fields or format the text so is unreadable without going along and manually widening the columns every time i open the file.
Anyone know why i got an error message?
Also when i tested a new excel 97-2003 sheet and imported lists from there, the import went fine but the event did not appear on the calendar.
very confused!
You can open CSV in Excel and change the field widths. :) I'm guessing there is a problem with the named range in the spreadsheet and outlook needs named ranges to import. Or the field mapping needs fixed - that is the last field of the import wizard.
Works perfectly in 2010. (used the 97-2003 xls format for import)
I realise that this is an older post but hoping someone who can answer my question, reads this. I am doing exactly what the instructions above describe, using both an "xls" and "csv" format. In both cases, however, when I get to the "Map Custom Fields" step in Outlook (2007), the OK button is disabled and nothing I do reactivates it. Then, when I finish the import process, nothing imports. Am I missing a step or is there somethign I can do to activate the OK button in the MAP Custom Fields step... Any help would be appreciated. Thanks.
I'm having the same issue as Linda - no responses from experts? I'm using Excel and Outlook 2010 and trying to get Outlook Calendar to import events from Excel. Using all possible combintations of file types from Excel, when I try to import I can get to the map custom fields (and BTW, I'm using filed names in Excel that match Outlook Calendar field names), the OK function is not activated. Backing up a screen and making sure the box to the left of the import file is checked, if I click anywhere else in the box with the list, the map fields option disappears, but finish is active. Clicking finish, it appears to be importing, but nothing shows up on the calendar.
What type of email account are you importing into? For best results and easiest import, use a CSV file.
Do you have both start & end dates and time fields set and mapped?
I am using Microsoft Outlook 2010 and the file does not come to my calendar. I follow the steps exactly, the last thing I see is a window with two folders and data flying in between, but nothing shows up in my calendar. What is preventing it from showing? Anybody can help, please? Thank you.
Same here - nor could I get Google calendar sync to work.
What software are you using for google sync?
Did you choose Default Map at the end of the import wizard?