Japka
Tutorial

Import Transactions From a Spreadsheet (CSV) Into Japka

Move your old expense spreadsheet into Japka in one step. The exact CSV format, an example file, common errors, and how to export from Excel or Google Sheets.

Updated 4 min read

Short answer: save your spreadsheet as a CSV with the columns date, for and amount (plus optional time, description and location), then in Japka open Settings → Import CSV and pick the file. Negative amounts become expenses, positive amounts become income.

The format

The first line is a header with column names. Columns can be in any order, and upper or lower case both work:

Column Required Format Example
date Yes dd/mm/yyyy, dd-mm-yyyy or dd.mm.yyyy 14/10/2026
for Yes Who or what it was for Supermarket
amount Yes Number. Negative = expense, positive = income -245.90
time No HH:mm 18:30
description No Free text Weekly groceries
location No Free text, where it happened Tel Aviv

Then one transaction per line, separated by commas.

Example file

date,time,for,amount,description
01/10/2026,09:00,Salary,12000,October salary
02/10/2026,,Rent,-5000,
05/10/2026,18:30,Supermarket,-245.90,Weekly groceries
07/10/2026,13:15,Lunch,-58,"Sushi, with Dana"

If a value contains a comma, wrap it in double quotes, as in the last line. That is the standard CSV rule (RFC 4180, section 2).

Rules that cause most errors

Japka rejects the whole file if any of these is broken, and tells you the line:

  • Only these six columns. Any other column, such as category or balance, makes the header line invalid. Delete extra columns before exporting.
  • Every line has the same number of values as the header. Leave an optional value empty, but keep its comma, like the rent line above.
  • Use a dot for decimals: -245.90, not -245,90. A comma-separated thousands value like "12,000" works only inside quotes.
  • No zero amounts. Every line must be a real expense or income.
  • Real dates and times. 31/02/2026 or 25:00 fail.

A few things are more forgiving than you might expect:

  • Missing time is saved as 12:00.
  • Two-digit years work: 14/10/26 means 2026.
  • Day first, always. Japka reads every date as day/month/year, the Israeli way. A US-style month-first date (10/14/2026) fails, and 10/07/2026 is 10 July, not 7 October.
  • Blank lines are skipped.

Export from Excel or Google Sheets

  1. Make sure your sheet has a header row named date, for, amount (and optionally time, description, location). Delete every other column.
  2. Put expenses as negative numbers. If your sheet has separate income and expense columns, add a formula column like =income-expense, then paste it as values and delete the originals.
  3. Format the date column as dd/mm/yyyy.
  4. Export:
    • Excel: File → Save As → CSV UTF-8 (Comma delimited).
    • Google Sheets: File → Download → Comma-separated values (.csv).
  5. Send the file to your phone (email, Drive, iCloud, Files).

UTF-8 keeps Hebrew text intact.

Import into Japka

  1. Open Settings → Import CSV.
  2. Read the format reminder and choose your file.
  3. Japka checks every line first. If all lines are valid, it adds them and shows “Import in progress (N transactions)”.

If any line is invalid, you’ll see “Invalid CSV at line N. Nothing was imported.” Fix that line and import again. Nothing is half-imported. Line 1 means the header: check the column names.

CSV import is free.

Export from Japka

Open Settings → Export CSV and choose where to save the file. It uses the same columns, so you can open it in Excel or Google Sheets, or import it back into Japka. Export is free too.

After importing

  • Open the Feed to check a few transactions.
  • Imported transactions arrive in the Other category. Edit the important ones to set a real category so the Category breakdown in Summary splits your spending correctly.
  • Paid for something in installments? If your sheet lists one payment per month, keep it that way: that already matches how Japka counts them. For new purchases, see how to budget installments.
  • Open the Summary and use the arrows on the Last Year card to step through your history. With past months imported, the trend means something from day one.

New to Japka? Getting started: your first week covers the rest of the app. To turn your history into a plan, try the 50/30/20 budget rule.

Summary

Bringing your history into Japka takes a few minutes: keep only the six columns, make expenses negative, use a dot for decimals, export as CSV UTF-8 and import from Settings. Japka validates the whole file first, so your data stays clean.

FAQ

What CSV format does Japka accept?

The first line is a header naming the columns, in any order. Required columns are date (dd/mm/yyyy), for and amount. Optional columns are time (HH:mm), description and location. No other columns are allowed. Negative amounts are expenses, positive amounts are income.

What happens if a row in my CSV has an error?

Japka tells you the line number of the first problem and imports nothing, so you never end up with a half-imported file. Fix the line and try again.

Can I import a CSV exported from my bank or credit card?

Yes, after a small cleanup. Bank exports usually have extra columns and their own header names. Keep only the date, description and amount columns, rename the headers to date, for and amount, make sure expenses are negative, and save as CSV UTF-8.

Is CSV import free?

Yes. CSV import and export are free for everyone.