scalar email

How to Export Contacts from an Excel Worksheet to Outlook

Contact information kept in an Excel Worksheet can be quickly exported and then imported right into Outlook. When the Excel data is conserved to a CSV format, you can import it right into your Outlook calls list.

Conserve Your Contacts as a CSV File

The get in touches with listed here is saved in an Excel worksheet. Guarantee your Excel spreadsheet is classified in a comparable style.

To export the paper as a CSV, first click “File” to open up the menu. Next, pick Save As > >

Browse. Specify the area for the conserved file on your computer system and afterwards pick “CSV (Comma Delimited)” from the Save as Type checklist. Click the “Save” switch.

Shut the Excel workbook. The get in touches with prepare to be imported right into Outlook.

Import Contacts from a CSV File right into Outlook

Open Outlook and after that click on “File” to open up the food selection. From there, select Open & Export > > Import/Export.

Select “Import from Another Program or File” and afterwards click the “Next” switch.

Highlight the “Comma Separated Values” option and then click the “Next” switch.

Select the “Browse” switch to locate the CSV documents you wish to import.

Pick an alternative for how you would like Outlook to take care of replicate call information and click the “Next” switch.

In this instance, “Replace Duplicates with Items Imported” is chosen. This will upgrade the existing get in touches with in Outlook with the latest get in touch with details.

Select the location folder for the imported get in touches with and after that click the “Next” switch. The destination folder will most likely be the Contacts folder, yet maybe a different folder that can save contact details.

Make certain that the activity to import your get in touches with detail into Outlook is selected.

Click the “Map Custom Fields” switch. This will certainly enable us to correctly compare the column headers from the Excel spreadsheet to the corresponding areas in Outlook.

In the Map Custom Fields Window, the areas from the CSV documents appear in the “From” pane left wing. In the “To” pane on the right, the fields from the Contacts folder in Outlook are revealed.

Any areas that have actually already been effectively matched are noted under the “Mapped From” column on the right.

The Email Address area was not matched. To repair this, click and also drag the Email Address field from the entrusted to the right. Doing so will map the area. Click the “ALRIGHT” button to continue.

A home window might appear to show the import progression.

The calls need to now have actually been efficiently imported into Outlook.

Leave a Reply

Need help with the Commons? Visit our
help page
Send us a message