The Excel mobile app limitations that matter for a converted bank statement are few but real: no Power Query, read-only CSV and XLS files on iPhone, macros that will not run, and a small screen that makes long sheets hard to check. Reading, sorting and totalling rows works well. Reshaping a messy conversion is a job for a computer.
Which Excel mobile app limitations hit converted statements?
The limitations that hit converted statements fall into three groups: features the phone app does not have, file types it will not edit, and the plain fact of a small screen. A clean conversion with one row per transaction rarely runs into any of them. A messy conversion that needs reshaping runs into all three.
Here is how common statement jobs fare in the phone app. "Practical" means it works without a fight on a phone screen, not that the feature is missing elsewhere.
| Statement job | In the phone app | Why |
|---|---|---|
| Read rows and scroll the statement | Practical | Viewing is the app's strongest job |
| Sum a column of amounts | Practical | Select the column and read the total |
| Sort by date or amount | Practical | Sort is in the app's menus |
| Filter to one payee | Practical | Filters work, the list is just short on screen |
| Fix a few wrong cells | Practical | Tap and type |
| Import a PDF with Get Data | Not available | Power Query is not supported on mobile |
| Edit a CSV export on iPhone | Not available | CSV opens read-only on iOS |
| Run a clean-up macro | Not available | VBA does not run on mobile |
| Split one combined column into three | Slow | Needs formulas typed on a phone keyboard |
| Compare 300 rows against the PDF | Slow | Only a few rows fit on the screen |
The rest of this post takes the "not available" and "slow" rows in turn, with what to do instead.
Power Query and the Excel mobile app
Power Query, the Get Data feature that imports and reshapes data in desktop Excel, is not in the Excel mobile app. Microsoft's page on Power Query data sources in Excel versions states it plainly for Excel for Android and iOS: Power Query is not supported.
That rules out two things people try on a phone. The first is importing a PDF straight into a workbook, which Excel for Microsoft 365 on Windows does through Get Data, From PDF, and the same page lists no PDF source for Excel for Mac. The second is refreshing a query that someone built on a computer. A workbook with a query still opens on the phone, and its last loaded results are there to read. The query itself cannot run or be edited.
What to use on a phone instead
For a PDF on a phone, the conversion has to happen somewhere other than Excel. A browser converter that returns an XLSX file is the usual route, and the phone app then opens the result. For a table that only exists as a photo or a screenshot, the phone's own text recognition is another route. Copying a table from an image on iPhone covers Live Text and the one-column paste it tends to produce. On Android, copying text from a photo does the same job with Google's tools.
File types the Excel mobile app opens read-only
Some files open in the Excel mobile app but refuse edits, and the cause is the file type, not your account. Microsoft's table of file types Excel can open on mobile shows that on iOS, CSV and XLS files open read-only, while XLSX opens for editing. Android edits a few more types than iOS.
The table matters for statements because many banks and converters hand out CSV. On an iPhone, a CSV export opens and looks normal, but you cannot type into it. Two fixes work:
- Ask for XLSX instead. If the converter offers Excel output, pick it on a phone.
- Open the CSV in another app. Numbers on iPhone imports CSV as an editable table, and Google Sheets opens it too.
Macro-enabled workbooks
The same Microsoft table says that macro-enabled workbooks (XLSM) open and can be edited on both iOS and Android, but VBA functions will not run. A clean-up macro that someone wrote to tidy a statement export, such as one that deletes header rows or flips signs, does nothing on the phone. The workbook's data is still there. Run the macro later on a computer.
Can the Excel mobile app handle a large converted sheet?
The Excel mobile app opens a large converted sheet, but the phone screen makes it hard to work with. Only a small window of rows and columns fits at once. A year of transactions can run to well over a thousand rows. Scrolling through that to find one wrong amount is slow, and it is easy to lose your place.
Some habits make a long sheet manageable on a phone:
- Freeze the header row. If the app's View options include freezing panes, use it on row 1. The column names stay on screen while you scroll, so you always know which column is the amount.
- Check with sums, not eyes. Total the deposits and withdrawals and compare them with the statement's summary box. A match means you do not need to look at every row.
- Filter before you scroll. Filter to one month or one payee, so the list on screen is short enough to read.
- Turn the phone sideways. Landscape shows more columns, which helps with a wide sheet that has date, description, debit, credit and balance.
If the totals do not match and the gap is not in an obvious row, stop and wait for a bigger screen. Line-by-line comparison on a phone is where mistakes creep in.
Splitting text into columns in the Excel mobile app
When a conversion puts date, payee and amount into one cell, desktop users reach for Text to Columns. Look under the Data tab in the phone app. If your version lacks it, formulas do the same job, one column at a time. On a phone keyboard that is slow, so it suits a short statement.
A worked formula example
Suppose column A holds lines like the example below, with the date, the description and the amount separated by spaces. The values are made up for illustration.
| A (example converted text) |
|---|
| 09/14 GROCERY MART 52.18 |
| 09/15 CITY WATER 41.00 |
| 09/16 PAYROLL DEPOSIT 1,250.00 |
The date is always the first five characters, and the amount is everything after the last space. These formulas use only long-standing text functions:
- Date (column B):
=LEFT(A2,5)returns09/14. - Amount (column D):
=VALUE(TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",50)),50)))returns52.18as a number. The SUBSTITUTE step pads each space so the last word can be pulled cleanly from the right. - Description (column C):
=TRIM(MID(A2,7,LEN(A2)-6-LEN(TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",50)),50)))))returnsGROCERY MART.
Type each formula once in row 2, then fill it down. Check the payroll row in particular, because the comma in 1,250.00 must be read as a thousands separator, not text. If VALUE returns an error there, your phone's region settings may use a different separator.
That is a lot of typing on glass. If a statement arrives in this shape, converting it again with a tool that returns separate columns is usually faster than fixing it in the phone app.
Free Excel mobile editing and screen size limits
Excel's phone app is free for basic editing on small screens, and asks for a subscription for premium features. Microsoft's page on what you can do in the Microsoft 365 mobile apps says that without a qualifying plan you can create and view files and do basic editing for non-business accounts, with a 10.1-inch screen limit.
Every phone sits under that limit, so the free tier covers everything a converted statement needs on a phone: reading, sorting, filtering, totals and fixing cells. The screen limit matters more for large tablets, where the same app may need a qualifying plan before it allows edits.
Two cases still produce a subscription prompt on a phone:
- A premium feature. Microsoft does not list Excel's premium features on that page, but tapping one shows a message to buy a subscription. Back out and do the step another way.
- A business account or file. The basic editing line covers non-business accounts and files. A workbook from a company account may need the company's plan.
Statement clean-up edits that still need a PC
Some clean-up edits belong on a computer even though a phone could, in theory, manage them. The rule of thumb is simple: if the fix touches every row, or needs a tool the phone app lacks, wait for a PC. If it touches a handful of cells, do it on the phone and move on.
Save these for a computer:
- Importing or reshaping with Power Query. The feature is not on mobile at all.
- Running a macro. VBA will not run in the phone app.
- Splitting a combined column across hundreds of rows. The formulas above work, but a computer makes them fast.
- Converting text amounts to numbers across a whole column. One wrong fill on a phone is hard to spot.
- Finding a balance gap that is not one obvious row. A side-by-side view of PDF and sheet beats scrolling.
- Building lookups or category rules. Long formulas are error-prone on a phone keyboard.
When not to start on the phone at all
A converted file that arrives badly shaped, with columns merged or numbers stored as text, is better converted again than repaired on a phone. The same goes for a photo of a statement. Turning an image into Excel rows explains how to shoot the page so the conversion is clean from the start, which saves the clean-up the phone app handles worst.
FastBankConvert is being built to return dates, descriptions, amounts and balances in their own columns, which keeps phone edits to the light jobs the app does well. It is getting ready to open, and the Get started page is where to join.