Import contacts from an Excel spreadsheet to Outlook
https://support.microsoft.com:443/en-us/office/import-contacts-from-an-excel-spreadsheet-to-outlook-f6483469-0684-4c30-82c5-c881930f5451
Explore subscription benefits, browse training courses, learn how to secure your device, and more. See more , you'll see a box with the column names from the CSV file you're importing. , 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 Outlook for Microsoft 365 Outlook 2021 Outlook 2019 Outlook 2016 If you have a lot of business or personal contact information that you keep in a sp… 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 … In your workbook, click the worksheet with the contact information you want to import. If you’re importing the .csv file into an Outlook.com account (or another Excha… Import contacts into an Outlook.com account At the top of your Outlook ribbon, choose
, you'll see a box with the column names from the CSV file you're importing.
, 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
Outlook for Microsoft 365 Outlook 2021 Outlook 2019 Outlook 2016
If you have a lot of business or personal contact information that you keep in a sp…
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 …
In your workbook, click the worksheet with the contact information you want to import.
If you’re importing the .csv file into an Outlook.com account (or another Excha…
Import contacts into an Outlook.com account
At the top of your Outlook ribbon, choose
DA: 42 PA: 20 MOZ Rank: 29