Guides · Spendee

Spendee import: CSV and Excel files in the web app, step by step

Updated November 19, 2026 · 5 min read · By the Utilly team

Spendee imports transactions from CSV and Excel files, but only in its web app, only into cash wallets, and with no duplicate check. It doesn't list PDF as a file type, so bank statements you only have as PDFs need converting first. Here's what the file needs, the import steps, the catches Spendee's help warns about, and free CSV test files with known totals so you can try an import before you touch real data.

Short answer: sign in at app.spendee.com (import isn't in the mobile app), click Import, choose a CSV, .xls or .xlsx file, pick the cash wallet to import into, match your columns (date, category name, amount, note), check the preview and confirm. Every row needs a date and an amount; include a category name too. Import only new or missing transactions, because Spendee won't spot ones that are already there. Free test files: a checking CSV (31 fictional transactions) and a credit card CSV (21).

See the statement behind the test files

Open Utilly's fictional September 2026 checking statement: every line, the balance check from 12,418.36 to 13,440.52, and the CSV download. Free, because the data is made up. The checking test file on this page holds those same 31 lines, so you know exactly what an import should bring in.

Checking CSVCard CSV

1. The test files

These files hold Utilly's fictional September 2026 checking and credit card statements as CSVs laid out for Spendee's import, so you can try it on a spare cash wallet and compare the result with known totals. No sign-up.

FileWhat's in itKnown totals
Checking CSVA Date, Category, Amount, Note header row, then the 31 lines of the fictional checking statement20 payments 28,575.27; 11 deposits 29,597.43; net +1,022.16
Credit card CSVThe same header, then the 21 lines of the matching fictional card statement, by date19 charges 1,939.94; 2 credits 1,542.18; 397.76 more owed

The rows come from Utilly's fictional sample statements (explained on sample bank statement PDF), read by the same engine Utilly's converters use. Each CSV is comma-delimited with a header row and four columns: the date written year first (2026-09-01), a plain category name (Utilly's own simple labels such as Software, Travel or Income; Spendee lets you create them or file them under Other), the amount as one signed number with a period decimal (money out is negative), and the statement description as the note, with commas and quote marks taken out.

Date,Category,Amount,Note
2026-09-01,Payroll,-6420.18,ACH DEBIT GUSTO PAYROLL 0912
2026-09-01,Income,3184.27,STRIPE TRANSFER ST-K2M8Q4
2026-09-02,Checks,-1850.00,CHECK 2041

2. What Spendee's import accepts

RuleSpendee's help saysWhat it means for you
Where"You can import transactions from a file in the Spendee web app at app.spendee.com. Import is not available in the mobile app."Use a computer browser, signed in with the same account as your phone
File types"Use a CSV or Excel file (.xls or .xlsx)." The older help page adds: "The maximum file size is 10MB."No PDF, OFX or QIF on the list. Convert those first (section 4)
Required data"Each transaction needs at least a date and an amount. Add a category name to keep your categories." The older help page lists "the date format, date, category name and amount" as the minimumInclude a category column even if it's just Other; the test files have one
Wallet"You can import only into cash wallets, not into connected bank accounts."Import into a cash wallet. A bank-connected wallet won't take a file
CurrencySpendee's blog: "it is currently not possible to import files containing transactions with different currencies."One currency per file
Duplicates"Import only new or missing transactions, so you don't create duplicates."Spendee doesn't check for you. Trim the file to the dates you don't already have
Transfers"Transfers come in as ordinary transactions. Change them to transfers by hand after the import."The test checking file has one (Online transfer to savings) and an Amex card payment you may want to turn into transfers

3. Importing a file, step by step

Spendee's current help page gives four steps:

  1. "Sign in at app.spendee.com."
  2. "Click Import and choose your file."
  3. "Pick the cash wallet you want to import into."
  4. "Check the preview and confirm the import."

Spendee's 2018 blog post on the import describes the screens in between. You choose the wallet and currency, then decide what to do with categories Spendee doesn't have yet: "You can either create new categories out of them or you can choose for them to be categorized as Other." Then you name each column. The post lists the choices as "category name, amount, amount (expense), amount (income), type of category (expense, income), date, note", or not importing the column. For the test files that means Date as date, Category as category name, Amount as amount and Note as note. Then click Import data. The screens may have changed since 2018, so treat the names as a guide.

Spendee's pages don't say how a negative number in a single amount column is read. Import the test file into a spare cash wallet first and check that the 20 payments come in as expenses (section 5). If they don't, split the amounts into two columns and use the amount (expense) and amount (income) choices instead.

After the import, you can rename new categories and change their icon or colour in the wallet settings, and fix other details with bulk editing, which Spendee lists as a web app feature.

4. PDF bank statements

Spendee's import takes CSV and Excel files, so months you only have as PDF statements need converting first:

  1. Convert each statement with Utilly's bank statement PDF to CSV converter (card statements: credit card statement to CSV, or PDF to Excel if you'd rather tidy it in a spreadsheet). The free preview shows every line and whether the statement balances before you download.
  2. The CSV has Date, Description, Amount and Balance columns with year-first dates. Add a Category column (Other is fine to start), and either delete Balance or don't import it.
  3. Remove any dates already in the Spendee wallet, then import into a cash wallet, mapping Description to note.

5. Checking the import against known totals

Import a test file into a new cash wallet you don't rely on, then compare:

CheckChecking fileCredit card fileIf it's wrong
Transactions3121Fewer: a row didn't parse, or the header row wasn't recognised
Expenses28,575.27 (20)1,939.94 (19)All as income: map amount (expense) and amount (income) columns instead
Income29,597.43 (11)1,542.18 (2)Same as above
Change in balance+1,022.16−397.76A different figure means rows are missing or a sign was flipped
DatesSept 1–30, 2026Sept 1–30, 2026Day and month swapped: check the date format chosen during import

The data is fictional (Example Community Bank and Sample Customer LLC don't exist; both statements say SAMPLE STATEMENT, FICTIONAL DATA FOR DEMONSTRATION ONLY). Delete the test wallet afterwards, and replace every row before using a template for real.

6. Problems and fixes

SymptomLikely cause and fix, from Spendee's help
No Import buttonYou're in the mobile app. Import is only in the web app at app.spendee.com
Can't choose your walletIt's connected to a bank. Import only goes into cash wallets
File rejectedNot a CSV, .xls or .xlsx file, or over the 10MB limit in the older help page. Split large files by month
Transactions doubledSpendee doesn't recognise transactions already entered. Delete the extras and import only new dates next time
Transfers counted as spendingTransfers import as ordinary transactions; change them to transfers by hand
Mixed currenciesA file can hold only one currency; split it per currency and wallet

Comparing apps? Wallet by BudgetBakers imports CSV, Excel and OFX files into General accounts from its Web App, PocketSmith also takes OFX and QIF, Monarch Money and YNAB import CSVs in their own layouts, and Firefly III and Actual Budget map a signed Amount column.

Get PDF statements into Spendee

PDF statements, downloaded or scanned, get a free preview with the balance check, no sign-up. Download a clean CSV with year-first dates and one signed Amount column, add a Category column, and import it into a cash wallet. Files are processed in memory and not stored.

Utilly isn't affiliated with Spendee. The steps and quotes above are from Spendee's own help pages and blog, checked November 19, 2026; the test files weren't imported into a live Spendee account, and screens may differ. Sources: How to import data (Spendee help, updated November 9, 2026), Data Import (Spendee Help Center, 2021), Spendee Web App (2022), Import your transactions in 1 minute (Spendee blog, 2018).

FAQ

Can I import transactions into Spendee?

Yes, from a CSV or Excel file (.xls or .xlsx) in the Spendee web app at app.spendee.com. Spendee's help says import is not available in the mobile app.

What columns does a Spendee import file need?

Spendee's current help page says each transaction needs at least a date and an amount, plus a category name if you want to keep your categories. Its older help page lists date, category name and amount as required, so include a category column to be safe.

Why can't I import into my Spendee wallet?

Spendee imports only into cash wallets, not into wallets connected to a bank. Pick or create a cash wallet in the import dialog.

Does Spendee skip duplicate transactions on import?

No. Spendee's help says the import won't recognize transactions already in the wallet, so import only new or missing transactions.

Can Spendee import a PDF bank statement?

Spendee's help lists CSV and Excel files only, not PDF. Convert the PDF statement to CSV first, add a category column, then import it in the web app.

Related tools

  • Bank reconciliation checker: compare a bank statement to your books and list missing, duplicate and mismatched transactions.
  • Receipt to CSV: turn PDF or photo receipts and invoices into CSV, Excel, or QuickBooks and Xero bill imports.