akpsir.blogg.se

How to export office 365 contacts to excel
How to export office 365 contacts to excel












(In Outlook 2007, you can also use Edit-> Copy)

  • Press CTRL+C to copy your selected Contacts.
  • (In Outlook 2007, you can also use Edit-> Select All)
  • Press CTRL+A to select al your contacts.
  • Press OK until all the open screens are closed.
  • You can choose between even more fields by selecting “All Contact fields” from the “Select available columns from” dropdown list. View-> Current View-> Customize Current View…-> button Fields… View-> click on the 3 dots on the right (…)-> Add Columns View-> group: Arrangement-> button Add Columns
  • Insert and arrange the columns you want to export to Excel.
  • Change your view to a table view like the “Phone List” view.
  • You can still achieve the same by exporting to the csv-format but that can be even more cumbersome.įortunately there is another, more graphical (WYSIWYG), way to do this as well via the copy/paste method.

    how to export office 365 contacts to excel

    The export to Excel option has been removed from Outlook 2013 mainly because it was still using the old xls-format instead of the new xlsx-format.

    how to export office 365 contacts to excel

    Although the Import and Export wizard allows you to export to an Excel spreadsheet, the Wizard doesn’t allow you to export all the fields and filtering the mapped fields is a cumbersome process as well.














    How to export office 365 contacts to excel