Google Docs, Sheets, and Slides

From Infogalactic: the planetary knowledge core
(Redirected from Google Spreadsheets)
Jump to: navigation, search
Google Docs, Sheets, and Slides
Google Docs, Sheets, and Slides Icons
The Google Docs, Sheets, and Slides icons
<templatestyles src="Template:Hidden begin/styles.css"/>
Screenshot
300px
An example of a document in Google Docs
Developer(s) Google
Initial release March 9, 2006; 18 years ago (2006-03-09)
Stable release 6000 / 2020
Preview release 6000 / 7000
Written in JavaScript
Operating system Web, Chrome, Android, iOS
Platform Yes
Available in 53 languages[1]
Type <templatestyles src="Plainlist/styles.css"/>
Website Google Docs
Google Sheets
Google Slides
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 documents online while collaborating with other users in real-time.

The three apps are available as web applications, as Chrome apps that work offline, 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). While Forms and Tables are only available as web applications, Drawings is also available as a Chrome app.

The suite is tightly integrated with Google Drive.[2] 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 The Next Web described Google Docs as a "pretty robust set of free tools that are improving every month".[3]

History

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

File:Writely logo.PNG
Writely's beta logo

Writely was a web-based word processor created by the software company Upstartle and launched in August 2005.[4] 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.[5] Writely's original features included a collaborative text editing suite and access controls.[citation needed] Menus, keyboard shortcuts, and dialog boxes are similar to what users may expect in a desktop word processor such as Microsoft Word or LibreOffice Writer.

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

On March 9, 2006, Google announced that it had acquired Upstartle.[7] At the time of acquisition, Upstartle had four employees.[8] Writely closed registration to its service until the move to Google servers was complete.[7] 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. Writely continued to maintain its own user system until September 19, 2006, when it was integrated with Google Accounts.[9]

Writely originally ran on Microsoft ASP.NET technology which uses Microsoft Windows. Since July 2006, Writely servers appear to be running a Linux-based operating system.[10]

Meanwhile, Google developed Google Spreadsheets using the technology it had acquired from 2Web Technologies in 2005 and launched Google Labs Spreadsheets[6][11] on June 6, 2006, as the first public component of what would eventually become Google Docs. It was initially made available to only a limited number of users, on a first-come, first-served basis. The limited test was later replaced with a beta version available to all Google Account holders, around the same time as a press release was issued.[12]

Summary of developments

  • In February 2007, Google Docs was made available to Google Apps users.
  • In June 2007, Google changed the front page to include folders instead of labels, organized in a side bar.[citation needed]
  • On September 17, 2007, Google released a presentation program for Google Docs, which originated from the company's acquisition of Tonic Systems on April 17, 2007.[13][14]
  • On July 6, 2009, Google announced on its official blog that Google Docs, along with other Google Apps, would be taken out of beta.[15]
  • On January 12, 2010, Google announced on its official blog that Google Docs would allow storage of any file type, with 1 GB of free space and $0.25/GB for additional storage.[16]
  • On January 29, 2010, Google announced that support for Internet Explorer 6 would end on March 1.[17]
  • On March 7, 2010, DocVerse, an online document collaboration company, was acquired by Google.[18] It allows multiple user online collaboration on Microsoft Office compatible document formats such as Word, Excel, and PowerPoint.[19] Improvements based on DocVerse were announced and deployed in April 2010.[20]
  • On April 12, 2010, Google launched a standalone drawings editor into the Google Docs suite.[21]
  • In June 2010, it was reported that access to Google Docs had been blocked in Turkey.[22] A Google employee confirmed the problem saying that it "appear[ed] to be linked to the ongoing ban on YouTube."[23]
  • On January 31, 2011, Google began to test a new homepage for docs.google.com. This shows users all of the files, documents or not without having to go to multiple places.[24]
  • As of September 29, 2011, Google Docs supported offline viewing through an opt-in beta HTML 5 web app.[25]
  • On 24 April 2012, Google launched Google Drive, which supplants Google Docs. It combines all of the Docs features with improved storage functionality.[26] This also incorporates the Google Docs service into Google Drive. Google Docs' URL now redirects to Google Drive.
  • On 15 May 2012, a research tool was introduced in Google Docs.[27]
  • In June 2012, Google announced that it had acquired Quickoffice, a leader in office productivity solutions.[28]
  • On 28 June 2012, offline editing was made available to Google Docs on Chrome and Chrome OS. The capability was announced at Google I/O by Clay Bavor, director of product management for Google Apps. Bavor stated that the company was also working on offline support for spreadsheets and presentations.[29]
  • In October 2012, following the launch of Google Drive, 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.[30]
  • On 23 January 2013, offline support was extended to Google Slides.[31]
  • On 11 December 2013, Google released a new version of Google Sheets on the Chrome Web Store that added offline support and removed most of the spreadsheet size restrictions, among other improvements.[32]
  • On 11 March 2014, Google introduced add-ons for Google Docs and Google Sheets.[33]
  • On 30 April 2014, Google announced standalone mobile apps for Google Docs, Google Sheets and Google Slides on Android and iOS. While Docs and Sheets were made available on both platforms immediately, Slides was announced to be "coming soon".[34]
  • On 25 June 2014 at the Google I/O, Google Slides was released for Android, while the iOS version was announced to be released over the "coming weeks". At the same time, a new collaborative feature called 'Suggested Edits' was introduced. A new Chrome extension called 'Office Editing for Docs, Sheets and Slides' was also introduced.[35]
  • Towards the end of July 2014, Google launched individual home screens for Google Docs, Sheets and Slides on the web. The interfaces incorporate Google's new Material Design language with a simplified menu and extensive use of colours, and is similar to the interface on the mobile apps. Users can still access all of their files collectively through Google Drive.[36]

