Documentation and sharing
Group table rows by one column and calculate a count, sum, average, minimum, or maximum.
Data & spreadsheets
Pivot table: group and aggregate
Group a table by column and calculate count, sum, average, minimum, or maximum. Processed locally in your browser without uploading the file.
- Export
Group table rows by one column and calculate a count, sum, average, minimum, or maximum.
Your files are processed locally in your browser and are never sent to our servers.
Drop your file here
Recommended size: up to 30 MB
Options
Processing…0 %
Was this tool useful?
How does this tool work?
Group table rows by one column and calculate a count, sum, average, minimum, or maximum. Processing runs locally in your browser and preserves a practical tabular structure for reuse.
The runtime reads the table locally and groups rows by the selected column. It then applies count, sum, average, minimum, or maximum to each group and keeps the result as an exportable table. This workflow also makes it easy to inspect the resulting structure before copying, downloading, or reusing the data in another tool.
How to use this tool
Import the table
Add an Excel, CSV, TSV, or JSON file from your device.
Configure the operation
Choose the transformation or aggregation settings.
Get the result
Preview and export the table as CSV or Excel.
Use cases
Data preparation
Transform a table before using it in another tool, database, or workflow.
Quick check
Preview the result before export to catch unexpected structure.
Tips and best practices
- Processing stays in your browser: the file is not uploaded to Bethemesh.
- Check data types and column names before reusing the result.
- For large files, work on a copy containing only the columns you need when possible.
Frequently asked questions
Which files are supported?
The tools accept CSV, TSV, XLSX, XLS, and JSON. For workbooks with several sheets, this version uses the first readable sheet.
Do my data leave my device?
No. File reading, transformation, and result generation run locally in the browser.
Are Excel formulas and styles preserved?
No. These tools operate on tabular data. Styles, macros, charts, and complex formulas are not part of the generated result.
Related tools
Keep going with these tools
Tools similar or complementary to this one.
Works well with
Analyze CSV columns and quickly get useful statistics about your data.
Data & spreadsheetsUse this tool
Remove duplicates, empty rows and unnecessary spaces.
Data & spreadsheetsUse this tool
Convert Excel, CSV, and other spreadsheet formats directly in your browser.
Data & spreadsheetsFeaturedUse this tool
Read next
GuideBest practicesBeginner
Transform a table: pivot, transpose and convert data
Learn when to pivot, transpose or convert a table to HTML, Markdown or SQL according to its structure and final use.
22 September 20262 min
GuideBest practicesBeginner
Data and tables: understanding CSV, Excel, JSON and dataset structure
Learn how tabular data is structured, how CSV, Excel, JSON and TSV differ, and how to choose the right format before cleaning, converting or automating a workflow.
29 August 20263 min
GuideBest practicesBeginner
How to clean and prepare a CSV or Excel file before using it
Learn a practical order for removing empty rows, trimming values, standardizing headers, checking identifiers and validating a CSV or Excel dataset.
29 August 20263 min
GuideBest practicesBeginner
Merge CSV or Excel files without misaligning columns
Learn how to align headers, verify schemas and combine several CSV or Excel files while avoiding duplicated or shifted columns.
29 August 20262 min