Saving a book in a different file format. Saving data in Excel To use the Save command

PDF - was developed as a format for presenting books and magazines on computers. In everyday life and business, it is most often used to create, so to speak, immutable documents. For example, you have created a table with tariffs or an agreement and you need to send it to the client so that the client does not change anything there, it is best to save it in PDF. After all, Excel can be easily, even if it is password protected.

XML- was developed as a language convenient for processing documents by programs and convenient and understandable for working with a document by a person. You can say a format specially created for the Internet. Very often, exchanges between two programs pass through such a universal language. For example, automatic unloading from Access and loading into 1C.

The full list of available formats is shown in the picture:

As shown earlier, to save Excel to PDF, you need to go to the menu, select Save As - then select PDF or XPS (in the first picture).

XPS is also a special format for protecting the content of a document, one might say an electronic sheet of paper.

Excel to JPEG or PNG

There is no special save function for the image format, but it is quite simple to do it using Windows tools.

First of all, almost every keyboard has a special Print Screen button (screenshot), it is located to the right of F12. Most often something like PrtScn or Prt Sc is written on it.

After clicking this button, the picture with the screen image is saved and you can paste it anywhere: in a letter, in Word, or in the Paint program. From Paint, you can already save to JPEG and PNG.

If you only want to copy the active window, press Alt + PrtScn - described in more detail.

It's even easier to find the scissors program (starting in Windows 7 is built-in). Start - all programs - Standard there are these same scissors - now you can select any fragment and immediately save it in the desired picture format. Convenient - I recommend it to those who do not use it.

If you have a MAC, press Shift + Command + 3 to take a screenshot

Save Excel to XML

Again, as shown in the big picture, left-click on Save as - then the save window will open in the File type window, look for XML data (*.xml).

If you get an error when saving, save as an XML 2003 table, also listed. Most often this happens because. An XML document may not accept more than 65 thousand lines, and the 2003 format cuts them off!

In most cases, you will most likely be saving your books in the current file format (XLSX). But sometimes you might want to save your workbook in a different format, such as an older version of Excel, a text file, or a PDF or XPS file. Just remember that whenever you save a workbook in a different file format, some of its formatting, data, and functionality cannot be saved.

The list of formats (also called file types) you can (and cannot) open or save in Excel 2013 is the file that appears at the end of this article.

Converting an Excel 97-2003 workbook to the current file format

If you have opened an Excel 97-2003 workbook but do not need to store it in this file format, simply convert the workbook to the current file format (XLSX).

On the menu File select a team Intelligence.

Click the button Transform.

Supported Excel file formats

In Excel 2013, you can open and save project files in the following formats.

Excel file formats

Text file formats

Note: If you save the book in any text format, all formatting will be lost.

Other file formats

File formats that use the clipboard

If you have copied the data to the clipboard in one of the following file formats, you can paste it into Excel using the command Insert or Special insert (home > Clipboard > Insert).

File formats not supported in Excel 2013

The file formats listed below are no longer supported, so you will not be able to open files in these formats or save files in these formats.

To work with workbook data in a program that is no longer supported, try the following steps.

Search the Internet for a company that produces file converters for formats not supported by Excel.

Save the workbook in a different file format that can be opened in another program. For example, save a workbook in an XML spreadsheet or text file format that may be supported by another program.

You can save an Excel 2007 and later workbook as previous versions of Excel, as a text file, and in other formats such as PDF and XPS files. Normally, you save in XLSX format, but you can change the default file format for saving. If you frequently use the command Save as, you can add it to the Quick Access Toolbar.

Save an Excel workbook in a different file format

Important: If you save a workbook in a different version of Excel file format, the formatting and features unique to Excel 2007 and later will be lost. See Use Excel with earlier versions of Excel for more information.

Open the workbook in Excel that you want to save in a format suitable for use in another program.

On the tab File select a team Save as.

Accept the name suggested in the field File name, or enter a new book name.

Drop File type select a format suitable for use in another program.

Use the arrows to scroll through the list and display more formats.

Note: Depending on the active sheet type (book sheet, chart sheet, or other sheet types), different file formats will be available for saving.

