About UnpivotTool

UnpivotTool was built by Joe Lee, a Data Analyst who saw a recurring problem: analysts and office workers spend too much time manually reshaping spreadsheets. Whether it is converting a wide report into a long format for analysis, expanding merged cells that break formulas, or pivoting summary data back into a readable table — these tasks should take seconds, not hours.

Privacy-First Philosophy

Every tool on UnpivotTool processes your data entirely in your browser. No files are uploaded to any server. Your data never leaves your device. This was a deliberate design choice from day one — your spreadsheets may contain sensitive business information, personal data, or proprietary metrics. We believe you should not have to trust a third-party server just to reshape a table.

What the Tools Do

• Unpivot — Converts wide-format data into long-format rows, making it ready for pivot tables, charting, and statistical analysis.
• Unmerge & Fill — Detects and expands merged cells in Excel exports, filling down the values so your data is structurally clean and formula-ready.
• Pivot — Transforms long-format data back into a wide summary table, useful for building reports and dashboards.

Who Is This For?

UnpivotTool is designed for data analysts, accountants, researchers, and anyone who works with spreadsheets on a regular basis. If you have ever copied data from a PDF report, downloaded a pivot-table output, or received a spreadsheet full of merged cells — these tools are for you.

Get in Touch

Have feedback, found a bug, or want to suggest a new tool? Visit the contact page to reach out. All input is welcome and helps improve the tools for everyone.

Joe Lee — Data Analyst