How to use
- sales_lines.xlsxdate, region, sales
Add the sales lines
- Month × region sumdates grouped by month
Choose rows, columns, value
- sales_lines_summary.xlsxnumbers kept as numbers
Save the summary table
Choose an Excel (.xlsx) or CSV file with “Choose file”. “Try with sample” loads a sales line table built on your device.
Under “Row fields”, choose the columns that become rows. Date columns can be grouped by year, quarter, month, week or day.
Under “Column field”, optionally choose the column whose values become column headings.
Choose the “Value column” and the “Aggregate” (sum, count, average, minimum, maximum or distinct count).
If needed, set a filter, a row order or the top N rows, and check the summary table and the notes (for example, cells that are not numbers). Download as Excel (.xlsx) or CSV.
What it does
Summary table from row and column fields
Choose one or more row fields and an optional column field. Each combination of values becomes one cell. Without a column field, the aggregate is shown in one column.
Dates grouped by year, quarter, month, week or day
Date columns can be grouped by year, quarter, month, week (starting Monday) or day. Dates are read as calendar dates, so the result does not depend on the device’s time zone.
Six aggregates
Sum, count, average, minimum, maximum and distinct count. Sum and average use numbers only; cells that are not numbers are left out and counted.
Row and column totals, and sorting
Add a row total (last column) and a column total (last row). Rows can be sorted by label, or by total from largest or smallest.
Filter and top N rows
Keep only chosen values from a column’s list. Top N rows (5, 10, 20, 50 or 100) are chosen by the largest row total.
Use cases
- Turn sales lines into a table of totals by month and by region
- Summarise survey answers into counts or shares for each item
- Show the number of orders and the average amount for each sales rep
- Check the largest and smallest stock or quantity for each product in one list
- Try out a summary layout before building a pivot table in Excel
Supported formats
Input
Output
Capability matrix
| Feature | Support | Notes |
|---|---|---|
| Cross-tab by row and column fields | Supported | — |
| Sum, count, average, minimum, maximum, distinct count | Supported | — |
| Date groups by year, quarter, month, week and day | Supported | — |
| Row and column totals, sorting, top N rows, filter by value list | Supported | — |
| Several value columns at once | Not supported | One value column per run |
| Median and quartiles | Not supported | Use Excel functions or statistics software |
| Drag-and-drop interactive pivot table | Not supported | Change the settings and summarise again |
| Charts | Not supported | Save the table and make the chart in Excel |
| Formulas, formatting, merged cells | Not supported | Values only (formulas become their results) |
| Legacy Excel (.xls) and several sheets at once | Not supported | Re-save as .xlsx and choose one sheet per run |
Limits & notes
- Reads up to 100 MB and 3 million cells per file. Up to 1 million data rows; the summary table is limited to 1 million cells and Excel’s grid. Beyond that, the summary stops with an error.
- Sums are added in exact decimal arithmetic. Averages divide the sum in floating point, as Excel does, and are rounded to 10 decimal places. A sum too large for Excel to hold exactly is saved as text.
- The filter list shows the first 200 distinct values. Top N rows are ranked by row total and then shown in the chosen order. Totals include rows that are not shown.
- Works on a smartphone (390 px wide), but choosing fields takes many steps, so use a PC for large tables.
Privacy & safety
Reading, summarising and building the download all happen in your browser. File contents are never sent to or stored on a server.
FAQ
How do I make a pivot table without Excel?
How do I get monthly totals of sales?
Does it work with CSV files?
What happens to cells that are not numbers?
How do I swap rows and columns?
Are my files uploaded?
Related tools
Excel Reshape
Swap the rows and columns of an Excel or CSV table (transpose), turn a wide table with a column per month into a long one (unpivot), or pivot long data back into a wide table. The result is built in your browser and saved as .xlsx or CSV.
Excel Cleanup
Tick what to fix and clean up spaces, character widths, dates and numbers across a whole Excel or CSV file at once. Changed cells are highlighted, and you can save as Excel or CSV.
CSV Studio
Open CSV files that are slow or garbled in Excel and view, search and edit them right away in your browser. Combine, split and save as CSV (UTF-8 with BOM, Shift_JIS), Excel or JSON on one screen.
Chart Maker
Open a CSV or Excel file, or paste a table copied from a spreadsheet, and make bar, line, area, pie, scatter or combo charts. Save PNG (with scale) or SVG. Your table is never sent off your device.
CSV Encoding Fix
Convert CSV files that show garbled text in Excel to UTF-8 with BOM or Shift_JIS, with automatic encoding detection. Mojibake that was already saved, such as “日本語”, can usually be restored too.
CSV, JSON, XML & Excel Converter
Convert between CSV, TSV, JSON, JSON Lines, XML and Excel (.xlsx) by pasting or opening a file. Values stay as text by default, so zero-padded postal codes, phone numbers and long IDs are never changed. Everything runs in your browser; your data is not uploaded.
Last updated: