Online Excel alternatives. How to open Excel file online?

Updated: August 04, 2020

2020. Layer gets $5.6M to make spreadsheet collaboration less hassle

Layer is not trying to replace Excel or Google Sheets. Instead the Berlin-based productivity startup wants to make life easier for those whose job entails wrangling massive spreadsheets and managing data inputs from across an organization — such as for budgeting, financial reporting or HR functions — by adding a granular control access layer on top. The idea is to offer a one-stop shop for managing access and data flows around multi-stakeholder spreadsheets, enabling access down to individual cell level and aiding collaboration and overall productivity around these key documents by streamlining the process of making and receiving data input requests.

2018. Mobile Zoho Sheet adds real-time spreadsheet collaboration

Zoho unveiled new Zoho Sheet app for iOS and Android, that allows you to carry your spreadsheets with ease and collaborate in real time with your team, using your mobile devices. You can share your spreadsheets as Microsoft Excel, .pdf or .csv files too. Besides, the new version allows to create large data sets and sort and filter your data for an uncluttered view. Then you can bring your data alive with our vibrant range of charts. View them in full screen, choose to filter out series and analyze your charts with at most comfort and accuracy. Additionally, observe data patterns and trends with conditional formats and icon sets, on your smartphones.

2018. How to open, view and edit Excel spreadsheet online

So, somebody sent you an Excel document and you don’t have Microsoft Excel installed on your computer. Or another common case: you have Excel 2003 but somebody sent you a document in the xlsx format, which can only be opened in Excel 2007 or newer. What should you do? Don’t panic. You can easily open, view and even edit the document in an online word processor. Today there is large variety of these tools. Let’s consider the process of opening the Excel for example using one of the most popular online solutions - Google Docs. The first and most difficult step - you need to register an account on Google. But nowadays many people might already have it. Registered? Let’s continue. Open the Google Docs site and press the Upload button (because first you need to upload your document into the cloud). Pick up the file on your computer. Then the service asks whether you want to convert the document to Google Docs format. Let’s consider this step in details. The fact is that third party (not Microsoft’s) online editors use their own formats for editing documents online (because .doc format is closed one). If you want to edit a document online, you need to convert it. If you simply want to view it online - you don’t need to convert. Google Docs and other online editors can display the Microsoft Excel documents without conversion. You also need to know that the online spreadsheet editors usually don’t contain all the features of the desktop Microsoft Excel, so some functions may be "lost" after the conversion. The same applies to some text formatting in the spreadsheet cells and some diagrams. So, after you have uploaded the spreadsheet - it will appear in the list of your documents, and by clicking on it you can open it for editing. The interface and toolbars in the online editors usually imitate Microsoft Excel, with the difference that they provide only the basic functions. But as a rule it’s enough. From the other hand you can use the main advantage of online document editors and invite your colleagues to co-edit the document instead of sending the file back and forth by email. In Google Spreadsheets you can even collaboratively edit the document with your co-workers simultaneously – in real time. At that you can see, who is now editing the document and what cell he is editing right now. Each user is assigned a color, so you can see it. In addition, you can communicate with the co-workers in the inbuilt chat or comments. Once you have edited the document - you can download it back to your computer in the Microsoft Excel format or another. But don’t rush to do it. If you need to send the document for approval or comments - you can just share it with another user. He will receive a notification by email, and will be able to access the spreadsheet directly in browser, provide feedback and (if you give him access to editing) - make his edits. This is especially useful if you need to send a document to several people. True, in Google Docs all other users in order to access the document should have a Google-account. This is not always acceptable. Other services, such asOffice Online allow to send documents to external users without making them registering in the service.

2018. Online Word and Online Excel: advantages and disadvantages

