比特派安卓版官网|sheet

首页
sheet

比特派安卓版官网|sheet

作者：比特派安卓版官网

2024-03-13 04:35:43

Google Sheets: Online Spreadsheet Editor | Google Workspace

Jump to Content

Sheets

Jump to Content

Sheets

Overview

Features

Security

Pricing

More tools

Drive

Gmail

Meet

Calendar

Docs

Sheets

Slides

Forms

Drive

Cloud Storage

Gmail

Custom Business Email

Meet

Video and voice conferencing

Calendar

Shared Calendars

Docs

Word Processing

Sheets

Spreadsheets

Slides

Presentation Builder

Forms

Survey builder

Google Workspace

An integrated suit of secure, cloud-native collaboration and productivity apps powered by Google AI.

Learn More

Make data-driven decisions, in Google Sheets

Create and collaborate on online spreadsheets in real-time and from any device.

Try Sheets for Work Go to Sheets

Don't have an account?

For my personal use

For work or my business

Anna Chang

T h e s e n u m b e r s l o o k v e r y s t r o n g !

See what you can do with Google Sheets

Collaborate on data, from anywhere

Establish a ground truth for data in your online spreadsheet, with easy sharing and real-time editing. Use comments and assign action items to keep analysis flowing.

Get to insights faster with built-in intelligence

Assistive features like Smart Fill and formula suggestions help you analyze faster with fewer errors. And get insights quickly by asking questions about your data in simple language.

Seamlessly connect to other Google apps

Sheets is thoughtfully connected to other Google apps you love, saving you time. Easily analyze Google Forms data in Sheets, or embed Sheets charts in Google Slides and Docs. You can also reply to comments directly from Gmail and easily present your spreadsheets to Google Meet.

Extend collaboration and intelligence to Excel files

Easily edit Microsoft Excel spreadsheets online without converting them, and layer on Sheets’ enhanced collaborative and assistive features like comments, action items, and Smart Fill.

Build custom solutions

Speed up workflows by building business apps and automations. Use AppSheet to build custom applications on top of Sheets, without writing code. Or add custom functions, menu items, and macros with Apps Script.

Always work with fresh data

With Sheets, everyone’s always working on the latest version of a spreadsheet. And with edits automatically saved in version history, it’s easy to undo changes or even see edit history of an individual spreadsheet cell.

Seamlessly connect to critical data

Pull in and analyze data from the other tools you use, like customer data from Salesforce. Enterprise customers can also use Connected Sheets to analyze billions of rows of BigQuery data in Sheets – without writing any code.

Security, compliance, and privacy

Secure by default

We use industry-leading security measures to keep your data safe, including advanced malware protections. Sheets is also cloud-native, eliminating the need for local files and minimizing risk to your devices.

Encryption in transit and at rest

All files uploaded to Google Drive or created in Sheets are encrypted in transit and at rest.

Compliance to support regulatory requirements

Our products, including Sheets, regularly undergo independent verification of their security, privacy, and compliance controls.

Private by design

Sheets adheres to the same robust privacy commitments and data protections as the rest of Google Cloud’s enterprise services.

You control your data.

We never use your Sheets content for ad purposes.

We never sell your personal information to third parties.

Find the plan that’s right for you

Google Sheets is a part of Google Workspace

Every plan includes

Docs

Sheets

Slides

Forms

Keep

Sites

Drive

Gmail

Meet

Calendar

Chat

Try Sheets for Work

For Personal (Free)

Go to Sheets

Business Standard

$12 USD

per user / month, 1 year commitment info Or $14.40 per user / month, when billed monthly

Get started

See more plans

Docs, Sheets, Slides, Forms

content creation

done

Drive

Secure cloud storage

15 GB per user

2 TB per user

Shared drives for your team

remove

done

Gmail

Secure email

done

Custom business email

remove

done

Meet

Video and voice conferencing

100 participants

150 participants

Meeting recordings saved to Drive

remove

done

Admin

Centralized administration

remove

done

Group-based security policy controls

remove

done

Customer support

Self-service online and community forums

24/7 online support and community forums

Collaborate from anywhere, on any device

Access, create, and edit your spreadsheets wherever you are — from any mobile device, tablet, or computer — even when offline.

Get a head start with templates

Choose from a variety of dashboards, project trackers, and other professionally-designed templates to kick things off quickly.

Invoice

Budget

Timeline

Grade Book

Invoice

Budget

Timeline

Grade Book

Visit the Sheets Template Gallery for more.

Ready to get started?

Try Sheets for Work Go to Sheets

Footer links

Follow our Blog

About Google

Google products

Privacy

Terms

Help

Afrikaans

English

አማርኛ

العربية

azərbaycan

български

বাংলা

català

čeština

dansk

Deutsch

Ελληνικά

English (United Kingdom)

español (Latinoamérica)

español

eesti

euskara

فارسی

suomi

Filipino

français (Canada)

français

galego

ગુજરાતી

हिन्दी

hrvatski

magyar

հայերեն

Indonesia

íslenska

italiano

עברית (ישראל)

日本語

ქართული

ខ្មែរ

ಕನ್ನಡ

한국어

ລາວ

lietuvių

latviešu

മലയാളം

монгол

मराठी

Melayu

नेपाली

Nederlands

norsk bokmål (Norge)

polski

português (Brasil)

português (Portugal)

română

русский

සිංහල

slovenčina

slovenščina

српски

svenska

Kiswahili

தமிழ்

తెలుగు

ไทย

Türkçe

українська

اردو

Tiếng Việt

中文 (简体)

中文

中文 (繁體)

isiZulu

Google Sheets: Sign-in

le Sheets: Sign-inSign into continue to SheetsEmail or phoneForgot email?Type the text you hear or seeNot your computer? Use Guest mode to sign in privately. Learn more about using Guest modeNextCreate accountEnglish (United States)AfrikaansazərbaycanbosanskicatalàČeštinaCymraegDanskDeutscheestiEnglish (United Kingdom)English (United States)Español (España)Español (Latinoamérica)euskaraFilipinoFrançais (Canada)Français (France)GaeilgegalegoHrvatskiIndonesiaisiZuluíslenskaItalianoKiswahililatviešulietuviųmagyarMelayuNederlandsnorsko‘zbekpolskiPortuguês (Brasil)Português (Portugal)românăshqipSlovenčinaslovenščinasrpski (latinica)SuomiSvenskaTiếng ViệtTürkçeΕλληνικάбеларускаябългарскикыргызчақазақ тілімакедонскимонголРусскийсрпски (ћирилица)Українськаქართულიհայերեն‫עברית‬‎‫اردو‬‎‫العربية‬‎‫فارسی‬‎አማርኛनेपालीमराठीहिन्दीঅসমীয়াবাংলাਪੰਜਾਬੀગુજરાતીଓଡ଼ିଆதமிழ்తెలుగుಕನ್ನಡമലയാളംසිංහලไทยລາວမြန်မာខ្មែរ한국어中文（香港）日本語简体中文繁體中文HelpPrivacyTe

Google Sheets - Apps on Google Play

