Save a Workbook in another File Format

 

Save a Workbook in another File Format

When you save an Excel 2013 Workbook, by default it saves in the .xlsx format. Excel 2013 supports saving in other formats, but whenever you save a workbook in another file format, some of its formatting, data, and features might not be saved.

File Formats (File Types) that are supported in Excel 2013 −

• Excel File Formats
• Text File Formats
• Other File Formats

Excel File Formats

Format	Extension	Description
Excel Workbook	.xlsx	The default XML-based file format for Excel 2007-2013. Cannot store Microsoft Visual Basic for Applications (VBA) macro code or Microsoft Office Excel 4.0 macro sheets (.xlm).
Strict Open XML Spreadsheet	.xlsx	An ISO strict version of the Excel Workbook file format (.xlsx).
Excel Workbook (code)	.xlsm	The XML-based and macro-enabled file format for Excel 2007-2013. Stores VBA macro code or Excel 4.0 macro sheets (.xlm)
Excel Binary Workbook	.xlsb	The binary file format (BIFF12) for Excel 2007-2013.
Template	.xltx	The default file format for an Excel template for Excel 2007-2013. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm).
Template (code)	.xltm	The macro-enabled file format for an Excel template in Excel 2007-2013. Stores VBA macro code or Excel 4.0 macro sheets (.xlm).
Excel 97- Excel 2003 Workbook	.xls	The Excel 97 - Excel 2003 Binary file format (BIFF8).
Excel 97- Excel 2003 Template	.xlt	The Excel 97 - Excel 2003 Binary file format (BIFF8) for an Excel template
Microsoft Excel 5.0/95 Workbook	.xls	The Excel 5.0/95 Binary file format (BIFF5).
XML Spreadsheet 2003	.xml	XML Spreadsheet 2003 file format (XMLSS).
XML Data	.xml	XML Data format.
Excel Add-In	.xlam	The XML-based and macro-enabled Add-In format for Excel 2007-2013. An Add-In is a supplemental program that is designed to run additional code. Supports the use of VBA projects and Excel 4.0 macro sheets (.xlm).
Excel 97-2003 Add-In	.xla	The Excel 97-2003 Add-In, a supplemental program that is designed to run additional code. Supports the use of VBA projects.
Excel 4.0 Workbook	.xlw	An Excel 4.0 file format that saves only worksheets, chart sheets, and macro sheets. You can open a workbook in this file format in Excel 2013, but you cannot save an Excel file to this file format.

Text File Formats

If you save a workbook in any text format, all formatting is lost.

Format	Extension	Description
Formatted Text (Spacedelimited)	.prn	Lotus space-delimited format. Saves only the active sheet.
Text (Tabdelimited)	.txt	Saves a workbook as a tab-delimited text file for use on another Microsoft Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.
Text (Macintosh)	.txt	Saves a workbook as a tab-delimited text file for use on the Macintosh operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.
Text (MS-DOS)	.txt	Saves a workbook as a tab-delimited text file for use on the MS-DOS operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.
Unicode Text	.txt	Saves a workbook as Unicode text, a character encoding standard that was developed by the Unicode Consortium.
CSV (comma delimited)	.csv	Saves a workbook as a comma-delimited text file for use on another Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.
CSV (Macintosh)	.csv	Saves a workbook as a comma-delimited text file for use on the Macintosh operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.
CSV (MS-DOS)	.csv	Saves a workbook as a comma-delimited text file for use on the MS-DOS operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.
DIF	.dif	Data Interchange Format. Saves only the active sheet.
SYLK	.slk	Symbolic Link Format. Saves only the active sheet.

Other File Formats

