WorkToolsetTOOLS FOR A SMARTER WORKDAY
Pricing ✦ AI
✦ AI Pricing
FREN
Menu
Navigate
▦Tools211 tools organized by family ▣Studios 7Go further without re-uploading your files ✦WorkToolset AILocal, sourced, action-oriented AI ⚡WorkflowsAutomate recurring tasks ▣ProjectsOrganize and resume your work ◎SolutionsGuided journeys by business need ◫WorkspaceYour activity and shortcuts
Site language
FRFrançaisSwitch to French ENEnglishCurrent language
◇PricingCompare Free and Pro
Spreadsheets & data · ONLINE TOOL

CSV pivot table

Explore a pivot with accurate totals, group sorting, a comparison chart and source-row drilldown before export.

Local processingNo account required
USE CASES

When to use CSV pivot table?

Build and explore a CSV/TSV pivot with source-based totals, group sorting, a comparison chart and source-row drilldown.

  • Cross team and month with explicit dimension limits
  • See ignored non-numeric values before summing or averaging
  • Compare groups visually, click a result and export its original source rows
CONCRETE EXAMPLE

Sales by team and month

BEFORE
Detailed CSV · team · month · amount with some anomalies
→
AFTER
Preflight · weighted totals · comparison chart · source-row drilldown · detailed or filtered CSV
PRIVACY

Your data stays in the browser

Processed content is not uploaded to WorkToolset. Required libraries may be loaded by the site, but the file stays in the browser.

GOOD TO KNOW

Limitations to know

  • Row groups (500), column groups (100) and included source rows (100,000) are capped by the current engine.
  • Rows missing the row-axis category are excluded; non-numeric values are ignored in numeric aggregations.
  • The existing engine treats blank numeric cells as zero, including in averages.
HOW IT WORKS

A straightforward workflow.

  1. 1Prepare the required input and choose useful options.
  2. 2Review previews, warnings and limitations before export.
  3. 3Download a new copy or report: the original stays unchanged.
PRIVACY

Frequently asked questions

Are my files uploaded to WorkToolset?

No. This tool runs locally in your browser.

Is my original file modified?

No. WorkToolset creates a new copy or export.

Do I need an account?

No for this free tool. Accounts are mainly used for favorites, presets and future workflows.

RELATED TOOLS

Continue the same workflow

ΣSummarize a CSVPrepare and review a category summary with column profiles, ignored-value warnings, search/sort and controlled CSV export.→CHARTCSV chart makerGroup and compare values by category, sort groups, inspect source rows and export charts, aggregated data and original records locally.→✓Data Quality & ImportAudit, clean and prepare CSV/Excel data in one workspace. Free does the work; Pro adds deeper scoring, evidence and professional reporting.→SQLLocal SQL LabBuild SQL visually, filter, group, sort, revisit session queries and export checked results as CSV or Parquet.→
WORKTOOLSET ACCOUNT

Sign in

Access your favorites and presets across devices.

or with email

Your documents are not stored in your account.

 WORKTOOLSET PRO

When work needs verification, explanation or evidence, Pro takes over.

AUDITAudit & verificationScores · priorities · recommendations
≈Reconciliation & local AIAmbiguity · exceptions · sources
SAFEPrivacy & QAPreflight · accessibility · sharing
PDFEvidence & reportsSHA-256 · manifest · CSV · JSON · PDF
Scale afterwards, when neededAI Workbench with local content analysis, universal production queue, specialized batch processing, recipes, workflows, Studio sessions and projects remain included in Pro.
100 presets · 50 projects · 20 templates · 500 favorites

Payments, taxes and invoices are managed by Paddle. Your documents are never part of payment data.
⌕Esc
Search by name, task, or format. Simple typos are tolerated; Ctrl+K also finds Studios, workflows, guides, and business solutions.