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.
- Runs on your device
- No sign-up
- Works offline after a visit
0rows used
0row groups
0columns
0cells skipped
How to make a pivot table from a spreadsheet
- Drop a CSV or Excel file, or paste a table.
- Pick the rows, the values and how to add them up, such as Sum of amount.
- 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.
Reviews
No reviews yet. Be the first.