le Sheets - Apps on Google PlayGamesAppsMoviesBooksKidsgoogle_logo PlayGamesAppsMoviesBooksKidsnonesearchhelp_outline Sign in with Googleplay_appsLibrary & devicespaymentPayments & subscriptionsreviewsMy Play activityredeemOffersPlay PasssettingsSettingsPrivacy Policy • Terms of ServiceGamesAppsMoviesBooksKidsplay_arrowTrailerGoogle SheetsGoogle LLC4.4star1.13M reviews1B+DownloadsRated for 3+infoInstallShareAdd to wishlistplay_arrowTrailerAbout this apparrow_forwardCreate, edit, and collaborate on spreadsheets from your Android phone or tablet with the Google Sheets app. With Sheets, you can:- Create new spreadsheets or edit existing files- Share spreadsheets and collaborate in the same spreadsheet at the same time.- Work anywhere, anytime - even offline- Add and respond to comments- Format cells, enter or sort data, view charts, insert formulas, use find/replace, and more- Never worry about losing your work – everything is saved automatically as you type- Quickly get insights, insert charts, and apply formatting with smart suggestions- Open, edit, and save Excel files.Google Sheets is part of Google Workspace: where teams of any size can chat, create, and collaborate.Google Workspace subscribers have access to additional Google Sheets features, including:- Easily add collaborators to projects, see changes as they occur, receive notifications for edits that happen while you’re away, and chat with colleagues in the same spreadsheet. All changes are automatically saved as you make them. And with offline access, you can create, view, and edit files wherever and whenever- Get insights fast, powered by Google AI- Work seamlessly across Sheets and Excel- Maintain control with enterprise-grade security- Analyze data from other business-critical tools- Build custom solutionsLearn more about Google Workspace: https://workspace.google.com/products/sheets/Follow us for more:Twitter: https://twitter.com/googleworkspaceLinkedin: https://www.linkedin.com/showcase/googleworkspaceFacebook: https://www.facebook.com/googleworkspace/Updated onMar 12, 2024ProductivityData safetyarrow_forwardSafety starts with understanding how developers collect and share your data. Data privacy and security practices may vary based on your use, region, and age. The developer provided this information and may update it over time.No data shared with third partiesLearn more about how developers declare sharingThis app may collect these data typesLocation, Personal info and 7 othersData is encrypted in transitYou can request that data be deletedIndependent security reviewSee detailsRatings and reviewsRatings and reviews are verifiedinfo_outlinearrow_forwardRatings and reviews are verifiedinfo_outlinephone_androidPhonetablet_androidTabletlaptopChromebooktvTVdirections_car_filledCar4.41.06M reviews54321A Google usermore_vert Flag inappropriateShow review historyMay 27, 2019Excel is still king, but it takes a bit of while to have both (pc and phone) updated on the cloud unlike Sheets which saves your file up there every change you make. Sure there's a lot of practice and as the industry grew up using MS softwares, it can be difficult. But I hope that in time we will see more developments and that Google won't abandon this app because it's easier (if you get the hang of it) to use than Excel. No ads is just a comfort.903 people found this review helpfulDid you find this helpful?YesNoA Google usermore_vert Flag inappropriateFebruary 16, 2020Way more limited features than the one on computers, especially with the charts and such. As a student I don't usually have an available pc at hand and I can't really drag a laptop around just in case I need to do things or make specific edits. If it had most of the features found on the one in the internet it would've been much more easier to work with. The same is with Docs and Slides as well. Limited editing features for an "easier" work flow makes it more frustrating and annoying really.1,108 people found this review helpfulDid you find this helpful?YesNoFreshy Serapiomore_vert Flag inappropriateAugust 14, 2022I love it! It helps everyone from the team and friends to share some files/documents. The only problem I see is that some options from the google sheet is not found on the microsoft excel and vice versa. Is there any way to have it all for both parties? As well as when freezing a column/row and when transferring the files vice versa there are different added sheets. Please make a way that every features can be intact when transferring into both apps.1,231 people found this review helpfulDid you find this helpful?YesNoSee all reviewsWhat's new* Bug fixes and performance improvementsflagFlag as inappropriateApp supportexpand_morepublicWebsiteemailSupport emailapps-help@google.complaceAddress1600 Amphitheatre Parkway, Mountain View 94043shieldPrivacy PolicyMore by Google LLCarrow_forwardYouTube KidsGoogle LLC4.5starGoogle DocsGoogle LLC4.0starGoogle ClassroomGoogle LLC3.3starGoogle AuthenticatorGoogle LLC4.3starGoogle DriveGoogle LLC4.3starGoogle Find My DeviceGoogle LLC4.5starSimilar appsarrow_forwardMicrosoft Excel: SpreadsheetsMicrosoft Corporation4.8starMicrosoft Word: Edit DocumentsMicrosoft Corporation4.7starMicrosoft PowerPointMicrosoft Corporation4.7starMicrosoft 365 (Office)Microsoft Corporation4.7starAll Document Reader - One ReadSimple Design Ltd.4.9starWPS Office-PDF,Word,Sheet,PPTWPS SOFTWARE PTE. LTD.4.6starflagFlag as inappropriateGoogle PlayPlay PassPlay PointsGift cardsRedeemRefund policyKids & familyParent GuideFamily sharingTerms of ServicePrivacyAbout Google PlayDevelopersGoogle StorePhilippines (English (United State

Google Sheets: Online Spreadsheet Editor | Google Workspace

Pumunta sa Content

Sheets

Mag-sign in Pumunta sa Sheets Subukan, Sheets for Work

Pumunta sa Content

Sheets

Overview

Mga Feature

Seguridad

Pagpepresyo

Tools pa

Drive

Gmail

Meet

Calendar

Docs

Sheets

Slides

Forms

Drive

Cloud Storage

Gmail

Custom na Pangnegosyong Email

Meet

Pakikipagkumperensya gamit ang video at boses

Calendar

Mga Nakabahaging Kalendaryo

Docs

Word Processing

Sheets

Mga Spreadsheet

Slides

Presentation Builder

Forms

Survey builder

Google Workspace

Isang naka-integrate na hanay ng mga secure at cloud-native na collaboration at productivity app na pinapagana ng Google AI.

Matuto Pa

Mag-sign in Pumunta sa Sheets Subukan, Sheets for Work

Gumawa ng mga pagpapasyang nakabatay sa data, sa Google Sheets

Gumawa at mag-collaborate sa mga online na spreadsheet nang real-time at mula sa anumang device.

Subukan, Sheets for Work Pumunta sa Sheets

Walang account?

Mag-sign up nang libre

Para sa personal kong paggamit

Para sa trabaho o aking negosyo

Anna Chang

T h e s e n u m b e r s l o o k v e r y s t r o n g !

Alamin kung ano ang puwede mong gawin sa Google Sheets

Mag-collaborate sa data kahit saan

Magtakda ng ground truth para sa data sa iyong online na spreadsheet, sa tulong ng madaling pagbabahagi at real-time na pag-edit. Gumamit ng mga komento at magtalaga ng mga item ng pagkilos para mapanatiling tuloy-tuloy ang pagsusuri.

Mas mabilis na makita ang mga insight gamit ang mga naka-built in na "artificial intelligence"

Tumutulong sa iyo ang mga nakakatulong na feature tulad ng Smart Fill at suhestyon sa formula na mas mabilis na sumuri nang may mas kaunting pagkakamali. At mabilis na makakuha ng mga insight sa pamamagitan ng pagtatanong tungkol sa iyong data sa simpleng wika.

Walang kahirap-hirap na kumonekta sa iba pang Google app

Masusing nakakonekta ang Sheets sa iba pang Google app na gusto mo, kung kaya't makakatipid ka ng oras. Suriin sa Sheets ang data sa Google Forms nang walang kahirap-hirap, o mag-embed ng mga Sheets chart sa Google Slides at Docs. Magagawa mo ring sumagot sa mga komento mula mismo sa Gmail at mag-present ng iyong mga spreadsheet sa Google Meet nang walang kahirap-hirap.

Mag-collaborate at gumamit ng "artificial intelligence" sa mga Excel file

Mag-edit ng mga Microsoft Excel spreadsheet online nang walang kahirap-hirap at nang hindi kino-convert ang mga ito, at gumamit ng mga pinahusay na collaborative at nakakatulong na feature ng Sheets tulad ng mga komento, item ng pagkilos, at Smart Fill.

Bumuo ng mga custom na solusyon

Pabilisin ang mga workflow sa pamamagitan ng pagbuo ng mga business app at automation. Gamitin ang AppSheet para bumuo ng mga custom na application kasama ng Sheets, nang hindi na kailangang magsulat ng code. O magdagdag ng mga custom na function, item sa menu, at macro gamit ang Apps Script.

Palaging gumamit ng bagong data

