How to Make a Google Spreadsheet: Beginners Guide

PDF download Download Article
Create spreadsheets for free with Google Sheets on your computer, Android, iPhone, or iPad
PDF download Download Article

If you’re accustomed to creating your spreadsheets using an office suite or software like Excel , you won’t have any issue in creating a Google Spreadsheet . Google Spreadsheet works the same as Excel, and you can do most of the important spreadsheet tasks with it. You can use Google Spreadsheet directly from your web browser or from its mobile app.

Things You Should Know

  • You'll need a Google account to use Google Sheets, Docs, and Google Drive.
  • Visit https://docs.google.com/spreadsheets on your computer to access Google Sheets, then click the plus to start a new spreadsheet.
  • If you have an iPhone or iPad, download Google Sheets from the App Store. On an Android, get Sheets from the Play Store.
Method 1
Method 1 of 2:

Using a Computer

PDF download Download Article
  1. 1
    Sign into Google Sheets. Visit docs.google.com/spreadsheets and sign in with your Google or Gmail account. Your Gmail account gives you free access to Google Sheets.
  2. 2
    View your existing sheets. Upon logging in, you will be brought to the main directory. If you already have existing spreadsheets, you can see and access them from here.
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6e\/Make-a-Google-Spreadsheet-Step-3.jpg\/v4-460px-Make-a-Google-Spreadsheet-Step-3.jpg","bigUrl":"\/images\/thumb\/6\/6e\/Make-a-Google-Spreadsheet-Step-3.jpg\/v4-728px-Make-a-Google-Spreadsheet-Step-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    Click the large red circle with a plus sign on the lower right corner. A new window or tab will be opened with the web-based spreadsheet.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e5\/Make-a-Google-Spreadsheet-Step-4.jpg\/v4-460px-Make-a-Google-Spreadsheet-Step-4.jpg","bigUrl":"\/images\/thumb\/e\/e5\/Make-a-Google-Spreadsheet-Step-4.jpg\/v4-728px-Make-a-Google-Spreadsheet-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    “Untitled spreadsheet” appears on the top left corner. This is the current name of the spreadsheet. Click on it, and a small window will appear. Type in the name of the spreadsheet here, and click the “OK” button. You will see the name immediately change.
  5. 5
    Work on the spreadsheet. You can work on Google Sheets much like how you would work on Microsoft Excel. There’s a header menu and a toolbar with functions very similar to those of Microsoft Excel.
    • There’s no need to save with Google Sheets as everything you do is automatically saved at regular intervals.
  6. 6
    Exit the spreadsheet when you’re finished. If you’re done with your current document, you can just simply close the window or tab. Everything is saved automatically. You can access your document from Google Sheets or Google Drive.
    7. Advertisement
Method 2
Method 2 of 2:

Using the Mobile App

PDF download Download Article
  1. 1
    Launch Google Sheets. The app icon has an icon of a file or spreadsheet on it. If you don’t have Google Sheets, you can download it for free from your device’s respective app store. You can also access your spreadsheets from the Google Drive app.
  2. 2
    Sign in with your Google account. If this is the first time you’re using the app, you will need to link it with your Google account first in order for you to access your Google Sheets. Tap the “Get started” button and select your Google account to be used. You may need to enter your Gmail email address and password.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/dd\/Make-a-Google-Spreadsheet-Step-9.jpg\/v4-460px-Make-a-Google-Spreadsheet-Step-9.jpg","bigUrl":"\/images\/thumb\/d\/dd\/Make-a-Google-Spreadsheet-Step-9.jpg\/v4-728px-Make-a-Google-Spreadsheet-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    Upon logging in, you will be brought to the main directory. If you already have existing spreadsheets, you can see and access them from here.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/51\/Make-a-Google-Spreadsheet-Step-10.jpg\/v4-460px-Make-a-Google-Spreadsheet-Step-10.jpg","bigUrl":"\/images\/thumb\/5\/51\/Make-a-Google-Spreadsheet-Step-10.jpg\/v4-728px-Make-a-Google-Spreadsheet-Step-10.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    Tap the large red circle with a plus sign on the lower right corner. You will need to name your new spreadsheet right away. A small window will appear where you can type it in. Do so, then tap the “Create” button. An empty spreadsheet screen will be displayed in full screen.
  5. 5
    Work on the spreadsheet. You can work on Google Sheets much like how you would work on Microsoft Excel. There’s a toolbar on the header with functions very similar to those of Microsoft Excel.
  6. 6
    Exit the sheet. If you’re done with your current document, tap the checkmark on the top left corner of the header bar, then tap the left arrow. You will be brought back to the main directory. Your changes will be saved automatically.
    7. Advertisement


Community Q&A

Search
Add New Question
  • Question
    How do I add something to an existing spreadsheet?
    Community Answer
    1) Go to drive.google.com and log in. 2) Find the file you would like to change. 3) Double-click on the file to open it. 4) Start editing.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 2 Helpful 5
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Download Images from a Google Doc
      How to
      Alphabetize in Google Docs: 4 Simple Methods
      4 Easy Ways to Download and Save Google Docs
      9 Easy Steps to Flip an Image in Google Docs
      How to
      Convert a Google Doc to a PDF on iPhone or iPad
      Inserting Videos to Google Docs with Google Slides
      How to
      Make a Brochure Using Google Docs: Quick Guide
      How to
      Use Google Sheets: The Ultimate Guide for Getting Started
      5 Easiest Ways to Download or Save a Document in Google Docs
      3 Simple Ways to Make a Signup Form on Google Docs
      4 Easy Ways to Add Captions to Images in Google Docs
      2 Easy Ways to Move Images in Google Docs in 2 Ways
      How to
      Check a Google Doc's History (and Restore Previous Versions)
      How to
      Share Google Docs
      Advertisement

      About This Article

      Thanks to all authors for creating a page that has been read 128,281 times.

      Is this article up to date?

      Advertisement