Getting started

Moneywiz not working? Fix a CSV import that fails or misreads rows

Moneywiz or any budget app failing to import a CSV? Check date formats, amount columns, commas and encoding, with a sample file and fixes.

Editorial illustration for Moneywiz not working? Fix a CSV import that fails or misreads rows

When a budget app will not import a CSV, or imports it with scrambled dates and amounts, the file is nearly always the issue, not the app. Check four things in a spreadsheet before retrying: the date format, whether amounts sit in one column or two, stray commas inside numbers, and a clean header row. Fixing those usually makes the import go through.

Start by opening the CSV in a spreadsheet

A CSV is plain text with values separated by commas. Open it in Excel or Google Sheets and look at it as a table. If everything lands in column A, the file uses a different separator such as a semicolon, and you need to split it with Data, Text to Columns.

The four checks

  1. Dates: choose one format and stick to it. 05/11/2026 can be 5 November or 11 May depending on the app, so convert to 2026-11-05 if the app accepts it.
  2. Amounts: some statements show debits and credits in two columns, others in one column with minus signs. Match what the app expects.
  3. Commas in numbers: 1,25,000 stored as text with commas can break a numeric column. Remove thousand separators before import.
  4. Header row: one clear row with simple names such as Date, Description, Amount, and no merged cells above it.

A sample of what a clean file looks like

DateDescriptionAmount
2026-11-02Grocery store-1450.00
2026-11-03Salary58000.00
2026-11-04Metro card top-up-500.00
2026-11-05Electricity bill-1820.00

Check the arithmetic before importing: -1,450 + 58,000 - 500 - 1,820 = ₹54,230. If your spreadsheet total, =SUM(C2:C5), matches that figure, the numbers read correctly. If it returns 0 or a lower amount, some cells are text.

Why are my dates wrong after import?

Spreadsheets may swap day and month on opening. To force a clean text date, use =TEXT(A2,"yyyy-mm-dd") in a spare column, fill down, then copy and paste as values. Check one date you know, such as the salary credit, to confirm the day and month are not reversed.

What if the amount column has text like Dr and Cr?

Some statements write amounts as 1,450.00 Dr. Use =IF(RIGHT(C2,2)="Dr",-1,1)*VALUE(SUBSTITUTE(SUBSTITUTE(LEFT(C2,LEN(C2)-3),",","")," ","")) to turn it into a signed number, then check a few rows against the statement. Formats vary between banks, so look at your own file before adapting it.

When the file comes from a PDF

A PDF converted to CSV by a tool may merge columns or split descriptions across rows. Read the result before trusting it. SpendixAI accepts statements as PDF, CSV or Excel and shows the rows for review before saving, though we cannot promise every layout parses perfectly, so check the preview against your statement.

Encoding is the quiet cause of odd characters. If the rupee sign or a name with an accent shows as strange symbols, save the file again as CSV with UTF-8 encoding from your spreadsheet, which is a menu option in the Save As dialog of both Excel and Google Sheets' download options. Plain ASCII descriptions import more reliably than clever ones, so removing symbols from the description column is a cheap fix.

Another frequent problem is duplicate imports. If you import a statement for 1 to 30 November and later one for 15 November to 15 December, the overlap lands twice. Before importing, check the last date already in your records, and start the new file the day after. If the overlap has happened, sort by date and amount and remove the second copy of each pair.

Checklist

  • One date format, text or real dates, checked on a known row.
  • Amounts in the layout the app expects.
  • No thousand separators in number cells.
  • Five-row test import passed before the full file.
SPENDIXAI JOURNAL

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

Explore your reports