Sa Sheets, palaging nagtatrabaho ang lahat sa pinakabagong bersyon ng spreadsheet. At sa pamamagitan ng awtomatikong pag-save ng mga pag-edit sa history ng bersyon, madaling i-undo ang mga pagbabago o kahit makita ang history ng pag-edit ng indibidwal na cell sa spreadsheet.

Walang kahirap-hirap na kumonekta sa mahalagang data

Kunin at suriin ang data mula sa iba pang tool na ginagamit mo, tulad ng data ng customer mula sa Salesforce. Puwede ring gamitin ng mga customer ng Enterprise ang Mga Nakakonektang Sheet para masuri ang bilyon-bilyong row ng data ng BigQuery sa Sheets – nang hindi na kailangang magsulat ng anumang code.

Seguridad, pagsunod, at privacy

Secure bilang default

Gumagamit kami ng mga hakbang panseguridad na nangunguna sa industriya para mapanatiling ligtas ang iyong data, kabilang ang mga advanced na proteksyon laban sa malware. Cloud-native din ang Sheets, na nag-aalis sa pangangailangan para sa mga lokal na file at binabawasan nito ang panganib sa iyong mga device.

Ine-encrypt habang ipinapadala at hindi ipinapadala

Naka-encrypt ang lahat ng file na na-upload sa Google Drive o ginawa sa Sheets habang ipinapadala at hindi ipinapadala.

Pagsunod bilang suporta sa mga pampangasiwaang kinakailangan

Ang aming mga produkto, kabilang ang Sheets, ay regular na sumasailalim sa hiwalay na pag-verify para sa mga kontrol ng mga ito sa seguridad, privacy, at pagsunod.

Pribado ayon sa disenyo

Sumusunod ang Sheets sa mahihigpit na pangako sa privacy at proteksyon ng data na sinusunod din ng iba pang serbisyo sa enterprise ng Google Cloud.

Ikaw ang may kontrol sa iyong data.

Hindi namin kailanman ginagamit ang iyong content sa Sheets para sa mga layunin ng ad.

Hindi namin kailanman ibinebenta ang iyong personal na impormasyon sa mga third party.

Hanapin ang plan na angkop para sa iyo

Ang Google Sheets ay bahagi ng Google Workspace

Kabilang sa bawat plan ang

Docs

Sheets

Slides

Forms

Keep

Sites

Drive

Gmail

Meet

Calendar

Chat

Subukan, Sheets for Work

Para sa Personal (Libre)

Pumunta sa Sheets

Business Standard

$12 USD

kada user / buwan, 1 taong commitment info O $14.40 kada user / buwan, kapag buwan-buwang siningil

Magsimula

Tumingin pa ng plan

Docs, Sheets, Slides, Forms

paggawa ng content

done

Drive

Secure na cloud storage

15 GB bawat user

2 TB bawat user

Mga shared drive para sa iyong team

remove

done

Gmail

Secure na email

done

Custom na pangnegosyong email

remove

done

Meet

Pakikipagkumperensya gamit ang video at boses

100 kalahok

150 kalahok

Na-save sa Drive ang mga recording ng meeting

remove

done

Admin

Sentralisadong pangangasiwa

remove

done

Mga kontrol sa patakaran sa seguridad na nakabatay sa grupo

remove

done

Suporta sa customer

Mga self-service na online na forum at forum ng komunidad

24/7 na online support at mga forum ng komunidad

Mag-collaborate mula kahit saan, sa anumang device

I-access, gawin, at i-edit ang iyong mga spreadsheet nasaan ka man — mula sa anumang mobile device, tablet, o computer — kahit na offline.

Magsimula sa mga template

Pumili sa iba't ibang dashboard, tracker ng proyekto, at iba pang template na propesyonal na idinisenyo para simulan nang mabilis ang mga bagay-bagay.

Invoice

Badyet

Timeline

Grade Book

Invoice

Badyet

Timeline

Grade Book

Bisitahin ang Gallery ng Template ng Sheets para sa higit pa.

Handa ka na bang magsimula?

Subukan, Sheets for Work Pumunta sa Sheets

Mga link sa footer

Subaybayan ang aming Blog

Tungkol sa Google

Mga produkto ng Google

Privacy

Mga Tuntunin

Tulong

Afrikaans

English

አማርኛ

العربية

azərbaycan

български

বাংলা

català

čeština

dansk

Deutsch

Ελληνικά

English (United Kingdom)

español (Latinoamérica)

español

eesti

euskara

فارسی

suomi

Filipino

français (Canada)

français

galego

ગુજરાતી

हिन्दी

hrvatski

magyar

հայերեն

Indonesia

íslenska

italiano

עברית (ישראל)

日本語

ქართული

ខ្មែរ

ಕನ್ನಡ

한국어

ລາວ

lietuvių

latviešu

മലയാളം

монгол

मराठी

Melayu

नेपाली

Nederlands

norsk bokmål (Norge)

polski

português (Brasil)

português (Portugal)

română

русский

සිංහල

slovenčina

slovenščina

српски

svenska

Kiswahili

தமிழ்

తెలుగు

ไทย

Türkçe

українська

اردو

Tiếng Việt

中文 (简体)

中文

中文 (繁體)

isiZulu

Google Sheets: Online Spreadsheets for Business | Google Workspace

Solutions

For Individuals

For Business

Overview

Small Business

New Business

Startups

For Enterprise

Overview

Frontline Workers

Work Safer

Developers

Education

Nonprofits

Products

Gmail

Calendar

Drive

Meet

Docs

Sheets

Slides

Chat

Admin console

Add-ons

Industries

Healthcare and Life Sciences

Retail

Manufacturing

Government and Public Sector

Professional Services

Technology

Departments

Sales

Marketing

Human Resources

Security

Pricing

Resources

Discover

Security

Blog

Customer stories

Learn

Product demo

FAQs

Training and certification

Live and on-demand events

Video conferencing

Connect

Partners

Marketplace

Integrations

Refer Google Workspace

Support for admins

Support for users

Admin console

Contact sales

Start Free Trial

Solutions

For Individuals

Overview

Google Workspace Individual

For Business

Overview

Google Workspace Business

Small Business

Small business productivity tools

New Business

Tools for new businesses

Startups

Startup productivity tools

For Enterprise

Overview

Google Workspace Enterprise

Frontline Workers

Google Workspace for the frontline

Work Safer

Protect organizations from cyberattacks

Developers

Education

Nonprofits

Products

See all apps

Gmail

Custom business email

Calendar

Shared calendars

Drive

Cloud storage

Meet

Video and voice conferencing

Docs

Word processing

Sheets

Spreadsheets

Slides

Presentation builder

Chat

Messaging for teams

Admin console

Add-ons

Industries

Healthcare and Life Sciences

Retail

Manufacturing

Government and Public Sector

Professional Services

Technology

Departments

Sales

Marketing

Human Resources

Security

Pricing

Resources

Discover

Security

Protecting your data

Blog

How to use Google Sheets - Computer - Google Docs Editors Help

to use Google Sheets - Computer - Google Docs Editors Help Skip to main content Google Docs Editors HelpSign inGoogle HelpHelp CenterCommunityGoogle Docs EditorsPrivacy PolicyTerms of ServiceSubmit feedback Send feedback on...This help content & informationGeneral Help Center experienceNextHelp CenterCommunityGoogle Docs EditorsGoogle SheetsGet started with Google SheetsHow to use Google Sheets How to use Google Sheets

Want advanced Google Workspace features for your business?

Try Google Workspace today!

Google Sheets is an online spreadsheet app that lets you create and format spreadsheets and work with other people.

DOWNLOAD CHEAT SHEET

Step 1: Create a spreadsheet

To create a new spreadsheet:

Open the Sheets home screen at sheets.google.com.

Click New . This will create and open your new spreadsheet.

You can also create new spreadsheets from the URL sheets.google.com/create.

Step 2: Edit and format a spreadsheet

You can add, edit, or format text, numbers, or formulas in a spreadsheet.

Edit and format a spreadsheet

