Contacts 

What extension do Excel spreadsheet files have? Useful extensions for Microsoft Excel

Calling the command:
-group Books/Sheets -Books

The command changes the format for all selected files to the specified one. In this case, the command can create a copy of the file or replace the format of the original file, as well as apply the specified macro from any selected workbook to each file.
Why this might be needed: Some programs and macros allow you to work exclusively with certain file formats. But in life, not all files are always in the same format. This command can also be used to remove macros from all specified workbooks. All workbooks in which macros need to be deleted are placed in one folder. Next, run this command, select the format "xlsx - Excel workbook without macro support" and is executed. All files will be saved in this format. After this, the files can be saved in another format (xls, for example). But there will definitely be no macros there.
Changing the format with this command applies exclusively to Excel files and cannot be used to change the file formats of other programs (OpenOffice, Paint, etc.).

View files:

  • Everything in the selected folder- after clicking OK, you will be prompted to select a folder with files. The formats of all files in this folder will be changed to the specified one.
      including subfolders- available for the All in selected folder item. If installed, then files will be viewed not only in the specified folder, but also in all its subfolders, up to the deepest subfolder. If disabled, files will be viewed exclusively in the specified folder.

    • Only selected - after clicking OK, you will be prompted to select a group of files or a file (several files can be selected by holding down the Shift or Ctrl key). All selected file formats will be changed to the specified one.

Change file format:- enable if you need to change the file format. If disabled, the file format is not changed. This can be used if you only need to apply a specific macro to a group of files without changing the formats themselves.

    Save all files in the format- select the file format that will be assigned to the selected files after executing the command. Nine formats available:
    • xlsx- Excel workbook without macro support
    • xlsm- Excel workbook with macro support
    • xlsb- Excel binary workbook (with macro support)
    • xlam - Excel add-in
    • xltx- Excel template
    • xltm- Excel template with macro support
    • xls- Excel workbook (97-2003)
    • xla- Excel add-in (97-2003)
    • xlt- Excel template (97-2003)

    All formats are standard for Excel
    If the file exists- the option is intended to allow you to select actions in the event of file creation conflicts that arise when there is such a file in the folder. What does it mean. If the program needs to change the file format "Book1.xlsx" to "Book1.xlsm", but the file "Book1.xlsm" already exists in the folder with the source files, the program can either replace the existing file or leave it and not convert anything. And in such situations, you can choose what the program should do:

    • Action Request- if the file is already in the folder, the program will display a message with the file name and ask what needs to be done: replace this file or skip it
    • Overwrite without prompting- if the file is already in the folder, the program will overwrite this file, replacing it with a new one
    • Skip- if the file is already in the folder, then the program will not do anything with it, but will not change the format of the original file. The original file is not deleted

    Keep original files- if installed, then when changing the format, the source files (the format of which changes) are not deleted, but remain in the same folder. In this case, the format change occurs on copies source files. If among the files being viewed there are files whose format matches the one specified in paragraph Save all files in the format, then the files are not resaved. If , then the code will still be applied.

Apply code (macro) to each file- if installed, you must select the workbook containing macros. Below you will see a list of macros available for execution. You can select any one macro to be executed for each book being viewed. The field contains only those macros that do not contain mandatory passed arguments.

    after executing the code
  • save books- available only if you select to apply code (macro) to files. If installed, then after applying the code (macro) to the books, the books will be saved. If disabled, books will not be saved. However, this only applies to workbooks that were opened BEFORE the command was executed. If the books were closed before, then before closing they are saved in any case.
  • close- available only if you select to apply code (macro) to files. If installed, the book closes after applying the code. However, if the workbook was open before the command was executed, it will not be closed. Only those books that were closed before executing the command to change the format or executing the code (macro) are closed. Also, if the book was closed before the command was executed, then before closing it is saved in any case, even if the checkbox is checked save books removed.

Note: Applying this command You should make sure that you have all rights to write and change files in the specified folders. You should also carefully select formats and files - operations to change the format are irreversible and in order to avoid data loss, it is recommended to try the functionality of the command on copies of files. In case of loss of any data due to careless use of this command, the author of the add-on does not bear any responsibility.

