Friday 22 November 2019

How to Export Contacts from an Excel Worksheet to Outlook

Excel Logo

Contact details stored in an Excel Worksheet can be easily exported and then imported into Outlook. Once the Excel file is saved to a CSV format, you can import it into your Outlook contacts list.

Save Your Contacts as a CSV File

The contacts list below is stored in an Excel worksheet. Ensure your Excel spreadsheet is labeled in a similar fashion.

Contacts list in Excel

To export the document as a CSV, first click “File” to open the menu. Next, select Save As > Browse.

Save as as different file type in Excel

Specify the location for the saved file on your computer and then select “CSV (Comma Delimited)” from the Save as Type list. Click the “Save” button.

Save as a CSV file type

Close the Excel workbook. The contacts are ready to be imported into Outlook.

Import Contacts from a CSV File into Outlook

Read the remaining 26 paragraphs



from How-To Geek https://ift.tt/2XzZpZe

No comments:

Post a Comment