# Bank statement pdf to Excel columns merged? How accountants split them on Mac, 2026

> Bank statement pdf to Excel columns merged on Mac? Fix it with CSV exports, Text to Columns and Preview copy steps for 2026.

URL: https://www.lazur.app/for/accountants/problems/bank-statement-pdf-excel-columns-merged
Updated: 2026-11-08

Bank statement PDF columns merge in Excel because the PDF stores text by position, not as a table. The fastest fix is to skip the PDF. Download a CSV or QBO file from your bank. If you only have the PDF, split the merged text with Data > Text to Columns on a copy.

## Quick answer

- Merged columns come from how the PDF is built, so the converter has to guess the column edges.
- Download a CSV or QBO file from the bank first. It skips the guessing.
- If you only have the PDF, split the text on a copy with Data > Text to Columns.
- Totals are the final test. Add the amounts and compare them with the statement before you post.

## What bank statement pdf columns merged on conversion costs you

- **Hours spent fixing data by hand.** Senior finance staff feel this first. A 2026 FERF and FEI survey found 36% of organizations say directors, controllers and senior managers spend 31% to 50% of their time manually intervening in data. The survey does not measure bank statements alone, so treat it as context, not a measure of your week.
- **Reopened books and rework.** Errors found late cost more than the fix itself. In a 2022 FloQast survey of 204 professionals, 85% reopened the books in at least one month to fix errors. FloQast sponsored the study and used an online panel, so it is not representative. It suggests errors often surface after posting.
- **Amounts that post to the wrong place.** A shifted amount can land in the wrong column and post the wrong way. Parseur reports that 50.4% of respondents say manual data entry leads to costly errors. That figure is self-reported perception, not a measured error rate, so use it with care. No study counts how often converted statements carry this risk.
- **Cleanup that slows every later step.** Sorting, filtering and totals can fail on text that looks like numbers. One merged column slows every later step on the sheet. You end up checking the data before you can analyze it, and that check often takes longer than the conversion did.

## Why it happens

1. **PDFs store text positions, not a table.** A PDF records where each word sits on the page. It rarely records which cells belong together. Converters rebuild the table from those positions. When positions are close, they can join two columns. Adobe's guide names misaligned columns, extra spaces and merged cells as the usual result.
2. **Tight or uneven spacing.** Columns with little space between them merge first. Bank statements often pack the description, reference and amount close together to fit the page. A long payee name can push the amount into the next column's space. Adobe says misaligned columns can happen with complex layouts or inconsistent spacing.
3. **Wrapped rows read as separate rows.** A transaction with a two-line description is one logical row. Many converters read each line as its own row. Microsoft's PDF documentation says multi-line rows are often not identified correctly. The result looks like a merge, or like a row split in half.
4. **Scans and image PDFs.** A scanned statement is a picture of text. The converter must read characters first, then guess the table on top of them. Errors stack up at each step. Microsoft's Q&A answers point to the From Picture tool for this case, and they warn that results vary.
5. **Layouts that change by bank.** Each bank lays out its statement differently. Download options vary too. CapyParse says formats and date limits vary by bank. One template fix will not match every statement you receive, so check each new bank before you trust the result.

## How to fix it

- **Download the bank's CSV or QBO.** This is the cleanest fix because nothing has to be guessed from layout. Use the download menu on the bank's transactions page. CSV opens in Excel and Numbers. QBO works for QuickBooks uploads. Check the first rows and the date format, then compare the totals with the statement.
- **Split merged text with Text to Columns.** Use Data > Text to Columns on a copy. Choose Delimited, then the separator that fits the text. Set the destination to an empty column. Text to Columns only splits text that already sits in one cell. It cannot rebuild columns the converter never separated.
- **Copy one column at a time from Preview.** Open the PDF in Preview. Choose Tools > Text Selection. Hold Option while you select a single column. Paste each column into its own place in Excel. Use this when the converter keeps merging a column you need, such as the amount. Check wrapped rows afterward.
- **Export from Acrobat, then review.** In Acrobat, use All Tools > Export a PDF > Microsoft Excel > Excel Workbook (.xlsx). Then review the sheet against the PDF. Check the first few rows and every row that wraps. Adobe says to review the data for accuracy. This route needs a paid Acrobat subscription.
- **Use Power Query where it appears.** If Data > Get Data offers a PDF option in your copy of Excel, test it. Microsoft's Power Query PDF documentation says multi-line rows can be cleaned with Table.FillDown or Table.Group. Microsoft does not clearly document this for Mac, so test on a copy first.
- **Check totals before you post.** Opening balance plus credits minus debits should equal the closing balance. Totals catch a shifted column even when the rows look fine. Put a check cell in the sheet and keep it until the month closes. If the check fails, find the rows that differ before you move on.
- **Filter for the rows that broke.** Filter the amount column for blanks or text values. Those rows usually show where the merge hit. Fix only those rows on the copy. This saves you from re-checking every line of a statement that converted cleanly.