How to open a document in xls format if you do not have the MS Office software package installed on your computer?

As a rule, the main and most popular application for viewing and editing .xls files is Excel, however, not all PC users have portable devices It is possible to install this table processor.

.xls is a data file format developed by Microsoft. Information in a document of this format is stored in special address cells, thus creating a complex table. Format .xlsx is a newer modification of the extension that allows you to create a smaller document, but with a wider range of functions.

Let's take a closer look at alternative programs that work with .xls for all popular operating systems today.

If you have Windows

In addition to the most popular package office applications MS Office, many other good programs for working with documents have been developed for Windows OS. For example, the Open Office utility is free for your PC and can work with text files, tables and presentations.

Open Office

To get started, launch the program and home page select the type of document you want to create:

LibreOffice

LibreOffice is another good program with open source for working with spreadsheets. In addition to utilities for working with text, presentations and tables, LibreOffice has a built-in editor vector graphics, formula editor and DBMS (comprehensive database management system). The program is distributed exclusively free of charge.

If you have Mac OS

Recently, on Mac OS you can download official version MS Office package, however, is not the most popular program among Apple OS users.

Apple Numbers

Apple Numbers is perhaps the best spreadsheet utility available for the Mac. The application allows you to open files very quickly, without losing quality or data. Using Apple Numbers, you will not encounter the problem of graphs and table cells that have moved out of place.

Planamesa NeoOffice

Planamesa NeoOffice – set software for working with text, presentations and tables. Supports all common office document formats, in particular xls.

With this application you can open, edit, save files. The main window and toolbar of the program are very reminiscent of MS Office.

Also for Mac OS you can download the previously described Open Office or LibreOffice.

Online services

If you do not want to install bulky programs on your computer, you should use Internet services that can work with office files. All such sites are usually free and do not restrict users in their use.

Yandex Disk

Yandex disk is a comprehensive cloud storage, which allows you not only to store files, but also to view them. Unfortunately, you will not be able to edit the document, but you can quickly view its contents.

To open .xls, first upload the file you need to the service (for this you need to have a registered account and enough space for cloud drive). Then wait for the file to finish downloading, click on it and select “View”. The contents of the file will open in new page browser.

Google Docs

The next service that can quickly open xls without losing data is Google Docs.

Website Google Drive (drive.google.com) – cloud storage for any type of file. The service has attached applications for working with documents, which open and work directly in the browser.

To work, you need an Internet connection, or additional settings utilities that allow you to work offline (including this task is performed by the Chrome browser extension).

The service is popularly called GoogleDox; it fully works with all types of ordinary office documents and contains many copies of templates, or document templates - for creating resumes, to-do sheets, annual reports, budgeting, etc. (Fig. 6).

Application for text documents called Google Docs, it is convenient for opening and editing any text files, including MS Word files with .doc, .docx resolution; for presentations - Google Slides; for tables – Google Sheets; There are other applications for drawing and working with databases.

To access Google Drive you must have an account Google entry– the service works in conjunction with postal service gmail.com. At launch, each user receives 7 GB free space in the storage and the ability to edit any documents online, including in collaboration with other users.

If you have Android

Kingsoft WPS Office

Kingsoft WPS Office is a multi-platform application created to organize work with text files and user tables.

It should be noted that the version for Android OS was a success for the developers - a simple interface, minimal consumption of device resources and a wide range of functions brought Kingsoft WPS Office to the TOP best apps official Google Play store.

Fig. 10 – appearance Kingsoft WPS Office programs in Android OS

Also on Android you can use the above online services for free.

If you have iOS

There are quite a few good ones for iOS office programs. Until recently, the most popular was the official Microsoft Excel, but recently more and more users are switching to more universal online services and client applications from Google.

If all this does not suit you for some reason, there is another program that is worth paying attention to - MobiSystems OfficeSuite Pro.

MobiSystems OfficeSuite Pro

In addition to viewing documents, users also have the opportunity to use a convenient built-in explorer to search for files in the phone's memory and download additional free dictionaries, tools and e-books.

If you have Windows Phone

On all devices under Windows control Phone comes pre-installed with Microsoft's document management software package.

However, a decent number of users note many shortcomings in the work of standard software: files are difficult to find in Explorer, large documents open with loss of formatting, etc.

