importing, transforming and exporting csv files

NikolinoDE

Platinum Contributor

Feb 08, 2021

juan jimenez

Export contact data

You can export your address book to Excel as follows:

Open the Contacts module.

In Outlook select the command File → Import / Export. In Outlook, go to File → Open → Import.

Select Export to File and click Next.

Select Microsoft Excel as the file type and click Next.

Select Contacts and click Next.

Specify where and under what name the Excel file should be saved and click Next.

Click Map Fields. Check whether the fields from Outlook are correctly mapped to the fields in the Excel table. The assignments usually match. If not, simply drag one of the fields from the left window into the corresponding field in the right window. When you are finished, close the dialog with OK.

Click on Finish to generate the Excel file.

Edit data with Excel

Open the contact information file in Excel. Typical inconsistencies, assignment errors and different spellings can be quickly identified in the table.

Once you are done editing, save the Excel file and close it.

Import contacts again

Export the changed Excel file

Call the command File → Import / Export in Outlook or File → Open → Import.

Select Import from other programs or files and click Next.

Select Microsoft Excel as the file type and click Next.

Select the Excel file. Under Options, select Replace duplicates with imported items.

Then click on Next.

Select Contacts as the destination folder and then click Next.

Click Finish to import the data.

I would be happy to know if I could help.

Nikolino