Creating a new Google Spreadsheet takes three steps
Go to Google Sheets at sheets.google.com in your web browser. If you are not already signed into your Google account, sign in now. Once you are on the Google Sheets home page, look for the large plus sign (+) icon in the top left corner and click it. A blank spreadsheet will open immediately.
Google Sheets creates the spreadsheet in your Google Drive automatically. The spreadsheet starts with a default name like "Untitled spreadsheet" — you can rename it by clicking the title at the top of the page and typing a new name. Press Enter when you are done, and the new name saves right away.
Your spreadsheet is now ready to use. You can start typing data into the cells, or you can share it with other people by clicking the blue "Share" button in the top right corner.
Key Takeaways
- You need a Google account to create a spreadsheet, but creating the account itself is free and takes less than five minutes.
- Google Sheets saves your work automatically as you type, so you do not have to remember to save manually like you do in Excel.
- You can share a spreadsheet with other people by clicking Share and entering their email addresses, and they can edit it at the same time you do.
- Google Sheets works in any web browser on any device — computer, tablet, or phone — so you can access your spreadsheet from anywhere.
- You can download your spreadsheet as an Excel file, PDF, or other format by clicking File and then Download.
Naming and organizing your spreadsheet
When you create a new spreadsheet, it lands in your Google Drive with a temporary name. Click the title at the top of the page to rename it to something you will recognize later. Type the new name and press Enter — the change takes effect immediately.
If you want to organize your spreadsheets into folders, you can do that in Google Drive itself. Go to drive.google.com, right-click on your spreadsheet, and select "Move" to choose a folder. You can also create new folders directly in Google Drive and drag spreadsheets into them.
Adding data and basic formatting
Click any cell in the spreadsheet to start typing. Each cell is identified by a letter (the column) and a number (the row) — for example, cell A1 is in the top left corner. Type your data and press Tab to move to the next cell to the right, or press Enter to move down to the next row.
To format text — make it bold, change the color, or adjust the font size — select the cells you want to change by clicking and dragging across them. Then use the formatting toolbar at the top of the page. The toolbar shows buttons for bold, italic, text color, and other common formatting options. Click any button to apply that formatting to the selected cells.
You can also right-click on selected cells to open a menu with more formatting choices, including cell background color and text alignment.
Sharing your spreadsheet with others
Click the blue "Share" button in the top right corner of your spreadsheet. A box will appear asking for the email addresses of the people you want to share with. Type their email addresses, separated by commas if you are adding more than one person.
Before you click "Share", you will see a dropdown menu that says "Editor", "Commenter", or "Viewer". Choose the permission level you want: Editor means they can make changes, Commenter means they can leave notes but not edit, and Viewer means they can only see the spreadsheet. Click "Share" when you are ready.
The people you shared with will receive an email with a link to the spreadsheet. They can open it and start working on it right away. If you are both working on the spreadsheet at the same time, you will see a small colored circle with their name or initial showing which cells they are editing.
Moving data between Google Sheets and Excel
If you have data in an Excel file and want to move it to Google Sheets, you can upload the file directly. Go to sheets.google.com, click the plus sign to create a new spreadsheet, and then click "File" and "Open". Select "Upload" and choose your Excel file from your computer. Google Sheets will convert it automatically.
To go the other direction — download a Google Sheet as an Excel file — click "File" at the top left, then "Download", and choose "Microsoft Excel (.xlsx)". The file will download to your computer in the same way other downloads do.
Be aware that some advanced Excel features — like certain formulas or macros — may not work exactly the same way in Google Sheets, but basic data, formatting, and common formulas transfer without problems.
Using templates to get your free guide faster
Google Sheets includes templates for common tasks like budgets, project timelines, and expense tracking. When you go to sheets.google.com, you will see a gallery of templates below the plus sign. Click any template to open a copy of it. You can then edit the template to match your needs.
Templates save time because they already have the structure and formulas set up — you just fill in your own data. If none of the built-in templates match what you need, you can start with a blank spreadsheet and build it yourself, or search online for templates other people have created and shared.
Troubleshooting common problems
If your spreadsheet is not saving, check your internet connection. Google Sheets saves automatically, but it needs to be connected to the internet to do so. You will see a small checkmark next to "All changes saved to Drive" at the top of the page when the save is complete. If you see a spinning circle instead, wait a moment for the connection to come back.
If you accidentally delete data, you can undo the change by pressing Ctrl+Z on Windows or Command+Z on a Mac. You can also click "File" and then "Version history" to see all the changes made to the spreadsheet and restore an earlier version if needed.
If you cannot see a spreadsheet someone shared with you, ask them to double-check that they entered your email address correctly. Also make sure you are signed into Google with the same email account they used to share it with you.
Frequently Asked Questions
Do I need to pay for Google Sheets?
No. Google Sheets is free for anyone with a Google account. You can create and store as many spreadsheets as you want at no cost. Google does offer a paid version called Google Workspace for businesses that need additional features and storage, but the basic version is completely free.
Can I use Google Sheets offline?
Yes, but you have to turn on offline mode first. Click the three-dot menu in the top right corner, select "Settings", and then turn on "Offline". After that, you can open and edit spreadsheets even when you are not connected to the internet. Changes will sync back to the cloud when you reconnect.
What is the difference between Google Sheets and Excel?
Google Sheets works in your web browser and saves automatically to the cloud, while Excel is a program you install on your computer and save manually. Google Sheets makes it easier to share and collaborate with others in real time. Excel has more advanced features for complex calculations and data analysis, but for most everyday tasks, both work similarly.
Can I add images or charts to a Google Spreadsheet?
Yes. Click "Insert" at the top of the page to add images, charts, shapes, or other objects. For charts, select the data you want to visualize first, then click Insert and Chart. Google Sheets will create a chart automatically and let you customize it.
How many people can edit a spreadsheet at the same time?
Google Sheets supports multiple people editing the same spreadsheet simultaneously without any limit. You will see colored circles showing where each person is working, and you can see their changes appear in real time as they type.