# Automator Extract PDF Text on Mac for Free

- Author: CheapBankConvert (https://cheapbankconvert.com)
- Published: 2026-10-17
- Category: Free tools you already own
- Canonical: https://cheapbankconvert.com/blog/automator-extract-pdf-text-on-mac

> Use Automator to extract PDF text on a Mac for free: build the workflow, run it on a statement, and open the text in Numbers or Excel.
Automator can extract PDF text on a Mac for free with its Extract PDF Text action. Build a Quick Action once, right-click a statement in Finder, and Automator writes a text file next to it. The text keeps the words but not the columns, so you split each line into date, description and amount in Numbers or Excel.

## Can Automator extract PDF text on a Mac for free?

Yes. Automator comes with macOS, and its library includes an action called Extract PDF Text that saves a PDF's text to a file. It costs nothing and works offline. It only reads PDFs that contain real text, and it returns lines, not a table.

Automator builds small programs, called workflows, out of ready-made actions. Apple's guide to [creating Automator workflows](https://support.apple.com/guide/automator/create-workflows-aut7cac58839/mac) explains the basics: choose File, New, pick a workflow type, then add actions from the Library by double-clicking them. A Quick Action is the useful type here, because Apple's guide says a Quick Action is then available from Finder windows, the Services menu or the Quick Actions menu.

The result for a statement is a plain text file. Each printed line of the PDF becomes a line of text, with the date, merchant and amount separated by spaces. That is enough to rebuild the table in a spreadsheet, and a lot less typing than entering a month of transactions by hand.

## Building the Automator PDF text workflow, step by step

The workflow needs one action and two settings. You create a Quick Action, tell it to accept PDF files in Finder, add Extract PDF Text, pick plain text output and save the workflow with a clear name. It takes about five minutes the first time.

1. Open Automator from the Applications folder.
2. Choose File, New, select Quick Action and click Choose.
3. At the top of the workflow area, set the "Workflow receives current" menu to PDF files, in Finder.
4. In the Library, select the PDFs category, or type "Extract PDF Text" in the search field.
5. Double-click Extract PDF Text to add it to the workflow.
6. In the action's options, choose plain text as the output, and pick where the file should be saved. Saving to the same folder as the PDF keeps the pair together.
7. Choose File, Save and name it something you will recognize, such as "Statement to text."

Plain text is the better choice for a statement. Formatting such as bold headings does nothing for a spreadsheet, and a plain file opens anywhere.

## Running the Automator workflow on a statement PDF

To run it, right-click the statement in Finder, choose Quick Actions, and pick the workflow by name. A text file appears in the folder you chose. You can also test it inside Automator, where Apple's guide says the Run button runs each action in turn and shows progress in the Log area.

Apple's page on [running an Automator workflow](https://support.apple.com/guide/automator/run-a-workflow-aut945a313b9/mac) adds two useful checks. A green checkmark appears on each action as it completes, and warnings or errors appear in the Log. If you want to see what an action produced, the guide suggests adding the View Results action from the Utilities category to the workflow.

Here is what two rows from an example statement might look like in the text file. The values are invented.

```
03/04 EXAMPLE GROCERY #221 SPRINGFIELD 54.18 2,145.82
03/05 EXAMPLE TRANSIT CARD RELOAD 20.00 2,125.82
```

The date is first, the balance last and the amount second to last. Everything in between is the description. That pattern is what you use to split the lines.

## Opening Automator's statement text in Numbers or Excel

Open the text file, copy the transaction lines, and paste them into a blank sheet. Then split the first word into a date column and the last two numbers into amount and balance. Excel formulas that work from both ends of the line do this. In Numbers, formulas that find the first and last spaces do the same job.

Text to Columns on spaces is the obvious tool, but it breaks here. A four-word description and a two-word description push the amounts into different columns, so the amount column does not line up. In Microsoft 365 Excel, with a line in A2, these formulas split from the ends instead:

1. Paste the lines into column A, starting at A2.
2. Date in B2: `=TEXTBEFORE(A2," ")`
3. Description in C2: `=TEXTBEFORE(TEXTAFTER(A2," ")," ",-2)`
4. Amount in D2: `=VALUE(TEXTAFTER(TEXTBEFORE(A2," ",-1)," ",-1))`
5. Balance in E2: `=VALUE(TEXTAFTER(A2," ",-1))`
6. Fill the four formulas down to the last line.

On the first example row, these return 03/04, EXAMPLE GROCERY #221 SPRINGFIELD, 54.18 and 2145.82.

Every page of a statement repeats its header lines, such as the bank's name and the column titles. Those come through as text lines too. Delete them, or use the filter method in [removing repeated headers in Excel](/blog/remove-repeated-headers-in-excel).

If you do not have Excel, Numbers is free on every Mac, and other free options are compared in [free spreadsheet software for bank statements](/blog/free-spreadsheet-software-for-bank-statements).

Finish with a balance check: the opening balance plus deposits minus withdrawals should equal the closing balance. When it matches, no line was lost.

## Automator edge case: a scanned statement that gives back empty text

If the text file comes out empty, or holds only a page number, the PDF is a scan. A scan is a picture of a page with no text layer, and Extract PDF Text has nothing to read. You need OCR, which recognizes characters in an image, before any text extraction can work.

Test the file in Preview first. Drag across a line of the statement. If words highlight, the text is there and the workflow should work. If nothing highlights, or the whole page highlights as one block, it is a scan.

For a scanned page, [Live Text on a Mac](/blog/live-text-on-mac) can select text inside an image in Preview, which lets you copy lines by hand. Other $0 routes, with and without OCR, are ranked in [whether you can convert a PDF to Excel with tools you already have](/blog/can-i-convert-pdf-to-excel).

A second edge case: some statements do contain text, but the columns come out in a jumbled order, such as all dates first and then all amounts. That happens when the PDF stores each column as a separate block. Copying one column at a time from Preview usually works better for those files.

## Is an Automator text workflow worth keeping for monthly statements?

Keep it if your bank's statements extract cleanly, because the workflow costs nothing to run again and takes seconds. The slow part is the spreadsheet cleanup, which you repeat every month. If that cleanup runs past half an hour per statement, a tool that outputs columns directly may be cheaper in time.

A few ways to keep the routine light:

- Save a blank spreadsheet with your split formulas already in place, and paste each month's text into it.
- Keep the workflow's output folder next to your statements, so the text files never get lost.
- Note which page lines to delete for your bank, so the cleanup becomes a checklist.

Paying for software is the other option, and it pays to compare how you pay. [Whether a lifetime license beats paying per file](/blog/pdf-converter-lifetime-license) works through the break-even. For a few digital statements a year, a one-time purchase per file is another path: [CheapBankConvert](/get-started) is preparing to open with early prices from $2.99 a statement and a free preview of the first two pages, and it delivers columns instead of lines.