Word processors and spreadsheets are an integral part of any office infrastructure. Projects, contracts, analytical reports, commercial proposals, legal and marketing literature, bills - all these vital documents are created, viewed and edited in the above mentioned programs. Desktop applications - Microsoft Word and Excel – for a long time were almost monopolists in this space. Their own proprietary document formats (.doc and .xls) have become the de facto industry standards. And when companies exchanged documents, they should send documents and spreadsheets only in these formats. Therefore, even the open and free office suites such as OpenOffice, had very little chance to compete with Word and Excel even if they provided the similar functionality. But in recent years, the new generation of online office applications appeared. They provide completely new opportunities for working with documents and that’s why they succeed in breaking the monopoly of Word and Excel. Though they are less functional, but their powerful collaborative features and mobile access to the documents - allowing them to occupy their niche and entice Microsoft Word and Excel users. Let's consider the pros and cons of the online Word and Excel alternatives. Collaborative document editing Conventional collaboration process on a Word or Excel document previously assumed that someone creates a document and then sends it by e-mail to co-workers. They make edits, add comments and send back the revised documents. Then the author must somehow combine all these changes into one file and send back for approval. And so on. In result you loosing a lot of time for routine work, and your inbox if filled by different versions of the same document. Online editors allow you to store a document in the cloud and share access to it with all co-workers. They can make corrections and add comments into a single document without having to send it back and forth. The collaborative editing is going much faster. Some online editors even allow several users to edit a single document at once - in real time. You can see who is currently working on a document and what paragraph (in a text document) or cell (in a spreadsheet) he is editing right now. You can also communicate with co-editors in online chat or video chat, discussing the document. If you want to share a document with someone outside your company (customer or partner) to get his feedback - you can provide him with view-only access only for comments, but not for editing. And then you won’t have to check whether the customer changed something in the contract or not. Mobile access to documents Of course, it’s much easier access documents stored in the cloud than document stored on an office desktop from mobile devices. Of course, if your mobile device is connected to the Internet. That is the first reason of why the emergence of online editors significantly pushed forward the mobile document editing. The second reason was that the online editors didn’t require powerful computing resources to work with documents. Because most operations with a document are executed by the cloud server and the computer gets only the resulting data. And in mobile devices (smartphones, tablets) the computing resource is a weak point. That is why the online editors, working in mobile browsers, have become a godsend for mobile world. Imagine that you can work with Word or Excel on your tablet on the road with virtually no loss in functionality and the interface speed. All this has become possible thanks to the online editors. Other advantages of the online editors When your documents are stored in the cloud and the document editing programs also work in the cloud - you become totally independent of your location and computer equipment, available right now. You can start working on the document on the office desktop, continue it at home on your laptop and finish on the beach with your smartphone. In addition, because now not only document editors but also many others business applications that operate with documents (e-mail, content management systems, project management software...) are also working in the cloud, it’s inconvenient to upload / download document to them al the time. Online office editors allow you to create documents in the cloud, view them in the cloud and edit them in the cloud without having to upload / download them. For example, when you receive an email with attached Word document to your online mailbox - you can click on it and in a moment view right in your browser. Another advantage of online office editors – is that usually they are free. Disadvantages of online office editors Online document editor have all the same disadvantages as any online application. The most obvious disadvantage is that they don’t work without the Internet connection. It certainly could be a problem in some remote regions, but generally in any city (since appearance of wireless 3G/4G providers) any user has 1-2 backup channels for the Internet access. Besides, some online editors already provide the ability to store documents offline via using HTML5 technology or installing proprietary browser plug-ins. The second drawback is the extension of the first one – low interface speed at a low internet connection speed. It was a big problem several years ago. But today's broadband internet channels in most cases eliminate this drawback. Another classic lack of the online applications – is that your data is stored on a third-party provider’s server. This is still a blocking factor for security-obsessed companies. But in-fact the commercial data leaks because of the company employees and not because of the cloud providers. In addition, using of data encryption technologies (SLL) for transferring and storing documents significantly increases the security level of online services. Lack of # 4 - loss of functionality. Indeed, the online editors don’t offer even 50% of all the features available in desktop Word and Excel. But you probably won’t be surprised to know that the average office worker uses 10-15% of all functions in these programs. So in most cases, online editors functionality - is enough. But the real problem with the online office editors - is not ideal support for industry formats: .doc and .xls. Because they are proprietary and closed, the third-party providers can not perfectly restore the document formatting from them. Simple documents usually are restored fine, but some complex elements (tables, positioned pictures, etc.) – can be distorted. At least it occurs when opening a document for editing. When you view Word and Excel documents online editors – they are displayed perfectly. But the problem is not only in a proprietary format. Online editors simply don’t support some complex elements – tables, formulas, diagrams. Even when you upload a document to Microsoft’s online editors - Office Web Apps sometimes the formatting of complex objects is lost. Online Word and Excel via virtual dektop Web applications - is not the only way to edit documents online. The virtualization and terminal access technologies also provide an opportunity to work on Word and Excel files remotely in an ordinary browser. At that the Word and Excel documents are physically located and processes on a cloud server and you only receive the resulting picture to your screen. Obvious advantages of this approach is that you will not lose any functionality in Word and Excel are won’t have any problems with formats compatibility. But the cost of such solutions can’t compete with online services, as they are more complicated and don’t eliminate the need for licensing Word and Excel. Typically, ISPs that provides Word and Excel as components of a virtual desktop doesn’t require to purchase the licenses, but charge a monthly fee for their use. Another disadvantage is the higher requirement for Internet connection speed (because you actually receiving the online video broadcast) and the need to install / support the virtualization client on your computer. Online document viewers In those cases where you do not need to edit Word or Excel document, but just need to view it, or publish it, or show it to your customers and partners and get their comments,- you can instead of the online office suites use a special service for online document viewing and publishin. For example, Scribd, SlideShare or DocStoc. These services doesn’t allow document editing but they doing a really good job for displaying documents online. First, they almost instantly display even very heavy document (thank to using document broadcasting technologies – similar to video broadcasting on YouTube). Second, they are very handy for zooming, scrolling and searching in the document. These services allow you to embed a document to any web page (by inserting the small code). They provide various options for the document protection and access control. History The first version of Word has been released by Microsoft in 1983 and the first version of Excel - in 1985. After more than twenty years (in 2006) the online alternatives became emerging. One of the first online office was ThinkFree, that used (and still uses) Java runtime technology. At the moment, ThinkFree is a service for document publication, rather than an online office suite. Then came Zoho Office. It is still the most functional suite of online document editors. Like most of today's online applications, Zoho editors are built on the open standards HTML, Javascript, Ajax. But the online document editors became really popular after the appearance of Google Docs and Google Spreadsheets ( in later 2006). That were Google’s services that forced Microsoft to think about implementing online technologies, and in 2010 Microsoft launched the online versions of Word and Excel in the Office Online suite.