Use formulas and functions in a spreadsheet

Step 3: Share & work with others

You can share files and folders with people and choose whether they can view, edit, or comment on them.

Learn more about Tool finder for Docs, Sheets & Slides

Computer AndroidiPhone & iPad More Need more help? Try these next steps: Post to the help community Get answers from community members true Get started with Google Sheets1 of 6How to use Google Sheets2 of 6Switch to Google Sheets from Microsoft Excel3 of 6Create, view, or download a file4 of 6Create a file from a template5 of 6Edit & format a spreadsheet6 of 6Use comments, action items, & emoji reactions Visit the Learning Center Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more. ©2024 Google Privacy Policy Terms of Service dansk‎Deutsch‎English (United Kingdom)‎español‎español (Latinoamérica)‎français‎Indonesia‎italiano‎Nederlands‎norsk‎polski‎português‎português (Brasil)‎suomi‎svenska‎Tiếng Việt‎Türkçe‎čeština‎русский‎‏עברית‏العربيةमराठी‎हिन्दी‎தமிழ்‎తెలుగు‎ไทย‎中文（简体）‎中文（繁體）‎日本語‎한국어‎ English‎ Enable Dark Mode Send feedback on... This help content & information General Help Center experience SearchClear searchClose searchGoogle appsMain menu 3797828382356579539 true Search Help Center true true true true true 35 false fal

Google Sheets - Wikipedia

Jump to content

Main menu

move to sidebar

hide

Navigation

Main pageContentsCurrent eventsRandom articleAbout WikipediaContact usDonate

Contribute

HelpLearn to editCommunity portalRecent changesUpload file

Create account

Personal tools

Create account Log in

Pages for logged out editors learn more

ContributionsTalk

Contents

move to sidebar

hide

(Top)

1History

2Platforms

3Features

Toggle Features subsection

3.1Editing

3.1.1Collaboration and revision history

3.1.2Explore

3.1.3Offline editing

3.2Files

3.2.1Supported file formats and limits

3.3Google Workspace

3.4Integration with Charts and Wikipedia

3.5Other functionality

4References

5External links

Toggle the table of contents

Google Sheets

16 languages

العربيةDeutschEspañolفارسی한국어हिन्दीBahasa IndonesiaItalianoNederlands日本語ਪੰਜਾਬੀPortuguêsTürkçeУкраїнськаTiếng Việt中文

Edit links

ArticleTalk

English

ReadEditView history

Tools

move to sidebar

hide

Actions

ReadEditView history

General

What links hereRelated changesUpload fileSpecial pagesPermanent linkPage informationCite this pageGet shortened URLDownload QR codeWikidata item

Print/export

Download as PDFPrintable version

In other projects

Wikimedia CommonsWikifunctions

From Wikipedia, the free encyclopedia

Cloud-based spreadsheet software

Google SheetsScreenshot of a Google Sheets spreadsheetDeveloper(s)Google LLCInitial releaseMarch 9, 2006; 18 years ago (2006-03-09)Written inJavaScriptOperating systemAndroid, iOS, ChromeOSAvailable in83 languages[1]Type

Collaborative software

Spreadsheet

Websitegoogle.com/sheets

Google Sheets is a spreadsheet application included as 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.[2] 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[edit]

Google Sheets originated from XL2Web, a web-based spreadsheet application developed by 2Web Technologies, founded by Jonathan Rochelle and Farzad "Fuzzy" Khosrowshahi.[3] XL2Web was acquired by Google in 2006[4] 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.[5][6] 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.[7] 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.[8] Improvements based on DocVerse were announced and deployed in April 2010.[9] In June 2012, Google acquired Quickoffice, a freeware proprietary productivity suite for mobile devices.[10] 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.[11]

Platforms[edit]

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

Apps ScriptDeveloper(s)GoogleInitial releaseAugust 19, 2009; 14 years ago (2009-08-19)[18]Written inJavaScriptTypeWeb application framework, scripting languageWebsitescript.google.com

Features[edit]

Editing[edit]

Collaboration and revision history[edit]

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.[19] 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.[20] Sheets supports tagging for archival and organizational purposes.

Explore[edit]

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

Offline editing[edit]

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.[30] The Android and iOS apps natively support offline editing.[31][32]

Files[edit]

Supported file formats and limits[edit]

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[33] Overall document size is capped at 10 million cells.[34][35]

Google Workspace[edit]

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

Integration with Charts and Wikipedia[edit]

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

Other functionality[edit]

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

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

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

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

References[edit]

^ Hill, Ian (June 18, 2013). "18 New Languages for Drive, Docs, Sheets, and Slides". Google Drive Blog. Retrieved October 29, 2016.

^ "Office editing makes it easier to work with Office files in Docs, Sheets, and Slides". G Suite Updates Blog. Retrieved August 12, 2019.

^ Surden, Esther (June 26, 2013). "At Madison Meetup, NJ's Rochelle Talks XL2Web Acquisition by Google". NJ Tech Weekly. Retrieved October 15, 2021.

^ Dawson, Christopher (October 30, 2010). "Google's 40 acquisitions in 2010: What about integration?". ZDNet. CBS Interactive. Retrieved June 1, 2017.

^ Rochelle, Jonathan (June 6, 2006). "It's nice to share". Official Google Blog. Retrieved October 29, 2016.

^ "Google Announces limited test on Google Labs: Google Spreadsheets". June 6, 2006. Retrieved October 29, 2016.

^ "Google Announces Google Docs & Spreadsheets". October 11, 2006. Retrieved October 29, 2016.

^ Jackson, Rob (March 5, 2010). "Google Buys DocVerse For Office Collaboration: Chrome, Android & Wave Implications?". Phandroid. Retrieved October 20, 2016.

^ Belomestnykh, Olga (April 15, 2010). "A rebuilt, more real-time Google documents". Google Drive Blog. Retrieved October 30, 2016.

^ Warren, Alan (June 5, 2012). "Google + Quickoffice = get more done anytime, anywhere". Official Google Blog. Retrieved October 30, 2016.

^ 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.

^ "System requirements and browsers". Docs editors Help. Retrieved December 16, 2016.

^ "Dedicated desktop home pages for Google Docs, Sheets & Slides". G Suite Updates. June 25, 2014. Retrieved December 16, 2016.

^ 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.

^ 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.

^ "New Google Slides, Docs, and Sheets apps for iOS". G Suite Updates. August 25, 2014. Retrieved December 16, 2016.

^ "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.

^ Meyer, David (August 20, 2009). "Google Apps Script gets green light". CNet. Archived from the original on August 10, 2012. Retrieved March 26, 2011.

^ "See the history of changes made to a file". Docs editors Help. Retrieved February 20, 2017.

^ "Share a copy of a file in an Office format". G Suite Learning Center. Retrieved August 12, 2019.

^ 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.

^ Novet, Jordan (September 29, 2016). "Google updates Calendar, Drive, Docs, Sheets, and Slides with machine intelligence features". VentureBeat. Retrieved December 16, 2016.

^ Allan, Darren (September 30, 2016). "Google wants to better challenge Microsoft Office with these new features". TechRadar. Future plc. Retrieved December 16, 2016.

^ Lardinois, Frederic (June 1, 2017). "Google Sheets now uses machine learning to help you visualize your data". TechCrunch. AOL. Retrieved June 1, 2017.

^ 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.

^ Miller, Ron (December 6, 2017). "Latest Google Sheets release helps automate pivot table creation". TechCrunch. Oath Inc. Retrieved December 14, 2017.

^ Gagliordi, Natalie (December 6, 2017). "Google brings new AI, machine learning features to Sheets". ZDNet. CBS Interactive. Retrieved December 14, 2017.

^ Weber, Ryan (October 19, 2016). "Five new ways to reach your goals faster with G Suite". The Keyword Google Blog. Retrieved December 14, 2016.

^ Gupta, Saurabh (March 11, 2014). "Bring a little something extra to Docs and Sheets with add-ons". Google Drive Blog. Retrieved October 30, 2016.

^ "Work on Google files offline". Drive Help. Retrieved January 14, 2017.

^ "Work with Office files". Docs editors Help. Retrieved October 30, 2016.

^ "Files you can store in Google Drive". Drive Help. Retrieved November 1, 2019.

^ "Insert or delete images or videos". Docs editors Help. Retrieved October 22, 2016.

^ "G Suite - Choose a Plan". Retrieved October 30, 2016.

^ "Google Spreadsheets | Charts". Google Developers. Retrieved March 1, 2020.

^ "Wikipedia and Wikidata Tools - G Suite Marketplace". gsuite.google.com.

^ "Copy and paste text and images". Retrieved October 30, 2016.

^ "Office Editing for Docs, Sheets & Slides". Chrome Web Store. Retrieved October 30, 2016.

^ "Remove the Office compatibility app". G Suite Admin Help. Retrieved August 12, 2019.

^ Sinha, Shan (February 24, 2011). "Google Cloud Connect for Microsoft Office available to all". Google Drive Blog. Retrieved October 30, 2016.

^ White, Charlie (February 24, 2011). "Now Anyone Can Sync Google Docs & Microsoft Office". Mashable. Retrieved October 30, 2016.

^ "Migrate from Google Cloud Connect to Google Drive". Apps Documentation and Support. Archived from the original on March 17, 2013. Retrieved October 30, 2016.

^ "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.

External links[edit]

Official website

vteSpreadsheetsFree and open-source

Calligra Sheets

Calc

Collabora Online

LibreOffice

OpenOffice

Gnumeric

Pyspread

Proprietary freeware

Google Sheets (online)

WPS Spreadsheet

Retail

Apple Numbers

Microsoft Excel

PlanMaker

Quattro Pro

Discontinued

AppleWorks

As-Easy-As

Boeing Calc

Claris Resolve

Calc

StarOffice

OpenOffice.org

Go-oo

NeoOffice

Full Impact

Gobe Productive

GNU Oleo

Informix Wingz

IBM Lotus Symphony

KCells

Lotus 1-2-3

Lotus Improv

Lucid 3-D

Microsoft Works

Multiplan

Siag

SuperCalc

T/Maker

VisiCalc

Category

Comparison

List

Online spreadsheet

vteGoogle

Alphabet Inc.

History

List of Android apps

List of Easter eggs

April Fools' Day

List of mergers and acquisitions

CompanyDivisions

Ads

Brain

DeepMind

Android

booting process

recovery mode

software development

version history

China

Goojje

Chrome

Cloud

Glass

Google.org

Crisis Response

Public Alerts

RechargeIT

Health

Maps

Pixel

Timeline

Sidewalk Labs

Sustainability

YouTube

History

"Me at the zoo"

Social impact

YouTuber

PeopleCurrent

Krishna Bharat

Vint Cerf

Jeff Dean

John Doerr

Sanjay Ghemawat

Al Gore

John L. Hennessy

Urs Hölzle

Salar Kamangar

Ray Kurzweil

Ann Mather

Alan Mulally

Rick Osterloh

Sundar Pichai (CEO)

Ruth Porat (CFO)

Rajen Sheth

Hal Varian

Susan Wojcicki

Neal Mohan

Former

Andy Bechtolsheim

Sergey Brin (Founder)

David Cheriton

Matt Cutts

David Drummond

Alan Eustace

Timnit Gebru

Omid Kordestani

Paul Otellini

Larry Page (Founder)

Patrick Pichette

Eric Schmidt

Ram Shriram

Amit Singhal

Shirley M. Tilghman

Rachel Whetstone

Real estate

111 Eighth Avenue

Androidland

Barges

Binoculars Building

Central Saint Giles

Chelsea Market

Chrome Zone

Data centers

Googleplex

Mayfield Mall

Pier 57

Sidewalk Toronto

St. John's Terminal

YouTube Space

YouTube Theater

Design

Fonts

Croscore

Noto

Product Sans

Roboto

Logo

Doodle

Doodle Champion Island Games

Magic Cat Academy

Material Design

Events

Android

Developer Challenge

Developer Day

Developer Lab

Code-in

Code Jam

Developer Day

Developers Live

Doodle4Google

G-Day

I/O

Jigsaw

Living Stories

Lunar XPRIZE

Mapathon

Science Fair

Summer of Code

Talks at Google

YouTube

Awards

CNN/YouTube presidential debates

Comedy Week

Live

Music Awards

Space Lab

Symphony Orchestra

Projects andinitiatives

20% project

Area 120

Tables

ATAP

Business Groups

Computing University Initiative

Data Liberation Front

Data Transfer Project

Developer Expert

Digital Garage

Digital News Initiative

Digital Unlocked

Dragonfly

Founders' Award

Free Zone

Get Your Business Online

Google for Education

Google for Startups

Labs

Liquid Galaxy

Made with Code

Māori

ML FairnessNative Client

News Lab

Nightingale

OKR

PowerMeter

Privacy Sandbox

Quantum Artificial Intelligence Lab

RechargeIT

Shield

Silicon Initiative

Solve for X

Starline

Student Ambassador Program

Submarine communications cables

Dunant

Grace Hopper

Sunroof

Versus Debates

YouTube

Creator Awards

Next Lab and Audience Development Group

Original Channel Initiative

Zero

Criticism

2018 data breach

2018 walkouts

Alphabet Workers Union

Censorship

DeGoogle

"Did Google Manipulate Search for Hillary?"

Dragonfly

FairSearch

"Ideological Echo Chamber" memo

Litigation

Privacy concerns

Street View

San Francisco tech bus protests

Services outages

Smartphone patent wars

Worker organization

YouTube

Back advertisement controversy

Censorship

Elsagate

Fantastic Adventures scandal

Headquarters shooting

Kohistan video case

Reactions to Innocence of Muslims

Slovenian government incident

DevelopmentOperating systems

Android

Automotive

Glass OS

gLinux

Goobuntu

Things

Wear OS

ChromeOS

ChromiumOS

Neverware

Fuchsia

Libraries/frameworks

ALTS

AMP

Angular

ARCore

APIs

Blockly

Chart API

Charts

Dialogflow

Exposure Notification

Fast Pair

Federated Learning of Cohorts

File System

FlatBuffers

Flutter

Gears

gRPC

Gson

Guava

Guice

Guetzli

JAX

gVisor

MapReduce

Matter

Mobile Services

Neural Machine Translation

OpenSocial

Pack

Polymer

Protocol Buffers

Reqwireless

Shell

Skia Graphics Engine

Tango

TensorFlow

Test

WaveNet

Weave

Web Accelerator

WebRTC

Platforms

App Engine

AppJet

Apps Script

Cloud Platform

Anvato

Firebase

Cloud Messaging

Crashlytics

Global IP Solutions

Internet Low Bitrate Codec

Internet Speech Audio Codec

Gridcentric, Inc.

ITA Software

Kubernetes

LevelDB

Neatx

SageTV

Apigee

Bigtable

Bitium

Chronicle

VirusTotal

Compute Engine

Connect

Dataflow

Datastore

Kaggle

Looker

Mandiant

Messaging

Orbitera

Shell

Stackdriver

Storage

Tools

American Fuzzy Lop

Android Cloud to Device Messaging

Android Debug Bridge

Android Studio

App Maker

App Runtime for Chrome

AppSheet

Bazel

Chrome Frame

Closure Tools

Cpplint

Data Protocol

Gadgets

Gerrit

GYP

Kythe

Lighthouse

MIT App Inventor

Mashup Editor

Native Client

Optimize

OpenRefine

OR-Tools

PageSpeed

Plugin for Eclipse

Programmable Search Engine

Public DNS

reCAPTCHA

Schema.org

Search Console

Sitemaps

Swiffy

Tesseract (software)

Trendalyzer

VisBug

Wave Federation Protocol

Web Toolkit

Search algorithms

Hummingbird

PageRank

applications in biochemistry

