Free tool · Sales

Sales analyzer

Upload the Excel or CSV file with your sales and see your average order value, top products and customers, what's declining, who stopped buying and who you could sell more to. Free, no sign-up, and your file never leaves your browser.

  • Free
  • No sign-up
  • Works on your phone
  • Your file stays in your browser

Upload your sales file

You need a date column and an amount column (or price and quantity). With product, customer and order number you get the full report.

Paste from Excel or Google Sheets

Your file never leaves your browser. It's read on your device, never uploaded to any server, and cleared when you close or reload the page.

A sales analyzer turns the spreadsheet where you log your sales into answers: how much you sold, how many orders that was, how much each customer spends per order, which products carry your business and which ones are slipping. No formulas or pivot tables: the report is built right in your browser.

What each metric means

Say one week of your file has five lines: order 1 has rice for $200 and oil for $100 from Rosa's Store; order 2 is rice for $300 from Sunrise Mart; order 3 is flour for $250 from Main Street Bakery; and order 4 is rice for $150 from Rosa's Store again.

  • Total sales is the sum of the amount column: $1,000.
  • Orders are the distinct order numbers. Order 1 has two lines but is a single order, so there are 4.
  • Average order value = total sales ÷ orders = $1,000 ÷ 4 = $250.
  • Product share = product sales ÷ total sales. Rice sold $650, or 65%.
  • Concentration is how much of your sales comes from your top customers. Rosa's Store bought $450 of $1,000, or 45%.
  • Cross-selling: of the customers who buy A, how many also buy B. Two customers bought rice and one of them also bought oil, so P(oil | rice) = 1 ÷ 2 = 50%. Sunrise Mart is who you offer the oil to.

Declining products and lapsed customers

To spot a decline, the tool compares a recent period with an earlier one of the same length. If a product sold $3,000 from April to June and $1,800 from July to September, the drop is ($3,000 − $1,800) ÷ $3,000 = 40%, and you sold $1,200 less. Only products that made up at least 2% of sales and dropped 25% or more are listed. A customer has stopped buying when they bought two or more times and their last purchase is more than twice their usual gap and more than 30 days before the last date in the file.

How to prepare your file

Use one row per sale or invoice line, one header row and real dates. Amounts like $1,234.56 or 1.234,56 both work: the decimal separator is decided by looking at the whole column. Save old .xls files as .xlsx or .csv first. When you'd rather not export a file every week, Zavora's order automation logs each WhatsApp order for you. See pricing or browse more free tools.

FAQ

Questions businesses ask before starting

Is my file uploaded to a server?

No. The file is read by your browser on your phone or computer, and neither your sales nor your customer or product names are sent to Zavora or anyone else. It isn't stored either: closing or reloading the page clears it. The only things your browser remembers are the currency and which column was which, so it doesn't ask again for the same file.

Which columns does my file need?

At least the date and the amount of each sale (or the unit price and quantity). Add a product column to see best sellers and declining products, a customer column for top customers, lapsed customers and cross-selling, and an order or invoice number for an exact average order value. Common headers in English, Spanish and Portuguese are recognized, such as Date, Customer, Amount, Qty or Invoice #.

Why do my dates look wrong?

A date like 03/04/2026 can be March 4 or April 3. The tool checks the whole column: if any first number is above 12, it's day/month; if the second one is, it's month/day. If none is above 12, there's no way to know, so on this page it reads them as month/day and warns you. To avoid any doubt, save dates as year-month-day (2026-04-03).

How are returns handled?

Rows with a negative amount, like -250 or (250), are subtracted from total sales, and the report says how many there were and for how much. An order with only returns doesn't count as an order, so your average order value isn't pulled down by mistake. Product and customer shares are measured on sales before returns, so no percentage goes over 100%.