Import and export Outlook email, contacts, and calendarĪdd your other email accounts to Outlook. Related TopicsĬreate, view, and edit contacts and contact lists in Įxport contacts from to a CSV file If you're having trouble importing contacts to your account, see Fix problems importing contacts to. Enter a name for your file, and select CSV UTF-8 (Comma delimited) (*.csv) as your file type.
How to import contacts into outlook from brighthouse windows#
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.Ĭheck that characters are displayed correctly in Excel. Browse to your exported CSV file (you may have to select to display Text Files (.csv) to see it). In Excel, create a new blank document (workbook).įrom the Data menu, select From Text/CSV. How to convert your CSV file to UTF-8 using Microsoft Excel 2016: How to do this will be different between apps and app versions. If you can't export your contacts using UTF-8 directly, you can convert the exported CSV file using Excel or third-party apps. Therefore, you should save the contacts file with UTF-8 encoding if you have that option during export. 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. If you’re importing Gmail contacts into an account (or another Exchange ActiveSync account) in Outlook 2016 or 2013, see Import contacts into an account.Typically, you can import contacts without worrying about the underlying details of how the text is stored in the CSV file. Step 8: On the next window, select 'Import from. Step 7: Click on Open & Export > Import/Export. Step 6: Open the Outlook program, and click on the File tab from the top ribbon section. Step 5: Choose 'Yes' to save your current worksheet as a CSV file from XSLX format. In step 5, when prompted out to handle duplicates, be sure to choose Replace duplicates with items imported. Step 4: A dialog box will explain file compatibility details. Repeat the steps to import your contacts.csv file to Outlook. If you choose No, the file will get messed up and you'll need to start over again by exporting the list from Gmail. When you save the CSV file, Excel will prompt you a few times with "are you sure you want to save it in CSV format?" Always choose Yes. Outlook requires the column headings in the first row so don’t replace them with something else. You can edit the CSV file using Excel to add names and other missing information. Repeat the steps to import your contacts.csv file to Outlook.Ĭontacts are missing info: After you import your contacts, if you open Outlook and see that not all the info was imported, open the CSV file with Excel to see if the information was there. If you choose No, the file will get messed up and you'll need to start over with a new contacts.csv file. When you close the file, Excel will prompt you a few times with "are you sure you want to save it in CSV format?" Always choose Yes. Be sure to choose to export All contacts, or the right group of contacts.Īfter you export your contacts, use Excel to open the CSV file and check that there's data. In that case:Įxport your contacts from Google again. If there isn't any information in the CSV file, the export from Google didn't work. Use Excel to open the CSV file you exported from Google.Ĭheck whether there is any information in the CSV file. : Open Applications Launcher > People > Manage > Import contacts > Browse. Select the CSV file and follow the on-screen steps. Then choose Import from another program or file > Comma Separated Values. Locate the csv file you exported from Google. Desktop: Go to File > Open & Export > Import/Export to open the Import/Export Wizard. No contacts appear in Outlook: If you complete the import process but no contacts appear in Outlook, do the following: csv files, and then import each newly created CSV file. Use a program such as Excel to open the CSV file, separate your list of contacts into smaller. You get an error message: If you try to import more than 2000 contacts at a time, you'll see an error message. You'll see your list of contacts in the Address Book.įixing issues with importing Gmail contacts In Outlook, select Address Book, choose the name of your mailbox, and choose Contacts.