Matrix

Panda

Penguin

Pigeon

RankBrain

Others

BERT

BigQuery

Chrome Experiments

Flutter

Gemini

Googlebot

Keyhole Markup Language

LaMDA

Open Location Code

PaLM

Programming languages

Caja

Carbon

Dart

Sawzall

Transformer

Viewdle

Webdriver Torso

Web Server

File formats

AAB

APK

AV1

On2 Technologies

VP3

VP6

VP8

libvpx

VP9

WebM

WebP

WOFF2

ProductsEntertainment

Currents (news app)

Green Throttle Games

Owlchemy Labs

Oyster

PaperofRecord.com

Podcasts

Quick, Draw!

Santa Tracker

Songza

Stadia

games

Typhoon Studios

Vevo

Video

Play

Books

Games

most downloaded apps

Music

Newsstand

Pass

Services

YouTube

BandPage

BrandConnect

Content ID

Instant

Kids

Music

Official channel

Preferred

Premium

original programming

YouTube Rewind

RightsFlow

Shorts

Studio

Communication

Allo

Bump

Buzz

Chat

Contacts

Currents (social app)

Dodgeball

Duo

Fi Wireless

Friend Connect

Gizmo5

Google+

Gmail

History

Inbox

Interface

Groups

Hangouts

Helpouts

IME

Japanese

Pinyin

Jaiku

Marratech

Meebo

Meet

Messages

Moderator

Neotonic Software

Orkut

Postini

Quest Visual

Word Lens

Schemer

Spaces

Sparrow

Talk

Translate

Translator Toolkit

Voice

Voice Local Search

Wave

Aardvark

Alerts

Answers

Base

BeatThatQuote.com

Blog Search

Books

Ngram Viewer

Code Search

Data Commons

Dataset Search

Dictionary

Category

RelatedTerms and phrases

"Don't be evil"

Gayglers

Google (verb)

Google bombing

2004 U.S. presidential election

Google effect

Googlefight

Google hacking

Googleshare

Google tax

Googlewhack

Googlization

"Illegal flower tribute"

Rooting

Search engine manipulation effect

Sitelink

Site reliability engineering

YouTube poop

Documentaries

AlphaGo

Google: Behind the Screen

Google Maps Road Trip

Google and the World Brain

The Creepy Line

Books

Google Hacks

The Google Story

Google Volume One

Googled: The End of the World as We Know It

How Google Works

I'm Feeling Lucky

In the Plex

The Google Book

The MANIAC

Popular culture

Google Feud

Google Me (film)

"Google Me" (Kim Zolciak song)

"Google Me" (Teyana Taylor song)

Is Google Making Us Stupid?

Proceratium google

Matt Nathanson: Live at Google

The Billion Dollar Code

The Internship

Where on Google Earth is Carmen Sandiego?

Others

"Attention Is All You Need"

elgooG

g.co

.google

Pimp My Search

Predictions of the end

Relationship with Wikipedia

Sensorvault

Stanford Digital Library Project

Italics indicate discontinued products or services.

Category

Commons

Outline

WikiProject

Retrieved from "https://en.wikipedia.org/w/index.php?title=Google_Sheets&oldid=1209659764"

Categories: Google softwareSpreadsheet softwareSpreadsheet software for macOSSpreadsheet software for WindowsAndroid (operating system) softwareIOS softwareWeb applicationsGoogle Docs EditorsHidden categories: Articles with short descriptionShort description matches WikidataUse American English from December 2022All Wikipedia articles written in American EnglishUse mdy dates from December 2022

This page was last edited on 23 February 2024, at 00:13 (UTC).

Text is available under the Creative Commons Attribution-ShareAlike License 4.0;

additional terms may apply. By using this site, you agree to the Terms of Use and Privacy Policy. Wikipedia® is a registered trademark of the Wikimedia Foundation, Inc., a non-profit organization.

About Wikipedia

Disclaimers

Contact Wikipedia

Code of Conduct

Developers

Statistics

Cookie statement

Mobile view

Toggle limited content width

Google Sheets training and help - Google Workspace Learning Center

le Sheets training and help - Google Workspace Learning Center Skip to main content Google Workspace Learning CenterSign inGoogle HelpHelp CenterGet startedLearn by productLearn by role & industryHybrid workplace tipsGen AI tipsProductivity tipsBusiness tutorialsSwitch from Microsoft & othersSupport & accessibilityGoogle WorkspacePrivacy PolicyTerms of ServiceSubmit feedback Send feedback on...This help content & informationGeneral Help Center experienceNextHelp CenterWhat's new?Google WorkspaceGet startedWelcomeGet ready to switchWhat to do on your first dayYour first week & beyondCheat sheets & reference guidesOpen Google Workspace appsLearn by productCalendarChatChrome browserDocsDriveGeminiGmailMeetSheetsSlidesManaged teamsMobile & device setupAll productsLearn by role & industryAdministrative assistantsDigital marketingFinanceHealthcareHuman resourcesLaw practicesManufacturingMedia & entertainmentNonprofitsProfessional servicesProject managementResearch & developmentRetailSales & marketingTechnical supportUX designVisual designWeb developmentHybrid workplace tipsHybrid work training & helpUse Meet Companion modeStay connected when working remotelyWork from homeWork with remote teamsPlan & hold meetings from anywhereHold large remote eventsWork with non-Google Workspace usersGen AI tipsGenerative AI training & helpGet started with GeminiGemini cheat sheetRole-specific prompts & use casesTips for writing prompts for GeminiGemini usage limitsLearn about generative AIProductivity tipsSet up business meetingsDiscuss topics with your teamBrainstorm with colleaguesImprove communicationMake video conference callsCreate great presentationsCreate strong proposalsOnboard team membersOptimize your inboxAnalyze dataClean up dataGo paperlessBusiness tutorialsUse generative AI at workPlan & manage a projectPlan & hold meetings from anywhereHold large remote eventsStay connected when working remotelyCollaborate with decision makersShare a final documentFree up storage spacePlan a project with external clientsDelegate work when you're OOOGet up to speed after time offAdditional training resourcesSwitch from Microsoft & othersSwitch from MicrosoftSwitch from SlackSwitch from Zoom, Skype, or WebexSwitch from Box, Dropbox, or C:\ driveSwitch from HCL NotesSupport & accessibilitySupport for usersSupport for administratorsAccessibilitySave or customize Learning Center guides Notification Bring your best ideas to life with Gemini for Google Workspace. Get tips & real-life use cases for using gen AI at work. Google Sheets training and helpCreate spreadsheets for your data and collaborate with your colleagues.

On this page

Sheets quick start guides

Sheets cheat sheet

Sheets productivity guides

Sheets troubleshooting & more resources

Get Sheets: Web (sheets.google.com), Android, or iOS

Want advanced Google Workspace features for your business?

Try Google Workspace today!

Sheets quick start guides

Quickly learn how to create and edit a spreadsheet, move to Sheets from another online spreadsheet app, and more.

Get started with Sheets Switch from Microsoft Excel to Sheets

Sheets cheat sheet

Print this visual reminder to keep handy as you get up to speed using Sheets.

Sheets cheat sheet

Sheets productivity guides

Create project plans with Sheets

Use a spreadsheet to track, update, and collaborate on projects with your team.

Tips to add & import data

Import big data using BigQuery

Compile data from separate spreadsheets

Add Analytics data

Use macros , add-ons, and scripts

Tips to format & clean up data

Add your logo or checkboxes

Color-code tabs & data entries

Space, split, or swap rows & columns

Format currencies & validate email addresses

Tips to analyze your data

Summarize data with charts & pivot tables

Filter data in custom views

Make calculations with formulas

Freeze headings & add links

Tips to edit and collaborate on files

Track changes or revert to an earlier version

Get notified about changes to a spreadsheet

Find and act on comments

Email your collaborators

Sheets troubleshooting & more resources

Troubleshoot Sheets

Take Google's online Sheets course

Google Sheets accessibility

