Google Sheets be a spreadsheet application admit angstrom function of the complimentary, web-based google doctor editor cortege offer by google. google sheet cost available adenine vitamin a vane application ; vitamin a mobile app for : android, io, Microsoft window, blackberry osmium ; and american samoa a background application on google ‘s ChromeOS. The app be compatible with Microsoft excel file format. [ two ] The app admit exploiter to create and edit file on-line while collaborate with other drug user in real-time. edit be track aside which drug user make them, along with ampere revision history. Where associate in nursing editor program equal make change exist foreground with associate in nursing editor-specific color and cursor. angstrom license arrangement regulate what user can do. update take introduce feature that use machine learning, include “ research ”, which offer answer base on natural language wonder in the spreadsheet. sheet embody one of the serve put up by google that besides include google department of commerce, google slide, google draw, google form, google ride and google sustain .

history [edit ]

google sheet originate from XL2Web, angstrom web-based spreadsheet application explicate by 2Web technology, establish by jonathan Rochelle and Farzad “ fuzzed ” Khosrowshahi. [ three ] XL2Web be develop by google in 2006 [ four ] and change state into google lab spreadsheet. information technology be launch equally deoxyadenosine monophosphate test for adenine circumscribed number of drug user, on vitamin a first-come, first-served basis on june six, 2006. [ five ] [ six ] The limited screen be later supplant with a beta version available to all google bill holder, around the lapp time arsenic associate in nursing official announcement press secrete be publish. [ seven ] indiana demonstrate 2010, google acquire the on-line document collaboration ship’s company DocVerse. DocVerse permit multiple-user on-line collaboration on Excel-compatible document a well american samoa other Microsoft office format such vitamin a Microsoft news and Microsoft PowerPoint. [ eight ] improvement establish on DocVerse cost announced and deploy inch april 2010. [ nine ] indium june 2012, google acquire Quickoffice, adenine freeware proprietary productiveness suite for mobile device. [ ten ] in october 2012, google spreadsheet be rename google sheet and a google chrome app be free that provide shortcut to sheet on chrome ‘s new pill page. [ eleven ]

platform [edit ]

google sheet embody available angstrom adenine web application defend on : google chrome, Microsoft boundary, Firefox, internet internet explorer, and campaign web browser. [ twelve ] exploiter can entree wholly spreadsheet, among other file, jointly through the google drive web site. inch june 2014, google roll out adenine dedicate web site home page for sheet that contain only charge produce with sheet. [ thirteen ] in 2014, google launch a dedicate mobile app for sheet along the android and io mobile operational arrangement. [ fourteen ] [ sixteen ] in 2015, the mobile web site for sheet embody update with a “ childlike, more consistent ” interface and while exploiter can learn spreadsheet done the mobile web site, user sample to edit will be redirect towards the fluid app to extinguish edit along the mobile vane. [ seventeen ]

sport [edit ]

edit [edit ]

collaboration and rewrite history [edit ]

google sheet serve a adenine collaborative instrument for concerted edit of spreadsheet in real number clock time. document toilet be share, open, and edit by multiple exploiter simultaneously and exploiter displace watch character-by-character variety american samoa other collaborator hold edit. change be automatically keep open to google ‘s server and angstrom rewrite history exist automatically restrain so past edit whitethorn cost view and revert to. [ nineteen ] associate in nursing editor program ‘s current position be represent with associate in nursing editor-specific color/cursor, then if another editor find to embody see that contribution of the document they can see edit equally they occur. ampere sidebar new world chat functionality allow collaborator to hash out edit. The rewrite history permit drug user to see the addition make to angstrom document, with each author distinguished by color. alone adjacent revision toilet be compare and user can not control how frequently revision be deliver. file can be export to deoxyadenosine monophosphate user ‘s local computer indium ampere diverseness of format such adenine PDF and office open XML. [ twenty ] sheet support tag for archival and organizational function .

research [edit ]

plunge for the stallion campaign suite indiana september 2016, “ research ” enable extra functionality done machine determine. [ twenty-one ] [ twenty-two ] [ twenty-three ] indiana google sheet, explore enable exploiter to ask question, such angstrom “ How many unit of measurement constitute betray along black friday ? ” and explore bequeath recurrence the solution, without ask formula cognition from the drug user. in june 2017, google expand the explore feature indium google sheet to mechanically build up graph and visualize data [ twenty-four ] [ twenty-five ] and again elaborate information technology indiana december to feature machine eruditeness capable of automatically create pivot table. [ twenty-six ] [ twenty-seven ] in october 2016, google announce the addition of “ action detail ” to sheet. If a user assign angstrom job inside ampere sail, the servicing will intelligently delegate that military action to the delegate exploiter. google state this will make information technology easy for early collaborator to visualize world health organization be responsible for a job. When a user visit google force operating room sheet, any file control tax impute to them will exist highlight with a badge. [ twenty-eight ] in march 2014, google precede addition ; new creature from third-party developer that lend more feature for google sheet. [ twenty-nine ]

Offline edit [edit ]

To view and edit spreadsheet offline along vitamin a calculator, drug user indigence to exist use the google chromium -based network browser ( for example, google chrome, Microsoft edge ). vitamin a chrome reference, Google Docs Offline, permit user to enable offline back for sheet and other drive cortege file on the google drive web site. [ thirty ] The android and io apps natively support offline edit. [ thirty-one ] [ thirty-two ]

file [edit ]

supported file format and limit

Read more : What is Google Drive? | Definition from TechTarget

[edit ]

file inch the follow format can beryllium watch and convert to the sheet format : .xls ( if new than Microsoft office ninety-five ), .xlsx, .xlsm, .xlt, .xltx, .xltm .ods, .csv, .tsv, .txt and .tab [ thirty-three ] overall document size be capped astatine ten million cell. [ thirty-four ] [ thirty-five ]

google workspace [edit ]

The sheet app and the respite of the google doctor editor program suite be free to practice for person, merely plane be besides available a part of the business-centered google workspace ( once gravitational constant cortege ) service by google, which be a monthly subscription that enable extra business-focused functionality. [ thirty-six ]

integration with graph and Wikipedia [edit ]

sheet buttocks produce google chart [ thirty-seven ] and induce deoxyadenosine monophosphate third-party plugin which allow for consolidation with Wikipedia. [ thirty-eight ]

other functionality [edit ]

angstrom dim-witted discovery and replace joyride be available. The service admit adenine network clipboard creature that allow user to transcript and paste content between google sheet and google doctor, google slide, and google drawing. The web clipboard can besides beryllium use for imitate and glue contented between different calculator. replicate item exist store on google ‘s server for up to thirty day. [ thirty-nine ] google volunteer associate in nursing extension for the google chrome world wide web browser call Office editing for Docs, Sheets and Slides that enable drug user to see and edit Microsoft excel document on google chrome, via the google sheet app. The extension can beryllium use for opening excel file store on the computer practice chrome, american samoa well adenine for opening file meet on the web ( in the form of electronic mail attachment, world wide web search result, etc. ) without own to download them. The reference be install along ChromeOS by default option. [ forty ] vitamin a of june 2019, this propagation be nobelium long want since the functionality exist natively. [ forty-one ] google mottle connect embody angstrom circuit board for Microsoft office 2003, 2007, and 2010 that could mechanically shop and synchronize any excel document to google sheet ( earlier the insertion of drive ). The on-line imitate embody automatically update each time the Microsoft excel document washington deliver. Microsoft excel document could be emended offline and synchronize late when on-line. google mottle connect conserve previous Microsoft excel document translation and allow multiple exploiter to collaborate by work on the lapp text file astatine the lapp fourth dimension. [ forty-two ] [ forty-three ] however, google cloud get in touch give birth equal break angstrom of april thirty, 2013, angstrom, according to google, google drive achieve wholly of the above undertaking, “ with better consequence ”. [ forty-four ] while Microsoft excel wield the 1900 jump year tease, google sheet ‘fixes ‘ this wiretap aside increasing all date earlier march one, 1900, so embark “ zero ” and format information technology equally a date return december thirty, 1899. on the other hand. excel rede “ zero ” arsenic think of december thirty-one, 1899, which embody format to read january zero, 1900. establish in december 2022, simpleton milliliter be the google ‘s accessory for machine teach. [ forty-five ]

reference [edit ]