Google Docs, Sheets and Slides

Web-based office suite offered by Google
  (Redirected from Google Docs)
Google Docs, Sheets, and Slides
Google Docs, Sheets, and Slides Icons
The Google Docs, Sheets, and Slides icons
Google Docs - example document.png
An example of a document in Google Docs
Developer(s) Google
Initial release March 9, 2006; 11 years ago (2006-03-09)
Stable release(s) [±]
Docs for Android 1.7.052.10 / February 12, 2017; 39 days ago (2017-02-12)[1]
Sheets for Android 1.7.052.07 / February 10, 2017; 41 days ago (2017-02-10)[2]
Slides for Android 1.7.052.06 / February 11, 2017; 40 days ago (2017-02-11)[3]
Docs for iOS 1.2017.04204 / February 8, 2017; 43 days ago (2017-02-08)[4]
Sheets for iOS 1.2017.04204 / February 8, 2017; 43 days ago (2017-02-08)[5]
Slides for iOS 1.2017.04205 / February 8, 2017; 43 days ago (2017-02-08)[6]
Written in JavaScript
Operating system Web, Android, iOS
Available in 83 languages[7]
Type
Website Google Docs
Google Sheets
Google Slides
Google Forms
Developer(s) Google
Initial release October 31, 2012; 4 years ago (2012-10-31)
Development status Active
Operating system Web
Platform Yes
Type Survey software
Website Google Forms

Google Docs, Google Sheets and Google Slides are a word processor, a spreadsheet and a presentation program respectively, all part of a free, web-based software office suite offered by Google within its Google Drive service. The suite allows users to create and edit files online while collaborating with other users in real-time.

The three apps are available as web applications, and as mobile apps for Android and iOS. The apps are compatible with Microsoft Office file formats. The suite also consists of Google Forms (survey software), Google Drawings (diagramming software) and Google Fusion Tables (database manager; experimental[8]).

The suite is tightly integrated with Google Drive. All files created with the apps are by default saved to Google Drive.

While Google Docs has been criticized for traditionally lacking the functionality of Microsoft Office, it has received praise for its simplicity, ease of collaboration and frequent product updates. In 2011, Paul Sawers of The Next Web described Google Docs as a "pretty robust set of free tools that are improving every month".[9]

Contents

HistoryEdit

Google Docs originated from two separate products, Writely and Google Spreadsheets.

 
Writely's beta logo

Writely was a web-based word processor created by the software company Upstartle and launched in August 2005.[9][10] It began as an experiment by programmers Sam Schillace, Steve Newman and Claudia Carpenter, trying out the then-new Ajax technology and the "content editable" function in browsers.[11]

Google Spreadsheets, first launched as a limited test on Google Labs on June 6, 2006,[12] originated from the product XL2Web by 2Web Technologies, which was acquired by Google in June 2005.[citation needed]

On March 9, 2006, Google announced that it had acquired Upstartle. Writely closed registration to its service until the move to Google servers was complete.[13] In August 2006, Writely sent account invitations to everyone who had requested to be placed on a waiting list, and then became publicly available on August 23.[citation needed] Writely continued to maintain its own user system until September 21, 2006, when it was integrated with Google Accounts.[14]

Meanwhile, Google developed Google Spreadsheets using the technology it had acquired from 2Web Technologies in 2005 and launched Google Labs Spreadsheets[12] on June 6, 2006, as the first public component of what would eventually become Google Sheets. It was initially made available to only a limited number of users, on a first-come, first-served basis.[15] 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.[16]

In September 2007, Google released a presentation program for Google Docs,[17][18] which originated from the company's acquisition of Tonic Systems on April 17, 2007.[19]

In July 2009, Google dropped the beta testing status from Google Docs.[20]

