To get a two column PDF to Excel cleanly, convert each half of the page separately. A converter reads across the full width, so it pairs a left-hand line with whichever right-hand line sits at the same height. Crop the page into a left file and a right file, convert both, then stack the right half under the left.
Why do lines from a two column PDF interleave in Excel?
Lines interleave because most converters build rows by height on the page. Everything that shares a baseline becomes one row, from the left margin to the right. On a two-column page, that baseline crosses the gap between the columns, so line 1 of the left half and line 1 of the right half land in the same row.
A PDF does not store "left column" and "right column" as objects. It stores pieces of text and the coordinates where each one is drawn. The idea of a column is something your eye builds from the white gap down the middle of the page, called the gutter. A table-detection step sees that gap too, but it often reads it as a space between two columns of one table, not as the edge between two separate blocks.
The result looks plausible at first glance. Every cell holds real text from the page, and the row count roughly matches the number of lines in one half. The damage only shows when you read a row across: a January transaction sits next to a March one, or a description from the left half ends up beside an amount from the right.
Some converters do detect blocks of text and read one before the other. They still get confused when the halves hold rows of different heights, or when one half has a heading the other lacks. Because you cannot see which strategy a tool used, it is safer to remove the problem before conversion.
Spotting a two column page layout before you convert
A two-column layout is two independent runs of text side by side, each with its own top-to-bottom order. The test is to read down the left half and ask whether the story continues at the top of the right half. If it does, the page is two columns. If each line reads straight across, it is one wide table.
Look for these signs on the page:
- A clean vertical gutter from the top of the text area to the bottom, with nothing crossing it.
- Repeated headers, such as "Date Description Amount" printed twice on one line, once over each half.
- Rows that do not line up, where the left half has more lines than the right, or the lines sit at slightly different heights.
- A "continued" note at the bottom of the left half, pointing to the right.
Bank statements rarely use two columns for the transaction list itself. The layout shows up more on summary pages, fee schedules, account notices and some older statements that squeezed two months of activity onto one sheet. Card statements sometimes print rewards or interest details in two narrow blocks. Know which page you are looking at before you plan the fix, since a statement may have a single-column transaction list and one two-column summary page.
Cropping each half of a two column PDF
Cropping each half means making two copies of the page and setting a different visible area on each. One copy shows only the left column; the other shows only the right. Most PDF editors and some free tools let you set a crop box by dragging a rectangle or typing the margins.
Here is the step list. The numbers are an example for a US letter page, 8.5 inches wide, with the gutter in the middle.
- Measure the gutter. Zoom in and note where the white gap sits. In this example, the left column ends at 4.1 inches and the right column starts at 4.4 inches.
- Duplicate the file. Save two copies, named with "left" and "right" so you cannot mix them up.
- Crop the left copy. Set the right edge of the visible area inside the gutter, at about 4.25 inches. Keep the full height.
- Crop the right copy. Set the left edge at the same 4.25 inches, inside the gutter.
- Check both copies. Scroll every page. No character should be cut in half at the crop edge.
- Convert each copy. Run the left file, then the right file, through the same converter with the same settings.
A crop only hides content; the text outside the crop box is usually still in the file, as cropping a PDF before converting explains. Some converters read the crop box and some read the whole page, so test one page first. If the hidden half still appears in the output, print the cropped copy to a new PDF, which writes only what is visible. If the file errors out at this stage, the cause is usually the file rather than the layout, and why a PDF to Excel conversion failed helps sort that out. A file that throws errors in every tool may need repairing a corrupted PDF first.
Rejoining the left and right halves in Excel
Rejoining the halves means stacking them, not placing them side by side. The reading order of a two-column page is the whole left column, then the whole right column. So the right half's rows belong under the left half's rows, page by page, and the order of pages still matters.
A worked example
The lines below are an example: a summary page with four lines in each half.
| Position on the page | Left half | Right half |
|---|---|---|
| Line 1 | L1 Jan 03 Opening deposit | R1 Feb 02 Rent |
| Line 2 | L2 Jan 09 Card payment | R2 Feb 11 Insurance |
| Line 3 | L3 Jan 17 Transfer in | R3 Feb 19 Card payment |
| Line 4 | L4 Jan 28 Service fee | R4 Feb 26 Service fee |
A converter that reads straight across produces four rows, each holding two transactions: L1 beside R1, L2 beside R2, and so on. Sorting by date then scrambles them further, because each row has two dates.
After cropping and converting each half, you get two sheets of four rows. The rejoined sheet should read:
| Row | Content |
|---|---|
| 1 | L1 Jan 03 Opening deposit |
| 2 | L2 Jan 09 Card payment |
| 3 | L3 Jan 17 Transfer in |
| 4 | L4 Jan 28 Service fee |
| 5 | R1 Feb 02 Rent |
| 6 | R2 Feb 11 Insurance |
| 7 | R3 Feb 19 Card payment |
| 8 | R4 Feb 26 Service fee |
Keeping pages in order
With several pages, the order is page 1 left, page 1 right, page 2 left, page 2 right. Converting the two files gives you all the left halves together and all the right halves together, so add a helper column before you stack them. Put the page number in one column and a 1 or 2 for the half in another. Paste the right-half rows under the left-half rows, then sort by page, then half, then the original row number. A third helper column holding each row's position within its half keeps that last sort stable.
When the sheet is in order, delete the helper columns, then check the totals. If the page printed a total for each half, both should match the sum of their rows.
Is a two column statement page ever a single table?
Yes. A page with two money columns, such as debits on the left and credits on the right, is usually one table, even when a wide gap separates them. Each line is one transaction. The debit and credit belong to the same row, so cropping them apart would break every row in two.
The difference is in what each line means. In a true two-column layout, the left and right text on the same line are unrelated. In a wide table, they describe the same event. Read three or four lines across. If the date on the left belongs with the amount on the right, leave the page alone and convert it whole.
Edge cases sit between the two. A statement may print a transaction list down the left two-thirds of the page and a box of messages or a balance summary down the right. That box is not data you want in the transaction rows. Cropping it off is the fix, and only the left part needs converting. Another case is a page of check images arranged in two or more columns. The images are pictures rather than rows, and what to do with check images on a bank statement covers whether they belong in a spreadsheet at all.
Two column splits that cut through text
A split cuts through text when the gutter is narrow or something spans both columns. Then the crop edge lands on characters, and each half loses a few letters or digits. The output looks complete, but an amount can lose its last digit and still look like a valid number.
Watch for these failure points:
- A narrow gutter. When the gap is only a few characters wide, a crop line drawn by eye can clip the end of a right-aligned amount in the left half. Zoom in to the highest level before setting the edge.
- Headings that span the page. A title or a "Summary of activity" banner across both columns gets cut in two. Delete the fragments from both sheets after conversion; they are not data.
- Uneven columns. If the left column runs longer than the right, the extra rows of the left half have no partner. That is fine once you stack the halves, but it confuses any check that expects equal row counts.
- Different layouts per page. A two-column summary page may be followed by single-column transaction pages. Split only the pages that need it, and convert the rest whole.
- Scanned pages. On a scan, the gutter may drift a little from page to page because each sheet sat differently on the glass. Check the crop edge on every page, not just the first.
The quickest proof of a clean split is a count. Count the lines in each half on one page, then count the rows each half produced. They should match. Then compare a few amounts digit by digit, focusing on numbers that sat closest to the gutter.
FastBankConvert is built to read typical digital statement pages, and it tells you before download when the balances fail to tie, which is the sign a split or crop cost you a row. It is getting ready to open, and Get started puts you on the list.