Spreadsheets for business

Updated: October 28, 2019

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.

2008. SocialText wiki platform gets collaborative spreadsheets

Corporate Wiki software company SocialText is adding a spreadsheet to its wiki product. The new feature, SocialCalc, allows users to collaborate on spreadsheets the same way they do in the company's text-based Wikis. The product is based on Dan Bricklin's open-source Wikicalc. For spreadsheet jockeys this is both good and bad news. SocialCalc spreadsheets inherit wiki-style revision tracking, which is an automatic audit trail that will arguably be even more important on spreadsheets with financial and other hard data on them than it is on text-based wiki pages. Users can also easily embed data from other SocialCalc sheets in their spreadsheets, or for that matter data from any SocialText wiki page or Web URL. This could make building workgroup-wide, or even company-wide spreadsheets possible. Assuming, that is, everyone in said workgroup or company is comfortable using SocialCalc instead of Excel.

2006. Google Spreadsheets Goes Live

Google just posted a tour of Google Spreadsheets, their new Excel rival. They’re also inviting users to test the service on a first-come-first-served basis. It looks blissfully simple, and includes live chat, multi-user editing and import/export functionality. In short: an impressive product. This is probably a mixed blessing for the online spreadsheet startups - while no-one wants to compete with Google, this move will likely lead to some acquisitions. Among the contenders: Numbler, JotSpot Tracker, NumSum, DabbleDB, TracksLife, ZohoSheet, EditGrid, WikiCalc and iRows. JotSpot is the hot-ticket here - between (unfounded?) acquisition rumors and a partnership with Salesforce, they’re getting a lot of ink.