Menu
Nov 8, 2018 - Manually Export Contacts out of Microsoft Outlook to Import into Constant Contact. Manually exporting a file of contacts from Outlook 2013 or 2016 results in a CSV file with all of your contacts and lots of. Working on a Mac? Import contacts from other apps into Contacts on Mac. You can import contacts from other computers or apps as files in a variety of file types—for example, vCard (with the extension.vcf), archive (.abbu), LDAP Data Interchange Format (.ldif), or a tab-delimited or comma-separated value (.csv) text file.
It doesn't sound like your csv file is formatted correctly. It should be something like this: firstname,lastname,homeEmailAddress,workEmailAddress,homePhone,workPhone,street,city,state,zipcode John,Doe,[email protected],[email protected],+0,+5,100 Maple Dr.,Somewhere,OutThere,12345 Each row in the csv is an individual contact record. Each record has fields for the parts of the address information. If you don't have a header record, add one. It makes it easier. Also, make sure each row has the same number of fields, even if they are empty. You will only have to match the fields once, and it will import each record the same way.
I also created a CSV file on my Windows computer (having used Windows Mail), which I sent to my new Mac. I imported all 1900+ contacts, and it left me with 1900+ blank fields in Outlook for Mac (only 3 email addresses were shown). How is it possible that the formatting of a CSV file in Mail for Windows, is not recognized by Outlook for Mac. Is there another solution to import a Windows based CSV file correctly into Outlook? (there are no other formatting edits possible when exporting the address book from Windows Mail to a CSV file). It's slightly scandalous how bad the Apple Contacts app is.
The test below were done in Yosemite. Maybe it's better in later OS updates but I doubt it. Most of the time I have lists of either name and email or just email addresses. Here's what you want for a list of just email addresses. In a text editor format your emails as shown below. You need a CR at the end of each line. Note that the mail tags in the text below are just some Apple forum stupidity I can't get rid of, just ignore them.
Search for blank spaces and delete them. Save as 'Names.csv' or something similar,email,sandy@ foo.edu,. Open Contacts. Contacts - Import and find your csv file Tick the 'ignore first line' box After import succeeds, create a new Group name in Contacts Click Last Import in Contacts Drag your new cards from Last Import to the group you just made Names and email would be setup as below. You can leave name slots blank but don't forget the commas Search for spaces in your text editor and delete them. Firstname,lastname,email, sandy,lake,sandy@ foo.edu, bill,miller, john,smith.
Apple Footer. This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site.
All postings and use of the content on this site are subject to the.
. At the top of your Outlook 2013 or 2016 ribbon, choose File. If your ribbon doesn't have a File option in the top left corner, you're not using Outlook 2016 or 2013.
See to get to the import instructions for your version of Outlook. Choose Open & Export Import/Export. This starts the wizard!.
Choose Import from another program or file, and then choose Next. Choose Comma Separated Values, and then choose Next. In the Import a File box, browse to your contacts file, and then double-click to select it. Choose one of the following to specify how you want Outlook to handle duplicate contacts:. Replace duplicates with items imported If a contact is already in Outlook and your contacts file, Outlook discards the info it has for that contact and uses the info from your contacts file. You should choose this option if the contact info in your contacts file is more complete or more current than the contact info in Outlook. Allow duplicates to be created If a contact is in Outlook and your contacts file, Outlook creates duplicate contacts, one with the original Outlook info and one with the info imported from your contacts file.
You can combine info for those people later to eliminate duplicate contacts. This is the default option.
Do not import duplicate items If a contact is in Outlook and your contacts file, Outlook keeps the info it has for that contact and discards the info from your contacts file. You should choose this option if the contact info in Outlook is more complete or more current than the info in your contacts file. Click Next. In the Select a destination folder box, scroll to the top if needed and select the Contacts folder Next. If you have multiple email accounts, choose the Contacts folder that's under the email account you want to be associated with the contacts. Choose Finish. Outlook begins importing your contacts immediately.
You'll know it's finished when the Import Progress box closes. To see your contacts, at the bottom of Outlook, choose the People icon.
At the top of your Outlook ribbon, choose the File tab. If your ribbon doesn't have a File option in the top left corner, you're not using Outlook 2010. See to get to the import instructions for your version of Outlook. Choose Open Import. This starts the wizard!.
![Import Csv Contacts Into Outlook For Mac Import Csv Contacts Into Outlook For Mac](/uploads/1/2/4/2/124218733/674709221.png)
In the Import and Export Wizard, click Import from another program or file, and the click Next. To import a CSV file, choose Comma Separated Values (Windows). Choose Browse, then choose the.csv file you want to import, and choose Next. Notes:. Under Options, if you want the imported information to replace duplicate items already in Outlook, choose that. Otherwise, choose Do not import duplicates. Set the options for importing items.
Choose Filter if you want to only import certain emails. Choose the More Choices tab if you want to only import emails that are read or unread. The default settings usually don’t need to be changed. The top folder — usually Personal Folders, Outlook Data File, or your email address — is selected automatically.
Include subfolders is selected by default. All folders under the folder selected will be imported.
The default selection of Import items into the same folder in matches the folders from the imported file to the folders in Outlook. If a folder doesn’t exist in Outlook, it will be created. Choose Finish. Outlook starts importing your data immediately. You'll know it's finished when the progress box closes.
To view your contacts, at the bottom of the Outlook navigation bar, choose Contacts. Note: If the file doesn't have UTF-8 encoding, the import tool may not recognize and display all text correctly. The import tool will then show you some example contacts from your file, and you can check that the text is readable and correct. If the text is not displayed correctly, select Cancel. You will need a file in UTF-8 encoding to continue. Convert your CSV file to use UTF-8 encoding, and restart the import. To learn more about UTF-8 encoding, see Instructions for classic Outlook on the web.
At the bottom of the page, select to go the People page. On the toolbar, select Manage Import contacts. Choose any of the email services listed.
It doesn't matter which service you choose, as you'll import your contacts from a CSV file in the next step. Select Browse, choose your CSV file, and then select Open. Select Upload. Note: If the file doesn't have UTF-8 encoding, the import tool may not recognize and display all text correctly. The import tool will then show you some example contacts from your file, and you can check that the text is readable and correct. If the text is not displayed correctly, select Cancel.
You will need a file in UTF-8 encoding to continue. Convert your CSV file to use UTF-8 encoding, and restart the import.
To learn more about UTF-8 encoding, see Why should I care about UTF-8 encoding? Typically, you can import contacts without worrying about the underlying details of how the text is stored in the CSV file. However, if the contact information includes characters not found in the English alphabet, such as Greek, Cyrillic, Arabic, or Japanese characters, this can cause problems when importing contacts. Therefore, you should save the contacts file with UTF-8 encoding if you have that option during export. If you can't export your contacts using UTF-8 directly, you can convert the exported CSV file using Excel or third-party apps.
How to do this will be different between apps and app versions. How to convert your CSV file to UTF-8 using Microsoft Excel 2016:. In Excel, create a new blank document (workbook).
From the Data menu, select From Text/CSV. Browse to your exported CSV file (you may have to select to display Text Files (.csv) to see it).
Select Import. In the dialog box that appears, under File Origin, choose the encoding that makes the characters in the text appear correctly, for example, Cyrillic Windows 1251, and then select Load. Check that characters are displayed correctly in Excel. Select File Save As. Enter a name for your file, and select CSV UTF-8 (Comma delimited) (.csv) as your file type. Select Save.