2018. Google Sheets gets smart macros recording

Google has launched a major update to Google Sheets. With this update, Sheets users can now record macros. The new “record macros” feature, which sits in the Tools menu, does exactly what you think it should do. You simply start your recording, go through your usual steps and when you’re done, all it takes to repeat all those steps is to run the macro again. In the backend, Sheets actually converts your macro into Apps Script code, which also means that if you want to dive a bit deeper or make a small change, you can edit that script.

2016. ONLYOFFICE now allows to edit documents offline

ONLYOFFICE released Desktop Editors, an office suite that combines viewers and editors for text documents, spreadsheets and presentations working offline. Desktop editors support Copy/Paste, direct print options, local fonts, language detection. ONLYOFFICE Desktop Editors are absolutely free for personal use. For business use the desktop applications are available by subscription: 1 year subscription for $39 and an unlimited subscription for $59. Regular updates and email support are included.

2014. Teamlab opens source code, renames to ONLYOFFICE

Online team collaboration service Teamlab always wanted to become an Office - since the time when it got the own suite of office document editors. It's really oystanding, and Teamlab decided to make it the primary feature. At some point the developers even renamed the service to Teamlab Office. But even this wasn't enough for them. Yesterday (in honour of the 4th birthday) Teamlab was renamed to ONLYOFFICE. Although, as you can see on the site screenshot, it still includes not ONLY OFFICE, but also CRM, project management and document management tools. Beside the rebranding, the developers decided to fully open the source code of the product, so that the users could make sure in it's security. So, from now, if you want to install ONLYOFFICE on your own server - you can do it completely free.