Cloud-based spreadsheet software
Google Sheets is a spreadsheet plan included as separate of the dislodge, web-based Google Docs Editors suite offered by Google. The service besides includes Google Docs, Google Slides, Google Drawings, Google Forms, Google Sites, and Google Keep. Google Sheets is available as a web application, mobile app for Android, io, Windows, BlackBerry, and as a background application on Google ‘s Chrome OS. The app is compatible with Microsoft Excel file formats. [ 2 ] The app allows users to create and edit files online while collaborating with other users in real-time. Edits are tracked by drug user with a revision history salute changes. An editor program ‘s position is highlighted with an editor-specific discolor and cursor and a permissions system regulates what users can do. Updates have introduced features using machine learn, including “ Explore ”, offering answers based on natural speech questions in a spreadsheet .

history [edit ]

Google Sheets originated from XL2Web, a web-based spreadsheet application developed by 2Web Technologies, founded by Jonathan Rochelle and Farzad “ Fuzzy ” Khosrowshahi. [ 3 ] XL2Web was acquired by Google in 2006 [ 4 ] and turned into Google Labs Spreadsheets. It was launched as a test for a limited number of users, on a first-come, first-served basis on June 6, 2006. [ 5 ] [ 6 ] The limited test was by and by replaced with a beta version available to all Google Account holders, around the lapp time as an official announcement bid release was issued. [ 7 ] In March 2010, Google acquired the on-line document collaboration company DocVerse. DocVerse allowed multiple-user on-line collaboration on Excel -compatible document adenine well as early Microsoft Office formats such as Word and PowerPoint. [ 8 ] Improvements based on DocVerse were announced and deployed in April 2010. [ 9 ] In June 2012, Google acquired Quickoffice, a freeware proprietorship productiveness suite for mobile devices. [ 10 ] In October 2012, Google Spreadsheets was renamed Google Sheets and a Chrome app was released that provided shortcuts to Sheets on Chrome ‘s raw yellow journalism foliate. [ 11 ]

Platforms [edit ]

Google Sheets is available as a web application supported on Google Chrome, Microsoft Edge, Mozilla Firefox, Internet Explorer, and Apple Safari web browsers. [ 12 ] Users can access all spreadsheets, among early files, jointly through the Google Drive web site. In June 2014, Google rolled out a dedicate web site home page for Sheets that contain only files created with Sheets. [ 13 ] In 2014, Google launched a dedicated fluid app for Sheets on the Android and iOS mobile operating systems. [ 14 ] [ 16 ] In 2015, the mobile web site for Sheets was updated with a “ childlike, more undifferentiated ” interface, and while users can read spreadsheets through the mobile websites, users trying to edit will be redirected towards the fluid app to eliminate editing on the mobile world wide web. [ 17 ]

Features [edit ]

Editing [edit ]

collaboration and rewrite history [edit ]

Google Sheets serves as a collaborative tool for concerted edit of spreadsheets in real-time. Documents can be shared, opened, and edited by multiple users simultaneously and users are able to see character-by-character changes as other collaborators make edits. Changes are mechanically saved to Google ‘s servers, and a revision history is automatically kept so past edits may be viewed and reverted to. [ 19 ] An editor program ‘s stream place is represented with an editor-specific color/cursor, so if another editor program happens to be viewing that part of the document they can see edits as they occur. A sidebar old world chat functionality allows collaborators to discuss edits. The revision history allows users to see the additions made to a document, with each writer distinguished by color. alone adjacent revisions can be compared, and users can not control how frequently revisions are saved. Files can be exported to a exploiter ‘s local computer in a assortment of formats such as PDF and Office Open XML. [ 20 ] Sheets supports tagging for archival and organizational purposes .

explore [edit ]