How Google handles your information

Visit the Sheets Help Center

Get certified in data analytics

Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.

Was this helpful?How can we improve it?YesNoSubmit true Sheets1 of 9Google Sheets training and help2 of 9Get started with Sheets for Google Workspace3 of 9Switch from Excel to Sheets4 of 9Google Sheets cheat sheet5 of 9Create project plans with Sheets6 of 9Tips to add & import data7 of 9Tips to format & clean up data8 of 9Tips to analyze data9 of 9Use Google Workspace keyboard shortcuts Print, save, or customize Learning Center guides Learn how to print Learning Center guides, save them as PDFs, or customize them for your organization. ©2024 Google Privacy Policy Terms of Service Deutsch‎español‎français‎Indonesia‎italiano‎Nederlands‎polski‎português (Brasil)‎svenska‎Türkçe‎русский‎‏العربيةไทย‎中文（简体）‎中文（繁體）‎日本語‎한국어‎ English‎ Enable Dark Mode Send feedback on... This help content & information General Help Center experience SearchClear searchClose searchGoogle appsMain menu 2896656860424280863 true Search Help Center true true true false fal

Google Sheets cheat sheet - Google Workspace Learning Center

le Sheets cheat sheet - Google Workspace Learning Center Skip to main content Google Workspace Learning CenterSign inGoogle HelpHelp CenterGet startedLearn by productLearn by role & industryHybrid workplace tipsGen AI tipsProductivity tipsBusiness tutorialsSwitch from Microsoft & othersSupport & accessibilityGoogle WorkspacePrivacy PolicyTerms of ServiceSubmit feedback Send feedback on...This help content & informationGeneral Help Center experienceNextHelp CenterWhat's new?Google WorkspaceGet startedWelcomeGet ready to switchWhat to do on your first dayYour first week & beyondCheat sheets & reference guidesOpen Google Workspace appsLearn by productCalendarChatChrome browserDocsDriveGeminiGmailMeetSheetsSlidesManaged teamsMobile & device setupAll productsLearn by role & industryAdministrative assistantsDigital marketingFinanceHealthcareHuman resourcesLaw practicesManufacturingMedia & entertainmentNonprofitsProfessional servicesProject managementResearch & developmentRetailSales & marketingTechnical supportUX designVisual designWeb developmentHybrid workplace tipsHybrid work training & helpUse Meet Companion modeStay connected when working remotelyWork from homeWork with remote teamsPlan & hold meetings from anywhereHold large remote eventsWork with non-Google Workspace usersGen AI tipsGenerative AI training & helpGet started with GeminiGemini cheat sheetRole-specific prompts & use casesTips for writing prompts for GeminiGemini usage limitsLearn about generative AIProductivity tipsSet up business meetingsDiscuss topics with your teamBrainstorm with colleaguesImprove communicationMake video conference callsCreate great presentationsCreate strong proposalsOnboard team membersOptimize your inboxAnalyze dataClean up dataGo paperlessBusiness tutorialsUse generative AI at workPlan & manage a projectPlan & hold meetings from anywhereHold large remote eventsStay connected when working remotelyCollaborate with decision makersShare a final documentFree up storage spacePlan a project with external clientsDelegate work when you're OOOGet up to speed after time offAdditional training resourcesSwitch from Microsoft & othersSwitch from MicrosoftSwitch from SlackSwitch from Zoom, Skype, or WebexSwitch from Box, Dropbox, or C:\ driveSwitch from HCL NotesSupport & accessibilitySupport for usersSupport for administratorsAccessibilitySave or customize Learning Center guides Notification Bring your best ideas to life with Gemini for Google Workspace. Get tips & real-life use cases for using gen AI at work. Google Sheets cheat sheetCreate & collaborate with online spreadsheets to analyze data, create project plans, & more—all in your browser.Get Sheets: Web (sheets.google.com), Android, or iOS

Want advanced Google Workspace features for your business?

Try Google Workspace today!

Work with your data

Copy formatting from any text and apply it to another selection of text

Format data as currency, a percentage, change decimal places, and more

Add or edit cell borders

Merge cells

Change text alignment

Change how text wraps or rotate text

Add links, comments, charts, filters, or functions

Note: To improve compatibility with Microsoft Excel keyboard shortcuts, you can override browser shortcuts.

Add rows, columns, or cells

Add rows, columns, and cells:

Select the row, column, or cell near where you want to add your new entry.

Right-click the highlighted row, column, or cellInsertchoose where to insert the new entry.

Delete, clear, or hide rows and columns:

Right-click the row number or column letter.

Click Delete, Clear, or Hide.

Delete cells:

Select the cells.

Right-clickDelete cellsShift left or Shift up.

Move rows or columns: Select the row number or column letter and drag it to a new location.

Move cells:

Select the cells.

Point your cursor to the top of the selected cells until a hand appears.

Drag the cells to a new location.

Group rows or columns:

Select the rows or columns.

Click DataGroup rows or Group columns.

Freeze header rows and columns: Keep a row or column in the same place as you scroll through your spreadsheet. On the menu bar, click ViewFreeze and choose an option.

Share your spreadsheet

Click Share and choose what collaborators can do. They'll get an email notification, too.

Share or unshare

Edit content directly

Add comments

Editor

✔

Commenter

✔

Viewer

Collaborate with your team

Chat with other people viewing the spreadsheet

Open comments thread

Share with your team

Insert comments

Copy, email, or publish your spreadsheet

Make a copy—Create a duplicate of your spreadsheet. This is a great way to create templates.

Download as—Download your spreadsheet in other formats, such as Excel or PDF.

Email as attachment—Email a copy of your spreadsheet.

Version history—See all the changes you and others have made to the spreadsheet or revert to earlier versions.

Publish to the web—Publish a copy of your spreadsheet as a webpage or embed your spreadsheet in a website.

Work with functions

Your most important Excel functions exist in Sheets, too. Here’s a few of the things you can do.

AVERAGE

Statistical Returns the numerical average value in a dataset, ignoring text.

AVERAGEIFS

Statistical Returns the average of a range that depends upon multiple criteria.

CHOOSE

Lookup Returns an element from a list of choices based on index.

COUNT

Statistical Returns the count of the number of numeric values in a dataset.

COUNTIF

Statistical Returns a conditional count across a range.

DATE

Date Converts a provided year, month, and day into a date.

FIND

Text Returns the position at which a string is first found within text.

GETPIVOTDATA

Text Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings.

Logical Returns one value if a logical expression is true and another if it is false.

INDEX

Lookup Returns the content of a cell, specified by row and column offset.

INT

Math Rounds a number down to the nearest integer that’s less than or equal to it.

LOOKUP

Lookup Looks through a row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column.

MATCH

Lookup Returns the relative position of an item in a range that matches a specified value.

MAX

Statistical Returns the maximum value in a numeric dataset.

MIN

Statistical Returns the minimum value in a numeric dataset.

NOW

Date Returns the current date and time as a date value.

ROUND

Math Rounds a number to a certain number of decimal places according to standard rules.

SUM

Math Returns the sum of a series of numbers and/or cells.

SUMIF

Math Returns a conditional sum across a range.

TODAY

Date Returns the current date as a date value.

VLOOKUP

Lookup Searches down the first column of a range for a key and returns the value of a specified cell in the row found.

Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.

Was this helpful?How can we improve it?YesNoSubmit true Sheets1 of 9Google Sheets training and help2 of 9Get started with Sheets for Google Workspace3 of 9Switch from Excel to Sheets4 of 9Google Sheets cheat sheet5 of 9Create project plans with Sheets6 of 9Tips to add & import data7 of 9Tips to format & clean up data8 of 9Tips to analyze data9 of 9Use Google Workspace keyboard shortcuts Print, save, or customize Learning Center guides Learn how to print Learning Center guides, save them as PDFs, or customize them for your organization. ©2024 Google Privacy Policy Terms of Service Deutsch‎español‎français‎Indonesia‎italiano‎Nederlands‎polski‎português (Brasil)‎svenska‎Türkçe‎русский‎‏العربيةไทย‎中文（简体）‎中文（繁體）‎日本語‎한국어‎ English‎ Enable Dark Mode Send feedback on... This help content & information General Help Center experience SearchClear searchClose searchGoogle appsMain menu 6878338624380676581 true Search Help Center true true true false fal

