Contact particulars saved in an Excel Worksheet could be simply exported after which imported into Outlook. As soon as the Excel file is saved to a CSV format, you’ll be able to import it into your Outlook contacts listing.
Save Your Contacts as a CSV File
The contacts listing beneath is saved in an Excel worksheet. Guarantee your Excel spreadsheet is labeled similarly.
To export the doc as a CSV, first click on “File” to open the menu. Subsequent, choose Save As > Browse.
Specify the placement for the saved file in your laptop after which choose “CSV (Comma Delimited)” from the Save as Kind listing. Click on the “Save” button.
Shut the Excel workbook. The contacts are able to be imported into Outlook.
Import Contacts from a CSV File into Outlook
Open Outlook after which click on on “File” to open the menu. From there, choose Open & Export > Import/Export.
Choose “Import from One other Program or File” after which click on the “Subsequent” button.
Spotlight the “Comma Separated Values” possibility after which click on the “Subsequent” button.
Choose the “Browse” button to seek out the CSV file you need to import.
Select an possibility for the way you want to Outlook to deal with duplicate contact particulars and click on the “Subsequent” button.
On this instance, “Substitute Duplicates with Objects Imported” is chosen. This may replace the present contacts in Outlook with the most recent contact particulars.
Choose the vacation spot folder for the imported contacts after which click on the “Subsequent” button. The vacation spot folder will most likely be the Contacts folder, nevertheless it might be a distinct folder that may retailer contact particulars.
Make sure that the motion to import your contacts listing into Outlook is chosen.
Click on the “Map Customized Fields” button. This may allow us to appropriately match up the column headers from the Excel spreadsheet to the corresponding fields in Outlook.
Within the Map Customized Fields Window, the fields from the CSV file seem within the “From” pane on the left. Within the “To” pane on the suitable, the fields from the Contacts folder in Outlook are proven.
Any fields which have already been efficiently matched are listed underneath the “Mapped From” column on the suitable.
The Electronic mail Deal with discipline was not matched. To repair this, click on and drag the Electronic mail Deal with discipline from the left to the suitable. Doing so will map the sector. Click on the “OK” button to proceed.
A window would possibly seem to point out the import progress.
The contacts ought to now have been efficiently imported into Outlook.