Google Sheets for Beginners: Your First Budget Spreadsheet

Illustration of a simple spreadsheet grid listing a weekly food shop with a pound sign and a total row, beside the title Google Sheets for Beginners.

Last checked: 28 October 2026. Steps follow Google Docs Editors Help on that date, and the screenshots were taken in Google Sheets in a web browser the same day. Google tweaks its menus now and then, so your screen may look slightly different.

The word "spreadsheet" puts a lot of people off. It sounds like something accountants do late at night. But a spreadsheet is really just a list that can do sums for you, and it beats totting things up on the back of an envelope.

In this guide we'll build one together: a weekly food shop budget in Google Sheets, with a total that works itself out and prices in pounds and pence. It's free, and there's nothing to install on a computer.

What is Google Sheets?

Google Sheets is Google's free spreadsheet app. Google describes it as an online spreadsheet app that lets you create and format spreadsheets and work with other people. You can use it:

  • On a computer, in your web browser at sheets.google.com.
  • On an Android phone or tablet, with the free Google Sheets app from Google Play.
  • On an iPhone or iPad, with the free Google Sheets app from the App Store.

You need a Google Account (if you have Gmail, you've got one). Spreadsheets are saved in Google Drive, so the same file opens on your computer and your phone.

A spreadsheet is a grid. The columns across the top are labelled with letters (A, B, C) and the rows down the side are numbered (1, 2, 3). Each box is a cell, and every cell has an address made from its column and row, so the top-left cell is A1 and the one to its right is B1. That's honestly most of the jargon.

Why use it?

  • It does the maths. Change a price and the total updates by itself.
  • It saves as you go. Google says that when you're online your changes are saved automatically as you type. There's no Save button to forget.
  • It's on every device. Start a list on the computer and check it on your phone.
  • It's shareable. You can let someone else in the household view or edit the list.

Step by step: your first spreadsheet, a weekly food shop

Say you do one big shop a week and want to see roughly what it costs. These steps are for a computer, which is the easiest place to learn. The phone app is covered further down.

Step 1: Create a blank spreadsheet

  1. Open your web browser and go to sheets.google.com. Sign in with your Google Account if asked.
  2. Click New (some Google pages call it Create) to start a blank spreadsheet. You can also go straight to sheets.google.com/create.
  3. A new spreadsheet opens called "Untitled spreadsheet". Click that name at the top, type Weekly Food Shop and press Enter.

Step 2: Add your headings

  1. Click cell A1 (top left) and type Item. Press Enter.
  2. Click cell B1 and type Cost (£). Press Enter.
  3. To make the headings stand out, click A1, drag across to B1, then click the Bold button in the toolbar.

Step 3: Type in your shopping

Click cell A2 and type your first item, then press Tab to jump across to B2 and type its price as a plain number, without the £ sign. Press Enter to move down. For this example:

  • Milk: 1.45
  • Bread: 1.20
  • Eggs (6): 2.10
  • Bananas: 0.95
  • Cheese: 3.25

Don't worry if 1.20 shows as 1.2 and 2.10 as 2.1. Sheets drops the trailing zero for now, and we'll tidy that up in Step 5. These prices are just examples to practise with, so use your own.

To change something you've already typed, double-click the cell, make your change and press Enter.

Step 4: Let Sheets add it up

  1. Click cell A7 and type Total.
  2. Click cell B7 and type =SUM(B2:B6) exactly as shown, then press Enter.

The cell now shows 8.95. In plain English, the formula says "add up everything from B2 to B6". The equals sign tells Sheets it's a formula rather than ordinary text, and the colon means "everything in between".

A Google Sheets spreadsheet with Item and Cost (£) headings in bold, five food items with prices from 0.95 to 3.25 in column B, and a Total row showing 8.95.

The finished list: items in column A, prices in column B and the total in row 7.

Click B7 again and look at the formula bar just above the grid. The cell shows the answer, but the bar shows the formula behind it. Now try changing the price of milk. The total changes straight away, which is the whole point.

Cell B7 selected in Google Sheets, with the formula bar above the grid showing =SUM(B2:B6) and the cell showing the total 8.95.

Select the total and the formula bar shows =SUM(B2:B6), the formula doing the work.

Step 5: Show the prices in pounds and pence

  1. Click B2 and drag down to B7 to select all the prices and the total.
  2. At the top, click Format, then Number.
  3. Choose Currency.

Your prices now show as £1.45, £1.20 and so on, with two decimal places throughout. Currency rounded, just below it, drops the pence, which is handy for a rough monthly budget but not for a shopping list.

The Google Sheets Format menu open with Number selected, showing options including Automatic, Number, Accounting, Currency with the example £1,000.12, Currency rounded, Date with the example 26/09/2008, and Custom currency.

Format > Number > Currency. The examples on the right show the £ sign and a day/month/year date, because this spreadsheet's locale is set to the United Kingdom.

Step 6: Check your spreadsheet is set to the UK

If Currency shows a dollar sign, or dates come out month first, your spreadsheet's locale is set to another country. Google says changing the locale changes the spreadsheet's default currency, date and number formatting. To fix it on a computer:

  1. Click File, then Settings.
  2. Under General, open the Locale menu and choose United Kingdom. You can set Time zone here too.
  3. Click Save settings, then apply Currency again if needed.

This setting belongs to that one spreadsheet, and Google notes that everyone working on it sees the change. It doesn't change the language Sheets is shown in.

Using the Google Sheets app on your phone

  1. Install Google Sheets from Google Play (Android) or the App Store (iPhone), and sign in with the same Google Account.
  2. Your Weekly Food Shop file appears in the list. Tap it to open it.
  3. To start a new one instead, tap Create at the bottom right. On iPhone you'll be asked to type a name, then tap Create.
  4. To edit a cell on Android, double-tap it, type, then tap Done.
  5. To format prices, select the cells and tap Format. On iPhone, go to Cell, then Number format. Google says the currency options are based on the spreadsheet's locale.

Google's locale instructions are for a computer, so set that up there first. The phone is handy in the aisles; the computer is easier for building the sheet.

Tips worth knowing

  • Quick total without a formula. On a computer, select some prices and look at the bottom right of the screen, next to Explore. Google says you'll see "Sum: total". Click it to see the average, minimum, maximum and count.
  • Keep the headings in view. On a long list, click View, then Freeze, and choose 1 row. The Item and Cost headings stay put as you scroll.
  • One tab per week. The tabs along the bottom are separate sheets in the same file. Double-click a tab to rename it (say, "w/c 2 Nov"), or use the small arrow on the tab and choose Duplicate to copy last week's list and just change the prices.
  • Undo mistakes. The Undo button in the toolbar reverses your last change. For bigger slips, click Last edit at the top right to open the version history, pick an earlier version and click Restore this version.
  • Want an Excel copy? Click File, then Download, and choose a file type such as Microsoft Excel.

Common problems

  • My formula shows as text. It needs to start with an equals sign. SUM(B2:B6) on its own is just words; =SUM(B2:B6) is a sum.
  • I added an item and the total didn't change. The formula only adds the cells it's told to. If you add a sixth item in row 7 and move the total down, change the formula to cover the new row, for example =SUM(B2:B7).
  • I see a $ instead of £. Check File > Settings > Locale (Step 6), then apply Format > Number > Currency again.
  • The "Sum:" box at the bottom right is missing. Google says this feature doesn't work with some number or currency formats. A =SUM formula always works.
  • It won't work without the internet. On a computer, offline editing needs Chrome or Microsoft Edge, not a private or Incognito window, and Google's Docs Offline extension. Then use File > Make available offline for the file you need.

Security and privacy

  • Check who can see it. Click Share to add people as Viewer, Commenter or Editor. Under General access, Restricted means only people you've added can open it. "Anyone with the link" means exactly that, so use it with care.
  • Give the lowest access that works. Google says editors can, by default, change permissions and share the file with others. If someone only needs to look, make them a Viewer.
  • Keep sensitive details out. A food budget is fine. Bank account numbers, card numbers, passwords and your National Insurance number don't belong in a spreadsheet.
  • "Protect" isn't a lock. Sheets has a Data > Protect sheets and ranges option, but Google says it shouldn't be used as a security measure, as people can still copy and export a protected spreadsheet.
  • Protect your Google Account. Your spreadsheets are only as safe as your account, so a strong password and 2-Step Verification are worth the five minutes.

Frequently asked questions

Is Google Sheets free?

Yes, with a free Google Account. Your spreadsheets count towards your Google storage, which is up to 15 GB per account, shared across Gmail, Google Drive and Google Photos. A simple list like this takes up very little. If your storage is filling up, see Google Storage Full? Free Up Drive, Gmail & Photos.

Is it the same as Microsoft Excel?

Not the same, but similar for everyday jobs like this. The =SUM formula works the same way in both. Google says Sheets can open and edit Excel files, and you can download a Sheets file as an Excel file.

Where is my spreadsheet saved?

In your Google Drive, automatically. You'll find it on the Sheets home screen at sheets.google.com, in the Sheets app, or in Google Drive.

Final thoughts

That's your first spreadsheet done: a list, a formula that does the sums, prices in pounds and pence, and a file that saves itself. The same steps work for a holiday budget or who owes what for the Christmas meal. Start small, keep personal details out, and let Sheets do the adding up.

Happy budgeting — Paul

Read next

Google Beginner Series: Previous: Google Translate for Beginners: Text, Voice and Camera | Next: coming soon

Last checked: 28 October 2026.

Official references (checked 28 October 2026): How to use Google Sheets; Create, view or download a file; Edit and format a spreadsheet; Add formulas and functions; SUM; Format numbers in a spreadsheet; Set a spreadsheet's location and calculation settings; See the sum and average; Freeze, group, hide or merge rows and columns; Find out what's changed in a file; Use Google Docs, Sheets and Slides offline; Protect, hide and edit sheets; Share and manage access to files in Google Drive; How your Google storage works.

Made with help from Grok Bot.

Comments