Save a different file format in Excel 2007 and later format

Any file that opens in Excel 2007 and later can be saved in the current Excel workbook format (XSLX). This way you can take advantage of new features that are not supported in other file formats.

Note: When you save a workbook created in an earlier version of Excel as an Excel 2007 or later workbook, some functionality and some formatting may be lost. For unsupported features in Excel 97-2003, see

Tools for working with tables in MS Word are implemented very conveniently. This, of course, is not Excel, however, you can create and modify tables in this program, and more often is not required.

So, for example, copying a finished table in Word and pasting it into another place in the document, or even into a completely different program, is not difficult. The task is noticeably more complicated if you need to copy a table from a site and paste it into Word. It is about how to do this that we will tell in this article.

Tables presented on various sites on the Internet can differ markedly not only visually, but also in their structure. Therefore, after pasting into Word, they can also look different. And yet, in the presence of the so-called skeleton, filled with data that is divided into columns and rows, you can always give the table the desired look. But first, of course, you need to insert it into the document.

1. Go to the site from which you need to copy the table, and select it.

Advice: Start selecting a table from its first cell, located in the upper left corner, that is, where its first column and row originate. It is necessary to finish the selection of the table on the diagonally opposite corner - the lower right.

2. Copy the highlighted table. To do this, click "CTRL+C" or right-click on the selected table and select "Copy".

3. Open the Word document into which you want to insert this table, and left-click in the place where it should be located.

4. Insert a table by clicking "CTRL+V" or by selecting "Insert" in the context menu (called by one click with the right mouse button).

5. The table will be inserted into the document in almost the same form in which it was on the site.

Note: Be prepared for the fact that the "cap" of the table can move to the side. This is due to the fact that it can be added to the site as a separate element. So, in our case, this is just text above the table, not cells.

In addition, if the cells contain elements that Word does not support, they will not be inserted into the table at all. In our example, these are circles from the “Shape” column. Also, the symbolism of the command is “cut off”.

Change the appearance of a table

Looking ahead, let's say that the table copied from the site and pasted into Word in our example is quite complicated, since in addition to text it also has graphic elements, there are no visual column separators, but only lines. With most tables, you will have to tinker with much less, but with such a difficult example, you will definitely learn how to give any table a “human” look.

To make it easier for you to understand how and what operations we will do below, be sure to read our article on creating tables and working with them.

Dimension Alignment

The first thing that can and should be done is to adjust the size of the table. Just click on its upper right corner to display the "work" area, and then drag the marker located in the lower right corner.

Also, if necessary, you can always move the table to any place on the page or document. To do this, click on the square with a plus sign inside, which is located in the upper left corner of the table, and drag it in the desired direction.

Show table borders

If in your table, as in our example, the row/column/cell borders are hidden, for greater convenience of working with the table, you need to enable their display. To do this, follow these steps:

1. Select the table by clicking on the plus sign in its upper right corner.

2. Tab "Home" in Group "Paragraph" click on the button "Borders" and select the item "All Borders".

3. The table borders will become visible, now it will be much easier to combine and align a separate header with the main table.

If necessary, you can always hide the table borders by making them completely invisible. You can learn how to do this from our material:

As you can see, empty columns appeared in our table, as well as missing cells. This all needs to be corrected, but first we will align the header.

Header alignment

In our case, you can only align the table header manually, that is, you need to cut the text from one cell and paste it into another, in which it is located on the site. Since the “Form” column was not copied from us, we will simply delete it.

To do this, click on an empty column with the right mouse button, in the top menu, click the button "Delete" and select the item "Delete column".

In our example, there are two empty columns, but in the header of one of them there is text that should be in a completely different column. Actually, it's time to move on to aligning the header. If you have as many cells (columns) in the header as in the entire table, just copy it from one cell and move it to the one where it is located on the site. Repeat the same action for the rest of the cells.

Advice: Use the mouse to select text, paying attention to the fact that only the text is selected, from the first to the last letter of the word or words, but not the cell itself.

To cut a word from one cell, press the keys "CTRL+X" to paste it, click in the cell where you want to paste it and press "CTRL+V".

