Google Sheets

Google Sheets
Developer(s)Google LLC
Initial releaseMarch 9, 2006; 18 years ago (2006-03-09)
Stable release(s) [±]
Android1.24.452.01 / 8 November 2024; 7 days ago (2024-11-08)[1][2]
iOS1.2024.45201 / 11 November 2024; 4 days ago (2024-11-11)[3]
Written inJavaScript
Operating systemAndroid, iOS, ChromeOS
Available in83 languages[4]
Type
Websitegoogle.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.[5] 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.[6] XL2Web was acquired by Google in 2006[7] 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.[8][9] 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.[10] 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.[11] Improvements based on DocVerse were announced and deployed in April 2010.[12] In June 2012, Google acquired Quickoffice, a freeware proprietary productivity suite for mobile devices.[13] 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.[14]

Platforms

Google Sheets is available as a web application supported on: Google Chrome, Microsoft Edge, Firefox, and Safari web browsers.[15] 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.[16] In 2014, Google launched a dedicated mobile app for Sheets on the Android and iOS mobile operating systems.[17][18][19] 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.[20]

Apps Script
Developer(s)Google
Initial releaseAugust 19, 2009; 15 years ago (2009-08-19)[21]
Written inJavaScript
TypeWeb application framework, scripting language
Websitescript.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.[22] 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.[23] Sheets supports tagging for archival and organizational purposes.[24]

Explore

Launched for the entire Drive suite in September 2016, "Explore" enables additional functionality through machine learning.[25][26][27] 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[28][29] and again expanded it in December to feature machine learning capable of automatically creating pivot tables.[30][31] 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.[32] In March 2014, Google introduced add-ons; new tools from third-party developers that add more features for Google Sheets.[33]

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.[34] The Android and iOS apps natively support offline editing.[35][36]

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[37] Overall document size is capped at 10 million cells.[38][39]

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.[40]

Integration with Charts and Wikipedia

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

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.[43]

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.[44] As of June 2019, this extension is no longer required since the functionality exists natively.[45]

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.[46][47] 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".[48]

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.[49]

See also

