Sales CSV Analyzer
What do your sales files actually say?
Free. No sign-up.
Drop CSV files here, or .
A Square sales export, or any sheet saved as CSV with a date and an amount. Read in your browser; the files you choose are never uploaded.
- Sample: a cafe’s daily sales78 rows
- Sample: its supplier invoices35 rows
Showing a sample cafe until you add your own files.
Sales
$93,693
2026-06-02 to 2026-08-30
Average open day
$1,201
78 days with sales
Last 4 weeks
+5.8%
against the 4 weeks before
Best weekday
Saturday
by average sales
Average sales by weekday
Best days
- 2026-08-22$1,796
- 2026-07-25$1,715
- 2026-08-15$1,713
- 2026-06-27$1,634
- 2026-07-18$1,632
Quietest open days
- 2026-06-11$787
- 2026-06-24$798
- 2026-06-03$800
- 2026-06-16$811
- 2026-07-09$868
| Month | Sales | Change |
|---|---|---|
| June 2026 | $27,853 | — |
| July 2026 | $32,040 | +15% |
| August 2026 | $33,801 | +5.5% |
A month at either end of the file may be partial, so its change can look bigger than it was.
| Supplier | Invoiced | Share |
|---|---|---|
| Hill Street Dairy | $5,654 | 37.5% |
| Northside Coffee Roasters | $5,460 | 36.2% |
| Baker & Sons | $3,571 | 23.7% |
| Cup & Lid Supply | $380 | 2.5% |
| All suppliers | $15,065 | 100% |
| Month | Sales | Suppliers | Left |
|---|---|---|---|
| June 2026 | $27,853 | $4,615 | $23,238 |
| July 2026 | $32,040 | $5,787 | $26,253 |
| August 2026 | $33,801 | $4,663 | $29,138 |
Before wages, rent and everything else that is not a supplier invoice.
Everything you type stays in your browser. Nothing is uploaded or stored.
How this screen worksNext: Sales & costs, in your free account
This page does it once. Sales & costs in your free account gives you the same read of your sales with no file to export: the days you log are already in it, and it keeps going. Free forever, no credit card.
Supplier payments (on the paid plan)
How this works
Drop a sales or supplier CSV. See your best days, weekdays, month on month and supplier shares.
Most shops have months of sales sitting in exports nobody reads: a Square download, a spreadsheet, a folder of CSV files. Drop them here and the page answers the questions an owner actually asks. Which days are best? Is it going up? Which supplier takes the most? The files are read on your own device and never uploaded.
- It reads a Square sales export (it uses Net Sales), or any sheet saved as CSV with a date column and a sales, total or amount column in the first row.
- Several rows on one day, like a transactions export, are added up into that day.
- Best and quietest days are open days only: a day with no sales is treated as closed, not as your worst day.
- The last four weeks are compared with the four before, once the file covers eight weeks.
- Supplier shares need a file with a supplier column.
- Excel and Numbers files need saving as CSV first. Nothing is uploaded; the files are read in your browser.
Common questions
- How do I export my sales from Square?
- In the Square Dashboard, open Reports, then Sales summary or Transactions, choose the dates, and export as CSV. Drop that file here.
- Can it read an Excel file?
- Save it as CSV first. In Excel: File, Save As, then CSV. In Google Sheets: File, Download, CSV. The first row must name the columns.
- Are my figures uploaded?
- No. The files are read by your browser on your own device. Nothing is sent to us or stored.
- Why is a month showing a big drop?
- Usually because the file starts or ends partway through it. A month at either end of the file may be partial.
Short answer
What do your sales files actually say?
What should KANJIN do next?
Something this tool will not answer, or a tool that is not here. Tell us in your own words. No account needed.
Sending this suggestion leaves your browser. Nothing you typed into the calculator goes with it.
Used to reply to this and nothing else. No list, no newsletter.
Try next
Read more
Want this calculator on your own site? Get the embed code. It is free.