Google Sheets

Last updated

Google Sheets
Developer(s) Google LLC
Initial releaseMarch 9, 2006;18 years ago (2006-03-09)
Written in JavaScript
Operating system Android, iOS, ChromeOS
Available in83 languages [1]
Type
Website google.com/sheets

Google Sheets is a spreadsheet application included as part of the free, web-based Google Docs Editors suite offered by Google. Google Sheets is available as a web application; a mobile app for: Android, iOS, and as a desktop application on Google's ChromeOS. 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 which user made them, along with a revision history. Where an editor is making changes is highlighted with an editor-specific color and cursor. A permissions system regulates what users can do. Updates have introduced features that use machine learning, including "Explore", which offers answers based on natural language questions in the spreadsheet. Sheets is one of the services provided by Google that also includes Google Docs, Google Slides, Google Drawings, Google Forms, Google Sites and Google Keep.

Contents

History

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 later replaced with a beta version available to all Google Account holders, around the same time as an official announcement press release was issued. [7] In March 2010, Google acquired the online document collaboration company DocVerse. DocVerse allowed multiple-user online collaboration on Excel-compatible documents as well as other Microsoft Office formats such as Microsoft Word and Microsoft PowerPoint. [8] Improvements based on DocVerse were announced and deployed in April 2010. [9] In June 2012, Google acquired Quickoffice, a freeware proprietary productivity suite for mobile devices. [10] In October 2012, Google Spreadsheets was renamed Google Sheets and a Google Chrome app was released that provided shortcuts to Sheets on Chrome's new tab page. [11]

Platforms

Google Sheets is available as a web application supported on: Google Chrome, Microsoft Edge, Firefox, and Safari web browsers. [12] Users can access all spreadsheets, among other files, collectively through the Google Drive website. In June 2014, Google rolled out a dedicated website homepage for Sheets that contain only files created with Sheets. [13] In 2014, Google launched a dedicated mobile app for Sheets on the Android and iOS mobile operating systems. [14] [15] [16] In 2015, the mobile website for Sheets was updated with a "simpler, more uniform" interface. While users can read spreadsheets through the mobile websites, users trying to edit will be redirected towards the mobile app to eliminate editing on the mobile web. [17]

Apps Script
Developer(s) Google
Initial releaseAugust 19, 2009;14 years ago (2009-08-19) [18]
Written in JavaScript
Type Web application framework, scripting language
Website script.google.com

Features

Editing

Collaboration and revision history

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

Explore

Launched for the entire Drive suite in September 2016, "Explore" enables additional functionality through machine learning. [22] [23] [24] 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 knowledge from the user. In June 2017, Google expanded the Explore feature in Google Sheets to automatically build charts and visualize data [25] [26] and again expanded it in December to feature machine learning capable of automatically creating pivot tables. [27] [28] In October 2016, Google announced the addition of "Action items" to Sheets. If a user assigns a task within a Sheet, the service will intelligently assign that action to the designated user. Google states this will make it easier for other collaborators to visualize who is responsible for a task. When a user visits Google Drive or Sheets, any files containing tasks assigned to them will be highlighted with a badge. [29] In March 2014, Google introduced add-ons; new tools from third-party developers that add more features for Google Sheets. [30]

Offline editing

To view and edit spreadsheets offline on a computer, users need to be using the Chromium-based web browser (e.g., Google Chrome, Microsoft Edge). A Chrome extension, Google Docs Offline, allows users to enable offline support for Sheets and other Drive suite files on the Google Drive website. [31] The Android and iOS apps natively support offline editing. [32] [33]

Files

Supported file formats and limits

Files in the following 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 and .tab [34] Overall document size is capped at 10 million cells. [35] [36]

Google Workspace

The Sheets app and the rest of the Google Docs Editors suite are free to use for individuals, but Sheets is also available as part of the business-centered Google Workspace (formerly G Suite) service by Google, which is a monthly subscription that enables additional business-focused functionality. [37]

Integration with Charts and Wikipedia

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

Other functionality

