How can I export my Outlook contacts to Excel?

Question

Open Outlook. Click Contacts on the left-hand menu. In the "Current View" window, click the List option. Select the contacts you want to copy. . Copy the selected contacts (CTRL+C). Paste the contacts into an Excel spreadsheet (CTRL+V). Save the file as XLS or CSV format.

How do I Export my Outlook contacts?

Try it!1Select File.2Select Open & Export > Import/Export.3Select Export to a file > Next.4Select Comma Separated Values > Next.5Under the email account you want to export contacts from, select Contacts.6Select Browse... and go to where you want to save your . ... 7Type in a file name and then select OK.8Select Finish.

How do I merge Outlook contacts into Excel?

Open Outlook, then open your Address Book/Contacts folder (click the people icon at the bottom of the left panel). From the Contacts screen, click File > Open & Export > Import/Export. In the Import and Export Wizard dialog window, choose Export to a File, then click Next.

How do I Export a contact list to Excel?

Export from newer Google Contacts1Step 1: Select the “More” option: Along the left hand side of the page in Google Contacts, look for a “More” menu item. ... 2Step 2: Select the “Export” option. Click on the “Export” link on the left side menu.3Step 3: Select the file format. ... 4Step 4: Export.

How do I Export my Outlook contacts to a CSV File?

Outlook1Open. Microsoft® Outlook, then click. ... 2Select Export to a file then click. Next. .3Select Comma Separated Values (Windows) then click. Next. .4In the folder list, select the. Contacts. folder then click. ... 5Browse to the target folder to save . csv file.6Enter a name for the exported file then click. OK. .7Click. Next. Finish.

Expert · Answer