How to create spreadsheets in Google Drive?

Google Drive is one of the best tools that Google has ever made available to its users. One of its benefits is to create online spreadsheets, which can even be shared and edited by multiple people. This makes it much easier for those who need to work with it constantly. But there are still those who don't know how to create spreadsheets in Google Drive right.

The good news is that the process is extremely simple and can be done in minutes. To help you understand everything step by step, we'll teach you how to create spreadsheets in Google Drive below!

What is Google Drive?

how google drive works

Before we start teaching you how to create spreadsheets in Google Drive, we thought it was important to talk about the Google service itself. Google Drive is basically a cloud storage service for those who have a Gmail account.

Within this service, we have some tools for creating documents and files. They are very similar in general to what we see in the Microsoft office package, only without having to pay anything for it.

There are Google Docs (also known as Google Docs), there are Google Sheets and Google Slides. Each serves its purpose for different types of files, be it text document or slide shows, for example.

In the case of spreadsheets, there is not much mystery. They are very similar to Microsoft's popular Excel and allow you to enter data and even do mathematical calculations.

The best thing is that you can save these spreadsheets to a file on your PC. This file can be in Excel format, PDF or some others available.

Creating spreadsheets in Google Drive

Now that we know the basics of Drive and its tools, it's time to create our first spreadsheet there. As we mentioned, all you need is an active Gmail account.

With that guaranteed, go to the Google Drive website, something you can do at the following link. Then, just click on the “New” button.

create spreadsheets in Google Drive

Among the options offered, you must place the mouse over "Spreadsheets" to proceed.

create spreadsheets on google drive tips

There will be an option to create a spreadsheet from scratch or from a ready-made template. The “Based on a template” option will take you to another page full of spreadsheets ready to use as a base.

how to create a spreadsheet

These ready-made worksheets are divided into four categories: personal, professional, project management and education. There are templates for the task list, agenda, financial budget, etc.

create spreadsheets in google drive options

If you don't quite understand how to make a complex spreadsheet yourself, this is the most appropriate option. Just choose the model, click on it and start your edits with personal information.

spreadsheet based on a template

The spreadsheet made from scratch is very simple and has only the rows, columns and different formatting options and settings. If you want something completely personalized, this is the best option.

blank spreadsheet on google drive

This is entirely up to you, as it depends on your need and level of knowledge with spreadsheets. Anyway, all of these worksheets work well overall.

Saving files

After creating spreadsheets in Google Drive and editing them to your liking, it's time to think about how you want to store them. By default, all of your spreadsheets are automatically saved by Drive and are available online at all times.

If you just want to have the spreadsheet online, you don't need to do anything else. Just go back to Google Drive and access it when you need it.

But if you prefer the file on your PC for some reason, you can save the spreadsheet this way too. To do this, just click on the “File” option.

save work

Then, select the option "Download" and choose the format that you prefer the file of your spreadsheet. As we mentioned before, it is even possible to save it as if it were a normal Excel file.

If you do, you can easily open the spreadsheet in any newer version of Excel. This can be very useful if you need to work with Excel spreadsheets, but do not have the program installed on your PC.

Did you like the tips?

Did you take advantage of our tips to learn how you can create spreadsheets in Google Drive? So don't forget to leave your comment telling us what you think of the tutorial and everything went well with this excellent tool from Google.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *