In your workbook, click the worksheet with the contact information you want to import. Outlook can import comma separated value (.csv) files, but not workbooks with multiple sheets, so step 1 is saving your Excel workbook as a. Map the Excel spreadsheet columns with the appropriate Outlook fields.
If you have a lot of business or personal contact information that you keep in a spreadsheet, you can import it straight into Outlook 2013 or Outlook 2016 for Windows with just a little preparation.