A simple find and replace tool is available. The service includes a web clipboard tool that allows users to copy and paste content between Google Sheets and Google Docs, Google Slides, and Google Drawings. The web clipboard can also be used for copying and pasting content between different computers. Copied items are stored on Google's servers for up to 30 days. [40]

Google offers an extension 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 Google Sheets app. The extension can be used for opening Excel files stored on the computer using Chrome, as well as for opening files encountered on the web (in the form of email attachments, web search results, etc.) without having to download them. The extension is installed on ChromeOS by default. [41] As of June 2019, this extension is no longer required since the functionality exists natively. [42]

Google Cloud Connect was a plug-in for Microsoft Office 2003, 2007, and 2010 that could automatically store and synchronize any Excel document to Google Sheets (before the introduction of Drive). The online copy was automatically updated each time the Microsoft Excel document was saved. Microsoft Excel documents could be edited offline and synchronized later when online. Google Cloud Connect maintained previous Microsoft Excel document versions and allowed multiple users to collaborate by working on the same document at the same time. [43] [44] 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". [45]

While Microsoft Excel maintains the 1900 Leap year bug, Google sheets 'fixes' this bug by increasing all dates before March 1, 1900, so entering "0" and formatting it as a date returns December 30, 1899. On the other hand. Excel interprets "0" as meaning December 31, 1899, which is formatted to read January 0, 1900.

Launched in December 2022, Simple ML is the Google's add-on for machine learning. [46]

See also

Related Research Articles

<span class="mw-page-title-main">Microsoft Office</span> Suite of office software

Microsoft Office, or simply Office, is a family of client software, server software, and services developed by Microsoft. It was first announced by Bill Gates on August 1, 1988, at COMDEX in Las Vegas. Initially a marketing term for an office suite, the first version of Office contained Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. Over the years, Office applications have grown substantially closer with shared features such as a common spell checker, Object Linking and Embedding data integration and Visual Basic for Applications scripting language. Microsoft also positions Office as a development platform for line-of-business software under the Office Business Applications brand.

iWork Office suite of applications created by Apple Inc.

iWork is an office suite of applications created by Apple for its macOS, iPadOS, and iOS operating systems, and also available cross-platform through the iCloud website.

A collaborative real-time editor is a type of collaborative software or web application which enables real-time collaborative editing, simultaneous editing, or live editing of the same digital document, computer file or cloud-stored data – such as an online spreadsheet, word processing document, database or presentation – at the same time by different users on different computers or mobile devices, with automatic and nearly instantaneous merging of their edits.

The following tables compare general and technical information for a number of office suites:

This is an overview of software support for the OpenDocument format, an open document file format for saving and exchanging editable office documents.

<span class="mw-page-title-main">Microsoft Office Live</span> Discontinued web-based service

Microsoft Office Live is a discontinued web-based service providing document sharing and website creation tools for consumers and small businesses. Its successor was branded Windows Live. Office Live consisted of two services, Office Live Workspace, which was superseded by OneDrive, and Office Live Small Business, which was superseded by Office 365.

Google Workspace is a collection of cloud computing, productivity and collaboration tools, software and products developed and marketed by Google. It consists of Gmail, Contacts, Calendar, Meet and Chat for communication; Currents for employee engagement; Drive for storage; and the Google Docs Editors suite for content creation. An Admin Panel is provided for managing users and services. Depending on edition Google Workspace may also include the digital interactive whiteboard Jamboard and an option to purchase add-ons such as the telephony service Voice. The education edition adds a learning platform Google Classroom and today has the name Workspace for Education.

<span class="mw-page-title-main">OneDrive</span> File hosting and synchronization service operated by Microsoft

Microsoft OneDrive is a file hosting service operated by Microsoft. First released in August 2007, it allows registered users to store, share and sync their files. OneDrive also works as the storage backend of the web version of Microsoft 365 / Office. OneDrive offers 5 GB of storage space free of charge, with 100 GB, 1 TB, and 6 TB storage options available either separately or with Microsoft 365 subscriptions.

