All the data will be in column A and the quote marks will be gone. Import contacts to Outlook. Export contacts from Outlook. Manage and organize. Import and export. Create or edit. Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback?
The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. When you export your contacts, they will typically be stored in a comma separated values file CSV. Outlook for Windows —see Export contacts from Outlook. Gmail —see Gmail help.
Mail —see Yahoo! Mail help. If you have your own contacts list you want to import, see Create your own import contacts template below. If the file doesn't have UTF-8 encoding, the import tool may not recognize and display all text correctly. In Outlook. If possible, export one contact from Outlook. Start a new row for each contact and add the information you want to each column. You don't have to have something in every column. 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.
How to do this will be different between apps and app versions. Make sure the columns have meaningful headers, though they don't need to correspond precisely to the fields used in the Outlook address book. You can manually map columns to fields during the import process. The screenshots below are for Outlook Screens in other versions of Outlook may differ slightly, but the steps are the same. Any variations for older versions will be noted.
Go to File. In Outlook , then click Open. In Outlook , click Import. Select Comma Separated Values , then click Next.
Click Browse , then locate the CSV file that contains the contacts you want to import. Choose one of the following:. Click Next. Select the Outlook folder into which you want to import the contacts. This may be your Contacts folder, or it can be a Contacts folder in any of your other folders. You can also create an Outlook folder just for imported items.
Click Map Custom Fields. Map all columns from the CSV file to the desired Outlook address book fields. Outlook automatically maps some fields; change these if they are not mapped correctly. Click OK , and then click Finish to begin the import process. You can upload your contacts CSV file to Outlook. The process is a bit different from the software versions. Open the Applications Launcher and click People. Click Browse.
0コメント