Google Sheets has no built-in receipt scanner. Google Drive can turn a photo into text, but you still pick the date, vendor, total and tax out of that text yourself, so for an ongoing pile you want something that writes one row per receipt into the sheet.
Below are the three real ways to get a receipt into a row, what each one hands you, and a worked ledger with the formulas to total it.
Three ways to get a receipt into a Google Sheet
- Type it. Open the receipt, read it, type the date, merchant, total and tax into a row. Free and accurate, and slow once the pile grows.
- Use Google Drive's text recognition, then copy. Drive reads the text for you. You still find the right numbers and paste them into the sheet.
- Use a tool that writes rows. Each receipt becomes one row with the same columns, and you import or sync that into your sheet.
The first route needs no explanation. The other two are worth a closer look, because the gap between text and a row is where the time goes.
What Google Drive's OCR actually gives you
Google's own help page on converting images to text (read October 20, 2026) describes the steps: in Google Drive, right-click a file and choose Open with, then Google Docs. Google lists these limits:
- It works on PDFs and on .jpeg, .png and .gif photos.
- The file should be 2 MB or smaller.
- Text should be at least 10 pixels high.
- The document must be right-side up.
- Google says lists, tables, columns, footnotes and endnotes "are not likely to be detected."
Two practical points follow. First, the output is a Google Doc, not a row in a sheet. You get the receipt's text in a document, and the sorting is still yours. Second, HEIC, the default photo format on iPhone, isn't on Google's supported list, so iPhone photos may need converting to JPEG first.
A receipt is mostly a list with prices in a column, which is the layout Google says it is least likely to keep. Expect the text, not the structure.
What raw OCR text looks like
We ran our own test with Tesseract 5.5, an open-source OCR engine, on 20 synthetic receipts. These are Tesseract numbers, not Google Drive numbers. OCR produced 284 lines of text in total, a mean of 14.2 lines per receipt, and a mean of 6.05 money-looking numbers per receipt. Someone still has to decide which one is the total.
Here is the raw Tesseract output for one synthetic test receipt, a coffee shop slip:
BLUE BOTTLE COFFEE
300 Webster St, Oakland CA
Date: 2026-04-18
New Orleans Iced Coffee $5.50
Cortado $4.75
Almond Croissant $4.85
Oat Milk Upgrade $0.85
SUBTOTAL $16.95
TAX $1.52
TOTAL $18.47
CARD ****4412
THANK YOU
Seven amounts, and the sheet needs two of them: 18.47 as the total and 1.52 as the tax. Clean text is the easy part. Picking the right fields, every time, is the work. The full test, including blurry and tilted photos, is in our Tesseract alternative write-up, and the four ways to convert receipts to a spreadsheet compares typing, OCR and other routes side by side.
Set up the ledger: one row per receipt
Whichever route you choose, give the sheet fixed columns and keep one row per receipt. We use the same 9 columns Slipsheet exports, in this order:
- date: the receipt date, as YYYY-MM-DD
- merchant: who you paid
- total_amount: what you paid, tax included
- currency: such as USD
- tax_amount: the tax line on its own, or 0.00
- category: such as saas, office or restaurant
- client_tag: which client the cost belongs to, if any
- notes: anything you want to remember
- file_name: the original receipt file, so you can find it again
There is no subtotal column and no link column. If you need the pre-tax amount, total_amount minus tax_amount gives it. file_name is how you trace a row back to the receipt it came from.
A worked example: 20 receipts, Q2 2026
This is synthetic example data: 20 made-up receipts from April to June 2026, the same set used in our OCR test, reshaped into the 9 columns. Here are 6 of the rows:
| date | merchant | total_amount | currency | tax_amount | category | client_tag | notes | file_name |
|---|---|---|---|---|---|---|---|---|
| 2026-04-03 | Amazon Web Services | 428.17 | USD | 0.00 | saas | 01-aws.png | ||
| 2026-04-18 | Blue Bottle Coffee | 18.47 | USD | 1.52 | restaurant | 04-bluebottle.png | ||
| 2026-04-22 | Uber Technologies | 24.83 | USD | 2.15 | rideshare | 05-uber.png | ||
| 2026-04-27 | Staples | 67.34 | USD | 5.54 | office | 06-staples.png | ||
| 2026-05-12 | Home Depot | 156.88 | USD | 12.91 | hardware | 10-homedepot.png | ||
| 2026-06-02 | Uber Technologies | 41.19 | USD | 3.57 | rideshare | 14-uber2.png |
Across all 20 rows, total_amount adds up to 2,034.43 and tax_amount to 89.05. Six rows have 0.00 tax, and all six are software subscriptions. By month, April comes to 694.80, May to 669.12 and June to 670.51.
| category | receipts | total_amount |
|---|---|---|
| saas | 7 | 1,020.66 |
| hardware | 3 | 461.30 |
| restaurant | 5 | 346.48 |
| office | 2 | 120.55 |
| rideshare | 3 | 85.44 |
Uber Technologies appears twice, on different dates with different amounts. A repeat vendor is normal and not a mistake, so check the date and amount before you delete anything.
The formulas that total it
Import the CSV with headers in row 1, so column A is date, B is merchant, C is total_amount, D is currency, E is tax_amount, F is category, G is client_tag, H is notes and I is file_name. Then these formulas produce the numbers above:
Grand total: =SUM(C2:C)
Total tax: =SUM(E2:E)
Software total: =SUMIFS(C2:C,F2:F,"saas")
Zero-tax rows: =COUNTIF(E2:E,0)
May total: =SUMIFS(C2:C,A2:A,">="&DATE(2026,5,1),A2:A,"<"&DATE(2026,6,1))
On the example data they return 2,034.43, 89.05, 1,020.66, 6 and 669.12. Change the category text or the two dates to get any other slice. For deeper formula work, see our guide to Google Sheets formulas for receipts.
Add each month to one running sheet
Google's help page on importing data into Sheets covers the steps. Open your ledger, click File, then Import, and choose the .csv file. Then pick an import option:
- Append rows to current sheet adds the imported data after the last row with any data. Use this to add each month's export to one running ledger instead of making a tab per month.
- Separator character controls how the file splits into columns. Detect automatically usually works for a CSV. If the columns come in wrong, choose Comma.
Import into the tab that already has your headers, and delete the extra header row the new file brings in, so your formulas keep working on one clean range.
Where Slipsheet fits
Slipsheet does the third route. You upload photos and PDFs, or forward receipt emails on paid plans, and each receipt becomes one row. Export is one CSV, slipsheet-YYYYMMDD.csv, with the nine columns above. Google Sheets sync is live on Pro. Excel and Microsoft 365 are listed as coming soon, and QuickBooks and Xero work by importing the CSV.
Starter is $5 a month for up to 250 receipts. Pro is $12 a month for up to 1,500 receipts and adds Google Sheets sync. Both start with a 14-day free trial, no card needed. See how the Google Sheets integration works, or start a trial and import your first CSV into the ledger above.
Frequently asked questions
Can Google Sheets scan receipts?
No. Google Sheets has no built-in receipt scanner. Google Drive can read text from a photo or PDF when you open it with Google Docs, but the result is a Google Doc, not a row. You still copy the date, merchant, total and tax into your sheet yourself.
Can I scan receipts into Google Sheets for free?
Yes, if you do the sorting yourself. Upload the receipt to Drive, open it with Google Docs to get the text, then copy the four or five fields you need into a row. For a few receipts a month that works. For a steady pile, a tool that writes the rows saves the copying.
How do I add new receipts to the same sheet every month?
Import each month's CSV into the same tab. In Google Sheets, go to File, then Import, pick the CSV, and choose Append rows to current sheet. Google adds the data after the last row with data, so one running ledger keeps growing instead of a new tab every month.
Should tax be its own column?
Yes. Keep tax separate from the total so you can add it up on its own. In our synthetic example, tax was 89.05 of 2,034.43 across 20 receipts, and 6 rows had 0.00 tax, all software subscriptions. Mixing tax into the total would hide that.