A long table hides its story. Try it free below — no sign-up, and it runs entirely in your browser.
Versión en español: Crear Tabla Dinámica Gratis – Agrupa y Suma tus Datos CSV
How to use it
A long table hides its story. Hundreds of sales rows tell you little until you group them by city, product or month and add the numbers up. This free pivot table maker does exactly that: it groups your CSV rows and returns a short summary table with sums, counts or averages.
- Paste your CSV into the box, or upload a CSV file.
- Choose the column to group by, for example city or product.
- Choose the number column you want to summarise.
- Pick Sum, Count or Average as the calculation.
- Press Generate to see the summary, then download it as CSV.
What it can do
- Groups rows by any column in your file.
- Sums numbers, counts rows, or averages values per group.
- Works with pasted data or an uploaded CSV file.
- Downloads the summary as a fresh CSV for reports and charts.
- Runs fully in your browser, with no sign-up and no upload.
Example
A market seller has a year of sales rows with city and amount columns. She pastes the file, groups by city, and sums the amount. In seconds she sees which city earned most, instead of scrolling through a thousand rows or learning spreadsheet formulas.
Tips for a better result
- Make sure the first row holds column names, so the tool can offer them as fields.
- Check that the number column really holds numbers, not text like “10 euros”.
- Use Count when you want to know how many orders each group had.
- Use Average to compare typical order sizes between groups.
Who it is for
It suits small business owners, students, teachers and office workers who need quick answers from a table. It is a gentle first step into data analysis, with no spreadsheet skills required.
Frequently asked questions
What is a pivot table?
It is a summary that groups rows by a shared value and calculates a number for each group, such as a total or an average.
Can I group by more than one column?
This maker groups by one column at a time. For two levels, clean and filter the file first, then pivot each part.
Is my data sent anywhere?
No. The grouping happens in your browser, and the file never leaves your device.
Why use a browser tool?
There is nothing to install, update or learn before you start. The Pivot Table Maker opens on a phone, a tablet or a computer, and it works the same everywhere because the whole tool lives on this page. You do not need an account, you do not hand over an email address, and you do not wait for a download. That matters when you only need the tool once, or when you are on a shared computer. It also means the version you see is always the latest one, with no old copy lingering on your device after you finish.
Ideas to try next
Once the basics feel easy, try the tool with a real task instead of the sample data. Use your own names, numbers or files, and compare the result with what you expected. If something looks wrong, check the inputs first, because most surprises come from a typo or a wrong unit, not from the tool. Then try a second version with different settings and keep the one you like best. That habit, test, compare, keep, turns a quick tool into a reliable part of your routine.
Paste a table, pick a group and a number, and read the summary. The answer hiding in your rows is usually one pivot away.
Your data stays private: the tool runs entirely in your browser, with no account and nothing uploaded.
More free tools
- Avatar Builder Canvas – Build a Cartoon Avatar Free
- Business Card Designer – Print-Ready Cards Free
- Mandala Pattern Drawer – Symmetrical Art in One Stroke