Spreadsheets

Clean up a statement CSV on your phone with a spreadsheet app

What you can realistically do with a bank statement CSV on a phone: open it, delete junk rows, fix the date column, share it, and when to wait for a laptop.

Editorial illustration for Clean up a statement CSV on your phone with a spreadsheet app

On a phone you can open a statement CSV in a spreadsheet app, delete the title and summary rows, correct the date column and share the cleaned file. You cannot comfortably split columns, repair long reference numbers or reconcile hundreds of rows, so keep the phone for light tidying and leave the heavy work for a laptop.

What is realistic to do on a phone?

JobOn a phoneBetter on a laptop
Open the CSV and read the rowsFineNot needed
Delete header, footer and blank rowsFine, a few at a timeFaster with filters
Fix a date columnPossible, with careEasier with the locale-aware import
Split one column into severalOften not availableText to Columns
Repair 16-digit reference numbersNot reliableImport them as text
Check totals against the statementFine for a short listBetter for long lists

How do you open the CSV without breaking it?

Save the file from your email or browser into your phone's Files or Downloads folder first. Then use Open with and pick Google Sheets or Excel. Avoid opening it from a chat app's preview, because the preview often shows a file as plain text. When the file opens, scroll to the first and last rows and check that the columns are separate. If everything sits in one column, stop, since the repair is a laptop job.

How do you delete the junk rows?

  1. Scroll to the top. Statements often begin with your name, account details and a period line before the real header row.
  2. Touch and hold a row number, then drag the handle down to include every junk row.
  3. Choose Delete rows from the menu that appears.
  4. Do the same for summary lines, page totals and blank rows at the bottom.
  5. Keep exactly one header row, with columns such as Date, Narration, Debit, Credit and Balance.

Delete in small groups and glance at the first transaction row after each deletion, so you never remove a real transaction by accident.

How do you fix the date column on a phone?

Look at how the dates sit in their cells. Right-aligned means the app read them as dates, left-aligned means text. For text dates, select the column, open the format menu and set it to Date, but check one row such as 25/01/2026 afterwards. If it did not convert, the app's region does not match the file's day-first order, and this is the moment to wait for a laptop rather than guess. A wrongly read 05/01 looks fine, so spot-check against your bank app.

How do you share the cleaned file safely?

  • Save the result as a new file, such as a Sheets or XLSX copy, and leave the original CSV alone.
  • Share only with yourself, for example by saving it to a private folder, rather than to a group chat.
  • Statements hold your name and spending, so avoid sending them through apps where the file stays in many places.
  • Delete the downloaded original and the extra copies once the clean version is stored.

When should you wait for a laptop?

Wait if the columns are merged into one, if reference numbers show in scientific notation, if you have more than a couple of hundred rows, or if you need to combine several months. These are quick on a laptop with the import preview and slow, risky taps on a small screen.

If you only want your spending sorted, you can skip cleaning: SpendixAI takes a statement as PDF, CSV or Excel, lets you pick the account first, and shows the rows for review before saving. Check the preview, because bank layouts vary.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports