How to Make a Google Spreadsheet: Beginners Guide

wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, volunteer authors worked to edit and improve it over time.

This article has been viewed 120,958 times.

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 of 2:

Using a Computer

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.

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.

Create a new spreadsheet. 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.

Name the spreadsheet. “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.

There’s no need to save with Google Sheets as everything you do is automatically saved at regular intervals.

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.

Advertisement Method 2 of 2:

Using the Mobile App

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.

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.

View your 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.

Create a new spreadsheet. 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.

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.

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.

Community Q&A

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

Ask a Question 200 characters left Include your email address to get a message when this question is answered. Advertisement

Tips

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