Format	Extension	Description
DBF 3, DBF 4	.dbf	dBase III and IV. You can open these files formats in Excel, but you cannot save an Excel file to dBase format.
OpenDocument Spreadsheet	.ods	OpenDocument Spreadsheet. You can save Excel 2010 files so they can be opened in spreadsheet applications that use the OpenDocument Spreadsheet format, such as Google Docs and OpenOffice.org Calc. You can also open spreadsheets in the .ods format in Excel 2010. Formatting might be lost when saving and opening .ods files.
PDF	.pdf	Portable Document Format (PDF). This file format preserves document formatting and enables file sharing. When the PDF format file is viewed online or printed, it retains the format that you intended. Data in the file cannot be easily changed. The PDF format is also useful for documents that will be reproduced by using commercial printing methods.
XPS Document	.xps	XML Paper Specification (XPS). This file format preserves document formatting and enables file sharing. When the XPS file is viewed online or printed, it retains exactly the format that you intended, and the data in the file cannot be easily changed.

Step 1 − Select the File menu.

Step 2 − Click on the option Save As. You get a choice of places to save the Workbook, both on local devices (e.g. Computer) and internet (e.g. OneDrive).

Step 3 − Click on Computer.

The Save As Dialog box opens.

Step 4 − Click on Save As type. The file formats will be listed.

The file formats displayed depend on the type of active Worksheet in your Workbook (Data Worksheet, Chart Worksheet, or other type of Worksheet).

Step 5 − Click on the File Format you want.

File Formats that Use the Clipboard

You can use the Clipboard to copy data to the clipboard in few File Formats, which you can paste into Excel using the command Paste or Paste Special.

Format	Extension	Clipboard Type Identifiers
Picture	.wmf or .emf	Pictures in Windows Metafile Format (WMF) or Windows Enhanced Metafile Format (EMF). NOTE − If you copy a Windows metafile picture from another program, Excel pastes the picture as an enhanced metafile.
Bitmap	.bmp	Pictures stored in Bitmap format (BMP).
Microsoft Excel file formats	.xls	Binary file formats for Excel versions 5.0/95 (BIFF5), Excel 97-2003 (BIFF8), and Excel 2013 (BIFF12).
SYLK	.slk	Symbolic Link Format.
DIF	.dif	Data Interchange Format.
Text (tabdelimited)	.txt	Tab-separated text format.
CSV (Commadelimited)	.csv	Comma-separated values format.
Formatted text (Space-delimited)	.rtf	Rich Text Format (RTF). Only from Excel.
Embedded object	.gif, .jpg, .doc, .xls, or .bmp	Microsoft Excel objects, objects from properly registered programs that support OLE 2.0 (OwnerLink), and Picture or another presentation format.
Linked object	.gif, .jpg, .doc, .xls, or .bmp	OwnerLink, ObjectLink, Link, Picture, or other format.
Office drawing object	.emf	Office drawing object format or Picture (Windows enhanced metafile format, EMF).
Text	.txt	Display Text, OEM Text.
Single File Web Page	.mht, .mhtml	Single File Web Page (MHT or MHTML). This file format integrates inline graphics, applets, linked documents, and other supporting items referenced in the document.
Web Page	.htm, .html	Hypertext Markup Language (HTML). NOTE − When you copy text from another program, Excel pastes the text in HTML format, regardless of the format of the original text.

File Formats not Supported in Excel 2013

Excel 2013 does not support the following File Formats anymore and you cannot open or save files in these File Formats.

Format	Extension	Clipboard Type Identifiers
Excel Chart	.xlc	Excel 2.0, 3.0, and 2.x file formats
WK1, FMT, WK2, WK3, FM3, WK4	.wk1, .wk2, .wk3, .wk4, .wks	Lotus 1-2-3 file formats (all versions)
Microsoft Works	.wks	Microsoft Works file format (all versions)
DBF 2	.dbf	DBASE II file format
WQ1	.wq1	Quattro Pro for MS-DOS file format
WB1, WB3	.wb1, .wb3	Quattro Pro 5.0 and 7.0 for Windows.

If you have to work with your Workbook data in a program that is not supported anymore, try the following −