<span class="mw-page-title-main">Quickoffice</span> Discontinued freeware proprietary productivity suite for mobile devices

Quickoffice, Inc. is a discontinued freeware proprietary productivity suite for mobile devices which allows viewing, creating and editing documents, presentations and spreadsheets. It consists of Quickword, Quicksheet, QuickPoint and QuickPDF. The programs are compatible with Microsoft Office file formats, but not the OpenDocument file format.

<span class="mw-page-title-main">Docs.com</span> Public document sharing service from Microsoft

Docs.com was a website where users could discover, upload and share Office documents. Supported file types included Word documents, Excel spreadsheets, PowerPoint presentations, Mix video presentations and Sways. Users could also add PDFs and URLs on to their page. Docs.com was a part of Microsoft Office Online.

<span class="mw-page-title-main">Google Cloud Connect</span> Cloud computing plug-in for Microsoft Office

Google Cloud Connect was a free cloud computing plug-in for Windows Microsoft Office 2003, 2007 and 2010 that can automatically store and synchronize any Microsoft Word document, PowerPoint presentation, or Excel spreadsheet to Google Docs in Google Docs or Microsoft Office formats. The Google Doc copy is automatically updated each time the Microsoft Office document is saved. Microsoft Office documents can be edited offline and synchronized later when online. Google Cloud Sync maintains previous Microsoft Office document versions and allows multiple users to collaborate, working on the same document at the same time. Google Cloud Connect was discontinued on April 30, 2013, as according to Google, all of Cloud Connect's features are available through Google Drive.

Google Drive is a file storage and synchronization service developed by Google. Launched on April 24, 2012, Google Drive allows users to store files in the cloud, synchronize files across devices, and share files. In addition to a web interface, Google Drive offers apps with offline capabilities for Windows and macOS computers, and Android and iOS smartphones and tablets. Google Drive encompasses Google Docs, Google Sheets, and Google Slides, which are a part of the Google Docs Editors office suite that permits collaborative editing of documents, spreadsheets, presentations, drawings, forms, and more. Files created and edited through the Google Docs suite are saved in Google Drive.

<span class="mw-page-title-main">Google Slides</span> Cloud-based presentation software

Google Slides is a presentation program included as part of the free, web-based Google Docs suite offered by Google. Google Slides is available as a web application, mobile app for: Android, iOS, and as a desktop application on Google's ChromeOS. The app is compatible with Microsoft PowerPoint file formats. The app allows users to create and edit files online while collaborating with other users in real-time. Edits are tracked by a user with a revision history presenting changes. An editor's position is highlighted with an editor-specific color and cursor and a permissions system regulates what users can do. Updates have introduced features using machine learning, including "Explore", offering and "tasks to other users."

<span class="mw-page-title-main">Google Drawings</span> Cloud-based diagramming software

Google Drawings is a diagramming software included as part of the free, web-based Google Docs Editors suite offered by Google. The service also includes Google Docs, Google Sheets, Google Slides, Google Forms, Google Sites, and Google Keep. Google Drawings is available as a web application and as a desktop application on Google's ChromeOS. The app allows users to create and edit flowcharts, organisational charts, website wireframes, mind maps, concept maps, and other types of diagrams online while collaborating with other users in real-time.

Google Forms is a survey administration software included as part of the free, web-based Google Docs Editors suite offered by Google. The service also includes Google Docs, Google Sheets, Google Slides, Google Drawings, Google Sites, and Google Keep. Google Forms is only available as a web application. The app allows users to create and edit surveys online while collaborating with other users in real-time. The collected information can be automatically entered into a spreadsheet.

<span class="mw-page-title-main">Google Docs</span> Cloud-based word processing software

Google Docs is an online word processor included as part of the free, web-based Google Docs Editors suite offered by Google, which also includes Google Sheets, Google Slides, Google Drawings, Google Forms, Google Sites and Google Keep. Google Docs is accessible via an internet browser as a web-based application and is also available as a mobile app on Android and iOS and as a desktop application on Google's ChromeOS.

