You can convert a PDF to Excel without losing formatting that matters: values, rows and columns come across, while fonts, colors and borders only partly do. Plan to keep the data and rebuild number formats, widths and bold totals in a few steps, because a faithful copy of the page rarely sorts or sums.
Which PDF formatting can Excel keep?
Excel can keep the text, the rough position of columns and sometimes bold type, but it rarely keeps the exact look of the page. A PDF stores drawn text and lines, not cells, so a converter has to rebuild a grid and then guess which styling to attach to it. What survives depends on the converter.
To judge any result, split formatting into two kinds. Content formatting changes how data is read: a currency symbol, a negative sign, a date order. Visual formatting changes how the page looks: a font, a shaded header, a border. Content formatting is the part to protect.
What a PDF stores
A PDF records glyphs at positions, plus lines and filled shapes. It has no idea that three words in a row are one cell, or that a number is a currency amount. The details are in what a PDF stores that Excel needs, and they explain every loss below.
A formatting scorecard
The table below shows what usually happens to each element in a typical PDF to Excel conversion. It is a general guide, not a promise: converters differ, and some keep more or less than shown. Test your own file before you rely on it.
| Element | Usually kept? | What happens | Fix in one step |
|---|---|---|---|
| Text and numbers | Kept | The characters arrive, though numbers may be text | Convert to Number |
| Font family | Often lost | Excel shows its default font | Select all, set one font |
| Font size | Often lost | Sizes flatten or shift | Select all, set one size |
| Text color | Sometimes kept | Colors may come across for headings | Reapply to headers if needed |
| Borders and lines | Mostly lost | Drawn lines do not become cell borders | Apply a border style to the table |
| Column width | Rebuilt | Widths follow the converter's grid, not the page | AutoFit Column Width |
| Bold totals | Sometimes kept | Weight may survive, or may be lost | Bold the total row by hand |
| Currency format | Lost | The symbol is text, not a format | Set the Currency format on the column |
| Merged headings | Often added | Titles become merged cells | Unmerge, or use Center Across Selection |
The last two rows matter most, and later sections cover them. If an element is in the middle of the table, expect a mixed result: some rows keep it and some do not.
Data vs looks: choosing what formatting to keep
Keep the formatting that helps Excel treat your data correctly, and drop the formatting that only decorates. Number formats, date formats and consistent column types are worth keeping. Fonts, shading and borders are cheap to recreate, and forcing them to match the PDF often makes the sheet harder to use.
Ask one question of each style you see: would losing it change a number, a sort or a total? If yes, keep it. If it only changes the look, restyle it once after the data is clean.
Why chasing an exact match backfires
Converters that try to copy every visual detail tend to build the sheet from text boxes, merged cells and spacer columns. That pattern reproduces the page while breaking the data. The cell you want to sum may be a piece of a merged block, or a number may be split across two cells to match the layout. A plain table with ordinary cells gives you less to look at and far more to work with.
If your goal is a printed or presentation copy, the PDF already is that copy. Excel earns its place when you need to change numbers, so choose the plain table first and style it second.
A simple order of work
- Convert the file and look at the raw result without editing.
- Check that each column holds one kind of value. If not, fix that first.
- Rebuild the number and date formats on every column.
- Restyle the header and total rows.
- Set column widths last, because other fixes change cell contents.
When a converted sheet will not total, the cause is rarely visual. Making a converted sheet truly editable starts with numbers stored as text, which no amount of styling repairs.
Rebuilding number formats after a PDF conversion
A number format is a display rule that Excel applies to a real number, and a conversion usually drops it. Rebuild it in two moves: make sure the cell holds a real number, then apply a format such as Currency, Accounting or Number with a thousands separator. The format changes the display only, not the stored value.
The order matters. A cell that holds the text "$1,234.50" ignores any number format you apply, because formats act on numbers. Convert it to a number first, and then format it.
Step by step for an amount column
- Select the amount column.
- Convert text to numbers. Use the Convert to Number option on the warning icon, or Data, then Text to Columns, then Finish.
- Open Format Cells with Ctrl+1 (Cmd+1 on a Mac).
- Choose Number with two decimals and "Use 1000 Separator", or Currency or Accounting if you want a symbol.
- Pick how negatives show. Red text, a minus sign and brackets are all options in the negative list.
Dates and percentages
Dates need the same two moves. A date printed as 14 Mar 2026 arrives as text unless Excel reads it. Convert it with Text to Columns, selecting Date in the final step and picking the order that matches the source, then apply a date format. Percentages follow the same pattern: a cell with 12% as text becomes a number once converted, and displays as 12% under the Percentage format. The stored value is 0.12.
Locale can reverse a date. A file written as day, month, year may be read as month, day, year, which scrambles dates whose day is 12 or lower. Check the first few rows against the PDF after converting.
One format for the whole column
Apply the format to the full column, not cell by cell. A table with consistent formats sorts and filters predictably, and a pivot table groups it correctly. A column that mixes formats is a sign that some cells are still text.
Do column widths and bold totals survive conversion?
Column widths are rebuilt rather than preserved, and bold totals survive only in some converters. A width is a property of an Excel grid, not of the PDF, so it must be set again. A bold total depends on whether the converter read font weight. Plan to fix both quickly after conversion.
Column widths
Widths in the converted file follow whatever grid the converter guessed. Some columns come out too narrow and show #### for numbers; others come out wide and waste space. Select the sheet, then choose Home, Format, AutoFit Column Width, or double-click the border between two column headings. This sets each width to fit its longest entry.
A cell full of #### is not an error in the data. It means the number is wider than the column. Widen the column and the value appears.
Bold totals and header rows
A total row is easy to find: the label says Total or Balance, and the numbers sit under the amount column. If bold weight did not survive, select the row and press Ctrl+B. Do the same for the header row.
Do not rely on bold to tell a total from a transaction. Once you sort or filter, a bold row is just another row, and a subtotal can end up inside the data. Put totals in a separate area or compute them with a formula, as in =SUM(D2:D40), and let the formula carry the meaning.
Freeze the header
One piece of formatting is worth adding because the PDF cannot give it: freeze panes. Choose View, then Freeze Panes, then Freeze Top Row. The header stays visible while you scroll a long statement, which no printed page does.
Keeping PDF formatting at the cost of merged cells
A pretty sheet refuses to sort because merged cells cannot be sorted together with ordinary cells. Excel stops with a message that sorting needs all merged cells to be the same size. A converter that copies a PDF's centered titles and spanning headings produces merged cells, and those break sort, filter and many formulas.
Merged cells come from the PDF's layout. A title centered over three columns, or a section label spanning the page, is one block of text in the PDF. A converter that wants to copy the look merges the cells under it.
What breaks
- Sort. A range with merged cells of different sizes cannot be sorted.
- Filter. Only the first row of a merged block holds a value, so filters hide or show the block unpredictably.
- Formulas. A merged area holds one value in its top-left cell, and the rest are empty, which skews counts and lookups.
- Pivot tables. Blank cells inside a merged heading produce blank labels.
- Power Query. Merged cells arrive as one value followed by blank cells.
How to fix it
- Select the sheet with Ctrl+A.
- Choose Home, then Merge & Center, then Unmerge Cells.
- Where a heading must stay centered over a few columns, select the cells and use Format Cells, Alignment, Horizontal, "Center Across Selection". It looks merged and leaves the cells independent.
- Fill the blank cells that unmerging created if they belonged to a group, for example by selecting the column, choosing Go To Special, Blanks, and entering
=followed by the cell above, then pressing Ctrl+Enter.
When a merged cell is acceptable
A report title above the data area is fine merged, provided it sits outside the table you sort. Keep a clear line between the title block and the table. If you are cleaning a long table with repeated headings and stuck columns, transforming a PDF import with Power Query steps is the next tool to pick up.
Pages that become sheets
Another layout habit gets in the way: some converters give each PDF page its own sheet, so the formatting is consistent inside a page but not across the file. Putting converted pages onto one sheet shows how to stack them, after which you can apply one format to the combined table.
If the PDF was made from a spreadsheet to begin with, a different question applies: how much of the original can come back? Convert PDF back to Excel covers what returns and what does not.
For bank statements, the formatting that counts is simple: dates as dates, amounts as numbers, balances in their own column. FastBankConvert is getting ready to open and is built to return a statement that way, so there is little formatting to rebuild; you can ask to hear when trial conversions start at Get started.