## Why bank statement PDF columns merge in Excel

A bank statement PDF is built for reading on a screen or on paper. Each word sits at a position on the page. There is no hidden grid of cells. When you convert, the converter has to guess where one column ends and the next begins. It guesses from spacing and alignment. When spacing is tight or uneven, the guess fails, and two columns land in one cell.

Adobe describes the same problem in its guide for bank statements. It warns that transaction tables can have misaligned columns, extra spaces or merged cells. It says this can happen when PDFs use complex layouts or inconsistent spacing. Expect other converters to fail in the same places, because they face the same layout problem.

![Accountant at a desk reviewing converted bank statement pdf to Excel columns merged data on a laptop](https://images.lazur.app/content-images/problem/bank-statement-pdf-excel-columns-merged/bank-statement-pdf-to-excel-columns-merged-1-15448a.jpg)

## Convert bank statement PDF to Excel on Mac: check the PDF first

Before you convert anything, test the PDF. Open it in Preview or in Chrome. Drag across one transaction line. If you can highlight the description and the amount separately, the PDF has real text, and conversion has a fair chance. If the whole page highlights as one block, or nothing highlights, the PDF is probably a scan.

Scans convert worse, and the merges get worse with them. Microsoft's Q&A answers point to the From Picture tool in Get & Transform Data on the Data tab. One answer suggests copying the table from a PDF reader, then using From Clipboard. The same answer warns that results vary with the PDF's structure. Treat that as a starting point, not a promise.

## The fastest fix: download a CSV or QBO file from your bank

This route beats every PDF fix. Log in to your bank's website and open the transactions or activity page. Look for a download or export menu. Many banks offer CSV. Some also offer QBO. CapyParse, a vendor blog from March 2026, says all 11 banks it lists offer CSV. It says four of them also offer QBO.

A CSV has no columns to guess. Each field is already separated. Check the first rows after you open it, because some files carry header text above the data. Also check the date format. Formats and date limits vary by bank, so treat that list as a snapshot, not a rule.

| Export | Where to look | What to watch |
| --- | --- | --- |
| CSV | Activity or transactions page, download menu | Column names and date format vary by bank |
| QBO | Download menu on some banks (CapyParse lists Chase, TD Bank, PNC and Fifth Third) | QuickBooks accepts QBO uploads |
| PDF | Statements page | Columns can shift or merge on conversion |

_Export types from a March 2026 vendor list, not a bank survey._

## Step by step: split merged cells with Text to Columns on Mac

Use this route when the converted sheet puts one long text string in each cell. Work on a copy, so you can start over if the split goes wrong.

1. Paste the converted data into a new sheet. Keep the original file closed or untouched.
2. Select the column that holds the merged text.
3. Choose Data > Text to Columns.
4. Pick Delimited, then click Next.
5. Check the separator that matches the text, such as Space, Tab or Comma. Read the preview before you go on.
6. Set the Destination to an empty column, so the original text stays until you check the result.
7. Click Finish. Then compare the first few rows with the PDF, one line at a time.

Microsoft's Text to Columns article covers the wizard and its Delimited option. It does not name Mac. The Data menu path above is what you should expect in Excel for Mac, so check it on your own copy.

> **Space splits too much:** If descriptions contain spaces, the Space separator splits every word into its own column. Check Space only for columns that need it. For other columns, split on a fixed marker, such as a slash or a card number.

## Copy columns from Preview instead of converting

Sometimes the converter is the problem. A copy from the PDF can come out cleaner. Open the statement in Preview. Choose Tools > Text Selection. Hold the Option key while you select one column of the table. Paste that column into its own place in Excel, then repeat for each column.

Do not use Tools > Rectangular Selection for this. Apple's guide says it copies a region as an image, not as text. You need text, so you need Text Selection. This method is slower than conversion. The column edges follow your drag, though, and that often beats a guess. Check every row that wraps onto a second line.

![Printed bank statement pages on a desk, the kind of PDF that can merge columns in Excel](https://images.lazur.app/content-images/problem/bank-statement-pdf-excel-columns-merged/bank-statement-pdf-to-excel-columns-merged-3-1e2c91.jpg)

## Export from Acrobat, then review in Excel

Adobe's India edition of its bank statement guide lists the steps. In Acrobat, choose All Tools > Export a PDF > Microsoft Excel > Excel Workbook (.xlsx). For CSV, Adobe's guide points to Home > Save As. Adobe also says to review the data in Excel for accuracy. Treat the export as a draft, not a finished file.

Acrobat is a paid product. Adobe's pricing page lists no ongoing free tier. Check the current price for your region before you buy it for one job. The pricing page shows Australian dollar prices, so check your own currency.

## Edge cases that break every method

- Wrapped descriptions: a payee name that runs onto a second line can become a separate row. Join the rows back using the date column as the anchor.
- Bracketed or trailing negatives: some statements show debits in brackets or with a trailing minus sign. Excel may read those as text, so convert them before you total.
- Balance rows: opening and closing balance lines are not transactions. Remove them before you import into accounting software. A QuickBooks Community reply gives the same advice.
- Split debit and credit columns: when they sit close together, a small shift moves a credit into the debit column. Check the sign of every amount.
- Repeated headers: a table that runs onto a new page can repeat its header row. Delete the repeats, or they become data.
- Date order: a converter can read day and month in the wrong order. Check that the first and last dates fall inside the statement period.

## Mistakes that make merged columns worse

Three habits do the most damage. First, people fix the merge in the original file. Then there is no clean copy to go back to. Second, people sort the sheet after they split a column. If one row split wrong, sorting moves its description away from its amount. Third, people check only the first page. A problem on a later page can stay hidden until the month closes.

Check the totals instead. Opening balance plus credits minus debits should equal the closing balance. If it does not, a column is wrong somewhere, even when every row looks fine. Visual checks miss shifts that a total catches.

## A worked example from start to finish

Say you convert a multi-page statement. The Description column holds the payee and a date. The amounts sit in one column next to the balance. Here is the order that tends to work.

1. Try the bank's CSV first. If it exists, skip the PDF.
2. If only the PDF exists, try highlighting one line in Preview. If the parts highlight separately, copy the Amount column with Option.
3. Paste the converted data into a new sheet. Add a check cell: opening balance plus credits minus debits.
4. Filter the amount column for blank or text values. Those rows show where the merge hit.
5. Use Text to Columns on the copy, only for the rows that need it.
6. Compare the check cell with the closing balance. Fix rows until the two match.

This order saves the most rework. The check cell gives you a number to compare at the end. A visual scan does not give you that.

## How much time this really costs

Nobody has measured how long bank statement conversion takes accountants. No primary study counts merged columns or the hours they cost. The closest sources measure broader work. A 2026 FERF and FEI survey of 116 senior finance and accounting executives, mostly in the US, found 36% of organizations report directors, controllers and senior managers spend 31% to 50% of their time manually intervening in data.

Parseur's 2025 survey of 500 US professionals across fields found more than 9 hours a week moving data from emails, PDFs, spreadsheets and scans. It covers all departments, not accountants alone. Parseur commissioned it. Use it as a rough signal, not a measure of your week.

- **36%** Organizations where directors, controllers and senior managers spend 31% to 50% of time manually intervening in data ([source](https://www.cpapracticeadvisor.com/2026/10/09/in-a-third-of-finance-teams-senior-staff-lose-up-to-half-the-week-to-manual-data-work/191264/))
- **85%** Accounting pros who reopened the books in at least one month to fix errors (2022 FloQast survey, n=204) ([source](https://www.floqast.com/press-releases/floqast-releases-survey-results-detailing-prevalent-burnout-in-accounting-industry))
- **9 hours** A week spent moving data from emails, PDFs, spreadsheets and scans, across all departments (Parseur, 2025) ([source](https://parseur.com/blog/manual-data-entry-report))

Errors cost more than minutes. In a 2022 FloQast survey of 204 accounting and finance professionals, 85% reopened the books in at least one month to fix errors. FloQast sponsored that survey, and the sample came from an online panel. It is not a representative sample of all accountants.

> **Evidence is thin:** No study tests whether any of these fixes reduces errors. The steps come from bank, Adobe and Microsoft documentation and from community answers. Verify each converted figure against the statement.

## Privacy and client data

Bank statements hold client financial data. Follow your firm's rules and your client agreements before you open a statement in any tool. That includes cloud converters, AI tools and Lazur. Your employer's policy decides what you may share. A voice assistant does not change that.

Here is how Lazur handles what it sees. It listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer, and they are not stored. Content is never used to train AI models. Those are product facts, not a promise about your firm's rules.

![Person using a Mac computer at a desk with a spreadsheet open for bank statement cleanup](https://images.lazur.app/content-images/problem/bank-statement-pdf-excel-columns-merged/bank-statement-pdf-to-excel-columns-merged-2-43c6ee.jpg)

## Where Lazur helps, and where it does not

Lazur is a voice assistant for the Mac that lives in the notch. It guides you, points at things and answers out loud. It does not click buttons, edit files or operate Excel for you. So it can show you where Text to Columns sits, but your hand still makes the click.

Hold ⌥ ⌘ to ask about anything on screen. Ask where the Data menu is, and Lazur draws a circle and a label around it. Ask how to split a column, and Lazur guides you one click at a time, waiting for each click before the next step. Lazur runs on macOS only. Windows is planned, not available.

For the export question, ask Lazur to research your bank's download formats. Research runs in Lazur's own Chrome tabs and comes back with a summary and a report. Check that answer on your bank's site yourself, because bank pages change.

## What to check before you post anything

- Opening balance plus credits minus debits equals the closing balance.
- Every amount has the right sign, and debits and credits sit in the right columns.
- Dates fall inside the statement period and read day then month correctly.
- No balance rows, repeated headers or blank rows came across as transactions.
- Each wrapped description matches the PDF, line for line.
- The original export is saved, so you can compare later.

> **Save the raw file:** Keep the untouched export next to your cleaned copy. If a figure looks wrong later, you can trace it back to the bank's own file. Name the file with the bank and the statement month, so you find it again.

## Where to go next for Excel and Numbers

For Excel basics, read [Excel for accountants on Mac](https://www.lazur.app/for/accountants/excel). If your team uses Numbers, see [how to open an Excel file in Numbers on Mac](https://www.lazur.app/how-to/open-an-excel-file-in-numbers). Lazur pricing is on the [pricing page](https://www.lazur.app/pricing).

## With Lazur

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ and ask; it sees your screen, answers out loud, points at buttons and walks you through apps. Hold fn to dictate. Free for 3 days, then $18/month: https://www.lazur.app/download

- “Where is Text to Columns in Excel?”: Lazur draws a circle and a label around the Data menu. You still click the menu and choose Text to Columns. (Points at it)
- “Where is Text to Columns in Excel?”: Lazur draws a circle and a label around the Data menu. You still click the menu yourself.
- “What does Delimited mean in this wizard?”: Lazur explains the choice out loud while the wizard stays open on your screen.
- “Walk me through splitting this column.”: Lazur guides you one click at a time and waits for each click before it goes on.
- “Find out which export formats my bank offers.”: Lazur runs a research job in its own Chrome tabs and returns a summary and a report. You verify it on the bank's site.
- “Draft a note asking the client for a CSV export.”: Lazur drafts and types the text. You read it and send it yourself.
- “Hold fn and dictate the variance note.”: Hold fn to dictate clean text at the cursor in any app, including your notes.

## A plan you can start this week

- **Day 1: Ask the bank for a CSV first.** Log in to your bank's website. Open the transactions page and look for a download or export menu. Save the CSV or QBO file in a folder for this client and month. If there is no export, note the bank name and move to Day 2.
- **Day 2: Test the PDF before converting.** Open the statement in Preview or Chrome. Try to highlight one transaction line. If the description and amount highlight separately, convert the PDF. If the page is one picture, expect worse results and plan extra checking time.
- **Day 3: Split on a copy only.** Paste the converted data into a new sheet. Use Data > Text to Columns for merged text, or copy single columns from Preview with Option. Keep the original export closed. Fix only the rows your filter finds.
- **Day 4: Reconcile and log the fix.** Run the opening balance plus credits minus debits check against the closing balance. Record the bank, the export type and any rows you changed. Next month, start from those notes, not from scratch.

## FAQ

### Why do my bank statement PDF columns merge when I convert to Excel on Mac?

The PDF stores text at positions, not as a table. The converter guesses column edges from spacing. When spacing is tight or uneven, two columns can land in one cell. Wrapped rows and scanned pages make it worse.

### What is the fastest way to avoid merged columns?

Download a CSV or QBO file from the bank's transactions page. It has no layout to guess from. Use the PDF only when the bank offers no export. CapyParse's March 2026 list says all 11 banks it covers offer CSV, but check your own bank.

### Does Excel for Mac have a From PDF option?

Microsoft's documentation does not clearly say. A Microsoft Q&A thread says Excel for Mac does not support extracting data from PDFs, but that answer is labeled AI-generated. Look under Data > Get Data in your copy to see what you have.

### How do I split a merged column without losing data?

Work on a copy. Use Data > Text to Columns, choose Delimited, and set the destination to an empty column. Check the preview before you click Finish.

### Why won't QuickBooks take my bank statement PDF?

QuickBooks cannot import a bank statement PDF directly. Accepted uploads are QBO, QFX or OFX, and CSV or TXT. A QuickBooks Community reply says a Date, Description, Amount CSV can work, once balance rows are removed.

### Can Lazur fix the columns in my spreadsheet?

No. Lazur guides, points and answers out loud. It does not click buttons or edit files for you. It can show you where Text to Columns is, then guide you one click at a time.

### Can I paste a client's bank statement into Lazur?

Follow your firm's rules and your clients' agreements first. Lazur listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer and are not stored. Your employer decides what is allowed.

## Sources

1. [CPA Practice Advisor: In a Third of Finance Teams, Senior Staff Lose Up to Half the Week to Manual Data Work](https://www.cpapracticeadvisor.com/2026/10/09/in-a-third-of-finance-teams-senior-staff-lose-up-to-half-the-week-to-manual-data-work/191264/), CPA Practice Advisor, checked 2026-11-08
2. [FloQast Releases Survey Results Detailing Prevalent Burnout In Accounting Industry](https://www.floqast.com/press-releases/floqast-releases-survey-results-detailing-prevalent-burnout-in-accounting-industry), FloQast, checked 2026-11-08
3. [Manual Data Entry Costs U.S. Companies $28,500 Per Employee Each Year](https://parseur.com/blog/manual-data-entry-report), Parseur, checked 2026-11-08
4. [How to convert bank statement PDF to Excel](https://www.adobe.com/in/acrobat/roc/blog/how-to-convert-bank-statement-pdf-to-excel.html), Adobe, checked 2026-11-08
5. [Adobe Acrobat pricing](https://www.adobe.com/acrobat/pricing.html), Adobe, checked 2026-11-08
6. [Power Query PDF connector](https://learn.microsoft.com/en-us/power-query/connectors/pdf), Microsoft Learn, checked 2026-11-08
7. [How to import data table from PDF on Excel for MAC](https://learn.microsoft.com/en-us/answers/questions/5752509/how-to-import-data-table-from-pdf-on-excel-for-mac), Microsoft Q&A, checked 2026-11-08
8. [Split text into different columns with Text to Columns](https://support.microsoft.com/en-us/office/split-text-into-different-columns-with-the-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7), Microsoft Support, checked 2026-11-08
9. [Preview User Guide for Mac](https://support.apple.com/guide/preview/prvw1020/mac), Apple Support, checked 2026-11-08
10. [How to download bank statements as CSV](https://capyparse.com/blog/how-to-download-bank-statements-as-csv), CapyParse, checked 2026-11-08
11. [How do I convert a PDF document to a QBO document to upload into QuickBooks Online?](https://quickbooks.intuit.com/learn-support/en-us/banking/how-do-i-convert-a-pdf-document-to-a-qbo-document-to-upload-into/00/1056529), Intuit QuickBooks Community, checked 2026-11-08