Microsoft KB Archive/212174

= How to save files in other formats in Excel 2000 =

Article ID: 212174

Article Last Modified on 3/30/2005

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q212174





For a Microsoft Excel 97 version of this article, see 166173.



For a Microsoft Excel 2002 version of this article, see 291064.



The Microsoft Office 2003 version of this article is available from Office Online. To see Office Online, visit the following Microsoft Web site:

http://office.microsoft.com/en-us/assistance/HP052001571033.aspx

IN THIS TASK
SUMMARY
 * Save a File in a Different Format
 * What File Formats Are Available?
 * Set a Different Default File Format
 * See This Information in Excel Help



SUMMARY
This article explains how to save Excel 2000 files in different formats and provides additional information to consider when you save files.

back to the top

Save a File in a Different Format
By default, Excel saves files in the Microsoft Excel Workbook format. Files that were saved in this format cannot be opened in versions of Excel earlier than Microsoft Excel 97, or in other spreadsheet programs.

NOTE: Excel 97 can open workbooks that were saved in Excel 2000; however, any features that are exclusive to Excel 2000 may not function or be available in Excel 97.

If you want to save a file in a different format, follow these steps:
 * 1) Open the workbook that you want to save in a different format.
 * 2) On the File menu, click Save As.
 * 3) In the Save as type list, click the file format that you want to use.
 * 4) If you want, change the name of the file, and then click Save.

NOTE: If the file format does not support multiple sheets or plies, you may receive the following warning message:

The selected file type does not support workbooks that contain multiple sheets.

If the file format does not support multiple sheets, make sure that you save the other sheets in your workbook before you close it. Otherwise, some of your work may be lost. The easiest way to save your whole workbook is to save it in the Microsoft Excel Workbook format.

back to the top

What File Formats Are Available?
You can save files in any of the following formats:   Format                                     Extension    Notes -  Microsoft Excel Workbook                   .xls         1 Web Page                                  .htm, .html  2 Template                                  .xlt         2 Formatted Text (Space delimited)          .prn         3 Text (Tab delimited)                      .txt         3 Unicode Text                              .txt         3 Microsoft Excel 5.0/95 Workbook           .xls         4 Microsoft Excel 97-2000 & 5.0/95 Workbook .xls         5 CSV (Comma delimited)                     .csv         3 Microsoft Excel 4.0 Worksheet             .xls         3 Microsoft Excel 3.0 Worksheet             .xls         3 Microsoft Excel 2.1 Worksheet             .xls         3 Microsoft Excel 4.0 Workbook              .xlw         6 WK4 (1-2-3)                               .wk4         7 WK3,FM3 (1-2-3)                           .wk3, .fm3   7 WK3 (1-2-3)                               .wk3         7 WK1,FMT (1-2-3)                           .wk1, .fmt   8 WK1,ALL (1-2-3)                           .wk1, .all   8 WK1 (1-2-3)                               .wk1         8 WKS (1-2-3)                               .wks         8 WQ1 (Quattro Pro/DOS)                     .wq1         8 DBF 4 (dBASE IV)                          .dbf         8 DBF 3 (dBASE III)                         .dbf         8 DBF 2 (dBASE II)                          .dbf         8 Text (Macintosh)                          .txt         9 Text (MS-DOS)                             .txt         9 CSV (Macintosh)                           .csv         9 CSV (MS-DOS)                              .csv         9 DIF (Data Interchange Format)             .dif         3 SYLK (Symbolic Link)                      .slk         3 Microsoft Excel Add-In                    .xla         10 Microsoft Excel Workspace                 .xlw         11 Microsoft Excel 4.0 Chart                 .xlc         12 Microsoft Excel 3.0 Chart                 .xlc         12 Microsoft Excel 2.1 Chart                 .xlc         12 Microsoft Excel 4.0 Macro                 .xlm         13 Microsoft Excel 4.0 Int'l Macro           .xlm         13 Microsoft Excel 3.0 Macro                 .xlm         13 Microsoft Excel 2.1 Macro                 .xlm         13

Set a Different Default File Format
The default file format is Microsoft Excel Workbook, but you can change it. To set a different default file format, follow these steps:
 * 1) On the Tools menu, click Options.
 * 2) Click the Transition tab.
 * 3) In the Save Excel files as list, click the default file format that you want.
 * 4) Click OK.

When you save a file by using the Save As command, the new default file format will be selected. Note that you can override this new default by selecting another file format in the Save as type list.

back to the top

See This Information in Excel Help
To see the information in this article in Excel Help, follow these steps:  On the standard toolbar, click Office Assistant. Type How can I save a file in a different format? , and then press ENTER.

In the help balloon that appears, there are a number of topics:  Click File format converters supplied with Microsoft Excel to read about the different file formats that are included with Excel. Click Change the default file format for saving workbooks to read about how to change the default file format.</ul>

You can also click the other topics to see additional information about how to open and save files in different formats.</li></ol>

back to the top

Additional query words: XL2000

Keywords: kbhowtomaster kbformat kbconversion kbsavefile KB212174

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.