Convert PDF to Google Sheets in 1 click - Table extractor that lives inside Google Sheets

Sriram G — Thu, 23 Apr 2026 11:34:12 +0000

Millions of professionals deal with bank statements, invoices, reports, that often is received as PDFs, and they need to get these data on a spreadsheet for analysis.

Whether it be a bookkeeper, small business owner, auditor, or a financial analyst, they all deal with this requirement frequently.

With the tech advancements we see around, it is still surpising to see many professionals still doing manual entry or copy-paste. This takes a significant time in their routine.

Others are typically aware of online converters that convert to XLSX or CSV format, which can then be imported in a Google Sheet or Excel. Some of them mess the formatting too.

But today with AI, we don't need to switch between apps to convert tabular data from PDF or Image. We can do this without leaving our spreadsheet.

While in Excel you have the native "Data from Picture" or "Get Data" from PDF with MS 365 subscription, many people who use Google Sheets are not aware of add-ons that help with converting tabular data.

I noticed a visible and frequent need for converting tabular data from PDFs and images to a spreadsheet, and started tinkering with apps script to build a tool that lives inside Google Sheets, uses optical character recognition with the help of AI, to identify structured tabular data from a PDF or image and write it on the active spreadsheet with the layout(rows and columns) preserved. All that the user needs to do is to uploade the PDF or image and click the "Extract Data" button, and the data will be written on the sheet within a minute. This tool is now live on the Google Workspace Marketplace as Convert PDF to Google Sheets™,CSV: Bank Statement with 300+ users from around the world.

This kind of add-on helps a bookkeeper, small business owner, financial analyst, etc. handle tabular data conversion from their PDFs and images, without leaving Google Sheet, and without any manual entry. All they need to do is upload the file and click the extract button, and the data would be available on their active spreadsheet within a minute.

This helps a lot in

Saving time: Conversion done in 1 minute, as compared to 5-15 mins in their usual process.
Reduced effort: No switching between apps, No typing, No copy-paste, just 1 click.
Reduced errors: AIs are not error free, but much better than manual process.
More time for other activities: More time and energy available for analysis and higher level activities, instead of spending on data entry.
Compatibility for both Excel and Google Sheets: The converted tabular data is also available as CSV, ready to be instantly imported in Excel.

Our initial customer was a remote bookkeeper working for a construction compmany from Australia, and she completed around 250 extractions in 2-3 days. This proved the need for a tool like this. We have got 56 users from the USA so far, and 3 of them have upgraded to paid plans, further proving the necessity of an add-on like this.
Bookkeepers, small business owners who do their own bookkeeping, often want to analyze the data by staging on a Google Sheet, and then import it into their accounting software(QBO or Xero). We noticed this and developed a Xero export feature, where they can Create Draft Bills in Xero directly from Google Sheets. This is particularly useful for Accounts Payable workflows that involve Xero and Google Sheets.

If you are someone dealing with bank statements or invoices or reports from PDFs or images, try this add-on for free and let us know if it saved your time.

DEV Community: Sriram G

Convert PDF to Google Sheets in 1 click - Table extractor that lives inside Google Sheets