# Make a pivot table from a spreadsheet

> Pick the rows, the columns and the values. The table updates as you choose, and dates group by month or year.

Group a CSV or Excel table by rows and columns, then sum, count or average the values, with totals and percentages. Runs in your browser. Free.

- Tool: [Pivot table maker](https://fixmint.cc/pivot-table-maker)
- Category: [Spreadsheets & data](https://fixmint.cc/spreadsheets)
- Fixes: Totals by group, no Excel
- Runs in the browser: files and text stay on the device, no sign-up, free.

## How to make a pivot table from a spreadsheet

1. Drop a CSV or Excel file, or paste a table.
2. Pick the rows, the values and how to add them up, such as Sum of amount.
3. Read the totals, then download them as CSV or Excel, or copy them into Excel.

## Questions

### What does Count unique do?

It counts the different values in the value column for each group. Values that differ only in capital letters or extra spaces count as one.

### Why are some cells left out of a sum?

Sum, Average, Minimum and Maximum read numbers the way spreadsheets write them, such as 1,200 or 12%. Any other text is left out and counted in the note above the table.

### Is my table uploaded?

No. The table is read and summed by your browser. Nothing is sent anywhere.

## Related tools

- [Join spreadsheets](https://fixmint.cc/join-spreadsheets): VLOOKUP keeps breaking
- [Compare spreadsheets](https://fixmint.cc/compare-spreadsheets): Spot what changed between files
- [CSV column profiler](https://fixmint.cc/csv-column-profiler): Need stats for every column
- [CSV cleaner](https://fixmint.cc/csv-cleaner): Messy CSV with blanks and copies