Extract Tables From a PDF to CSV on macOS (Offline)

Statements, invoices, price lists and reports often arrive as PDFs with perfectly good tables inside. Copying them into a spreadsheet by hand usually ends with everything pasted into one column. This guide shows how to extract tables from a PDF to CSV or Excel on macOS, offline, using PDF Foundry.

Why offline matters for tables

The PDFs with the most useful tables are often the most sensitive: bank statements, payroll summaries, vendor pricing, customer lists. Online converters ask you to upload the file. With PDF Foundry the extraction happens on your Mac. There are no uploads and no telemetry on your documents.

What the Tables tool does

The Table & Data Extractor is the second tool in the rail on the left, reachable with Command-2. It has two jobs:

1. Pull tables out of a PDF. It scans every page, finds tables, and keeps each one separate. You then save them as CSV files or as one Excel file.
2. Copy all the words. It saves every word in the PDF to a plain text or Markdown file, useful when you need the text rather than a table.

Step by step: PDF tables to CSV

1. Open PDF Foundry and choose the Tables tool.
2. Choose your PDF. Drop it in or use the file chooser. The app begins detecting tables as soon as the file is picked. You can also click Find tables to run detection again.
3. Review the results. A results list shows the tables it found, along with the page each came from. If it found none, see the limits section below.
4. Click Save as CSV files. The app writes one CSV per table into a new folder.
5. Or click Save as Excel file. You get a single workbook with the tables kept separate rather than merged.

Outputs go to your Downloads folder and never overwrite an existing file. CSV file names include the PDF name, the page and the table number, so statement_p2_t1.csv is the first table on page 2. The CSV files are written as UTF-8 with a byte-order mark, which helps Excel on Mac show accented characters and symbols such as the euro sign correctly.

Opening the CSV

Double-click a CSV and it opens in Numbers or Excel. If you use Numbers, you can also import it through File, Open. Each cell holds the text exactly as it appeared in the PDF, so a value like $1,450.00 arrives as text with its currency symbol. Nothing is converted behind your back. If you want numbers to calculate, clean the column in your spreadsheet, for example by removing the currency symbol and thousands separators with Find and Replace, then formatting the column as a number. Dates and amounts keep the format printed in the PDF.

The first row is treated like any other row. The app does not guess which row is a header, so the header row from the PDF appears as row 1 and you can style it yourself.

When you need the text, not the table

The second section of the tool, Copy all the words, saves the entire text of the PDF. Choose Plain text (.txt) or Markdown (.md), then click Save the text. This is useful for search, for pasting into notes, or for feeding into other tools you run locally.

Other related tools

Tables are one part of a document workflow. The Converters tool can turn a PDF into a Word document or into page pictures, at a sharpness you choose between 36 and 1200 dpi, with 300 being print quality. Long PDFs can take a few minutes to convert to Word.

Getting the best results

Table detection works from the structure on the page, so a few habits help:

• Prefer real PDFs over scans. Table extraction reads text that exists in the file. If the PDF is a photograph or scan of a page, there is no text to read, and the app does not perform OCR. Such a file will produce few or no tables.
• Tables with visible lines work best. Clear rows and columns are easiest to recognize. Tables formed only by spacing may be split differently than you expect.
• Check merged or multi-line cells. Line breaks inside a cell are turned into spaces, and heavily merged cells can shift values between columns. Skim the output against the PDF before relying on it.
• Large tables across several pages. A table that continues onto the next page is reported per page, so you may need to join those pieces in your spreadsheet.
• Spot-check totals. Add up one column in your spreadsheet and compare with the total printed in the PDF. It is the fastest way to catch a misplaced value.

A practical example workflow

Suppose you receive a quarterly supplier statement as a ten-page PDF.

1. Drop it into the Tables tool and wait for the detection to finish.
2. Click Save as Excel file and open the workbook.
3. Find the table with the line items, remove currency symbols from the amount column and sum it.
4. Compare the sum against the statement total.
5. If you need to share the original with a colleague but hide customer details, switch to Security & Redaction and make a redacted copy first.

Cost and trial

You can try the app free: the first three exports are included with no account. After that, a license is $19.99 per year or $39.99 once for lifetime use, and activation works offline. Viewing and editing are not limited.

Quick recap

• Tables & Data finds tables and saves them as separate CSV files or one Excel file.
• Output lands in Downloads and never overwrites existing files.
• Cell contents are kept as text, so tidy numeric columns in your spreadsheet.
• Works on PDFs with real text; scans are not read, because there is no OCR.
• Everything happens offline on your Mac.