Launched for the stallion Drive suite in September 2016, “ explore ” enables extra functionality through car memorize. [ 21 ] [ 22 ] [ 23 ] In Google Sheets, Explore enables users to ask questions, such as “ How many units were sold on Black Friday ? “, and Explore will return the answer, without requiring formula cognition from the user. In June 2017, Google expanded the Explore feature in Google Sheets to automatically build charts and visualize data, [ 24 ] [ 25 ] and again expanded it in December to feature machine learning capable of mechanically creating pivot tables. [ 26 ] [ 27 ] In October 2016, Google announced the addition of “ Action items ” to Sheets. If a exploiter assigns a tax within a Sheet, the service will intelligently assign that action to the designated exploiter. Google states this will make it easier for other collaborators to visualize who is creditworthy for a undertaking. When a drug user visits Google Drive or Sheets, any files containing tasks assigned to them will be highlighted with a badge. [ 28 ] In March 2014, Google introduced add-ons ; new tools from third-party developers that add more features for Google Sheets. [ 29 ]

Offline editing [edit ]

In order to opinion and edit spreadsheets offline on a computer, users need to be using the Google Chrome web browser. A Chrome extension, Google Docs Offline, allows users to enable offline hold for Sheets and other Drive suite files on the Google Drive web site. [ 30 ] The Android and io apps natively subscribe offline editing. [ 31 ] [ 32 ]

Files [edit ]

Supported file formats and limits

[edit ]

Files in the comply formats can be viewed and converted to the Sheets format : .xls ( if newer than Microsoft Office 95 ), .xlsx, .xlsm, .xlt, .xltx, .xltm .ods, .csv, .tsv, .txt, .tab [ 33 ] Overall document size is capped at 5 million cells. [ 34 ] [ 35 ]

Google Workspace [edit ]

The Sheets app and the pillow of the Google Docs Editors suite are dislodge to use for individuals, but Sheets is besides available as part of the business-centered Google Workspace ( once G Suite ) avail by Google, which is a monthly subscription that enables extra business-focused functionality. [ 36 ]

integration with Charts and Wikipedia [edit ]

Sheets can produce Google Charts [ 37 ] and has a third-party plugin which allows for integration with Wikipedia. [ 38 ]

other functionality [edit ]

A childlike rule and replace instrument is available. The service includes a web clipboard tool that allows users to copy and paste content between Google Sheets and Docs, Slides, and Drawings. The world wide web clipboard can besides be used for copying and pasting subject between different computers. Copied items are stored on Google ‘s servers for up to 30 days. [ 39 ] Google offers an elongation for the Google Chrome web browser called Office editing for Docs, Sheets and Slides that enables users to view and edit Microsoft Excel documents on Google Chrome, via the Sheets app. The extension can be used for opening Excel files stored on the computer using Chrome, deoxyadenosine monophosphate well as for opening files encountered on the web ( in the form of e-mail attachments, web search results, etc. ) without having to download them. The extension is installed on Chrome OS by default. [ 40 ] As of June 2019, this propagation is no long required since the functionality exists natively. [ 41 ] Google Cloud Connect was a circuit board for Microsoft Office 2003, 2007 and 2010 that could mechanically store and synchronize any Excel text file to Google Sheets ( before the introduction of Drive ). The on-line replicate was mechanically update each clock the Microsoft Excel document was saved. Microsoft Excel documents could be edited offline and synchronized belated when on-line. Google Cloud Connect maintained previous Microsoft Excel document versions and allowed multiple users to collaborate by working on the same document at the lapp time. [ 42 ] [ 43 ] however, Google Cloud Connect has been discontinued as of April 30, 2013, as, according to Google, Google Drive achieves all of the above tasks, “ with better results ”. [ 44 ] While Microsoft Excel maintains the 1900 Leap year tease, Google sheets ‘fixes ‘ this hemipterous insect by increasing all dates prior to March 1, 1900, thus entering “ 0 ” and formatting it as a date returns December 30, 1899. On the other hand. Excel treats “ 0 ” as December 31, 1899, which is formatted to read January 0, 1900 .

References [edit ]