• Search the web for a company that makes File Format Converters for File Formats that are not supported by Excel 2013.

• Save your Workbook to another File Format that can be opened in the other program. For example, save to an XML spreadsheet or text File Format that the other program might support as well.

Change in Charts Group

 

Change in Charts Group

The Charts Group on the Ribbon in MS Excel 2013 looks as follows −

You can observe that −

• The subgroups are clubbed together.

• A new option ‘Recommended Charts’ is added.

Let us create a chart. Follow the steps given below.

Step 1 − Select the data for which you want to create a chart.

Step 2 − Click on the Insert Column Chart icon as shown below.

When you click on the Insert Column chart, types of 2-D Column Charts, and 3-D Column Charts are displayed. You can also see the option of More Column Charts.

Step 3 − If you are sure of which chart you have to use, you can choose a Chart and proceed.

If you find that the one you pick is not working well for your data, the new Recommended Charts command on the Insert tab helps you to create a chart quickly that is just right for your data.

Chart Recommendations

Let us see the options available under this heading. (use another word for heading)

Step 1 − Select the Data from the worksheet.

Step 2 − Click on Recommended Charts.

The following window displaying the charts that suit your data will be displayed.

Step 3 − As you browse through the Recommended Charts, you will see the preview on the right side.

Step 4 − If you find the chart you like, click on it.

Step 5 − Click on the OK button. If you do not see a chart you like, click on All Charts to see all the available chart types.

Step 6 − The chart will be displayed in your worksheet.

Step 7 − Give a Title to the chart.

Fine Tune Charts Quickly

Click on the Chart. Three Buttons appear next to the upper-right corner of the chart. They are −

• Chart Elements
• Chart Styles and Colors, and
• Chart Filters

You can use these buttons −

• To add chart elements like axis titles or data labels
• To customize the look of the chart, or
• To change the data that’s shown in the chart

Select / De-select Chart Elements

Step 1 − Click on the Chart. Three Buttons will appear at the upper-right corner of the chart.

Step 2 − Click on the first button Chart Elements. A list of chart elements will be displayed under the Chart Elements option.

Step 3 − Select / De-select Chart Elements from the given List. Only the selected chart elements will be displayed on the Chart.

Format Style

Step 1 − Click on the Chart. Three Buttons will appear at the upper-right corner of the chart.

Step 2 − Click on the second button Chart Styles. A small window opens with different options of STYLE and COLOR as shown in the image given below.

Step 3 − Click on STYLE. Different options of Style will be displayed.

Step 4 − Scroll down the gallery. The live preview will show you how your chart data will look with the currently selected style.

Step 5 − Choose the Style option you want. The Chart will be displayed with the selected Style as shown in the image given below.

Format Color

Step 1 − Click on the Chart. Three Buttons will appear at the upper-right corner of the chart.

Step 2 − Click on Chart Styles. The STYLE and COLOR window will be displayed.

Step 3 − Click on the COLOR tab. Different Color Schemes will be displayed.

Step 4 − Scroll down the options. The live preview will show you how your chart data will look with the currently selected color scheme.

Step 5 − Pick the color scheme you want. Your Chart will be displayed with the selected Style and Color scheme as shown in the image given below.

You can change color schemes from Page Layout Tab also.

Step 1 − Click the tab Page Layout.

Step 2 − Click on the Colors button.

Step 3 − Pick the color scheme you like. You can also customize the Colors and have your own color scheme.

Filter Data being displayed on the Chart

Chart Filters are used to edit the data points and names that are visible on the chart being displayed, dynamically.

Step 1 − Click on the Chart. Three Buttons will appear at the upper-right corner of the chart.

Step 2 − Click on the third button Chart Filters as shown in the image.

Step 3 − Click on VALUES. The available SERIES and CATEGORIES in your Data appear.

Step 4 − Select / De-select the options given under Series and Categories. The chart changes dynamically.

