Convert PDF to CSV

How to turn the tables in a PDF into a CSV file using Google Sheets

Answer in brief

A CSV file stores a table as plain text, one row per line, with commas between the columns. Almost every spreadsheet and accounting tool can import one. To convert a PDF to CSV, the tables in the PDF first have to be extracted as rows and columns, then saved in CSV format.

The Convert PDF to Google Sheets™ add-on by Easy Image to Text does both inside Google Sheets: it writes the PDF's tables into your sheet, then its Download CSV button saves the same data as a CSV file.

Why convert a PDF to CSV

A PDF is made for reading and printing, not for reusing data. A CSV is the opposite: it has no layout at all, just the values, which is why so many tools accept it. Common reasons to convert are:

  • Importing into accounting software, such as bank transactions or supplier bills.
  • Opening the data in Excel when the PDF came from someone who doesn't use Google Sheets.
  • Loading data into another system, such as a database, a CRM or a reporting tool.
  • Keeping a plain copy of the figures that any program can open years from now.

How to convert a PDF to CSV with Google Sheets

  1. Install the Convert PDF to Google Sheets™ add-on from the Google Workspace Marketplace.
  2. Open a Google Sheet and launch the add-on from the Extensions menu.
  3. Upload the PDF and select the pages with tables, up to 5 at a time. You can also upload an image or paste a screenshot.
  4. Click Extract Data. The tables are written into your sheet, usually within 10 to 40 seconds, so you can check them against the PDF.
  5. Click Download CSV. The browser saves a file called extracted_tables.csv.

Each successfully extracted page uses 1 credit. Downloading the CSV doesn't use any extra credits. New users get 3 free credits.

What's inside the CSV file

  • One file for the whole run. If you extracted several pages, the tables from every successfully extracted page are in the same CSV. For longer documents, see multi-page PDF to Google Sheets.
  • Each table keeps its header row, so you can see which columns are which.
  • Separate tables are separated by a blank line, for example an invoice's line items and its totals block.
  • Values are saved exactly as extracted. Commas, quotation marks and line breaks inside a cell are handled correctly, so a description like Paper, A4 stays in one column.

The file holds the data as it was extracted, before any changes you make in the sheet. The next section explains how to export your edited version instead.

Exporting your edited sheet as a CSV

If you've corrected values, deleted rows or added columns after extraction, export the sheet itself rather than using the add-on's button:

  1. Click the tab of the sheet you want to export.
  2. Choose File → Download → Comma Separated Values (.csv).

Google Sheets exports only the sheet that is currently open, so repeat this for each page's sheet. To combine several pages into one table before exporting, see the formula in multi-page PDF to Google Sheets.

Opening the CSV in Excel without losing data

Double-clicking a CSV opens it in Excel straight away, but Excel then guesses the type of every column. That can quietly change your data:

  • Account numbers and codes lose their leading zeros, so 00123 becomes 123.
  • Long numbers, such as card or reference numbers, turn into scientific notation.
  • Dates can switch between day-first and month-first.
  • Currency symbols and accented letters can show up as odd characters.

To avoid this, import the file instead of double-clicking it:

  1. In Excel, go to Data → From Text/CSV and choose the file.
  2. Set File Origin to 65001: Unicode (UTF-8).
  3. Click Transform Data, select the columns that hold codes, account numbers or dates, and set their type to Text.
  4. Click Close & Load.

Google Sheets doesn't have this problem with the extracted data, because the add-on writes every value as plain text.

Other ways to convert a PDF to CSV

Online converter websites, PDF editors and code libraries can also turn a PDF into a CSV. They work well on clean digital PDFs, but you usually download the file first and only see problems once you open it. Scanned pages need a tool with OCR.

Going through Google Sheets adds a check in between: the tables appear in your sheet first, so you can fix anything before you save the CSV. For a side-by-side look at every option, see ways to convert PDF to Google Sheets, compared. Converting bank statements for accounting software? See PDF bank statement to Google Sheets.

Frequently asked questions

Can I convert a PDF to CSV for free?

Yes. New users of the Convert PDF to Google Sheets™ add-on get 3 free credits, and each successfully extracted page uses 1. Downloading the CSV doesn't use any extra credits.

Does the CSV include every page I extracted?

Yes. Download CSV gives you one file with the tables from every page that was successfully extracted in that run.

Will my edits in the sheet be included in the CSV?

No. Download CSV saves the data as it was extracted. To export your edited version, use File → Download → Comma Separated Values (.csv) in Google Sheets.

Can I convert a scanned PDF or an image to CSV?

Yes. Scanned PDFs, photos and screenshots work the same way. Clear, straight, well-lit pages give the most accurate results.

Why do leading zeros disappear when I open the CSV in Excel?

Excel treats columns that look like numbers as numbers and drops the leading zeros. Import the file with Data → From Text/CSV and set those columns to Text instead of double-clicking it.

Can I convert a PDF to Excel this way?

Yes. Import the CSV into Excel with Data → From Text/CSV, then save it as an Excel workbook (.xlsx).

Need your PDF tables as a CSV file? Try the Convert PDF to Google Sheets™ add-on by Easy Image to Text: install it free from the Google Workspace Marketplace, or learn more about PDF to Google Sheets conversion.

Last updated: 2026-11-17