IN official Store there are other applications good programs, which you can use as an analogue to the standard one for working with xls.

Excel Mobile

Excel Mobile - this utility only supports spreadsheets. Thanks to this, the program has more functions. The interface is identical to standard Excel for Windows.

Thematic videos:

Microsoft Excel is the leading application in the spreadsheet solutions market and is widely used by both corporate clients and home users. This recognition is quite justified, since this solution is easy to use, works stably and has very broad functionality. However, no matter how good one or another software, you can always find functions that would be nice to improve. Also with Excel program, to expand the functionality of which many add-on programs have been developed today. Their main purpose is to add new capabilities and automate routine routine operations. We will consider the most interesting solutions of this kind.

Data management

Working with cells, columns and rows

When working with tables, to achieve the desired result you have to perform great amount various actions: change formats in cells, move columns and rows, sort data, etc. All this requires some time, so it is extremely important to have functionality for quickly (that is, with one click, and not through sequential selection of certain menus) to carry out such operations. The functionality required for this in Excel can be developed manually through macros. For example, if you regularly have to set a number format in cells with one decimal place, then it makes more sense to create a macro for this operation, assign it to a button and place the latter on the toolbar. Note that some of this kind of routine operations in Excel have their own buttons, but they are simply not placed on the toolbar. Therefore, before fiddling with macros, it’s worth opening a window Settings(team Service-> Settings), activate tab Teams and, moving through the categories on the left side of the window, carefully look at the buttons on the right side. When you find a button you're interested in, drag it onto the toolbar. You can go the other way - expand the functionality of Excel by installing suitable add-ins such as ASAP Utilities, PLEX or Cells Assistant for Excel. This will significantly speed up the execution of a number of operations.

After installing the ASAP Utilities plugin (http://www.asaputilities.com/download/ASAPUtilities_setup_4-2-5.exe; 3.36 MB; $49), an additional ASAP Utilities menu appears in Excel (Fig. 1), which has a toolkit to perform a wide variety of actions. So, using this plugin, you can quickly number cells and insert specific text in the selected cells (before or after the entered values). It is equally easy to shuffle cell values ​​randomly and merge cells while preserving their contents. Or select cells in accordance with some condition - for example, only protected or unprotected, empty or non-empty, or those in which the values ​​are in certain intervals or have formulas associated with other files or sheets, etc. And also copy the settings of a separate sheet (margin sizes, headers and footers, page orientation, etc.) to any other sheet. ASAP Utilities will help you quickly remove all links, objects (images, buttons), unnecessary spaces and borders, as well as cells filled with a certain color or containing text of a certain color in the table. With its help, you can filter out cells within a specific range from a group of selected cells and sort the cells taking into account not only values, but also a number of other criteria (including cell fill color, color, typeface and font size, etc.). ASAP Utilities implements the use of formulas very conveniently - they are assigned to the entire selected range at once (Fig. 2), while the program remembers the last hundred used formulas, so that if used again, you no longer need to enter the desired formula - you can simply select it from the list.

Rice. 1. ASAP Utilities menu

Rice. 2. Assigning a formula to a selected range in ASAP Utilities

Announcement

XLSB Spreadsheet File Format

An XLSB document is a spreadsheet that was originally created in Microsoft Excel. There are many misconceptions associated with various files spreadsheets from Microsoft, but much of the confusion stems from the timing of the particular version of the program that created the spreadsheet. In earlier Excel versions files were saved in XLS format. This is a binary file format that was used in Excel up until version 2003. The XLSB extension was introduced in Excel 2007. An XLSB file is more efficient for the system to open and run. In addition, this format allows users to store significantly larger files.

Technical information about XLSB files

A file with an XLSB extension is a table created by latest version Microsoft Excel. Previous versions Excel can open XLSB files, but you will likely lose some of the extra functionality that has been added in newer versions of Excel. An XLSB file is an XML architecture compressed using ZIP. Microsoft has indicated that it is making the product "open" and available for anyone to use. However, XLSB technology is not the same as the Open Document standard. There is a separate XML table standard developed specifically for the Open Document standard.

Additional information about the XLSB format

File extension .xlsb