If for some reason you cannot insert text into empty cells, you can convert the text to a table (only if the header is not a table element). However, it would be much more convenient to create a one-line table with the same number of columns as the one you copied, and enter the appropriate names from the header in each cell. You can read about how to create a table in our article (link above).

Two separate tables, the one-line table you created and the main one copied from the site, need to be merged. To do this, use our instructions.

Directly in our example, in order to align the header, and at the same time also remove the empty column, you must first separate the header from the table, perform the necessary manipulations with each of its parts, and then merge these tables again.

Before joining, our two tables look like this:

As you can see, the number of columns is still different, which means that it will not work normally to merge the two tables yet. In our case, we will do the following.

1. Delete the "Form" cell in the first table.

2. Let's add at the beginning of the same table a cell in which “No.” will be indicated, since there is numbering in the first column of the second table. We will also add a cell called "Teams" that is missing from the header.

3. Let's delete the column with command symbols, which, firstly, was crookedly copied from the site, and secondly, we simply don't need it.

4. Now the number of columns in both tables is the same, so we can merge them.

5. Done - the table copied from the site has a completely adequate look, which you can then change as you like. Our lessons will help you with this.

Now you know how to copy a table from a website and paste it into Word. In addition, in this article, you also learned how to deal with all the modification and editing complexities that can sometimes be encountered. Recall that the table in our example was really complex in terms of its execution. Fortunately, most tables do not cause such problems.

This question arises if you stumble upon some data presented in the form of a table on the Internet and want to save it in Microsoft Word format (perhaps after editing it). If you simply open the saved HTML page in Word and then try to save it "as a Word document", then you will retain the original page format, which is hardly acceptable as a standalone document, and you will be tormented by cleaning it from all unnecessary.

The simplest is to transfer the table through the clipboard. This can be done directly from any browser or by first saving the page to a disk file and then opening it in Word. In the latter option, it is easier to select the table without capturing any extra elements - when you hover over the table, all versions of Word after XP show an icon next to the table in the upper left corner, when clicked, the entire table will be selected (you can also press the keyboard shortcut +). But the style of the table will remain the same as it was in the original document - the fashion adopted in HTML for a “convex” double border is especially annoying, and through the usual menu Format | Borders and shading (in new versions: Design | Borders or Design | Borders | Borders and shading) Word stubbornly refuses to change it to a regular frame of simple lines.

You can change the appearance of the frame of such a table by selecting a new style for it. In Word 2003, this is done through a menu with the non-obvious name Table | AutoFormat Table and then selecting one of the frame styles from the list (the simplest is called Table Grid 1). In newer versions, this is even easier, because several table styles glow right on the Design tab, and the remaining several dozen are available through the bottom button to the right of them (which is indicated by the cursor in Figure 3.3). Including there is also the simplest table with thin black lines.

Rice. Z.3. Office 2007 Table Styles

Usually this is not enough - you still have to change the font, set it to black, remove hyperlinks (color fonts when printed on a regular black and white laser printer will be displayed in ugly shades of gray in a fine mesh), format paragraphs if necessary. But it is still incomparably easier than creating such a table from scratch, transferring its cell by cell.

Command call:
-group Books/Sheets -Books -save all

The command saves all open books in the current session with one click.
What is it for? By default, there is no way to save all open books. It is only possible to close all books with saving (for this you need to press the close button of the application while holding down the key Shift and when prompted to save select Save All). But often there is no need to close books - you only need to save them. For example, when you simultaneously have to work with several open reports that are interconnected. And in such cases, as a standard, you have to switch separately to each book and press ctrl+S or icon on the panel.
With the team save all this problem will no longer be - just go to the menu -group Books/Sheets -Books and press save all. All open books will be saved.
Please note that new books (that have not yet been saved to the computer) will be saved to the default folder (usually this My Documents).

Note: in some cases, books are opened in such a way that each book belongs to a separate session (process). In this case, this command will not be able to save all books and save only those related to the process from which the command is launched. You can check how many Excel processes are running by pressing Cltr+Alt+Delete -Start Task Manager and in the window that appears, go to the Processes tab. If there is more than one process with the name EXCEL.EXE in the list, then several processes are running.