References

  1. ^ "Google Sheets". Google Play. Retrieved November 15, 2024.
  2. ^ "Google Sheets 1.24.452.01". APKMirror. November 8, 2024. Retrieved November 15, 2024.
  3. ^ "Google Sheets". App Store. Retrieved November 15, 2024.
  4. ^ Hill, Ian (June 18, 2013). "18 New Languages for Drive, Docs, Sheets, and Slides". Google Drive Blog. Retrieved October 29, 2016.
  5. ^ "Office editing makes it easier to work with Office files in Docs, Sheets, and Slides". G Suite Updates Blog. Retrieved August 12, 2019.
  6. ^ Surden, Esther (June 26, 2013). "At Madison Meetup, NJ's Rochelle Talks XL2Web Acquisition by Google". NJ Tech Weekly. Retrieved October 15, 2021.
  7. ^ Dawson, Christopher (October 30, 2010). "Google's 40 acquisitions in 2010: What about integration?". ZDNet. CBS Interactive. Retrieved June 1, 2017.
  8. ^ Rochelle, Jonathan (June 6, 2006). "It's nice to share". Official Google Blog. Retrieved October 29, 2016.
  9. ^ "Google Announces limited test on Google Labs: Google Spreadsheets". June 6, 2006. Retrieved October 29, 2016.
  10. ^ "Google Announces Google Docs & Spreadsheets". October 11, 2006. Retrieved October 29, 2016.
  11. ^ Jackson, Rob (March 5, 2010). "Google Buys DocVerse For Office Collaboration: Chrome, Android & Wave Implications?". Phandroid. Retrieved October 20, 2016.
  12. ^ Belomestnykh, Olga (April 15, 2010). "A rebuilt, more real-time Google documents". Google Drive Blog. Retrieved October 30, 2016.
  13. ^ Warren, Alan (June 5, 2012). "Google + Quickoffice = get more done anytime, anywhere". Official Google Blog. Retrieved October 30, 2016.
  14. ^ 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.
  15. ^ "System requirements and browsers". Docs editors Help. Retrieved December 16, 2016.
  16. ^ "Dedicated desktop home pages for Google Docs, Sheets & Slides". G Suite Updates. June 25, 2014. Retrieved December 16, 2016.
  17. ^ 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.
  18. ^ 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.
  19. ^ "New Google Slides, Docs, and Sheets apps for iOS". G Suite Updates. August 25, 2014. Retrieved December 16, 2016.
  20. ^ "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.
  21. ^ Meyer, David (August 20, 2009). "Google Apps Script gets green light". CNet. Archived from the original on August 10, 2012. Retrieved March 26, 2011.
  22. ^ "See the history of changes made to a file". Docs editors Help. Retrieved February 20, 2017.
  23. ^ "Share a copy of a file in an Office format". G Suite Learning Center. Retrieved August 12, 2019.
  24. ^ "Google sheet for organizational access".
  25. ^ 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.
  26. ^ Novet, Jordan (September 29, 2016). "Google updates Calendar, Drive, Docs, Sheets, and Slides with machine intelligence features". VentureBeat. Retrieved December 16, 2016.
  27. ^ Allan, Darren (September 30, 2016). "Google wants to better challenge Microsoft Office with these new features". TechRadar. Future plc. Retrieved December 16, 2016.
  28. ^ Lardinois, Frederic (June 1, 2017). "Google Sheets now uses machine learning to help you visualize your data". TechCrunch. AOL. Retrieved June 1, 2017.
  29. ^ 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.
  30. ^ Miller, Ron (December 6, 2017). "Latest Google Sheets release helps automate pivot table creation". TechCrunch. Oath Inc. Retrieved December 14, 2017.
  31. ^ Gagliordi, Natalie (December 6, 2017). "Google brings new AI, machine learning features to Sheets". ZDNet. CBS Interactive. Retrieved December 14, 2017.
  32. ^ Weber, Ryan (October 19, 2016). "Five new ways to reach your goals faster with G Suite". The Keyword Google Blog. Retrieved December 14, 2016.
  33. ^ Gupta, Saurabh (March 11, 2014). "Bring a little something extra to Docs and Sheets with add-ons". Google Drive Blog. Retrieved October 30, 2016.
  34. ^ "Work on Google files offline". Drive Help. Retrieved January 14, 2017.
  35. ^ "Work on Google files offline". Drive Help. Retrieved January 14, 2017.
  36. ^ "Work on Google files offline". Drive Help. Retrieved January 14, 2017.
  37. ^ "Work with Office files". Docs editors Help. Retrieved October 30, 2016.
  38. ^ "Files you can store in Google Drive". Drive Help. Retrieved November 1, 2019.
  39. ^ "Insert or delete images or videos". Docs editors Help. Retrieved October 22, 2016.
  40. ^ "G Suite - Choose a Plan". Retrieved October 30, 2016.
  41. ^ "Google Spreadsheets | Charts". Google Developers. Retrieved March 1, 2020.
  42. ^ "Wikipedia and Wikidata Tools - G Suite Marketplace". gsuite.google.com.
  43. ^ "Copy and paste text and images". Retrieved October 30, 2016.
  44. ^ "Office Editing for Docs, Sheets & Slides". Chrome Web Store. Retrieved October 30, 2016.
  45. ^ "Remove the Office compatibility app". G Suite Admin Help. Retrieved August 12, 2019.
  46. ^ Sinha, Shan (February 24, 2011). "Google Cloud Connect for Microsoft Office available to all". Google Drive Blog. Retrieved October 30, 2016.
  47. ^ White, Charlie (February 24, 2011). "Now Anyone Can Sync Google Docs & Microsoft Office". Mashable. Retrieved October 30, 2016.
  48. ^ "Migrate from Google Cloud Connect to Google Drive". Apps Documentation and Support. Archived from the original on March 17, 2013. Retrieved October 30, 2016.
  49. ^ "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.
  1. ^ AI Spreadsheet. Sourcetable Inc., 2024. Retrieved 2024-11-14.

Read other articles:

Play by Athol Fugard, John Kani, and Winston Ntshona This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.Find sources: The Island play – news · newspapers · books · scholar · JSTOR (February 2021) (Learn how and when to remove this template message) Poster for the 2000 Royal National Theatre production The Island is a pl...

 

 

ماسيميليانو أليغري (بالإيطالية: Massimiliano Allegri)‏ أليجري مع يوفنتوس عام 2021 معلومات شخصية الاسم الكامل ماسيميليانو أليغري[1] الميلاد 11 أغسطس 1967 (العمر 56 سنة)ليفورنو، إيطاليا الطول 1.86 م (6 قدم 1 بوصة)[2] مركز اللعب وسط الإقامة لِفُرنة  الجنسية إيطالي معلومات النا�...

 

 

Mountain in California, United States For the highest point in Arizona, see Humphreys Peak. Mount HumphreysMount Humphreys from the southHighest pointElevation13,992 ft (4,265 m) NAVD 88[1]Prominence2563 ft (781 m)[1]Isolation14.71 mi (23.67 km)[1]ListingNorth America highest peaks 62ndUS highest major peaks 47thCalifornia highest major peaks 6thSPS Emblem peak[2]Vagmarken Club Sierra Crest List[3]Western States Climbe...