Step 5 − After, you decide on the final Series and Categories, click on Apply. You can see that the chart is displayed with the selected data.

ORGANIZATIONAL STRUCTURE OF A DEPARTMENT IN THE GOVERNMENT OF INDIA

 

ORGANI

Ministries and departments of the Government of India

 

Ministries and departments of the Government of India 

#	Ministry	Department(s)
1	Prime Minister's Office	Department of Atomic Energy
		Department of Space
2	Ministry of Agriculture and Farmers Welfare	Department of Agriculture and Farmers Welfare
		Department of Agricultural Research and Education
3	Ministry of Ayush
4	Ministry of Chemicals and Fertilizers	Department of Chemicals and Petrochemicals
		Department of Fertilizers
		Department of Pharmaceuticals
5	Ministry of Civil Aviation
6	Ministry of Co-operation
7	Ministry of Coal
8	Ministry of Commerce and Industry	Department for Promotion of Industry and Internal Trade
		Department of Commerce
9	Ministry of Communications	Department of Posts
		Department of Telecommunications
10	Ministry of Consumer Affairs, Food and Public Distribution	Department of Consumer Affairs
		Department of Food and Public Distribution
11	Ministry of Corporate Affairs
12	Ministry of Culture
13	Ministry of Defence	Department of Defence
		Department of Defence Production
		Department of Defence Research and Development
		Department of Ex-Servicemen Welfare
		Department of Military Affairs
14	Ministry of Development of North Eastern Region
15	Ministry of Earth Sciences
16	Ministry of Education	Department of Higher Education
		Department of School Education and Literacy
17	Ministry of Electronics and Information Technology
18	Ministry of Environment, Forest and Climate Change
19	Ministry of External Affairs
20	Ministry of Finance	Department of Economic Affairs
		Department of Expenditure
		Department of Financial Services
		Department of Investment and Public Asset Management
		Department of Public Enterprises
		Department of Revenue
21	Ministry of Fisheries, Animal Husbandry and Dairying	Department of Animal Husbandry, Dairying & Fisheries
22	Ministry of Food Processing Industries
23	Ministry of Health and Family Welfare	Department of Family Welfare
		Department of Health
		Department of Health Research
24	Ministry of Heavy Industries
25	Ministry of Home Affairs	Department of Border Management
		Department of Home
		Department of Internal Security
		Department of Jammu, Kashmir and Ladakh Affairs
		Department of Official Language
		Department of States
26	Ministry of Housing and Urban Affairs	Central Public Works Department
27	Ministry of Information and Broadcasting
28	Ministry of Jal Shakti
29	Ministry of Labour and Employment
30	Ministry of Law and Justice	Department of Legal Affairs
		Department of Justice
		Legislative Department
31	Ministry of Micro, Small and Medium Enterprises
32	Ministry of Mines
33	Ministry of Minority Affairs
34	Ministry of New and Renewable Energy
35	Ministry of Panchayati Raj
36	Ministry of Parliamentary Affairs
37	Ministry of Personnel, Public Grievances and Pensions	Department of Administrative Reforms & Public Grievances
		Department of Pension and Pensioners' Welfare
		Department of Personnel and Training
38	Ministry of Petroleum and Natural Gas
39	Ministry of Planning
40	Ministry of Ports, Shipping and Waterways
41	Ministry of Power
42	Ministry of Railways
43	Ministry of Road Transport and Highways
44	Ministry of Rural Development	Department of Land Resources
		Department of Rural Development
45	Ministry of Science and Technology	Department of Biotechnology
		Department of Scientific and Industrial Research
		Department of Science and Technology
46	Ministry of Skill Development and Entrepreneurship
47	Ministry of Social Justice and Empowerment	Department of Empowerment of Persons with Disabilities
		Department of Social Justice and Empowerment
48	Ministry of Statistics and Programme Implementation
49	Ministry of Steel
50	Ministry of Textiles
51	Ministry of Tourism
52	Ministry of Tribal Affairs
53	Ministry of Women and Child Development
54	Ministry of Youth Affairs and Sports	Department of Youth Affairs
		Department of Sports

