← All text tools

Pivot table maker

Summarise a CSV with sums, counts and averages in a pivot table.

  • Free
  • No sign-up
  • Works on any device

About Pivot table maker

Load a CSV, choose a field for rows, optionally one for columns, and summarise a value with sum, count or average, just like an Excel pivot table. It suits quick questions such as sales by region or tickets by month, without opening a spreadsheet.

How to use Pivot table maker

  1. Open or paste your CSV data.
  2. Choose the rows, columns and the value to summarise.
  3. Pick sum, count or average and read the pivot table.

Why use this tool?

Also known as

Frequently asked questions

What is a pivot table?

A summary that groups rows by one or two fields and calculates totals, counts or averages for each group, without changing the source data.

When should I use count instead of sum?

Use count to see how many records fall in each group, and sum to total a number such as sales. Average suits values like scores or prices.

Why are my totals wrong?

Numbers stored as text will not add up. Clean the column first, for example with the CSV cleaner, then rebuild the pivot.

Is Pivot table maker free?

Yes. Pivot table maker on Toolipedia is free to use, with no sign-up and no watermark.

Is it safe to use?

Yes. Everything is worked out in your browser, and nothing you enter is sent to our server.

Does it work on my phone?

Yes. It works in any modern browser on Android and iPhone, as well as on tablets and computers. There's nothing to install.

Do I need an account?

No. Just open the page and use the tool. There's no sign-up and no email needed.

Related tools