Features

Google Docs is Google's "software as a service" office suite. Documents, spreadsheets, presentations can be created with Google Docs, imported through the web interface, or sent via email. Documents are automatically saved to Google's servers, and a revision history is automatically kept so past edits may be viewed (although this only works for adjacent revisions). In the Google Chrome browser, the contents of the user's Google Drive are downloaded to the computer so that documents may be edited offline.[37] Documents can also be exported to a user's local computer in a variety of formats (ODF, HTML, PDF, RTF, Text, Office Open XML). Documents can be tagged and archived for organizational purposes. The service is officially supported on recent versions of the Firefox, Internet Explorer, Safari and Chrome browsers running on Microsoft Windows, Apple OS X, and Linux operating systems.[38]

Google Docs serves as a collaborative tool for editing documents 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. Users cannot be notified of changes, but the application can notify users when a comment or discussion is made or replied to, facilitating collaboration. There is no way to highlight changes made by a particular editor in real time during a writing session, nor a way to jump to the changes made. However, 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 editors to discuss edits. Also, the revision history included in the service allows users to see the additions made to a document, with each author distinguished by color, but the entire document must be manually searched to find these changes. The revision history feature only displays one edit at a time, i.e. only adjacent revisions can be compared, and users cannot control how frequently revisions are saved. A new collaborative feature introduced in June 2014 allows any user with commenting access to make edit suggestions. However, this feature is currently available only for documents.[21][39]

The application supports opening and exporting two ISO standard document formats: OpenDocument and Office Open XML. It also includes support for viewing proprietary formats such as .doc and .xls.[40]

Google Docs is one of many cloud computing document-sharing services.[41] The majority of document-sharing services require user fees. (Google Docs is free for individuals, but has fees for business starting at $5/month.)[42] Its popularity amongst businesses is growing due to enhanced sharing features and accessibility. In addition, Google Docs has enjoyed a rapid rise in popularity among students and educational institutions.[43]

In September 2009, an equation editor was added which supports the LaTeX format; however, Google Docs lacks an equation numbering feature.[44][45]

A simple find and replace tool is available; there was no ability to do the search in a reverse direction in the original release, but a later version allowed reverse search and reverse replace.[citation needed]

Google Docs includes a web clipboard tool that allows users to copy and paste content between Google documents, spreadsheets, presentations 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.[46]

Google offers an extension for Google Chrome 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.[47]