In January 2010, Google Docs started allowing users to upload any file type up to 250 MB, with 1 GB of free space and paid storage available for $0.25 per GB per year.[21] This cloud storage feature was eventually reworked when Google Drive was introduced in 2012. Google Drive now serves as the cloud storage service from Google, while Docs, Sheets and Slides serve as the office suite inside Google Drive.[22]

In March 2010, Google acquired DocVerse, an online document collaboration company. DocVerse allowed multiple user online collaboration on Microsoft Office-compatible document formats such as Word, Excel, and PowerPoint.[23] Improvements based on DocVerse were announced and deployed in April 2010.[24]

In June 2012, Google acquired Quickoffice, a "leader in office productivity solutions", with particular emphasis on Quickoffice's "seamless interoperability with popular file formats".[25]

In October 2012, Google Documents, Spreadsheets and Presentations were renamed Google Docs, Sheets and Slides, respectively. At the same time, Chrome apps were released, which provided shortcuts to the services on Chrome's new tab page.[26] Google announced in August 2016 that support for Chrome apps would end on Microsoft Windows, Apple macOS, and Linux computers between 2017 and 2018.[27]

PlatformsEdit

Web appsEdit

Google Docs, Sheets and Slides are available as web applications for Google Chrome, Mozilla Firefox, Internet Explorer, Microsoft Edge, and Apple Safari web browsers.[28]

Users can access all documents, spreadsheets and presentations, among other files, collectively through the Google Drive website. In June 2014, Google started rolling out dedicated website homepages for Docs, Sheets and Slides that contain only files created with each respective service.[29]

Mobile appsEdit

In 2014, Google launched dedicated mobile apps for Google Docs, Sheets and Slides on the Android and iOS mobile operating systems.[30][31][32]

In 2015, the mobile websites for Docs, Sheets and Slides were updated with "simpler, more uniform" interfaces for each, and while users can read files through the mobile websites, users trying to edit will be redirected towards the dedicated mobile apps, thus preventing editing on the mobile web.[33]

In January 2017, Google announced that certain legacy versions of the Google Docs, Sheets and Slides mobile apps would be shut down on April 3, 2017, delivering a prompt that requires users to update to newer versions. App versions being shut down include:[34]

  • Docs versions for Android earlier than 1.6.292 and for iOS earlier than 1.2016.12204
  • Sheets versions for Android earlier than 1.6.292 and for iOS earlier than 1.2016.12208
  • Slides versions for Android earlier than 1.6.292 and for iOS earlier than 1.2016.12203

FeaturesEdit

EditingEdit

Collaboration and revision historyEdit

The suite serves as a collaborative tool for cooperative editing of documents, spreadsheets and presentations 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 automatically saved to Google's servers, and a revision history is automatically kept so past edits may be viewed and reverted to.[35] 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 (ODF, HTML, PDF, RTF, Text, Office Open XML). Files can be tagged and archived for organizational purposes.

ExploreEdit

Launched in September 2016, "Explore" enables additional functionality through machine learning.[36][37][38]

  • In Google Docs, Explore shows relevant Google search results based on information in the document, simplifying information gathering. Users can also mark specific document text, press Explore and see search results based on the marked text only.
  • 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 Google Slides, Explore dynamically generates design suggestions based on the contents of each slide.

The "Explore" features in Docs follow the launch of a more basic research tool originally introduced in 2012.[39][40][41]

In December 2016, Google introduced a quick citations feature to Google Docs. The quick citation tool allows users to "insert citations as footnotes with the click of a button" on the web through the Explore feature introduced in September. The citation feature also marked the launch of the Explore functionalities in G Suite for Education accounts.[42][43][44]

Suggested editsEdit

In June 2014, Google introduced "Suggested edits" in Google Docs; as part of the "commenting access" permission, participants can come up with suggestions for edits that the author can accept or reject, in contrary to full editing ability.[31]

Action itemsEdit

