Image to Google Sheets: Get Picture Data Into a Spreadsheet

Image to Google Sheets sounds like one action and is really two: reading the table out of the picture, then getting that table into a spreadsheet file Sheets will open. Google has no feature that drops pixels into cells. What works is to recognise the picture here, download a real workbook, and import it. This page covers both halves, including the part most guides skip — what happens to a number like 1,314.00 once it lands in a Google spreadsheet.

Why Google Sheets cannot read an image by itself

There is no "insert data from picture" in Sheets. There is only Drive's OCR, which is a different job: upload a PDF or a photo to Drive, open it with Google Docs, and Drive returns the recognised text as a document. What comes back is paragraphs in reading order. Row and column boundaries are gone, so a bank statement arrives as a wall of lines rather than a table — useless for summing a column, sorting by date, or feeding a pivot table.

That is the gap this workflow fills. A structure-rebuilding converter reads the picture as a grid: it decides which text belongs to which column, keeps the header row as a header row, and hands you a workbook where the cells are cells rather than lines of prose. Google Sheets then imports that workbook natively, because it speaks .xlsx and .csv. The two tools do different halves of the job and neither one is optional.

How to get an image into Google Sheets (step by step)

Open the converter and drop the picture in — PNG, JPG or WEBP, up to 10 MB each, up to ten per run.
Run recognition. The workbook is rebuilt from the image in your browser; the picture is not uploaded.
Fix the yellow cells against the original picture, then download .xlsx or .csv.
In Google Sheets choose File › Import › Upload, select the file, then pick Create new spreadsheet, Insert new sheet or Replace spreadsheet.

The fourth step has a shortcut: drop the .xlsx straight into Google Drive and double-click it. Drive converts it to a Google Sheet on open, with the same cells in the same places. Either route takes seconds, and the file you imported stays in Drive as an ordinary spreadsheet that you can share, query, and edit from any device.

.xlsx or .csv — pick the one that matches the job

Both import cleanly, and they fail in different places. An .xlsx file can hold several sheets, so a ten-image batch arrives as ten tabs instead of one merged grid — the right shape when each photo is a separate page of a statement. It also keeps number formats and dates as types, which is what you want before writing formulas.

A .csv file is one sheet of plain values. That sounds like a downgrade until you look at the work it suits: appending this week's receipts to a log that already has three hundred rows. Import a .csv with Append to current sheet and the new rows land at the bottom of the existing data, no tab juggling and no duplicated header — provided you delete the header row from the import first. If you only ever need one sheet, csv is the smaller, more predictable container.

The number that arrives as text

This is the failure people hit after a successful import, and it is not the converter's fault. A cell holding 1,314.00 is a string: the comma is a character, not a separator. Sheets reads it as text, aligns it left, and refuses to add it to anything. The value is also, deliberately, exactly what the document said — the converter does not silently decide that a European decimal comma or a thousands separator should be rewritten, because guessing wrong turns 1.314,00 into a number a thousand times too large.

Two ways out. Select the column and use Format › Number › Automatic, letting Sheets re-parse the text; or strip separators before import and keep a note of the currency elsewhere. Do this before you build formulas on top, because a text column that looks numeric will quietly break an SUM and give you a total of zero without an error message.

Where the picture is read, and where it goes

Recognition happens in the browser. The image you drop is not uploaded to a server here, which matters when the picture is a payslip, a supplier invoice, or a client's bank page. There is no account and no copy of your file stored anywhere.

Importing into Sheets changes that boundary, and it is worth saying plainly: once you upload the workbook to Drive, that file lives in Google's cloud. The privacy gain is limited but real — the original picture never leaves your machine, and the spreadsheet that does is text you have already reviewed. If the source image must never leave your device, keep the export local and open it in Excel or LibreOffice instead.

Getting a better read from a phone photo

The imports that go wrong usually started as a bad picture. Shoot the table straight on rather than at an angle, fill the frame with the grid, and keep the light even — a phone flash on a glossy invoice erases whole rows. Screenshots are the easiest input of all, since the characters were rendered by a machine and never suffered perspective or noise.

If the table continues past the edge of the frame, take a second photo with a clear overlap and delete the duplicated row after import. A table that is cropped mid-column is the one case where recognition has no way to recover: the missing data was never in the file.

When Sheets is the wrong destination

If the numbers are heading into Power Query, a pivot cache, or a workbook that will be mailed as a file, keep the .xlsx and stay out of Sheets entirely. Sheets is the better home when several people need to see the same grid at once, when the data is going to be read on a phone, or when the next step is a formula someone else will maintain. The converted workbook is the same file in both cases; only the container changes. For the spreadsheet-shaped version of this walkthrough, see how to convert an image to Excel.

Image to Google Sheets FAQ

Can Google Sheets read an image directly?

No. Sheets has no image-to-cell feature. Google Drive can OCR a PDF or picture, but it opens the result as a Google Doc with paragraphs, so the row and column structure is lost.

Should I import .xlsx or .csv into Sheets?

Use .xlsx when the run produced several sheets or you want the grid to arrive intact. Use .csv when you only need values from one sheet, for example appending receipt rows to an existing log.

Why do imported numbers sit on the left as text?

A value written as 1,314.00 keeps its comma and is read as text. Select the column and use Format › Number, or clean separators before import if you need arithmetic.

Is my picture uploaded anywhere?

Not by this tool. Recognition runs locally in the browser. The file only reaches Google Drive when you upload the exported spreadsheet into Sheets yourself.

Can I append new rows to an existing sheet?

Yes. In the import dialog choose Append to current sheet after selecting a .csv or single-sheet .xlsx, so new rows land under the existing ones.

Does this work on a phone?

Yes. The converter runs in a mobile browser and the exported file can be opened in the Sheets app, though the import dialog is easier to drive on a desktop.

What if the table spans several photos?

Convert each picture, then stack the resulting rows in one sheet. Watch the seam: the duplicated header row between two photos is the usual place for a doubled or missing line.

Is there a file size limit in Sheets?

A spreadsheet can hold up to 10 million cells. A converted page of a table is far below that, so the limit only matters if you import years of statements into one file.