Open Google Sheets and start a new blank sheet
The fastest way to create a Google Sheet is to go to sheets.google.com in your web browser. You'll see a homepage with template options and a button labeled "Blank spreadsheet" — click that button and a new sheet opens immediately in your browser.
If you're already in Google Drive, you can create a sheet there instead. Click the "Create" button on the left side, then select "Google Sheets" from the menu, then choose "Blank spreadsheet." Either route takes you to the same place: a blank grid ready for data.
The sheet automatically saves to your Google Drive with a default name like "Untitled spreadsheet." You can rename it right away by clicking the title at the top of the page and typing a new name, or wait and rename it later — Google saves your work constantly, so there's no risk of losing anything.
Key Takeaways
- Go to sheets.google.com and click "Blank spreadsheet" to create a new sheet in seconds without downloading anything.
- Your sheet saves automatically to Google Drive every few seconds, so you don't need to manually save or worry about losing work.
- You can rename your sheet by clicking the title at the top, or share it with others by clicking the "Share" button in the top right.
- Columns are labeled A, B, C and rows are numbered 1, 2, 3 — click any cell to start typing data into it.
- Google Sheets works in any web browser on any device, and you can access the same sheet from your phone, tablet, or computer.
Enter data into cells and organize it into rows and columns
Click any cell in the grid to start typing. A cell is one box in the spreadsheet — the column letter and row number tell you where it is. For example, cell A1 is in the top-left corner, in column A and row 1. When you click a cell, it highlights in blue and you can type directly into it.
Press Enter or Tab to move to the next cell. Enter moves you down to the cell below; Tab moves you right to the next cell in the same row. This lets you move quickly through your data without using the mouse. If you make a mistake, click the cell again and edit what's in it, or press Delete to clear it completely.
You can type numbers, text, dates, or formulas into cells. Google Sheets recognizes what you're typing — if you type a date like "3/15/2024," it formats it as a date automatically. If you type a number, you can do math with it later using formulas.
Add headers and format your sheet for readability
Most sheets start with a header row at the top that labels what each column contains. Click cell A1 and type a label like "Name," then Tab to B1 and type "Email," then Tab to C1 and type "Phone." This tells anyone reading the sheet what data goes in each column.
To make headers stand out, select the entire first row by clicking the row number "1" on the left side. Then click the fill color button (the paint bucket icon) in the toolbar and choose a light color. You can also make the text bold by clicking the Bold button (B) in the toolbar. These small changes make your sheet much easier to read.
You can also adjust column width by hovering your mouse between two column letters at the top until a resize cursor appears, then dragging left or right. This is useful if your text is cut off or if a column is wider than it needs to be.
Share your sheet with others or keep it private
Click the blue "Share" button in the top right corner to control who can see or edit your sheet. A dialog box opens where you can type email addresses of people you want to share with. Choose whether they can "View" the sheet (read-only), "Comment" on it, or "Edit" it (make changes).
If you don't share your sheet, only you can see it — it stays private in your Google Drive. Shared sheets show a small icon next to the title indicating how many people have access. You can change permissions anytime by clicking Share again and adjusting who has access or what they can do.
When you share a sheet with someone, they get a notification and a link. They can open it in their browser without downloading anything, and if multiple people edit at the same time, you see changes appear in real-time with each person's cursor shown in a different color.
Use basic formulas to calculate and organize data
Google Sheets can do math for you using formulas. A formula always starts with an equals sign (=). For example, if you have numbers in cells A1, A2, and A3, you can click cell A4 and type =SUM(A1:A3) to add them together. The colon (:) means "through," so A1:A3 means cells A1, A2, and A3.
Other common formulas include =AVERAGE() to find the average of numbers, =COUNT() to count how many cells have data, and =IF() to make decisions based on what's in a cell. You don't need to memorize these — when you start typing a formula, Google Sheets shows suggestions that explain what each one does.
When you press Enter after typing a formula, Google Sheets calculates the result and shows it in the cell. If you change any of the numbers the formula uses, the result updates automatically. This is what makes spreadsheets powerful — you set up the formula once and it stays correct even when your data changes.
Access your sheet from any device
Because your sheet lives in Google Drive, you can open it from your phone, tablet, or any computer with a web browser. Go to sheets.google.com on any device and sign in with the same Google account, and all your sheets appear in the list. Click one to open it.
On a phone or tablet, you can download the Google Sheets app from the App Store or Google Play to make editing easier. The app works offline too — if you lose internet connection, you can keep editing, and your changes sync back to the cloud when you reconnect.
Your sheet is always the same version across all devices. If you edit it on your computer, those changes appear on your phone the next time you open it. There's no confusion about which version is newest because there's only one version, stored in Google Drive.
Frequently Asked Questions
Do I need a Google account to create a sheet?
Yes, you need a free Google account to use Google Sheets. If you don't have one, go to accounts.google.com and click "Create account" to set one up in a few minutes. Once you have an account, you can create unlimited sheets.
Can I download my sheet as an Excel file?
Yes. Click the "File" menu at the top left, then "Download," then choose "Microsoft Excel." Google Sheets converts your sheet to an .xlsx file that you can open in Excel or any spreadsheet program. The formatting and formulas usually transfer correctly, though some advanced features may not.
What if I accidentally delete something important?
Click "File" then "Version history" to see every change made to your sheet, with timestamps showing who made each change and when. Click any earlier version to see what it looked like, and click "Restore this version" to go back to it. Google keeps version history for 30 days.
Can multiple people edit the same sheet at the same time?
Yes. When you share a sheet with edit permissions, multiple people can work on it simultaneously. You see each person's cursor in a different color, and changes appear instantly as they type. This makes it easy for teams to collaborate without emailing files back and forth.
Is my data safe in Google Sheets?
Google encrypts your data and stores it on secure servers. Your sheet is only visible to you and anyone you explicitly share it with. You can delete a sheet anytime, and Google keeps backups so you can recover it from version history if you change your mind within 30 days.