artikel ini perlu dirapikan agar memenuhi standar Wikipedia. Tidak ada alasan yang diberikan. Silakan kembangkan artikel ini semampu Anda. Merapikan artikel dapat dilakukan dengan wikifikasi atau membagi artikel ke paragraf-paragraf. Jika sudah dirapikan, silakan hapus templat ini. (Pelajari cara dan kapan saatnya untuk menghapus pesan templat ini) Artikel ini tidak memiliki referensi atau sumber tepercaya sehingga isinya tidak bisa dipastikan. Tolong bantu perbaiki artikel ini dengan menamba...

 

 

American politician For other people named Samuel Dana, see Samuel Dana (disambiguation). Samuel Whittlesey Dana1806 engraving by Charles Balthazar Julien Févret de Saint-Mémin.United States Senatorfrom ConnecticutIn officeDecember 4, 1810 – March 3, 1821Preceded byJames HillhouseSucceeded byElijah BoardmanMember of the U.S. House of Representativesfrom Connecticut's At-Large districtIn officeJanuary 3, 1797 – May 10, 1810Preceded byUriah TracySucceeded byEbenezer Hunt...

 

 

Autobiography by Gaylord Perry Me and the Spitter AuthorGaylord Perry with Bob SudykCountryUnited StatesLanguageEnglishSubjectBaseballGenreAutobiographyPublisherSaturday Review PressPublication date1974Media typePrint (Hardcover)Pages222 (1st ed.)ISBN0-841-50299-4 Me and the Spitter: An Autobiographical Confession is a 1974 autobiography by Major League Baseball (MLB) pitcher Gaylord Perry, written with Bob Sudyk, a sportswriter for the Cleveland Press. The book details how Perry cheated...

Lionel Murtonin TV's The Four Just Men (1960)BornWilliam Lionel Murton(1915-06-02)2 June 1915London, EnglandDied26 September 2006(2006-09-26) (aged 91)Basingstoke, Hampshire, EnglandResting placeBasingstoke Crematorium and Gardens of RemembranceOccupationActorYears active1945-1981SpouseAnita D'Allaire William Lionel Murton (2 June 1915 – 26 September 2006) was an English character actor.[1][2] Born in Wandsworth, London, he was resident at Little Orchard, Weston Ro...

 

 

Guangzhou F.C. 2010 Football team seasonGuangzhou F.C. 2010Chairman Liu YongzhuoHead coach Lee Jang-Soo  Li Chunman (in name)StadiumZengcheng StadiumCentury Lotus StadiumYuexiushan StadiumLeague One1stTop goalscorer Gao Lin (20 goals) Home colours Away colours ← 20092011 → The 2010 season is the 57th year in Guangzhou Football Club's existence, their 43rd season in the Chinese football league. The club was relegated to China League One in the fallout ...

 

 

التاريخ الاقتصادي للحرب العالمية الأولىمعلومات عامةوصفها المصدر الموسوعة السوفيتية الكبرى التأثيراتفرع من الحرب العالمية الأولى تعديل - تعديل مصدري - تعديل ويكي بيانات ملصق بريطاني يشجع على الاستثمار في أذون الحرب. يغطي التاريخ الاقتصادي للحرب العالمية الأولى الأساليب ...

Championnats du monde d'athlétisme 2003 Logo des championnats du monde d'athlétisme 2003.Généralités Sport Athlétisme Organisateur(s) IAAF Éditions 9e Lieu(x) Saint-Denis etParis, France Date 23 au 31 août 2003 Nations 198 Participants 1 679 Épreuves 46 Site(s) Stade de France Navigation 1983 • 1987 • 1991 • 1993 • 1995 • 1997 • 1999 • 2001 • 2003 • 2005 • 2007 • 2009 • 2011 • 2013 • 2015 • 2017 • 2019 • 2022 • 2023 • 2025 • 2027 modi...

 

 

العلاقات النمساوية الجيبوتية النمسا جيبوتي   النمسا   جيبوتي تعديل مصدري - تعديل   العلاقات النمساوية الجيبوتية هي العلاقات الثنائية التي تجمع بين النمسا وجيبوتي.[1][2][3][4][5] مقارنة بين البلدين هذه مقارنة عامة ومرجعية للدولتين: وجه المقارنة...

 

 

Canadian ice hockey player (born 1994) Ice hockey player Ann-Renee Desbiens playing for Team Canada in 2017Born (1994-04-10) April 10, 1994 (age 30)La Malbaie, Quebec, CanadaHeight 1.75 m (5 ft 9 in)Weight 73 kg (161 lb; 11 st 7 lb)Position GoaltenderCatches LeftPWHL teamFormer teams PWHL MontrealPWHPA MinnesotaWisconsin BadgersMontréal StarsNational team  CanadaPlaying career 2013–present Medal record Women's ice hockey Representing  C...

