To save your data extract file as an Excel spreadsheet…
- From within Microsoft Excel 2003, click File -> Save As from the Excel menu bar. The Save As dialog box appears.
- From within Microsoft Excel 2007, click on the Windows icon in the top left-hand corner of Excel, click Save As. The Save As dialog box opens.
: During the save process, make sure the file type is an Excel file (.xls) and not a Text file (.txt). This ensures that your data extract file is saved in an Excel-format table, which is easy to use for manipulating data.
: Your data extract is given a default file name, which you can change at this point – to make it easier to find later on. Also, you can choose in which directory you wish to save the file