#	Ministry	Department(s)
1	Prime Minister's Office	Department of Atomic Energy
		Department of Space
2	Ministry of Agriculture and Farmers Welfare	Department of Agriculture and Farmers Welfare
		Department of Agricultural Research and Education
3	Ministry of Ayush
4	Ministry of Chemicals and Fertilizers	Department of Chemicals and Petrochemicals
		Department of Fertilizers
		Department of Pharmaceuticals
5	Ministry of Civil Aviation
6	Ministry of Co-operation
7	Ministry of Coal
8	Ministry of Commerce and Industry	Department for Promotion of Industry and Internal Trade
		Department of Commerce
9	Ministry of Communications	Department of Posts
		Department of Telecommunications
10	Ministry of Consumer Affairs, Food and Public Distribution	Department of Consumer Affairs
		Department of Food and Public Distribution
11	Ministry of Corporate Affairs
12	Ministry of Culture
13	Ministry of Defence	Department of Defence
		Department of Defence Production
		Department of Defence Research and Development
		Department of Ex-Servicemen Welfare
		Department of Military Affairs
14	Ministry of Development of North Eastern Region
15	Ministry of Earth Sciences
16	Ministry of Education	Department of Higher Education
		Department of School Education and Literacy
17	Ministry of Electronics and Information Technology
18	Ministry of Environment, Forest and Climate Change
19	Ministry of External Affairs
20	Ministry of Finance	Department of Economic Affairs
		Department of Expenditure
		Department of Financial Services
		Department of Investment and Public Asset Management
		Department of Public Enterprises
		Department of Revenue
21	Ministry of Fisheries, Animal Husbandry and Dairying	Department of Animal Husbandry, Dairying & Fisheries
22	Ministry of Food Processing Industries
23	Ministry of Health and Family Welfare	Department of Family Welfare
		Department of Health
		Department of Health Research
24	Ministry of Heavy Industries
25	Ministry of Home Affairs	Department of Border Management
		Department of Home
		Department of Internal Security
		Department of Jammu, Kashmir and Ladakh Affairs
		Department of Official Language
		Department of States
26	Ministry of Housing and Urban Affairs	Central Public Works Department
27	Ministry of Information and Broadcasting
28	Ministry of Jal Shakti
29	Ministry of Labour and Employment
30	Ministry of Law and Justice	Department of Legal Affairs
		Department of Justice
		Legislative Department
31	Ministry of Micro, Small and Medium Enterprises
32	Ministry of Mines
33	Ministry of Minority Affairs
34	Ministry of New and Renewable Energy
35	Ministry of Panchayati Raj
36	Ministry of Parliamentary Affairs
37	Ministry of Personnel, Public Grievances and Pensions	Department of Administrative Reforms & Public Grievances
		Department of Pension and Pensioners' Welfare
		Department of Personnel and Training
38	Ministry of Petroleum and Natural Gas
39	Ministry of Planning
40	Ministry of Ports, Shipping and Waterways
41	Ministry of Power
42	Ministry of Railways
43	Ministry of Road Transport and Highways
44	Ministry of Rural Development	Department of Land Resources
		Department of Rural Development
45	Ministry of Science and Technology	Department of Biotechnology
		Department of Scientific and Industrial Research
		Department of Science and Technology
46	Ministry of Skill Development and Entrepreneurship
47	Ministry of Social Justice and Empowerment	Department of Empowerment of Persons with Disabilities
		Department of Social Justice and Empowerment
48	Ministry of Statistics and Programme Implementation
49	Ministry of Steel
50	Ministry of Textiles
51	Ministry of Tourism
52	Ministry of Tribal Affairs
53	Ministry of Women and Child Development
54	Ministry of Youth Affairs and Sports	Department of Youth Affairs
		Department of Sports