In October 2016, Google announced "Action items" to Docs, Sheets, and Slides. If a user writes phrases such as "Ryan to follow up on the keynote script", the respective service will intelligently assign that action to "Ryan". Google states this will make it easier for other collaborators to see which person is responsible for what task. When a user visits Google Drive, Docs, Sheets or Slides, any files with tasks assigned to them will be highlighted with a badge.[45]

Add-onsEdit

In March 2014, Google introduced add-ons; new tools from third-party developers that add more features for Google Docs and Google Sheets.[46]

OfflineEdit

In order to view and edit documents, spreadsheets and presentations 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 support for Docs, Sheets and Slides files on the Google Drive website.[47]

The Android and iOS apps natively support offline editing.[48][49]

FilesEdit

Supported file formatsEdit

Files in the following formats can be viewed and converted to Docs, Sheets or Slides formats:[50]

  • For documents: .doc (if newer than Microsoft Office 95), .docx, .docm .dot, .dotx, .dotm, .html, plain text (.txt), .rtf, .odt
  • For spreadsheets: .xls (if newer than Microsoft Office 95), .xlsx, .xlsm, .xlt, .xltx, .xltm .ods, .csv, .tsv, .txt, .tab
  • For presentations: .ppt (if newer than Microsoft Office 95), .pptx, .pptm, .pps, .ppsx, .ppsm, .pot, .potx, .potm
  • For drawings: .wmf
  • For optical character recognition: .jpg, .gif, .png, .pdf

File limitsEdit

There are limits, specific to file type, listed below:[51][52]

Documents (Google Docs)
Up to 1.02 million characters, regardless of the number of pages or font size. Document files converted to .gdoc Docs format cannot be larger than 50 MB. Images inserted cannot be larger than 50 MB, and must be in either .jpg, .png, or non-animated .gif formats.
Spreadsheets (Google Sheets)
Up to 2 million cells.
Presentations (Google Slides)
Presentation files converted to .gslides Slides format cannot be larger than 100 MB. Images inserted cannot be larger than 50 MB, and must be in either .jpg, .png, or non-animated .gif formats.

G SuiteEdit

The Google Docs, Sheets, and Slides suite is free to use for individuals, but it is also available as part of the business-centered G Suite service by Google, which is a monthly subscription that enables additional business-focused functionality.[53]

Other functionalityEdit

A simple find and replace tool is available.

Google Docs includes a web clipboard tool that allows users to copy and paste content between Google Docs, Sheets, Slides and 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. For most copying and pasting, Google Docs also supports keyboard shortcuts.[54]

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 Office documents on Google Chrome, via the Docs, Sheets and Slides apps. The extension can be used for opening Office files stored on the computer using Chrome, as well as for opening Office 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 Chrome OS by default.[55]

Discontinued functionalityEdit

Google Cloud Connect was a plug-in for Microsoft Office 2003, 2007 and 2010 that could automatically store and synchronize any Word document, PowerPoint presentation, or Excel spreadsheet to Google Docs (before the introduction of Drive) in Google Docs or Microsoft Office formats. The online copy was automatically updated each time the Microsoft Office document was saved. Microsoft Office documents could be edited offline and synchronized later when online. Google Cloud Connect maintained previous Microsoft Office document versions and allowed multiple users to collaborate by working on the same document at the same time.[56][57]

However, Google Cloud Connect has been discontinued as of April 30, 2013, as Google Drive achieves all of the above tasks, with better results.[58]

Google Forms and Google DrawingsEdit

Google FormsEdit

Google Forms is a tool that allows collecting information from users via a personalized survey or quiz. The information is then collected and automatically connected to a spreadsheet. The spreadsheet is populated with the survey and quiz responses.[59]

The Forms service has also received updates over the years. New features include, but are not limited to, menu search, shuffle of questions for randomized order, limiting responses to once per person, shorter URLs,[60] custom themes,[61] automatically generating answer suggestions when creating forms, and an "Upload file" option for users answering to share content through.[45]

