Bank statements

Wells Fargo statement to CSV, and what to do if the file is locked

Wells Fargo statement to CSV: get a CSV if your bank offers one, convert a PDF safely, fix common import errors, and handle a PDF that asks for an opening code.

Editorial illustration for Wells Fargo statement to CSV, and what to do if the file is locked

The cleanest route to a CSV is to ask your bank for one: many banks let you download transactions as CSV or Excel from the statement or activity page. If you only have a PDF, you can copy the table into a spreadsheet and save it as CSV. Look at your own bank's help page for the exact route; this article does not describe its menus, and the layout of your file may differ.

What is a CSV and why do apps want it?

A CSV is a plain text file where each line is one transaction and the columns are separated by commas. Spreadsheets, accounting tools and trackers can read it, which makes it the common currency of statement data. The columns you want are date, description, amount, and ideally a separate debit and credit or a signed amount.

How do I make one from a PDF?

  1. Check the PDF contains text: select a word, or search for a merchant.
  2. Copy the transaction table and paste it into a blank sheet in Excel or Google Sheets.
  3. Split columns if everything landed in one.
  4. Make sure dates are real dates and amounts are real numbers.
  5. Use Save As or Download, and choose CSV. Choose a UTF-8 option if it is offered, so symbols survive.
  6. Reopen the CSV in a plain text editor to confirm it looks right.

My statement PDF asks for something to open it. What now?

Some banks protect statement PDFs. The bank's own help page or the email that carried the file usually says what the opening code is built from, and it is typically something you already know. Look there first. If you cannot work it out, ask the bank through its official channel. Keep that code to yourself, never type it into a website that offers to unlock files for you, and do not send a protected statement to an unknown service. Remove protection only on your own copy, using your own PDF viewer's option, if you are entitled to the file.

What goes wrong with CSV files?

  • Dates flip between day-first and month-first. Check a date such as 03/04 against the statement.
  • Amounts with thousands commas split into two columns. Wrap those cells in quotes or remove the commas.
  • A leading zero disappears from reference numbers. Format that column as text before pasting.
  • Negative numbers shown in brackets turn into text. Convert them.
ProblemCheckFix
Date flipped03/04 on the statement is 3 April?Reformat the date column
Amount textLeft-aligned cellUse VALUE or Text to Columns
Garbled symbolOdd characters in editorSave as CSV UTF-8
Missing rowRow count and totalRecopy that page

A quick test with hypothetical figures: say the statement lists 12 debits adding to 8,240.50 and 3 credits adding to 5,000.00. Your CSV should give 12 negative rows summing to -8,240.50, 3 positive rows summing to 5,000.00 and a net change of -3,240.50. If it does not, find the page where a row went missing.

What happens at the other end?

SpendixAI accepts statements as PDF, CSV or Excel, so a tidy CSV is one route, but you can also upload the PDF directly and review the parsed rows before saving. Choose the account first, so each transaction keeps it. It does not ask for net-banking logins. A statement in another currency needs the base currency chosen before importing.

Final checklist

  1. Keep the original file.
  2. Name the CSV with the account and month.
  3. Check totals against the statement.
  4. Delete spare copies from shared folders when done.
SPENDIXAI JOURNAL

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

Explore your reports