Untuk munisipalitas di kanton Vaud, lihat Corsier-sur-Vevey. Corsier Lambang kebesaranNegaraSwissKantonJenewaDistrikn.a.Pemerintahan • WalikotaMaireGilbert HenchozLuas[1] • Total2,74 km2 (1,06 sq mi)Ketinggian430 m (1,410 ft)Populasi (Kesalahan: waktu tidak sah.[2]) • Total1,814 • Kepadatan660/km2 (1,700/sq mi)Kode pos1246Kode area telepon6619Dikelilingi olehAnières, Collonge-Bellerive, Gy, Mei...

 

 

ريمونسترانتيون تعديل مصدري - تعديل   جزء من سلسلة عنأرمينيانيةجاكوب أرمينيوس خلفية بروتستانتية إصلاح بروتستانتي Five Articles of Remonstrance Calvinist–Arminian debate Arminianism in the Anglican Church شخصيات جاكوب أرمينيوس Simon Episcopius هوغو غروتيوس The Remonstrants Synod of Dort participants جون ويزلي تعاليم Total depravity Conditional electi...

 

 

Government agency of New South Wales National Parks and Wildlife ServiceAgency overviewFormed1967; 57 years ago (1967)JurisdictionNew South WalesHeadquarters12 Darcy Street, Parramatta Square, Sydney NSW, AustraliaMinister responsibleThe Hon Penny Sharpe, MLC, Minister for the EnvironmentAgency executivesNaomi Stephens, Acting Deputy Secretary, National Parks and Wildlife ServiceAnthony Lean, Secretary, Department of Climate Change, Energy, the Environment and Water (NSW)Par...

Lebanese Christian nationalist political party and former militia For the faction during the Lebanese Civil War, see Lebanese Forces (militia). Not to be confused with Lebanese Armed Forces. Lebanese Forces القوات اللبنانيةal-Quwwāt al-LubnānīyahAbbreviationLFSecretary-GeneralEmile MoukarzelPresidentSamir GeageaFounderBachir GemayelVice-presidentGeorges AdwanFounded1976HeadquartersMaarab, LebanonNewspaperAlmassiraMembership50,000IdeologyChristian democracyLiberal conservatis...

 

 

Catholic ecclesiastical territory Diocese of Foz do IguaçuDioecesis IguassuensisDiocese de Foz do IguaçuCathedral of St. John the BaptistLocationCountry BrazilEcclesiastical provinceCascavelMetropolitanCascavelStatisticsArea6,822 km2 (2,634 sq mi)Population- Total- Catholics(as of 2013)521,000413,000 (79.3%)InformationRiteLatin RiteEstablished10 May 1926 (98 years ago)CathedralCathedral of St John the Baptist in Foz do IguaçuCurrent leadershipPopeFrancisB...

 

 

Ceylon Communist Party redirects here. For the Maoist faction, see Ceylon Communist Party (Maoist). United Socialist Party (Ceylon) redirects here. For the Trotskyist Group, see United Socialist Party (Sri Lanka). Political party in Sri Lanka Communist Party of Sri Lanka ශ්‍රී ලංකාවේ කොමියුනිස්ට් පක්ෂයஇலங்கை கம்யூனிஸ்ட் கட்சிGeneral SecretaryDr G. WeerasingheFounderS. A. WickramasingheFound...

Portuguese nobleman and explorer Cristóvão de MendonçaCristóvam de MendonçaBorn1475Mourão, Kingdom of PortugalDied1532 (aged 56–57)OrmusNationalityPortugueseOccupationExplorerParent(s)Diogo de Mendonça[contradictory]Brites Soares de Albergaria Cristóvão de Mendonça (Mourão, 1475 – Ormus, 1532)[1] was a Portuguese noble and explorer who was active in South East Asia in the 16th century. Son of Diogo de Mendonça,[contradictory] Alcaide-mor (lord ...

 

 

Robbie KayKay di San Diego Comic-Con International 2015LahirRobbie Kay[1]13 September 1995 (umur 28)[1]Lymington, InggrisPekerjaanAktorTahun aktif2006 — sekarang Robbie Kay (lahir 13 September 1995) adalah aktor asal Inggris yang dikenal karena perannya dalam film Fugitive Pieces (2007) dan Pinocchio (2008). Filmografi Tahun Film Peran Catatan 2006 The Illusionist ? Scenes cut from final film 2007 Hannibal Rising Kolnas's Son Credited as Robert Kay My Boy Jack Art...