We send Excel sheets to the Internet, share them, insert them into a web page and make them interactive. How to open xls file? Review of the best programs
The table format is incredibly convenient for all cases when simple calculations, budgeting or, for example, accounting are needed home budget. It often happens that you need to view or edit .xls, .xlsx or .csv files, but a full-fledged Microsoft Office, Open Office or Numbers is not at hand. Fortunately, technology does not stand still, and more and more “standard” “desktop” applications are finding their online counterparts.
So, a selection of excellent and free services for viewing and editing Excel online: working with formulas, formatting, data in cells, sheets and much more.
1.
Example of a complex document for budget and tax accounting . Easy to use, allows you to easily edit, organize into folders, import, export and publish tables. There is an online viewer that supports many formats, including XLS, XLSX, CSV, ODS. There is no need to even talk about the rich possibilities in terms of creating graphs, charts and histograms.
Advanced users will definitely appreciate the ability to write their own functions/macros in ActionScript, as well as deep integration with other Google services through formulas. For example, the formula = GOOGLEFINANCE() allows you to use data on the stock exchange and the economy with flexible settings.
This editor Excel online included in the free cloud package, which also offers many tools for working with documents, presentations, drawings and more.
2. online
Microsoft in its own style 3.
Just drag and drop the finished one CSV document or Excel XML(.xlsx) to the page - and it is immediately imported into EtherCalc. Or you can create new document at the touch of a button. EtherCalc seems no less convenient and functional than " Google Sheets" and others similar programs. In the comments of the Github repository, the author explains that EtherCalc is a Node.js port of the SocialCalc application. The program can be installed locally to work offline.
4.
. The simplest of all the online services presented above. Zoho Sheet is an office document viewer with the most basic set of tools: graphics and standard formulas. Intuitive, in general, but not as clear in setting up filters as Google's spreadsheet processor.
ExcelArt.ru – if you came to this post from social networks
Alexey Shelkovnikov, designer and lawyer, looks at the world in his own way. Cells in Excel mean almost nothing to him. It gives a completely different meaning to outlines, smart objects and bucket fills. Alexey looks askance at bookkeepers and uses spreadsheet applications for creative reasons, transferring modern and, at times, painful reality into three-dimensional illustrations.
Editing a table means changing the contents of cells and changing the structure of the table (adding, deleting rows or columns). Changing the appearance of the table, for example, the font used to display the contents of cells, the shading color of cells, and the appearance of cell borders is called formatting. Formatting tasks are discussed in the article Formatting a table in Excel.
To get started with existing table, it needs to be loaded into the Microsoft program Office Excel. There are several ways to do this.
If Microsoft program Office Excel is not running, then you need to open the folder in which the desired workbook is located and do double click left mouse button on the icon depicting a book.
Excel Cell Contents
In order to change the contents of a cell, you need to double-click the left mouse button in the selected cell or, using the cursor keys, place the active cell marker (frame) in this cell and press the key
How to add a row, column in an Excel table
When creating tables, you often need to add information to an already completed table, such as the name of a new employee. To do this, you must first insert a blank row into the table, and then enter the required data.
In order to insert an empty row between filled rows of a table, you first need to select the row before which the empty row should be inserted. To do this, left-click on the line number before which you want to insert an empty line. The line will be highlighted in color.
How to delete a row, column in Excel
To delete a row, you first need to select it by clicking on the row number of the sheet, and then click on the Delete button located on the Home -> Cells tab.
How to change column width in Excel
Quite often there is a need to change the width of a table column. This can be done in several ways.
The easiest way to change the column width is to use the mouse. To do this, place the mouse pointer in the sheet header on the right border of the column (the mouse pointer will take the form of a double-headed arrow), click left button and, holding it pressed, drag the column border to the right or left.
How to change row height in Excel
If you need to change the line height, just move the mouse pointer to lower limit rows of the table, press the left mouse button and, while holding the button pressed, move the border down or up.
Moving rows, columns, cells in Excel
Sometimes it becomes necessary to move several rows or columns of a table, for example, in order to change their order.
- In order to move a table fragment (a row, several rows, a column, several columns or a range of cells), you need to:
- Prepare the place where the fragment is to be inserted. The preparation is in adding the required number of empty rows or columns to the table. For example, in order for the Qty and Price columns to appear before the Cost column, you need to insert two empty columns before this column.
Today everyone seems to be moving to the cloud, so why are we any worse? New technologies for sharing access to Excel data via the Internet is a simple method that provides many opportunities and advantages that you can use.
With the advent Excel Online You no longer need cumbersome HTML code to post spreadsheets on the Internet. Simply save your workbook online and access it from literally anywhere, share it with others, and work together on the same spreadsheet. Using Excel Online, you can embed an Excel sheet into a website or blog and let visitors interact with it to get exactly the information they want to find.
How to send Excel 2013 sheets to the Internet
All Excel sheets Online are stored in the OneDrive web service ( former SkyDrive). As you probably know, this online storage has been around for a while now and is now integrated into Microsoft Excel, as a one-click interface command. In addition, guests, i.e. other users with whom you share your tables no longer need their own account Microsoft entry in order to view and edit the Excel files that you have shared with them.
If you still don't have account OneDrive, you can create it right now. This service is simple, free and definitely worth your attention, since most applications Microsoft package Office 2013 (not just Excel) support OneDrive. After registration, follow these steps:
1. Log in to your Microsoft account
Make sure you are signed in to a Microsoft account from Excel 2013. Open an Excel workbook and look in the right top corner. If you see your name and photo there, then go to next step, otherwise press Sign in(Entrance).
Excel will display a window asking you to confirm that you really want to allow Office to connect to the Internet. Click Yes(Yes) and then enter your account information Windows entries Live.
2. Save the Excel sheet to the cloud
Make sure, for your own peace of mind, that the correct one is open. workbook, that is, exactly the one to which you want to open general access in the Internet. I want to share the book Holiday Gift List so that my family and friends can watch it and contribute
With the desired workbook open, go to the tab File(File) and click Share(Sharing) on the left side of the window. By default the option will be selected Invite People(Invite other people), then you need to click Save To Cloud(Save to Cloud) on the right side of the window.
After that, select a location to save the Excel file. First on the list on the left is OneDrive, and it is selected by default. All you have to do is specify the folder to save the file on the right side of the window.
Comment: If you don't see the OneDrive menu item, it means you don't have a OneDrive account or you're not signed in to your account.
I have already created special folder Gift Planner, and it is shown in the list of recent folders. You can select any other folder by clicking the button Browse(Browse) below area Recent Folders(Recent folders), or create new folder, by clicking right click mouse and selecting from the context menu New(Create) > Folder(Folder). When desired folder will be selected, press Save(Save).
3. Share an Excel sheet saved on the Internet
Your work Excel workbook is already online and you can view it in your OneDrive. If you need to share Excel sheets saved on the Internet, then you only have one step left to do - choose one of the sharing methods offered by Excel 2013:
Advice: If you want to limit the area of an Excel workbook that can be viewed by other users, open the tab File(File) section Info(Details) and press Browser View Options(Browser viewing options). Here you can configure which sheets and which named elements can be displayed online.
That's all! Your Excel 2013 workbook is now online and accessible to selected users. And even if you don't like working with others, this method will allow you to access Excel files from anywhere, no matter whether you are in the office, working at home or traveling somewhere.
Working with workbooks in Excel Online
If you are a confident inhabitant of the Cloud Universe, then you can easily master Excel Online during your lunch break.
How to create a workbook in Excel Online
To create new book, click the small arrow next to the button Create(Create) and select from the drop-down list Excel workbook(Excel workbook).
To rename your online book, click the default name and enter a new one.
To load an existing workbook into Excel Online, click Upload(Upload) from the OneDrive toolbar and specify required file, saved on the computer.
How to Edit Workbooks in Excel Online
Once you have opened a workbook in Excel Online, you can work with it Excel help Web App (same as with Excel installed on personal computer), i.e. enter data, sort and filter, calculate using formulas, and visualize data using charts.
There is only one significant difference between the web version and the local version Excel version. Excel Online doesn't have a button Save(Save) because it saves the book automatically. If you change your mind, click Ctrl+Z to cancel the action, and Ctrl+Y to redo the undone action. For the same purpose you can use buttons Undo(Cancel) / Redo(Return) tab Home(Home) in the section Undo(Cancel).
If you try to edit some data, but nothing happens, then most likely the workbook is open in read-only mode. To enable editing mode, click Edit Workbook(Edit book) > Edit in Excel Web App(Edit in Excel Online) and enter quick changes right in your web browser. To access more advanced data analysis capabilities, such as pivot tables, sparklines or to communicate with external source data, press Edit in Excel(Open in Excel) to switch to Microsoft Excel on your computer.
When you save a sheet in Excel, it will be saved where you originally created it, that is, in cloud storage OneDrive.
Advice: If you want to make quick changes to multiple workbooks, then in the best possible way will open a list of files in your OneDrive, find the right book, right-click on it and select the required action from the context menu.
How to share a sheet with other users in Excel Online
... and then choose one of the options:
- Invite People(Send access link) – and enter the address Email people to whom you want to give access to the book.
- Get a link(Get link) - and paste this link into email, post it on your website or social networks.
You can also set access rights for contacts: the right to only view or give permission to edit the document.
When multiple people are editing a worksheet at the same time, Excel Online immediately shows their presence and the updates they've made, as long as everyone is editing the document in Excel Online and not in local Excel on their computer. If you click the small arrow next to the person's name in the upper right corner of the Excel sheet, you can see which cell is in this moment edited by this person.
How to block editing of certain cells in a shared worksheet
If you're sharing online sheets with your team, you might want to give them editing rights only certain cells, rows or columns Excel document. To do this in Excel at local computer you need to select the range(s) you allow to be edited, and then protect the sheet.
How to Embed an Excel Sheet into a Website or Blog
Comment: The embed code is an iframe, so make sure your site supports this tag and your blog allows it to be used in posts.
Implemented Excel Web App
What you see below is an interactive Excel sheet that demonstrates the described technique in action. This table calculates how many days are left until your next day birth, anniversary or some other event and colors the gaps in various shades of green, yellow and red. In Excel Web App, you simply enter your events in the first column, then try changing the corresponding dates and look at the results.
If you are curious about the formula used here, please take a look at the article How to set up conditional date formatting in Excel.
Translator's note: In some browsers, this iframe may not display correctly or may not be displayed at all.
Mashups in Excel Web App
If you want to create greater interaction between your Excel web sheets and other web apps or services, you can use the JavaScript API available on OneDrive to create interactive mashups of your data.
Below you can see a Destination Explorer mashup created by Excel command Web App as an example of what developers can create for your website or blog. This mashup uses the Excel Services JavaScript API and Bing Maps, and its task is to help site visitors choose a route for travel. You can select a location on the map, and the mashup will show you the weather in that location or the number of tourists visiting those locations. The screenshot below shows our location
Hi all! Very often, users, seeing a file with an xls extension, do not know how to open it. If you also encounter this problem, then let's figure it out together.
First, I propose to take a little look at what the xls format is, and then we will choose a program that can work with this type of file.
Xls is a data file format specially developed by Microsoft that contains information placed in special address cells, which in turn create a full-fledged table.
Upgraded version - xlsx format. It allows you to create files less weight, but with expanded functionality.
As you probably already guessed, to open an xls file you need to use word processor Excel, if on your computer or mobile device there is no MS Office software package, then let's take a look alternative options than to open xls.
If your computer does not have installed package office programs from Microsoft, I suggest using alternative free options, which can not only replace Excel, but will also become a complete replacement for the MS Office package.
Open Office
Probably the most popular free analogue MS Office is Open Office. This product is distributed completely free of charge and can work with all popular office documents. The program interface is very similar to MS Office, but there are some functions that will take some getting used to. To open xls file, you will need the Open application Office Calc, essentially this is the same Excel, only from a different developer. 
Among the disadvantages of this software package, I would like to note that it is not always high speed work, but for home use will fit perfectly.
You can download Open Office from the official website www.openoffice.org/ru/.
LibreOffice
Another free cross-platform software package with open source code. LibreOffice was created as a fork of OpenOffice back in 2010 and continues to be actively developed. LibreOffice can be installed on almost everything modern gadgets. The package includes programs for working with text, tables, presentations, graphics and databases.
To work with table files in xls format, LibreOffice provides the user with table processor Calc. 
The software package is perfect for both home use and small organizations who do not want to pay money for licensed products.
Windows File Viewer
If you do not want to install a suite of office programs on your PC and you only need to open a file with tables once, then I present to your attention an excellent file viewer called File Viewer.
The main difference between this program and its analogues is that in addition to viewing files, it is possible to edit them. True, I don’t recommend abusing the editor’s functions. It’s better to trust word processors specially designed for these purposes. 
Note! File program Viewer is paid, to get acquainted with the program's functions for free you have only 10 days after installation, after which you will need to purchase a license.
You can download File Viewer on the official website at windowsfileviewer.com.
How to open xls file for Mac OS users
If you are as operating system If you use Mac OS, you can install the MS Office software package, which appeared relatively recently for this operating system. By the way, for some reason, on this OS, Exel is not at all to the taste of users and many use other solutions. If you are interested in learning about them, read below.
Apple Numbers
If you don’t yet know how to open xls, then I recommend the quite popular Apple program Numbers, designed specifically for Mac OS. The main advantage of the program is the very high speed of working with files. 
Also, when working with tables created in other programs, the formatting does not get lost and the cells do not move out. I think Apple Numbers will be indispensable program for users who constantly work with tables. You can download the application from the link - www.apple.com/ru/numbers/
Planamesa NeoOffice
Another open source product that was created specifically for a proprietary operating system Apple. Current Package programs can work with all modern electronic documents. And it will do a great job with xls files, which you can view, edit and save. 
The program interface is very similar to MS Office, so users will not have any difficulty understanding all the tools on their own.
How to open xls using online services
If for some reason you are unable to install an office software package on your computer, then do not despair. It is possible to open an xls file using popular online services from Yandex and Google. Let's look at each of them.
Using Yandex Disk to view spreadsheets
Once you register for cloud storage, you will immediately receive 7 GB of cloud storage for free. This will be quite enough for storing and editing electronic documents and small files.
How to open xls file on Android devices
For Android platforms currently created great amount office software packages that users can download from Play Market, but not all of them work stably and quickly. Therefore, we have to make a choice in favor of more optimized solutions that do not take up much space and work quickly.
Kingsoft WPS Office
An excellent cross-platform application that works quickly with text documents and tables.
The main difference between Kingsoft WPS Office from analogues, is that applications have high speed and consume a minimum of resources. At the same time, they all have necessary functions to view and edit tables. 
The application interface is simple, which allows the user to quickly understand the functionality and comfortably work with documents.
No wonder Kingsoft WPS Office entered the top best apps for Android devices.
Open xls documents on Apple gadgets
There aren't many good ones for Apple device users. office applications. Previously, users of gadgets under iOS control used MS Excel, but now more and more people prefer online services. Since they do not require installation on the device, but still provide the same functions.
If for some reason you need to install office suite programs, then I recommend the following solution.
MobiSystem Office Suite Pro
One of the few office applications for iOS that has proven itself only with positive side. The software package allows you to work with all modern electronic documents, and also provides the user with a very convenient explorer for searching files. 
