To import contacts from a CSV file into Outlook: Select File > Import and Export from the menu in Outlook. Make sure Import from another program or file is highlighted. Now make sure Comma Separated Values (Windows) is selected. Use the Browse button, then select the desired file. Import contacts to Outlook. At the top of your Outlook 2013 or 2016 ribbon, choose File. Choose Open & Export > Import/Export. 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.
Newer versionsOffice 2010Outlook on the web
- 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 What version of Outlook do I have? 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 What version of Outlook do I have? to get to the import instructions for your version of Outlook.
- Choose Open > Import. This starts the wizard!
- 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.
Use a comma separated values file (CSV) to import your contacts into your Outlook on the web account.
Tip: For best results, make sure that the CSV file has UTF-8 encoding. This encoding works for all languages and alphabets.
Choose your version for instructions
The instructions are slightly different depending on whether you're using the new Outlook on the web. Choose which version of Outlook on the web you're using to see the steps that apply to you.
IF YOUR MAILBOX LOOKS LIKE.. | IF YOUR MAILBOX LOOKS LIKE.. DragonBallZ AF Mugen 2013 is one of the many fighting video games based on MUGEN that use the characters from Dragon Ball. What it has that the others don't is a series of Dragon Ball AF characters. Dragon Ball Super MUGEN FULL GAME by: TrafalgarLawzz Version M.U.G.E.N 1.1, Resolution 1280x720 FullScreen: Alt + Enter DOWNLOAD: https://licklink.net/jvbCjq8jW. Download Dragon Ball Mugen Games All Dragon Ball Mugen games in one place. About Dragon Ball Heroes Mugen. Popular MUGEN based fighting game made by Ristar87. Huge amount of characters and cool, fast gameplay will provide you hours of fun. Dragon ball heroes mugen download. |
---|---|
See Instructions for the new Outlook on the web. | See Instructions for classic Outlook on the web. |
Note: If your organization has included its logo in the toolbar, you might see something slightly different than shown above.
Instructions for the new Outlook on the web
- At the bottom of the page, select to go to the People page.
- On the toolbar, select Manage > Import contacts.
- Select Browse, choose your CSV file, and then select Open.
- Select Import.
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?
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?
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.
Didn't work?
See Fix problems importing contacts to Outlook.
See Also
Newer versionsOffice 2010Office 2007
If you have a lot of business or personal contact information that you keep in a spreadsheet, you can import it straight into Outlook 2013 or Outlook 2016 for Windows with just a little preparation. There are three major steps.
- Save your Excel workbook as a .csv file.
- Import your contacts.
- Map the Excel spreadsheet columns with the appropriate Outlook fields.
Step 1: Save your Excel workbook as a .csv file
Outlook can import comma separated value (.csv) files, but not workbooks with multiple sheets, so step 1 is saving your Excel workbook as a .csv file. Here’s how:
- In your workbook, click the worksheet with the contact information you want to import.
- Click File > Save As.
- Choose where to save your file.
- In the Save as type box, choose CSV (Comma delimited) (*.csv), and click Save.Excel tells you “The selected file type does not contain workbooks that contain multiple sheets.” This refers to a limitation of the CSV file; nothing will happen to your original workbook (the .xlsx file).
- Click OK.Excel tells you “Some features in your workbook might be lost if you save it as CSV (Comma delimited).” This refers only to limitations of the CSV file and can be ignored.
- Click Yes to have Excel save the current worksheet as a CSV file. The original workbook (the .xlsx file) closes.
- Close the CSV file.
You're done with Excel. Now, you can start the import process in Outlook.
Note: Some locales use different list separators by default. For example, the default separator for German is the semicolon. But Outlook doesn't support the semicolon as a field separator. So you might need to replace any semicolons in the CSV file with commas before going to the next step.
Step 2: Import your contacts to Outlook
Note: If you’re importing the .csv file into an Outlook.com account (or another Exchange ActiveSync account) in Outlook 2013, see Import contacts into an Outlook.com account.
- At the top of your Outlook ribbon, choose File.
- Choose Open & Export > Import/Export.
- Choose Import from another program or file and then click Next.Tip: If you are prompted to enter a password and you haven't set a password, click Cancel to move to the next window.
- Choose Comma Separated Values and click Next.
- Browse to the .csv file you want to import.
- Under Options, choose whether to replace duplicates (existing contacts), create duplicate contacts, or not import duplicates.
- Click Next and choose the destination folder for your contacts. Contacts should be selected by default, but if it's not, scroll up or down until you find it. You can also choose a different folder, or create a new one.
- Click Next.
- Make sure the check box next to Import 'MyContacts.csv' (assuming that's your file name) is selected.
- Don't click Finish yet, because you'll need to 'map' some of the columns in your CSV file to the contact fields in Outlook. Mapping can help the imported contacts turn out just the way you want.
Step 3: Map your CSV file columns to Outlook contact fields
- Click the Map Custom Fields button. The Map Custom Fields dialog box appears.
- Under From, you'll see a box with the column names from the CSV file you're importing.
- Under To, you'll see the standard fields that Outlook uses for contacts. If a field matches a column in the CSV file, you'll see your column under Mapped from.
- The fields Name, First Name, and Last Name are standard Outlook contact fields, so if the contact information in your file has any of those contact names, you're good to go.
- You'll probably need to do some manual mapping. For example, in this imported file, the contact's cell phone is in a column named 'Cell Ph.' It won't have an exact match in Outlook. But you can find a suitable match in Outlook by doing this:
- Scroll down in the pane on the right, and you'll find Other Address, which has a plus sign (+) next to it.
- Click the plus sign to expand what's under it, and you'll see a good match, Mobile Phone.
- In the pane on the left, drag Cell Ph and drop it on Mobile Phone in the right pane.You'll notice that Cell Ph now appears next to Mobile Phone in the Mapped from column.
- One at a time, drag the rest of the values from the left pane to the appropriate Outlook fields in the right pane. For example, you might drag Address to either Home Street or Business Street, depending on the type of address for your contacts.
- Click Finish.Your contacts are imported into Outlook.
- To view your contacts in Outlook 2016, at the bottom of the navigation bar, choose the People icon.
See also
- If you are importing into an existing Contacts folder, skip to step 3.
- To create a new folder in Outlook, right-click the Contacts folder, click New Folder, type a name for the new folder, and then click OK.
- Click the File tab in the Ribbon, and then click Open on the menu.
- Click on Import tab. The Import and Export Wizard opens.
- Select Import from another program or file, and then click Next.
- Click Comma Separated Values (Windows), and then click Next.
- If the file that is displayed is not the correct file, click Browse , browse to the folder that is mentioned in step 3, and then double-click the file to select it.
- If you are importing into a new folder, the Options settings are irrelevant because there are no duplicates. If you are not importing to a new folder, choose the most logical selection. Click Allow duplicates if you are not sure, and then click Next.
- Click the Contacts folder or another contacts-type folder that you have created, and then click Next.
- If you are not sure that the column names in the first row of the spreadsheet will map correctly to the Outlook fields, click Map custom fields to verify them.
- If you are importing into an existing Contacts folder, skip to step 3.
- To create a new folder in Outlook, click Contacts, right-click the Contacts folder, and then click New Folder, type a name for the new folder, and then click OK.
- On the File menu, click Import and Export.
- Select Import from another program or file, and then click Next.
- Click Comma Separated Values (Windows), and then click Next.
- If the file that is displayed is not the correct file, click Browse, browse to the folder noted in step 3, and then double-click the file to select it.
- If you are importing into a new folder, the Options settings is irrelevant because there are no duplicates. If not, choose the most logical selection. Click Allow duplicates if you are not sure, and then click Next.Drivers download intel. Amd Atombios may sometimes be at fault for other drivers ceasing to function These are the driver scans of 2 of our recent wiki members* *Scans were performed on computers suffering from Amd Atombios disfunctions.
- Click the Contacts folder, or other contacts-type folder that you have created, to import into, and then click Next.
- If you are not sure that the column names in the first row of the spreadsheet will map correctly to the Outlook fields, click Map custom fields to verify them.Note: If Map custom fields is unavailable, you have chosen a non-contact-type folder to import into. Click Back, and then choose the correct folder. If you are satisfied with the mapping, click OK to close the Map Custom Fields dialog box, and then click Finish.