Google Cloud Connect was a plug-in for Windows Microsoft Office 2003, 2007 and 2010 that could automatically store and synchronize any Microsoft Word document, PowerPoint presentation, or Excel spreadsheet to Google Docs in Google Docs or Microsoft Office formats. The online 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 by working on the same document at the same time.[48][49] However, Google Cloud Connect has been discontinued as of April 30, 2013, as Google Drive achieves all of the above tasks, with better results.[50]

Google Spreadsheets and Google Sites also incorporate Google Apps Script to write code within documents in a similar way to Visual Basic for Applications in Microsoft Office. The scripts can be activated either by user action or by a trigger in response to an event.[51][52]

Google Forms and Google Drawings have been added to the Google Docs suite. 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.[53][54]

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.[55][56]

On May 15, 2012, a research tool was introduced in Google Docs.[57] It allows users to easily access Google Search through a sidebar while editing a document.[58]

On March 11, 2014, Google introduced add-ons for Google Docs and Sheets which allow users to use third-party applications installed from the add-on stores to get additional features within the main services.[33] The add-on store was also made available to Google Forms in October 2014.[59]

File limits

Individual documents may not exceed 1 GB as of 13 January 2010, embedded images must not exceed 2 MB each.[60] Files uploaded, but not converted to Google Docs format, may be up to 5 TB in size.[61]

There are also limits, specific to file type, listed below:

Documents
1,024,000 characters, regardless of the number of pages or font size. Uploaded document files that are converted to Google Docs format can not be larger than 50 MB.[62]
Spreadsheets
In Google Sheets, spreadsheets can have at most 2 million cells, and formulas are subject to additional complexity limits.[62] Until around 2014, there could have been a maximum of 256 columns per sheet and 200 sheets per workbook, with 400,000 cells in all.[63] Uploaded spreadsheet files that are converted to Google Sheets were restricted to at most 20 MB.[63]
Presentations
Presentations created in Google Slides can be up to 50 MB. Uploaded presentation files that are converted into Google Slides format can also be up to 50 MB.[62]

Supported file formats

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

  • 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 OCR: .jpg, .gif, .png, .pdf
File:Google Slides.png
Google Slides running on Android

It should be noted that the viewing/conversion is not always complete or accurate (inaccuracies are mainly formatting and will be visible). Converting a document from a Microsoft format or ODF to Google and back again will remove some information and features, and the layout can subtly change. In particular, Google does not support file/document properties (metadata), which would be viewable from Windows Explorer and within the relevant Microsoft application; when converting a document from Google format the file/document properties will not be set.

Mobile access

On April 30, 2014, Google announced standalone mobile apps for Google Docs and Google Sheets on Android and iOS. A similar app for Google Slides was stated to be "coming soon". Google Slides for Android was released on 25 June 2014 at the Google I/O developers conference, while the iOS version was released on 25 August 2014. Google Docs, Sheets and Slides allow users to create, view and edit documents, spreadsheets and presentations respectively. These apps also work offline and are compatible with Microsoft Office file formats.[65]

The Safari browser on iOS also allows users to view documents, spreadsheets, and presentation and to edit and create Google Docs documents and spreadsheets.[66] Furthermore, the Google App for iPhone and iPad allows users to view and edit Google Docs files. Most other mobile devices can also view and edit Google Docs documents and spreadsheets using a mobile browser.[67] PDF files can be viewed but not edited.

See also