<span class="mw-page-title-main">OfficeSuite</span> Computer program

OfficeSuite is a cross-platform office suite application developed by MobiSystems. It has versions for Android, iOS and Microsoft Windows (PC) and adds extensive PDF abilities to its compatibility with the most frequently used Microsoft Office file formats. The software has over 220 million downloads on Google Play and is among the top Android business applications.

<span class="mw-page-title-main">Collabora Online</span> Online office suite based on LibreOffice

Collabora Online is an open source online office suite built on LibreOffice Technology, enabling web-based collaborative real-time editing of word processing documents, spreadsheets, presentations, and vector graphics. Optional apps are available for desktops, laptops, tablets, smartphones, and Chromebooks.

Google Docs Editors is a web-based productivity office suite offered by Google within its Google Drive service. The suite includes Google Docs, Google Sheets (spreadsheet), Google Slides, Google Drawings, Google Forms, Google Sites, Google Keep, and the awaited Google Vids It used to also include Google Fusion Tables until it was discontinued in 2019.

References

  1. ↑ Hill, Ian (June 18, 2013). "18 New Languages for Drive, Docs, Sheets, and Slides". Google Drive Blog. Retrieved October 29, 2016.
  2. ↑ "Office editing makes it easier to work with Office files in Docs, Sheets, and Slides". G Suite Updates Blog. Retrieved August 12, 2019.
  3. ↑ Surden, Esther (June 26, 2013). "At Madison Meetup, NJ's Rochelle Talks XL2Web Acquisition by Google". NJ Tech Weekly. Retrieved October 15, 2021.
  4. ↑ Dawson, Christopher (October 30, 2010). "Google's 40 acquisitions in 2010: What about integration?". ZDNet . CBS Interactive . Retrieved June 1, 2017.
  5. ↑ Rochelle, Jonathan (June 6, 2006). "It's nice to share". Official Google Blog. Retrieved October 29, 2016.
  6. ↑ "Google Announces limited test on Google Labs: Google Spreadsheets". June 6, 2006. Retrieved October 29, 2016.
  7. ↑ "Google Announces Google Docs & Spreadsheets". October 11, 2006. Retrieved October 29, 2016.
  8. ↑ Jackson, Rob (March 5, 2010). "Google Buys DocVerse For Office Collaboration: Chrome, Android & Wave Implications?". Phandroid. Retrieved October 20, 2016.
  9. ↑ Belomestnykh, Olga (April 15, 2010). "A rebuilt, more real-time Google documents". Google Drive Blog. Retrieved October 30, 2016.
  10. ↑ Warren, Alan (June 5, 2012). "Google + Quickoffice = get more done anytime, anywhere". Official Google Blog. Retrieved October 30, 2016.
  11. ↑ Sawers, Paul (October 23, 2012). "Google Drive apps renamed "Docs, Sheets and Slides", now available in the Chrome Web Store". The Next Web. Retrieved October 30, 2016.
  12. ↑ "System requirements and browsers". Docs editors Help. Retrieved December 16, 2016.
  13. ↑ "Dedicated desktop home pages for Google Docs, Sheets & Slides". G Suite Updates. June 25, 2014. Retrieved December 16, 2016.
  14. ↑ Levee, Brian (April 30, 2014). "New mobile apps for Docs, Sheets and Slides—work offline and on the go". Official Google Blog. Retrieved December 16, 2016.
  15. ↑ Tabone, Ryan (June 25, 2014). "Work with any file, on any device, any time with new Docs, Sheets, and Slides". Google Drive Blog. Retrieved December 16, 2016.
  16. ↑ "New Google Slides, Docs, and Sheets apps for iOS". G Suite Updates. August 25, 2014. Retrieved December 16, 2016.
  17. ↑ "A new look for the Google Docs, Sheets, and Slides viewers on the mobile web". G Suite Updates. July 27, 2015. Retrieved December 16, 2016.
  18. ↑ Meyer, David (August 20, 2009). "Google Apps Script gets green light". CNet. Archived from the original on August 10, 2012. Retrieved March 26, 2011.
  19. ↑ "See the history of changes made to a file". Docs editors Help. Retrieved February 20, 2017.
  20. ↑ "Share a copy of a file in an Office format". G Suite Learning Center. Retrieved August 12, 2019.
  21. ↑ "Google sheet for organizational access".
  22. ↑ Ranjan, Ritcha (September 29, 2016). "Explore in Docs, Sheets and Slides makes work a breeze — and makes you look good, too". Google Docs Blog. Retrieved December 16, 2016.
  23. ↑ Novet, Jordan (September 29, 2016). "Google updates Calendar, Drive, Docs, Sheets, and Slides with machine intelligence features". VentureBeat . Retrieved December 16, 2016.
  24. ↑ Allan, Darren (September 30, 2016). "Google wants to better challenge Microsoft Office with these new features". TechRadar . Future plc . Retrieved December 16, 2016.
  25. ↑ Lardinois, Frederic (June 1, 2017). "Google Sheets now uses machine learning to help you visualize your data". TechCrunch . AOL . Retrieved June 1, 2017.
  26. ↑ Carman, Ashley (June 1, 2017). "Google Sheets is making it easier to create charts through natural language commands". The Verge . Vox Media . Retrieved June 1, 2017.
  27. ↑ Miller, Ron (December 6, 2017). "Latest Google Sheets release helps automate pivot table creation". TechCrunch . Oath Inc. Retrieved December 14, 2017.
  28. ↑ Gagliordi, Natalie (December 6, 2017). "Google brings new AI, machine learning features to Sheets". ZDNet . CBS Interactive . Retrieved December 14, 2017.
  29. ↑ Weber, Ryan (October 19, 2016). "Five new ways to reach your goals faster with G Suite". The Keyword Google Blog. Retrieved December 14, 2016.
  30. ↑ Gupta, Saurabh (March 11, 2014). "Bring a little something extra to Docs and Sheets with add-ons". Google Drive Blog. Retrieved October 30, 2016.
  31. ↑ "Work on Google files offline". Drive Help. Retrieved January 14, 2017.
  32. ↑ "Work on Google files offline". Drive Help. Retrieved January 14, 2017.
  33. ↑ "Work on Google files offline". Drive Help. Retrieved January 14, 2017.
  34. ↑ "Work with Office files". Docs editors Help. Retrieved October 30, 2016.
  35. ↑ "Files you can store in Google Drive". Drive Help. Retrieved November 1, 2019.
  36. ↑ "Insert or delete images or videos". Docs editors Help. Retrieved October 22, 2016.
  37. ↑ "G Suite - Choose a Plan" . Retrieved October 30, 2016.
  38. ↑ "Google Spreadsheets | Charts". Google Developers. Retrieved March 1, 2020.
  39. ↑ "Wikipedia and Wikidata Tools - G Suite Marketplace". gsuite.google.com.
  40. ↑ "Copy and paste text and images" . Retrieved October 30, 2016.
  41. ↑ "Office Editing for Docs, Sheets & Slides". Chrome Web Store . Retrieved October 30, 2016.
  42. ↑ "Remove the Office compatibility app". G Suite Admin Help. Retrieved August 12, 2019.
  43. ↑ Sinha, Shan (February 24, 2011). "Google Cloud Connect for Microsoft Office available to all". Google Drive Blog. Retrieved October 30, 2016.
  44. ↑ White, Charlie (February 24, 2011). "Now Anyone Can Sync Google Docs & Microsoft Office". Mashable . Retrieved October 30, 2016.
  45. ↑ "Migrate from Google Cloud Connect to Google Drive". Apps Documentation and Support. Archived from the original on March 17, 2013. Retrieved October 30, 2016.
  46. ↑ "Google Unveils a New Machine Learning Add-on for Google Sheets, Called Simple ML for Sheets, Which Allows Users to Leverage the Power of Machine Learning Without Any Coding Experience". December 13, 2022.
This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.