In October 2014, Google introduced add-ons for Google Forms, that enable third-party developers to make new tools for more features in surveys.[62]

Google DrawingsEdit

Google Drawings allows users to collaborate creating, sharing, and editing images or drawings. Google Drawings can be used for creating charts, diagrams, designs, flow-charts, etc. It contains a subset of the features in Google Slides but with different templates. Its features include laying out drawings precisely with alignment guides, snap to grid, auto distribution, and inserting drawings into other Google documents, spreadsheets, or presentations.[63]

IssuesEdit

2009 document sharing incidentEdit

In early March 2009, a privacy error caused documents to be shared without user consent. Google released a statement, specifying that "sharing was limited to people with whom you, or a collaborator with sharing rights, had previously shared a document." The issue was fixed by Google, and followed by a statement that "less than 0.05% of documents" had been affected by the issue. Furthermore, Google said it has "extensive safeguards in place to protect all documents, and are confident this was an isolated incident."[64]

However, later the same month, security consultant Ade Barkah wrote on his blog about security issues with the software suite. Issues included that embedded images in private documents could be viewed publicly on the Internet (even after document deletion); when users got access to a document that included a diagram (a new feature at the time), the new user could see any previous version of the diagram (including any sensitive information that was removed before sharing); and in some scenarios, users who had access rights removed from a document could still access the document without the owner's knowledge. Google released a statement that it takes "the security of our users’ information very seriously", but "based on the information we’ve received, we do not believe there are significant security issues with Google Docs". The statement finished with, "We will share more information as soon as it’s available."[65][66]

See alsoEdit

