Google Sheets
{{short description|Cloud-based spreadsheet software}}
{{Use American English|date=December 2022}}
{{Use mdy dates|date=December 2022}}
{{Infobox software
| name = Google Sheets
| title = Google Sheets
| logo = Google Sheets 2020 Logo.svg
| logo_size = 70px
| logo caption =
| screenshot = Google Sheets Untitled spreadsheet.png
| caption = Screenshot of a Google Sheets spreadsheet
| author =
| developer = Google LLC
| released = {{start date and age|2006|3|9}}
| ver layout = stacked
| latest release version = {{Latest stable software release/Google Workspace}}
| programming language = JavaScript
| platform =
| operating system = Android, iOS, ChromeOS
| language count = 83
| genre = {{Plainlist |
}}
| website = {{URL|https://google.com/sheets}}
}}
Google Sheets is a spreadsheet application and 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.{{cite web |title=Office editing makes it easier to work with Office files in Docs, Sheets, and Slides |url=https://gsuiteupdates.googleblog.com/2019/04/office-editing.html |website=G Suite Updates Blog |access-date=August 12, 2019}} 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.
History
Google Sheets originated from XL2Web, a web-based spreadsheet application developed by 2Web Technologies, founded by Jonathan Rochelle and Farzad "Fuzzy" Khosrowshahi.{{Cite web|last=Surden|first=Esther|date=June 26, 2013|title=At Madison Meetup, NJ's Rochelle Talks XL2Web Acquisition by Google|url=https://njtechweekly.com/at-madison-meetup-njs-rochelle-talks-xl2web-acquisition-by-google/|access-date=October 15, 2021|website=NJ Tech Weekly|language=en-US}} XL2Web was acquired by Google in 2006{{cite web |first=Christopher |last=Dawson |title=Google's 40 acquisitions in 2010: What about integration? |url=https://www.zdnet.com/article/googles-40-acquisitions-in-2010-what-about-integration/ |website=ZDNet |publisher=CBS Interactive |date=October 30, 2010 |access-date=June 1, 2017}} 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.{{cite web |first=Jonathan |last=Rochelle |title=It's nice to share |url=https://googleblog.blogspot.no/2006/06/its-nice-to-share.html |website=Official Google Blog |date=June 6, 2006 |access-date=October 29, 2016}}{{cite web |title=Google Announces limited test on Google Labs: Google Spreadsheets |url=http://googlepress.blogspot.no/2006/06/google-announces-limited-test-on-google_06.html |date=June 6, 2006 |access-date=October 29, 2016}} 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.{{cite web |title=Google Announces Google Docs & Spreadsheets |url=http://googlepress.blogspot.no/2006/10/google-announces-google-docs_11.html |date=October 11, 2006 |access-date=October 29, 2016}} 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.{{cite web |first=Rob |last=Jackson |title=Google Buys DocVerse For Office Collaboration: Chrome, Android & Wave Implications? |url=http://phandroid.com/2010/03/05/google-buys-docverse-for-office-collaboration-chrome-android-wave-implications/ |website=Phandroid |date=March 5, 2010 |access-date=October 20, 2016}} Improvements based on DocVerse were announced and deployed in April 2010.{{cite web |first=Olga |last=Belomestnykh |title=A rebuilt, more real-time Google documents |url=https://drive.googleblog.com/2010/04/a-rebuilt-more-real-time-google.html |website=Google Drive Blog |date=April 15, 2010 |access-date=October 30, 2016}} In June 2012, Google acquired Quickoffice, a freeware proprietary productivity suite for mobile devices.{{cite web |first=Alan |last=Warren |title=Google + Quickoffice = get more done anytime, anywhere |url=https://googleblog.blogspot.no/2012/06/google-quickoffice-get-more-done.html |website=Official Google Blog |date=June 5, 2012 |access-date=October 30, 2016}} 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.{{cite web |first=Paul |last=Sawers |title=Google Drive apps renamed "Docs, Sheets and Slides", now available in the Chrome Web Store |url=https://thenextweb.com/google/2012/10/23/google-drive-apps-renamed-docs-sheets-and-slides-now-available-in-the-chrome-web-store/ |website=The Next Web |date=October 23, 2012 |access-date=October 30, 2016}}
Platforms
Google Sheets is available as a web application supported on: Google Chrome, Microsoft Edge, Firefox, and Safari web browsers.{{cite web |title=System requirements and browsers |url=https://support.google.com/docs/answer/2375082 |website=Docs editors Help |access-date=December 16, 2016}} 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.{{cite web |title=Dedicated desktop home pages for Google Docs, Sheets & Slides |url=https://gsuiteupdates.googleblog.com/2014/06/dedicated-desktop-home-pages-for-google.html |website=G Suite Updates |date=June 25, 2014 |access-date=December 16, 2016}} In 2014, Google launched a dedicated mobile app for Sheets on the Android and iOS mobile operating systems.{{cite web |first=Brian |last=Levee |title=New mobile apps for Docs, Sheets and Slides—work offline and on the go |url=https://googleblog.blogspot.com/2014/04/new-mobile-apps-for-docs-sheets-and.html |website=Official Google Blog |date=April 30, 2014 |access-date=December 16, 2016}}{{cite web |first=Ryan |last=Tabone |title=Work with any file, on any device, any time with new Docs, Sheets, and Slides |url=https://drive.googleblog.com/2014/06/newdocssheetsslides.html |website=Google Drive Blog |date=June 25, 2014 |access-date=December 16, 2016}}{{cite web |title=New Google Slides, Docs, and Sheets apps for iOS |url=https://gsuiteupdates.googleblog.com/2014/08/new-google-slides-docs-and-sheets-apps.html |website=G Suite Updates |date=August 25, 2014 |access-date=December 16, 2016}} 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.{{cite web |title=A new look for the Google Docs, Sheets, and Slides viewers on the mobile web |url=https://gsuiteupdates.googleblog.com/2015/07/a-new-look-for-google-docs-sheets-and.html |website=G Suite Updates |date=July 27, 2015 |access-date=December 16, 2016}}
{{Infobox software
| name = Apps Script
| developer = Google
| released = {{Start date and age|2009|8|19}}{{cite news|last=Meyer|first=David|title=Google Apps Script gets green light|url=http://news.cnet.com/8301-1001_3-10314002-92.html|access-date=March 26, 2011|newspaper=CNet|date=August 20, 2009|archive-date=August 10, 2012|archive-url=https://web.archive.org/web/20120810230818/http://news.cnet.com/8301-1001_3-10314002-92.html|url-status=dead}}
| programming language = JavaScript
| genre = Web application framework, scripting language
| website = {{URL|https://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.{{cite web |title=See the history of changes made to a file |url=https://support.google.com/docs/answer/190843 |website=Docs editors Help |access-date=February 20, 2017}} 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.{{cite web |title=Share a copy of a file in an Office format |url=https://support.google.com/a/users/answer/9308757?hl=en |website=G Suite Learning Center |access-date=August 12, 2019}} Sheets supports tagging for archival and organizational purposes.{{cite web|title= Google sheet for organizational access|url=https://docs.google.com/spreadsheets/d/e/2PACX-1vRMUG7FvU_k5OOtiXGZ69bCd4xHjdQEaWflhE9NZfKjD1z0fgJ4g_2EcY_g4acoL749ZgfPrBsQad9F/pubhtml}}
== Explore ==
Launched for the entire Drive suite in September 2016, "Explore" enables additional functionality through machine learning.{{cite web |first=Ritcha |last=Ranjan |title=Explore in Docs, Sheets and Slides makes work a breeze — and makes you look good, too |url=https://docs.googleblog.com/2016/09/ExploreinDocsSheetsSlides.html |website=Google Docs Blog |date=September 29, 2016 |access-date=December 16, 2016}}{{cite web |first=Jordan |last=Novet |title=Google updates Calendar, Drive, Docs, Sheets, and Slides with machine intelligence features |url=https://venturebeat.com/2016/09/29/google-updates-calendar-drive-docs-sheets-and-slides-with-machine-intelligence-features/ |website=VentureBeat |date=September 29, 2016 |access-date=December 16, 2016}}{{cite web |first=Darren |last=Allan |title=Google wants to better challenge Microsoft Office with these new features |url=http://www.techradar.com/news/software/google-wants-to-better-challenge-microsoft-office-with-these-new-features-1329658 |website=TechRadar |publisher=Future plc |date=September 30, 2016 |access-date=December 16, 2016}} 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{{cite web |first=Frederic |last=Lardinois |title=Google Sheets now uses machine learning to help you visualize your data |url=https://techcrunch.com/2017/06/01/google-sheets-now-uses-machine-learning-to-automatically-visualize-your-data/ |website=TechCrunch |publisher=AOL |date=June 1, 2017 |access-date=June 1, 2017}}{{cite web |first=Ashley |last=Carman |title=Google Sheets is making it easier to create charts through natural language commands |url=https://www.theverge.com/2017/6/1/15724970/google-sheets-update-charts-explore-sync-data |website=The Verge |publisher=Vox Media |date=June 1, 2017 |access-date=June 1, 2017}} and again expanded it in December to feature machine learning capable of automatically creating pivot tables.{{cite web |first=Ron |last=Miller |title=Latest Google Sheets release helps automate pivot table creation |url=https://techcrunch.com/2017/12/06/latest-google-sheets-release-adds-smarts-to-pivot-table-creation/ |website=TechCrunch |publisher=Oath Inc. |date=December 6, 2017 |access-date=December 14, 2017}}{{cite web |first=Natalie |last=Gagliordi |title=Google brings new AI, machine learning features to Sheets |url=https://www.zdnet.com/article/google-brings-new-ai-machine-learning-features-to-sheets/ |website=ZDNet |publisher=CBS Interactive |date=December 6, 2017 |access-date=December 14, 2017}} 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.{{cite web |first=Ryan |last=Weber |title=Five new ways to reach your goals faster with G Suite |url=https://www.blog.google/products/g-suite/five-new-ways-reach-your-goals-faster-g-suite/ |website=The Keyword Google Blog |date=October 19, 2016 |access-date=December 14, 2016}} In March 2014, Google introduced add-ons; new tools from third-party developers that add more features for Google Sheets.{{cite web |first=Saurabh |last=Gupta |title=Bring a little something extra to Docs and Sheets with add-ons |url=https://drive.googleblog.com/2014/03/add-ons.html |website=Google Drive Blog |date=March 11, 2014 |access-date=October 30, 2016}}
==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.{{cite web |title=Work on Google files offline |url=https://support.google.com/drive/answer/2375012 |website=Drive Help |access-date=January 14, 2017}} The Android and iOS apps natively support offline editing.{{cite web |title=Work on Google files offline |url=https://support.google.com/drive/answer/2375012?co=GENIE.Platform%3DAndroid&oco=1 |website=Drive Help |access-date=January 14, 2017}}{{cite web |title=Work on Google files offline |url=https://support.google.com/drive/answer/2375012?co=GENIE.Platform%3DiOS&oco=1 |website=Drive Help |access-date=January 14, 2017}}
= 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{{cite web |title=Work with Office files |url=https://support.google.com/docs/answer/6055139 |website=Docs editors Help |access-date=October 30, 2016}} Overall document size is capped at 10 million cells.{{cite web|url=https://support.google.com/drive/answer/37603|title=Files you can store in Google Drive|website=Drive Help|access-date=November 1, 2019}}{{cite web |title=Insert or delete images or videos |url=https://support.google.com/docs/answer/97447 |website=Docs editors Help |access-date=October 22, 2016}}
= 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.{{cite web |title=G Suite - Choose a Plan |url=https://gsuite.google.com/pricing.html |access-date=October 30, 2016}}
= Integration with Charts and Wikipedia =
Sheets can produce Google Charts{{cite web |title=Google Spreadsheets {{!}} Charts |url=https://developers.google.com/chart/interactive/docs/spreadsheets |website=Google Developers |access-date=March 1, 2020 |language=en}} and has a third-party plugin which allows for integration with Wikipedia.{{cite web |title=Wikipedia and Wikidata Tools - G Suite Marketplace |url=https://gsuite.google.com/marketplace/app/wikipedia_and_wikidata_tools/595109124715?pann=cwsdp&hl=en |website=gsuite.google.com}}
= 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.{{cite web |title=Copy and paste text and images |url=https://support.google.com/docs/answer/161768 |access-date=October 30, 2016}}
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.{{cite web |title=Office Editing for Docs, Sheets & Slides |url=https://chrome.google.com/webstore/detail/office-editing-for-docs-s/gbkeegbaiigmenfmjfclcdgdpimamgkj |website=Chrome Web Store |access-date=October 30, 2016}} As of June 2019, this extension is no longer required since the functionality exists natively.{{cite web |title=Remove the Office compatibility app |url=https://support.google.com/a/answer/9306273 |website=G Suite Admin Help |access-date=August 12, 2019}}
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.{{cite web |first=Shan |last=Sinha |title=Google Cloud Connect for Microsoft Office available to all |url=https://drive.googleblog.com/2011/02/google-cloud-connect-for-microsoft.html |website=Google Drive Blog |date=February 24, 2011 |access-date=October 30, 2016}}{{cite web |first=Charlie |last=White |title=Now Anyone Can Sync Google Docs & Microsoft Office |url=http://mashable.com/2011/02/24/google-cloud-connect-2/ |website=Mashable |date=February 24, 2011 |access-date=October 30, 2016}} 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".{{cite web|title=Migrate from Google Cloud Connect to Google Drive |url=https://support.google.com/a/bin/answer.py?hl=en&answer=3017040 |website=Apps Documentation and Support |archive-url=https://web.archive.org/web/20130317181727/https://support.google.com/a/bin/answer.py?hl=en&answer=3017040 |archive-date=March 17, 2013 |access-date=October 30, 2016 |url-status=dead }}
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.{{cite web|url=https://www.marktechpost.com/2022/12/13/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/|title=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|date=December 13, 2022}}
See also
References
{{Reflist}}
External links
- {{Official website|https://www.google.com/sheets/about/}}
{{Spreadsheets}}
{{Google LLC}}
Category:Spreadsheet software for macOS
Category:Spreadsheet software for Windows