When a redacted PDF goes to Excel, the result depends on how it was redacted. A true redaction deletes the text, so the cells under the black box come out empty. A black rectangle drawn on top leaves the text in the file, and a converter reads it straight into the spreadsheet. Test before you convert or share.
What does a redacted PDF contain under the black boxes?
A redacted PDF contains either nothing or the original text under each box, and you cannot tell which by looking. Both kinds of file show an identical black shape. The difference is inside the file: proper redaction removes the characters from the page, while a cover-up only paints over them.
A PDF page is built in layers. Text is stored as characters with positions, and drawings such as boxes, lines and highlights are stored separately and painted in a set order. A black box painted after the text hides it on screen and on paper. Nothing about painting it changes the text underneath. Selecting, copying, searching and converting all work on the stored characters, not on what the page looks like.
So the question to ask about any redacted statement is not "can I see the account number?" but "is the account number still in the file?" A converter will answer that question for you, possibly in a spreadsheet you have already emailed to someone.
True redaction versus a box drawn over the PDF text
True redaction removes the selected text and images from the file and then draws a box to mark the gap. A drawn box is only a shape placed on top. Redaction tools in PDF editors do the first. Drawing tools, comment boxes, black highlighter and shapes added in a word processor before saving to PDF do the second.
The way a file was redacted usually tells you which kind it is:
| How the box was made | What is left in the file | What a converter outputs |
|---|---|---|
| A redaction tool, applied and saved | No text under the box | An empty cell or a gap |
| A redaction tool, marked but not applied | All the original text | The original text |
| A rectangle or shape tool | All the original text | The original text |
| Black highlight or comment | All the original text | The original text |
| Black box in a word processor, then saved as PDF | Usually the original text | The original text |
| Printed, blacked out with a marker, then scanned | Only an image of the page | Whatever OCR can read, which is nothing under solid ink |
The second row catches people often. Many redaction tools work in two steps: you mark areas first, then apply the redactions. Marked areas can look like finished boxes. Until the apply step runs and the file is saved, the text stays put.
Some tools also flatten the page while redacting. They turn the text into images or shapes so nothing selectable remains anywhere on the page. That removes the hidden text, but it also removes the readable text you wanted to convert, which leaves a page that behaves like the ones in converting a PDF with outlined text.
Why hidden redacted text leaks into Excel cells
Hidden text leaks into Excel because a converter reads stored characters and their positions, then groups them into rows and columns. It never looks at which shapes are painted on top. A covered account number sits at the same coordinates as before, so it lands in the same cell it would occupy on an unredacted statement.
The leak can be worse in a spreadsheet than in the PDF. In the PDF, the hidden text is at least behind a box. In the spreadsheet there is no box, so the account number, name or amount sits in plain view, in a cell, ready to be sorted, filtered and shared.
Where leaks hide besides the page
Text on the page is not the only place a statement keeps sensitive details. Check these too:
- File properties. The title or subject field may hold the account holder's name or the original file name with an account number in it.
- Comments and notes. A reviewer's sticky note saying "redact the account number" sometimes contains the number.
- Attachments. A redacted cover document can carry the original statement as an attachment.
- Form fields. Interactive forms store field values separately from the page drawing. A form that was redacted on the page can keep the value in its field data. Forms built on the older XFA format are a special case, explained in converting an XFA PDF to Excel.
- Earlier versions. Some editors save changes by adding to the file rather than rewriting it, so earlier content can remain inside. A "save as" to a new file name usually rewrites it cleanly.
How do you test a redacted PDF before converting?
Test a redacted PDF by trying to get the hidden text out the way a converter would. Select all, copy and paste into a plain text editor. Search for a word you know sits under a box. If the text appears either way, the redaction did not remove it, and conversion will expose it too.
Run this checklist on a copy of the file, never the only one you have:
- Select all and paste. Press the select-all shortcut on a page, copy, and paste into a plain text editor. Look for anything that should be gone.
- Search for a known word. Use the reader's search box to look for a surname, the last four digits of the account or a payee you know was hidden. A match under a box means the text is there.
- Convert one page. Convert only the first redacted page and open the result. Look at the cells where the boxes were.
- Inspect the cells under the box. Empty cells are a good sign. Characters, even partial ones, are a failure.
- Check the file properties. Open the document properties and read the title, author, subject and keywords fields.
- Look for comments and attachments. Open the comments panel and the attachments panel in the sidebar and confirm both are empty.
If any test fails, go back to the person who redacted it, or redact the file properly yourself with a redaction tool, apply it, save it under a new name and run the tests again.
The same tests apply when the spreadsheet will open in Apple Numbers rather than Excel, because the hidden text arrives in the cells either way. Converting a PDF to Numbers on a Mac covers that route.
Redacted amounts and the statement balance check
Redacting an amount breaks the statement's arithmetic. A bank statement's opening balance plus deposits minus withdrawals must equal its closing balance. If a line's amount has been truly removed, the sum no longer ties, and any check that compares the totals will flag the statement as incomplete.
That is not a bug in the check. A converter cannot know whether a gap came from a missed row or a deliberate redaction, and both mean the spreadsheet does not account for all the money. Treat the flag as expected and note which lines were redacted.
A worked example
The figures below are an example of a short statement with one redacted payment.
| Line | Debit | Credit | Printed balance |
|---|---|---|---|
| Opening balance | 4,000.00 | ||
| Payroll deposit | 2,100.00 | 6,100.00 | |
| Redacted payment | (redacted) | (redacted) | |
| Utility bill | 180.00 | 5,320.00 | |
| Closing balance | 5,320.00 |
The visible lines account for 4,000.00 plus 2,100.00 minus 180.00, which is 5,920.00. The printed closing balance is 5,320.00. The 600.00 gap is the redacted payment. If the redactor also blacked out the running balance on the hidden line, its size is still recoverable from the difference.
This matters for privacy as much as for accuracy. Redacting an amount but not the balances on either side of it does not really hide the amount. Anyone with the spreadsheet can subtract one balance from the next.
When a redacted PDF should not go to a converter
A redacted PDF should not go to an online converter when the redaction exists to keep information from the converter's operator, or when you cannot confirm the redaction was applied. Uploading sends the whole file. Whatever is still inside it, hidden or not, leaves your computer.
Skip conversion, or convert offline, in these cases:
- The file came from someone else and you cannot run the tests above.
- The redaction was done for a legal or regulatory reason and the rules forbid sharing the original details.
- The tests show hidden text and you cannot get a clean copy.
- You only need two or three numbers. Retyping them is faster than proving the file is safe.
A sound redaction can still change the spreadsheet in small ways. Rows with a removed amount may convert with the amount column empty, and a redacted date can leave a row that sorts to the top or bottom of the sheet. Mark those rows in a notes column so nobody mistakes the gaps for conversion errors later.
When the redaction is sound, conversion is no riskier than for any other statement, and the empty cells simply mark where the boxes were.
FastBankConvert encrypts uploads in transit and deletes trial files after you download them, but anything still hidden in the file travels with the upload, so run the tests first. It is getting ready to open, and Get started is the place to join.