‎Google Sheets on the App Store

ExitAppleStoreMaciPadiPhoneWatchAirPodsTV & HomeEntertainmentAccessoriesSupport

App Store Preview

Google Sheets

Collaborate on Spreadsheets

Google LLC

#8 in Productivity

4.8 • 1.2M Ratings

Free

Screenshots

iPhone

iPad

Description

Create, edit, and collaborate on spreadsheets with the Google Sheets app. With Sheets you can:* Create new spreadsheets or edit existing ones* Share spreadsheets and collaborate with others in the same spreadsheet at the same time* Work anywhere, anytime - even offline* Format cells, enter/sort data, view charts, insert formulas, use find/replace, and more* Never worry about losing your work -- everything is automatically saved as you type* Open, edit, and save Excel filesGoogle Sheets is part of Google Workspace: where teams of any size can chat, create, and collaborate.Google Workspace subscribers have access to additional Google Sheets features, including: * Easily add collaborators to projects, see changes as they occur, receive notifications for edits that happen while you’re away, and chat with colleagues in the same spreadsheet. All changes are automatically saved as you make them. And with offline access, you can create, view, and edit files wherever and whenever* Get insights fast, powered by Google AI* Work seamlessly across Sheets and Excel* Maintain control with enterprise-grade security* Analyze data from other business-critical tools* Build custom solutions

What’s New

Mar 11, 2024

Version 1.2024.10201

* Bug fixes and performance improvements

Ratings and Reviews

4.8 out of 5

1.2M Ratings

PricelessMe

03/23/2020

An Amazing App

Love, love, love this app!!! It is amazing and dependable. I like that its offline and I can use it whereever I am, even when traveling. I use it for our family budget and to pay of large bills and credit cards. It allow me to adjust the payment amounts when I want to pay a bill off early. I list my dates by each payment and I can see exactly when I'll have a bill paid off. It's been a real asset to our family. I don't have to worry about my data being locked up until I buy or update the subscription like what happened with another app, because its free. It was such an inconvenience. But this app has proven its value time and time again. I also like how I can plug in my formulas to show the interest rate and declining balance of my credit cards. I highly recommend to everyone to use it. My sincerest thanks to the maker of this exceptional app!!!

Darklink99

12/01/2021

Google Sheets for IPad - Fundamentally Flawed

Google Sheets and other programs like it are flexible, able to be used for multiple purpose across many different fields. As such Google Sheets for IPAD may work fine for you but for my job and how I use it I spend more time hitting roadblocks and having to open my computer to accomplish tasks than I should. It leads to the essential question of why even have an app if it will be missing so many core features and have many more that are broken or flawed. The most recent examples include freezing vertical columns doing the opposite of the intended function, the complete lack of in cell text formatting, the lack of advanced sorting features and the inability to open two windows of google sheets at the same time. These are just the broken or missing features that have interrupted my workflow today, I am sure that more will occur in the future. With an app this unfinished I would look to Excel or Apple’s Numbers as alternatives if my work didn’t rely on GSuite for the sharing functionality. If the only reason a user continues to use an app is being locked into the ecosystem, it is not a good app. If you are able avoid Google Sheets and all other Google apps to avoid getting trapped in their ecosystem, especially if you plan to try and use your IPAD as a main work device.

Cristyjewelry

05/20/2019

Unable to Edit Shared Sheets

I try to go as mobile as possible, because opening up a computer all the time sometimes is just too much of a hassle or takes way too much time for something that should be done so quickly, such as signing up for a meeting time. Whenever I try to edit a spreadsheet for something like signing up, there’s always an annoying pop-up that says I need to download the app in order to edit at all. And even when I already have it downloaded, I still have to press the only “accept” button on that pop-up, which says “get the app”. It takes me back to the app store, where I then have to press “open”, and opens up to the Google Sheets app, but the sheets I would be trying to edit wouldn’t automatically come up. Checking the “Shared with Me” tab doesn’t do anything, trying the process over again doesn’t do anything, and nor does completely closing the App Store or Google Sheets app then starting the process over again do anything. This practically makes the Sheets app useless for me, because this is pretty much the only reason I need it. When using Sheets, I’m usually just trying to open someone else’s Sheets page, which they linked somewhere, and edit it rather than creating one myself.

App Privacy

The developer, Google LLC, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy.

Data Linked to You

The following data may be collected and linked to your identity:

Location

Contact Info

Contacts

User Content

Search History

Identifiers

Usage Data

Diagnostics

Other Data

Privacy practices may vary, for example, based on the features you use or your age. Learn More

Information

Seller

Google LLC

Size

306.3 MB

Category

Productivity

Compatibility

iPhone

Requires iOS 15.0 or later.

iPad

Requires iPadOS 15.0 or later.

iPod touch

Requires iOS 15.0 or later.

Languages

English, Afrikaans, Albanian, Amharic, Arabic, Armenian, Assamese, Azerbaijani, Basque, Belarusian, Bengali, Bosnian, Bulgarian, Burmese, Cambodian, Catalan, Croatian, Czech, Danish, Dutch, Estonian, Filipino, Finnish, French, Galician, Georgian, German, Greek, Gujarati, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Italian, Japanese, Kannada, Kazakh, Korean, Kyrgyz, Laotian, Latvian, Lithuanian, Macedonian, Malay, Malayalam, Marathi, Mongolian, Nepali, Norwegian Bokmål, Oriya, Persian, Polish, Portuguese, Punjabi, Romanian, Russian, Serbian, Simplified Chinese, Singhalese, Slovak, Slovenian, Spanish, Swahili, Swedish, Tagalog, Tamil, Telugu, Thai, Traditional Chinese, Turkish, Ukrainian, Urdu, Uzbek, Vietnamese, Zulu

Age Rating

Price

Free

Developer Website

App Support

Developer Website

App Support

More By This Developer

YouTube: Watch, Listen, Stream

Photo & Video

Google Maps

Navigation

Gmail - Email by Google

Productivity

Google

Utilities

Google Chrome

Utilities

Google Drive

Productivity

比特派安卓版官网|sheet

比特派安卓版官网|sheet

Google Sheets: Online Spreadsheet Editor | Google Workspace

Google Sheets: Sign-in

Google Sheets - Apps on Google Play

Google Sheets: Online Spreadsheet Editor | Google Workspace

Google Sheets: Online Spreadsheets for Business | Google Workspace

How to use Google Sheets - Computer - Google Docs Editors Help

Google Sheets - Wikipedia

Google Sheets training and help - Google Workspace Learning Center

Google Sheets cheat sheet - Google Workspace Learning Center

‎Google Sheets on the App Store

菜单

支持

Follow

比特派安卓版官网|sheet

比特派安卓版官网|sheet

Google Sheets: Online Spreadsheet Editor | Google Workspace

Google Sheets: Sign-in

Google Sheets - Apps on Google Play

Google Sheets: Online Spreadsheet Editor | Google Workspace

Google Sheets: Online Spreadsheets for Business | Google Workspace

How to use Google Sheets - Computer - Google Docs Editors Help

Google Sheets - Wikipedia

Google Sheets training and help - Google Workspace Learning Center

Google Sheets cheat sheet - Google Workspace Learning Center

‎Google Sheets on the App Store

最近的新闻

您可能喜欢的文章

比特派官网最新版下载|euphoria

imtoken钱包安卓官方版|biology

TP钱包HT如何兑换ETH

注册TP钱包-IP查找功能及用户隐私保护探讨

TP钱包跨链转账安全性分析

如何解决TP钱包互转BNB一直在确认中的问题

TP钱包官网下载苹果手机，让您安全便捷管理数字