ReferencesEdit

  1. ^ "Google Docs". APKMirror. Android Police. February 10, 2017. Retrieved February 13, 2017. 
  2. ^ "Google Sheets". APKMirror. Android Police. February 10, 2017. Retrieved February 13, 2017. 
  3. ^ "Google Slides". APKMirror. Android Police. February 11, 2017. Retrieved February 13, 2017. 
  4. ^ "Google Docs". iTunes Store. Apple Inc. February 8, 2017. Retrieved February 13, 2017. 
  5. ^ "Google Sheets". iTunes Store. Apple Inc. February 8, 2017. Retrieved February 13, 2017. 
  6. ^ "Google Slides". iTunes Store. Apple Inc. February 8, 2017. Retrieved February 13, 2017. 
  7. ^ Hill, Ian (June 18, 2013). "18 New Languages for Drive, Docs, Sheets, and Slides". Google Drive Blog. Google. Retrieved October 29, 2016. 
  8. ^ "About Fusion Tables". Fusion Tables Help. Google. Retrieved January 14, 2017. 
  9. ^ a b Sawers, Paul (September 2, 2011). "15 tips to get the most out of Google Docs". The Next Web. Retrieved October 29, 2016. 
  10. ^ Chang, Emily (October 5, 2005). "eHub Interviews Writely". eHub. Archived from the original on July 22, 2011. Retrieved October 29, 2016. 
  11. ^ Hamburger, Ellis (July 3, 2013). "Google Docs began as a hacked together experiment, says creator". The Verge. Vox Media. Retrieved October 29, 2016. 
  12. ^ a b "Google Announces limited test on Google Labs: Google Spreadsheets". Google. June 6, 2006. Retrieved October 29, 2016. 
  13. ^ Mazzon, Jen (March 9, 2006). "Writely so". Official Google Blog. Google. Retrieved October 29, 2016. 
  14. ^ "Google Account Sign-in LIVE". Writely. September 21, 2016. Retrieved October 29, 2016. 
  15. ^ Rochelle, Jonathan (June 6, 2006). "It's nice to share". Official Google Blog. Google. Retrieved October 29, 2016. 
  16. ^ "Google Announces Google Docs & Spreadsheets". Google. October 11, 2006. Retrieved October 29, 2016. 
  17. ^ Bodis, Attila (September 17, 2007). "Our feature presentation". Official Google Blog. Google. Retrieved October 30, 2016. 
  18. ^ Trapani, Gina (September 18, 2007). "Google Docs Adds Presentations". Lifehacker. Retrieved October 30, 2016. 
  19. ^ Schillace, Sam (April 17, 2007). "We're expecting". Official Google Blog. Google. Retrieved December 11, 2016. 
  20. ^ Glotzbach, Matthew (July 7, 2009). "Google Apps is out of beta (yes, really)". Official Google Blog. Google. Retrieved October 30, 2016. 
  21. ^ Bangaru, Vijay (January 12, 2010). "Upload and store your files in the cloud with Google Docs". Google Drive Blog. Google. Retrieved December 14, 2016. 
  22. ^ Pichai, Sundar (April 24, 2012). "Introducing Google Drive... yes, really". Official Google Blog. Google. Retrieved October 30, 2016. 
  23. ^ Jackson, Rob (March 5, 2010). "Google Buys DocVerse For Office Collaboration: Chrome, Android & Wave Implications?". Phandroid. Retrieved October 20, 2016. 
  24. ^ Belomestnykh, Olga (April 15, 2010). "A rebuilt, more real time Google documents". Google Drive Blog. Google. Retrieved October 30, 2016. 
  25. ^ Warren, Alan (June 5, 2012). "Google + Quickoffice = get more done anytime, anywhere". Official Google Blog. Google. Retrieved October 30, 2016. 
  26. ^ 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. 
  27. ^ Welch, Chris (August 19, 2016). "Google will end support for Chrome apps on Windows, Mac, and Linux". The Verge. Vox Media. Retrieved January 14, 2017. 
  28. ^ "System requirements and browsers". Docs editors Help. Google. Retrieved December 16, 2016. 
  29. ^ "Dedicated desktop home pages for Google Docs, Sheets & Slides". G Suite Updates. Google. June 25, 2014. Retrieved December 16, 2016. 
  30. ^ Levee, Brian (April 30, 2014). "New mobile apps for Docs, Sheets and Slides—work offline and on the go". Official Google Blog. Google. Retrieved December 16, 2016. 
  31. ^ a b Tabone, Ryan (June 25, 2014). "Work with any file, on any device, any time with new Docs, Sheets, and Slides". Google Drive Blog. Google. Retrieved December 16, 2016. 
  32. ^ "New Google Slides, Docs, and Sheets apps for iOS". G Suite Updates. Google. August 25, 2014. Retrieved December 16, 2016. 
  33. ^ "A new look for the Google Docs, Sheets, and Slides viewers on the mobile web". G Suite Updates. Google. July 27, 2015. Retrieved December 16, 2016. 
  34. ^ "Legacy versions of Google Drive, Docs, Sheets, and Slides mobile apps shutting down on April 3, 2017". G Suite Updates. Google. January 19, 2017. Retrieved January 20, 2017. 
  35. ^ "See the history of changes made to a file". Docs editors Help. Google. Retrieved February 20, 2017. 
  36. ^ Ranjan, Ritcha (September 29, 2016). "Explore in Docs, Sheets and Slides makes work a breeze — and makes you look good, too". Google Docs Blog. Google. Retrieved December 16, 2016. 
  37. ^ Novet, Jordan (September 29, 2016). "Google updates Calendar, Drive, Docs, Sheets, and Slides with machine intelligence features". VentureBeat. Retrieved December 16, 2016. 
  38. ^ Allan, Darren (September 30, 2016). "Google wants to better challenge Microsoft Office with these new features". TechRadar. Future plc. Retrieved December 16, 2016. 
  39. ^ Duddu, Sarveshwar (May 15, 2012). "Find facts and do research inside Google Documents". Official Google Cloud Blog. Google. Retrieved December 14, 2016. 
  40. ^ Robertson, Adi (May 15, 2012). "Google Docs Research sidebar looks up terms, adds images, quotes, and citations". The Verge. Vox Media. Retrieved December 14, 2016. 
  41. ^ Weber, Harrison (May 15, 2012). "Useful! Google Docs introduces new sidebar research tool". The Next Web. Retrieved December 14, 2016. 
  42. ^ "Quickly and easily cite your sources with Explore in Google Docs". G Suite Updates. Google. December 5, 2016. Retrieved December 6, 2016. 
  43. ^ Palmer, Jordan (December 5, 2016). "Explore in Google Docs gets new quick source citations". Android Police. Retrieved December 6, 2016. 
  44. ^ Garun, Natt (December 5, 2016). "Google Docs adds a quick citation button just in time for finals season". The Verge. Vox Media. Retrieved December 6, 2016. 
  45. ^ a b Weber, Ryan (October 19, 2016). "Five new ways to reach your goals faster with G Suite". The Keyword Google Blog. Google. Retrieved December 14, 2016. 
  46. ^ Gupta, Saurabh (March 11, 2014). "Bring a little something extra to Docs and Sheets with add-ons". Google Drive Blog. Google. Retrieved October 30, 2016. 
  47. ^ "Work on Google files offline". Drive Help. Google. Retrieved January 14, 2017. 
  48. ^ "Work on Google files offline". Drive Help. Google. Retrieved January 14, 2017. 
  49. ^ "Work on Google files offline". Drive Help. Google. Retrieved January 14, 2017. 
  50. ^ "Work with Office files". Docs editors Help. Google. Retrieved October 30, 2016. 
  51. ^ "Files you can store in Google Drive". Drive Help. Google. Retrieved October 22, 2016. 
  52. ^ "Insert or delete images or videos". Docs editors Help. Google. Retrieved October 22, 2016. 
  53. ^ "G Suite - Choose a Plan". Retrieved October 30, 2016. 
  54. ^ "Copy and paste text and images". Retrieved October 30, 2016. 
  55. ^ "Office Editing for Docs, Sheets & Slides". Chrome Web Store. Google. Retrieved October 30, 2016. 
  56. ^ Sinha, Shan (February 24, 2011). "Google Cloud Connect for Microsoft Office available to all". Google Drive Blog. Google. Retrieved October 30, 2016. 
  57. ^ White, Charlie (February 24, 2011). "Now Anyone Can Sync Google Docs & Microsoft Office". Mashable. Retrieved October 30, 2016. 
  58. ^ "Migrate from Google Cloud Connect to Google Drive". Apps Documentation and Support. Google. Archived from the original on March 17, 2013. Retrieved October 30, 2016. 
  59. ^ "Create a survey using Google Forms". Docs editors Help. Google. Retrieved October 30, 2016. 
  60. ^ "More ways to build and share Google Forms". G Suite Updates. Google. September 29, 2014. Retrieved December 12, 2016. 
  61. ^ "Custom themes in Google Forms". G Suite Updates. Google. September 2, 2014. Retrieved December 12, 2016. 
  62. ^ "Add-ons for Google Forms". G Suite Updates. Google. October 23, 2014. Retrieved December 12, 2016. 
  63. ^ "Create & edit drawings". Docs editors Help. Google. Retrieved October 30, 2016. 
  64. ^ Kincaid, Jason (March 7, 2009). "Google Privacy Blunder Shares Your Docs Without Permission". TechCrunch. AOL. Retrieved November 27, 2016. 
  65. ^ Ade (March 26, 2009). "Security issues with Google Docs". Peekay.org. Retrieved November 27, 2016. 
  66. ^ Wauters, Robin (March 26, 2009). "More Security Loopholes Found In Google Docs". TechCrunch. AOL. Retrieved November 27, 2016. 

Further readingEdit

  • Conner, Nancy (2008). Google Apps: The Missing Manual. Sebastopol: Pogue Press. ISBN 978-0-596-51579-9. 

External linksEdit