References

  1. Lua error in package.lua at line 80: module 'strict' not found.
  2. Lua error in package.lua at line 80: module 'strict' not found.
  3. Lua error in package.lua at line 80: module 'strict' not found.
  4. Lua error in package.lua at line 80: module 'strict' not found.
  5. Lua error in package.lua at line 80: module 'strict' not found.
  6. 6.0 6.1 Lua error in package.lua at line 80: module 'strict' not found.
  7. 7.0 7.1 Lua error in package.lua at line 80: module 'strict' not found.
  8. Lua error in package.lua at line 80: module 'strict' not found.
  9. Lua error in package.lua at line 80: module 'strict' not found.
  10. Lua error in package.lua at line 80: module 'strict' not found.[dead link]
  11. Lua error in package.lua at line 80: module 'strict' not found.
  12. Lua error in package.lua at line 80: module 'strict' not found.
  13. Lua error in package.lua at line 80: module 'strict' not found.
  14. Lua error in package.lua at line 80: module 'strict' not found.
  15. Lua error in package.lua at line 80: module 'strict' not found.
  16. Lua error in package.lua at line 80: module 'strict' not found.
  17. Lua error in package.lua at line 80: module 'strict' not found.
  18. Lua error in package.lua at line 80: module 'strict' not found.
  19. Lua error in package.lua at line 80: module 'strict' not found.
  20. Lua error in package.lua at line 80: module 'strict' not found.
  21. 21.0 21.1 Lua error in package.lua at line 80: module 'strict' not found.
  22. Lua error in package.lua at line 80: module 'strict' not found.
  23. Lua error in package.lua at line 80: module 'strict' not found.
  24. Lua error in package.lua at line 80: module 'strict' not found.
  25. Lua error in package.lua at line 80: module 'strict' not found.
  26. Lua error in package.lua at line 80: module 'strict' not found.
  27. Lua error in package.lua at line 80: module 'strict' not found.
  28. Lua error in package.lua at line 80: module 'strict' not found.
  29. Lua error in package.lua at line 80: module 'strict' not found.
  30. Lua error in package.lua at line 80: module 'strict' not found.
  31. Lua error in package.lua at line 80: module 'strict' not found.
  32. Lua error in package.lua at line 80: module 'strict' not found.
  33. 33.0 33.1 Lua error in package.lua at line 80: module 'strict' not found.
  34. Lua error in package.lua at line 80: module 'strict' not found.
  35. Lua error in package.lua at line 80: module 'strict' not found.
  36. Lua error in package.lua at line 80: module 'strict' not found.
  37. Lua error in package.lua at line 80: module 'strict' not found.
  38. Lua error in package.lua at line 80: module 'strict' not found.
  39. Lua error in package.lua at line 80: module 'strict' not found.
  40. Lua error in package.lua at line 80: module 'strict' not found.
  41. Lua error in package.lua at line 80: module 'strict' not found.
  42. Lua error in package.lua at line 80: module 'strict' not found.
  43. Firth, Mark & Mesureur, Germain. "Innovative uses for Google Docs in a university language program", The JALT CALL Journal. Retrieved on 2010-06-30.
  44. Lua error in package.lua at line 80: module 'strict' not found.
  45. Lua error in package.lua at line 80: module 'strict' not found.
  46. Lua error in package.lua at line 80: module 'strict' not found.
  47. Lua error in package.lua at line 80: module 'strict' not found.
  48. Google Cloud Connect for Microsoft Office available to all
  49. Lua error in package.lua at line 80: module 'strict' not found.
  50. Lua error in package.lua at line 80: module 'strict' not found.
  51. Lua error in package.lua at line 80: module 'strict' not found.
  52. Lua error in package.lua at line 80: module 'strict' not found.
  53. Lua error in package.lua at line 80: module 'strict' not found.
  54. Lua error in package.lua at line 80: module 'strict' not found.
  55. Lua error in package.lua at line 80: module 'strict' not found.
  56. Lua error in package.lua at line 80: module 'strict' not found.
  57. Lua error in package.lua at line 80: module 'strict' not found.
  58. Lua error in package.lua at line 80: module 'strict' not found.
  59. Lua error in package.lua at line 80: module 'strict' not found.
  60. Lua error in package.lua at line 80: module 'strict' not found.
  61. Lua error in package.lua at line 80: module 'strict' not found.
  62. 62.0 62.1 62.2 Lua error in package.lua at line 80: module 'strict' not found.
  63. 63.0 63.1 Google Docs, Sheets, and Slides size limits. Version as of January 11, 2014 (archived by the Internet Archive)
  64. Lua error in package.lua at line 80: module 'strict' not found.
  65. Lua error in package.lua at line 80: module 'strict' not found.
  66. Lua error in package.lua at line 80: module 'strict' not found.
  67. Lua error in package.lua at line 80: module 'strict' not found.

Further reading

  • Lua error in package.lua at line 80: module 'strict' not found.

External links

  1. REDIRECT Template:Google LLC