My Excel 2007 workbook cannot be used as an import source


When you attempt to import information from a Microsoft Office Excel 2007 worksheet, Microsoft Office Outlook 2007 fails to recognize the file.


By default, Office Excel 2007 uses a new file format that has file extensions of .xlsx, .xlsm, or .xlsb. Office Outlook 2007 does not support opening files in these file formats.


Office Outlook 2007 supports the previous Excel file format, which uses the file extension .xls. You can save your Office Excel 2007 worksheet in the file format used by previous releases of Excel and then import data from that file into Outlook.

Save an Excel workbook in the Excel 97-2003 Workbook (*.xls) format

Important: If you save a workbook in a file format other than a Microsoft Office Excel 2007 file format, formatting and features unique to Excel 2007 will not be retained. For more information, see Formatting and features that are not transferred in Excel file format conversions.

  1. Open the workbook that you want to import into Office Outlook 2007.

  2. Click the Microsoft Office Button Office button image , and then point to the arrow next to Save As.

  3. In the File name box, type a new name for the workbook.

    Tip: You can also accept the suggested name.

  4. In the Save as type list, click Excel 97-2003 Workbook (*.xls).

  5. Click Save.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.