Data cleaning, privacy vault, code generation, formula analysis, and sheet architecture. Column maps, real error strings, and cookbook examples for every workflow — every guide runs the same browser-native engine. Zero uploads.
References with full column maps, real error strings, and cookbook examples.
Strip leading and trailing whitespace from every cell of an .xlsx, .xls, .ods, or .csv file in your browser. Zero options, zero upload, zero install — drop the file and download a clean copy. Removes spaces, tabs, newlines, and edge non-breaking spaces (CHAR 160) at the start and end of each cell.
Open referenceRemove duplicate rows from an Excel sheet by picking one key column — Email, SKU, ID, or phone. The first matching row is kept, blank keys are preserved, everything runs in your browser.
Open referenceConvert Excel column values to UPPERCASE, lowercase, Title Case, or Sentence case without UPPER/LOWER/PROPER helper-column formulas. The Excel Case Normalizer hands off to the browser-local CSV Case Converter (four modes, per-column scope, headers untouched). Save your sheet as CSV first; nothing uploads.
Open referenceConvert mixed Excel date formats (MM/DD/YYYY, DD-Mon-YY, text dates) to ISO 8601 yyyy-MM-dd in one pass. Browser-only, zero upload, Pro tier.
Open referenceMultiply or divide Excel column values by a conversion factor to switch units — kg→lbs, km→miles, m→ft, and any custom factor — in one pass. Browser-local, Pro tier, outputs a fresh .xlsx of converted values.
Open referenceBlank the Company and Manager fields in docProps/app.xml and the creator, last-modified-by, description, subject, keywords and category fields in docProps/core.xml of an Excel workbook — and reset the Application/AppVersion fingerprint to a generic ExcelJS value. Browser-only via ExcelJS, no upload, Pro tier.
Open referenceDetect and delete approximate duplicate rows in Excel using Levenshtein similarity scoring. Set your own threshold. Pro tier. Browser-local.
Excel's Remove Duplicates only catches byte-identical rows — it leaves 'Acme Corp' next to 'Acme Corporation'. Fuzzy Dedup scores one column with normalized Levenshtein similarity (0–100%), keeps the first row of each cluster, and downloads a deduplicated .xlsx plus an on-screen report of every row it removed and the score it matched at. Pro tier, 100% in-browser.
ReadSalesforce, HubSpot, and Zoho exports list the same person as 'John Smith' and 'Jon Smith'. Fuzzy Dedup scores one name column with normalized Levenshtein similarity, keeps the first record of each cluster, and downloads a clean .xlsx plus a report of every contact it merged. Pro tier, browser-local.
ReadExcel's Remove Duplicates deletes only byte-identical rows. Fuzzy Dedup scores one column with normalized Levenshtein similarity (case-/whitespace-insensitive) and removes near-matches above your threshold. This guide compares both, when to use each, and how to combine them.
ReadProcurement data fragments spend across 'Microsoft Corp', 'Microsoft Corporation', and 'Microsoft, Inc.'. Fuzzy Dedup scores one vendor-name column with normalized Levenshtein similarity, collapses near-duplicates above your threshold, and downloads a clean .xlsx plus a report of every consolidation. Pro tier, browser-local.
ReadThe same subscriber sneaks in twice as 'Rob Johnson' and 'Robert Johnson' under different emails. Run exact email dedup first, then Fuzzy Dedup on the name column to surface name-based duplicates before importing to Mailchimp, Klaviyo, or HubSpot. Pro tier, browser-local.
ReadDetect and convert mixed date formats (MM/DD/YYYY, DD-Mon-YY, natural language) to ISO-8601 YYYY-MM-DD in Excel. Browser-only.
Convert mixed Excel date formats (MM/DD/YYYY, DD-Mon-YY, text dates) to ISO 8601 yyyy-MM-dd in one pass. Browser-only, zero upload, Pro tier.
ReadStandardize UK (DD/MM/YYYY) and US (MM/DD/YYYY) dates from Excel CRM exports to ISO 8601. Understand exactly how the parser disambiguates. Browser-only.
ReadDates sorting alphabetically instead of chronologically? They're text. Convert them to ISO 8601 so they sort right — in the browser, Pro tier.
ReadBulk-convert columns of text dates to one consistent format without DATEVALUE() formulas or helper columns. Handles formats DATEVALUE rejects. Pro tier.
ReadConvert mixed Excel date formats to ISO 8601 before pandas.to_datetime(), avoiding ParserError and NaT in your pipeline. Browser-only, Pro tier.
ReadMultiply or divide numeric columns by a factor to convert units (cents→dollars, kg→lbs, metres→feet). Browser-local.
Multiply or divide Excel column values by a conversion factor to switch units — kg→lbs, km→miles, m→ft, and any custom factor — in one pass. Browser-local, Pro tier, outputs a fresh .xlsx of converted values.
ReadMultiply an Excel product-weight column from kg to lbs (×2.20462) for Shopify, Amazon, and WooCommerce feeds — in one pass, browser-local, Pro tier. Keep the original kg column alongside for audit.
ReadMultiply or divide Excel columns for scientific SI conversions — nm→mm, µg→mg, mM→M — with any custom factor, full 10-decimal precision, scientific-notation support. Browser-local, Pro tier.
ReadConvert Excel columns by multiply/divide factor without a helper column or =A2*2.20462 formula. Define rules, download a clean values-only .xlsx. Browser-local, Pro tier.
ReadNormalise mixed measurement units in Excel columns to one unit before Power BI import, so DAX SUM and AVERAGE measures aggregate correctly. Browser-local, Pro tier, values-only .xlsx output.
ReadClear Company, Manager, and author/description fields from Excel XLSX files. Application/AppVersion are reset to generic ExcelJS defaults on save. Browser-local, ExcelJS.
Blank the Company and Manager fields in docProps/app.xml and the creator, last-modified-by, description, subject, keywords and category fields in docProps/core.xml of an Excel workbook — and reset the Application/AppVersion fingerprint to a generic ExcelJS value. Browser-only via ExcelJS, no upload, Pro tier.
ReadBefore you send a model or template to a client, remove the Company and Manager fields and replace your exact Office build number with a generic signature so docProps/app.xml stops fingerprinting your IT environment. Browser-only ExcelJS, Pro tier, no upload.
ReadThe Company field in docProps/app.xml is auto-filled from your Office settings and rides along in every workbook you share. Blank Company and Manager (and the author fields in core.xml) in the browser with ExcelJS — no upload, Pro tier.
ReadA precise comparison: what Excel's built-in Inspect Document removes, what this ExcelJS-based wiper removes, where they overlap, and the fields neither one clears (Title, custom.xml). Pick the right tool — or run both. Pro tier, browser-only.
ReadBefore submitting an Excel return or template to a regulator, blank the Company and Manager fields and the author fields in core.xml, and normalise the embedded software version. Browser-only ExcelJS, Pro tier — the file never leaves your environment.
ReadDetect and delete hidden and VBA-hidden (VeryHidden) sheets from XLSX files. Developer tier. Browser-local.
Excel workbooks carry sheets that are invisible in the tab bar (`hidden`) and sheets you cannot un-hide from the UI at all (`veryHidden`, set via VBA). This browser tool enumerates every sheet's visibility state with ExcelJS, then deletes the subset you choose — hidden only, VeryHidden only, or both — and downloads a cleaned `.xlsx`. No Excel install, no upload to a server.
Read`xlSheetVeryHidden` sheets are set by VBA and never appear in Excel's Unhide dialog — normally you have to open the Visual Basic Editor and flip `.Visible` to reveal them. This browser tool reads the XLSX package directly, lists every VeryHidden sheet by name, and deletes them with `Delete VeryHidden sheets` — no VBA, no developer tab, works even when the VBA project is password-protected.
ReadBefore you email a workbook externally, run a one-minute audit for hidden sheets the recipient can un-hide in two clicks — stale margin calcs, internal notes, salary tabs. List every hidden and VeryHidden sheet by name, delete the ones that should not leave the building, and download a cleaned `.xlsx`. Browser-local, nothing uploaded.
ReadHidden Excel sheets routinely hold API keys, connection strings, salary bands, pricing logic, and raw PII in plain text — and they offer zero protection, since any user un-hides them in two clicks. Learn what hidden and VeryHidden sheets typically contain, why hiding is not security, and how to enumerate and delete them in the browser.
ReadSharing an Excel workbook whose hidden sheet still holds patient records, SSNs, or customer PII is an unauthorized disclosure under GDPR and HIPAA — the recipient un-hides it in two clicks. List every hidden and VeryHidden sheet by name, delete the ones carrying personal data, and download a clean `.xlsx`. Browser-local, so the file never leaves your control during the audit.
ReadReplace every formula cell with its last-computed value. Share spreadsheets without exposing business logic. Browser-local.
Convert all Excel formulas to their last-cached static values in the browser. ExcelJS walks every sheet, replaces each formula cell with its stored result, and writes a `-values-only.xlsx`. No upload, Pro tier.
ReadFlatten every formula in a financial model to its cached value before client delivery, so the deliverable shows your numbers but hides the proprietary methodology. Browser-only ExcelJS, Pro tier.
ReadMake an Excel file self-contained before you move, email, or sync it by flattening every formula to its cached value — so external-file links can't break into #REF! at the new location. Browser-only ExcelJS, Pro tier.
ReadConvert formulas to values on every worksheet at once, without running Paste Special → Values tab by tab. One upload flattens the whole workbook in your browser via ExcelJS. Pro tier.
ReadMake a workbook self-contained before it goes to SharePoint or OneDrive by flattening every formula to its cached value, so external-file links can't break into #REF! for cloud recipients. Browser-only ExcelJS, Pro tier.
ReadList all external URLs and file path references embedded in an XLSX workbook. Browser-local, Pro tier.
Scan an XLSX workbook for external workbook references, cell hyperlinks, and data connections by parsing the OOXML relationship XML directly. Browser-local, Pro tier — the file never leaves your machine.
ReadScan an XLSX for external workbook references, network-path hyperlinks, and live data connections before delivery, so clients never see Update Links prompts or broken #REF! values. Browser-local, Pro tier.
ReadLocate the external references behind Excel's 'This workbook contains links to one or more external sources' prompt by reading the OOXML relationship XML directly. Browser-local, Pro tier.
ReadGet one report covering external workbook references, cell hyperlinks, and data connections — the three classes Excel's Edit Links dialog can't show together. Reads the raw OOXML XML, browser-local, Pro tier.
ReadScan an XLSX for external workbook references, hyperlinks, and data connections before uploading to SharePoint or Teams, so viewers don't hit broken-link errors. Browser-local OOXML scan, Pro tier.
ReadRemove every cell comment, note, and threaded comment from an XLSX workbook in one click. ExcelJS, browser-local.
Bulk-delete every cell note, threaded comment, and reviewer-name record from an .xlsx or .xlsm workbook in one click. Works on all sheets at once, runs 100% in your browser (no upload), and outputs a clean binary XLSX. Pro tier.
ReadStrip every internal reviewer note, threaded comment, and author name from a financial model or proposal before it goes to a client. One-click, whole-workbook, browser-local — outputs a clean binary XLSX. Pro tier.
ReadExcel comments and notes are visible to anyone who opens the file — no special view needed. Delete every one, plus the author records that name your team, in a single browser-local pass. Pro tier.
ReadExcel's Review → Delete All Comments only clears the active sheet. Purge every comment, note, and author record across all sheets in one upload — no macro, no per-sheet clicking. Browser-local, Pro tier.
ReadBefore an Excel dataset goes on an open-data portal, strip every QA note, analyst comment, and author record from the workbook. Whole-workbook, browser-local purge that outputs a clean binary XLSX. Pro tier.
ReadRemove all VBA macro code from .xlsm files by extracting and deleting xl/vbaProject.bin. Output is safe .xlsx. Browser-local.
Remove vbaProject.bin and XLM macro sheets from .xlsm/.xlam files in your browser. JSZip unzips and deletes the macro parts — the code never runs. Output is a clean .xlsx. Developer tier.
ReadStrip every VBA and XLM macro from an .xlsm email attachment before you open it. JSZip unzips and deletes the macro parts — the code never runs, nothing is uploaded. Output is a safe .xlsx. Developer tier.
ReadConvert .xlsm/.xlam files to clean .xlsx for compliant long-term archives by deleting vbaProject.bin and XLM macro sheets. Browser-local JSZip, no macro execution, data preserved. Developer tier.
ReadTrust Center 'disable macros' only stops macros on your machine — vbaProject.bin stays in the file and runs on anyone who clicks Enable Content. The VBA Macro Stripper deletes the binary for good. Developer tier.
ReadDelete vbaProject.bin and XLM macro sheets from .xlsm files before uploading to DLP-scanned, antivirus-filtered enterprise systems. Browser-local JSZip, no macro execution. Output is .xlsx. Developer tier.
ReadConvert Excel or CSV data into a fully-styled, responsive HTML table using Tailwind CSS utility classes. Pro tier.
Turn an Excel or CSV file into a ready-to-paste Tailwind CSS HTML table snippet. Four styles (striped, bordered, compact, minimal), optional dark mode, responsive overflow-x-auto wrapper. Runs 100% in your browser. Pro tier.
ReadGenerate a Tailwind CSS HTML table snippet from Excel or CSV data to paste into a React or Next.js component. Four styles, optional dark mode, responsive wrapper. Browser-only, Pro tier — and a note on the JSX gotchas (class vs className).
ReadTurn an Excel or CSV pricing sheet into a responsive Tailwind CSS HTML table with dark mode classes. Four styles, browser-only, Pro tier. Honest about what it does and doesn't do (no 'Most Popular' badge, no sticky header).
ReadCompare a static Tailwind CSS table generated from Excel against a DataTables.js setup. Static Tailwind is zero-JS and instant for read-only data; DataTables adds sort, search, and pagination at the cost of a dependency. Honest, code-grounded comparison.
ReadConvert Excel or CSV data to a Tailwind CSS HTML table snippet for embedding in Next.js pages at build time. Four styles, optional dark mode, browser-only, Pro tier. Includes the SSG, MDX, and content-purge specifics.
ReadGenerate a complete tRPC router with Zod schemas, TypeScript interfaces, and CRUD procedures from an Excel file. Developer tier.
Upload an `.xlsx`, `.xls`, `.ods`, or `.csv` file and the tRPC Router Builder reads the first row as headers, samples the first 50 rows to infer `z.number()` / `z.string()` / `z.boolean()`, and emits a single tRPC v11 `.ts` file with a Zod schema, an exported TypeScript interface, and `list` / `getById` / `create` / `update` / `delete` procedures. Runs 100% in your browser via SheetJS — the file never leaves your machine. Developer tier.
ReadTurn a spreadsheet data model into the TypeScript API layer: drop your `.xlsx` or `.csv`, and the tRPC Router Builder emits a Zod schema, a TypeScript interface, and a tRPC v11 router whose CRUD procedures call Prisma-style `ctx.db` placeholders. It reads headers as fields and samples 50 rows for types — it does not write a `.prisma` schema. Developer tier, 100% browser-side via SheetJS.
ReadSkip the repetitive scaffolding when prototyping a new entity: drop a requirements spreadsheet (`.xlsx` / `.csv`), name the router, and get a tRPC v11 file with a Zod schema, a TypeScript interface, and `list` / `getById` / `create` / `update` / `delete` procedures in seconds. Types are inferred from the first 50 rows; the data never leaves your browser. Developer tier.
ReadGenerate tRPC v11 routers from an Excel or CSV schema for a Next.js App Router project: `list` / `getById` as `publicProcedure`, `create` / `update` / `delete` as `protectedProcedure`, all with Zod-validated inputs and Prisma-style `ctx.db` placeholders. Drops into `server/api/routers/` for create-t3-app layouts. Developer tier, browser-side via SheetJS.
ReadtRPC flows the router type straight to the client. Generate the server router from your Excel/CSV schema and the matching client types come for free — plus an exported `${Entity}` interface and an `export type ${Entity}Router` you can hand to your tRPC client. Types are inferred from the first 50 rows; runs in-browser. Developer tier.
ReadConvert Excel or CSV data into self-contained SVG bar, line, and pie charts. Zero external dependencies. Pro tier.
Turn any Excel or CSV dataset into a single self-contained 640×400 SVG bar chart you can paste straight into HTML, email, or markdown. No Chart.js, D3, or Recharts — the output is one pure `<svg>` element with no JavaScript, generated entirely in your browser.
ReadGitHub renders SVG files referenced as images but strips `<script>` and inline `<svg>` from markdown. Convert your benchmark numbers, coverage stats, or download counts from Excel into a self-contained `chart-bar.svg`, commit it to your repo, and reference it with standard `` syntax — no Chart.js, no image host, no Action.
ReadTurn an Excel category breakdown into a self-contained 640×400 SVG pie chart you can inline in an HTML email — no external image host, no CDN, no blocked-image placeholder. Generated in your browser as one static `<svg>` element with percentage labels and a colour legend.
ReadTurn an Excel time-series — weekly revenue, monthly signups, daily active users — into a self-contained 640×400 SVG line chart with area fill, point markers, and an axis grid. Embed it in an HTML dashboard, static-site report, or PDF with no chart library and no JavaScript.
ReadConfluence, Notion, and Jira render uploaded SVG files as crisp images. Convert your sprint metrics or project data from Excel into a self-contained `chart-bar.svg` / `chart-line.svg` / `chart-pie.svg` and attach it — no screenshot of an Excel chart, no chart plugin, no broken vector quality.
ReadEncode any XLSX file to a Base64 string for embedding in JSON payloads, API requests, or email attachments. Free.
Encode an .xlsx, .xls, .ods, or .csv file to a Base64 string for embedding in API requests, JSON payloads, or config files. Free, 100% browser-side — your file never leaves the page.
ReadEncode an Excel workbook to a Base64 string for embedding directly in a REST API JSON body, webhook payload, or config. Free, browser-only — no upload, raw Base64 output.
ReadEncode an Excel workbook to a Base64 string for attaching via the SendGrid, Postmark, Mailgun, or AWS SES email APIs. Free, browser-only — raw Base64, MIME type included.
ReadConvert an Excel file to Base64 without running Python base64.b64encode() or the base64 CLI. Browser-based, identical raw Base64 output, copy in seconds. Free.
ReadEncode an Excel file to Base64 for the Microsoft Graph /v1.0/me/sendMail contentBytes attachment field. Free, browser-only — raw Base64, contentType ready to copy.
ReadExport Excel or CSV rows as Python dicts, lists, or pandas DataFrames for use in scripts and Jupyter notebooks. Pro tier.
Generate Python code from Excel — list of dicts, dict of lists, or a pandas DataFrame constructor — ready to paste into a script or Jupyter notebook. Browser-only, Pro tier, up to 500 rows inlined per file.
ReadConvert an Excel or CSV sheet into a ready-to-paste pd.DataFrame({...}) constructor for Jupyter, Colab, and analysis notebooks. Browser-only, Pro tier, first sheet, up to 500 rows.
ReadTurn an Excel or CSV sheet into a Python list of dicts for pytest fixtures and parametrize cases driving FastAPI endpoint tests. Browser-only, Pro tier, first sheet, up to 500 rows.
ReadCompare inline Python data generated from Excel against pandas.read_excel(): use the generator for small portable fixtures (≤500 rows); use read_excel for large or live datasets. Honest trade-offs, real limits.
ReadTurn an Excel survey export (Google Forms, SurveyMonkey, Qualtrics) into a Python list of dicts for analysis in pandas, scipy, or statsmodels. Browser-only, Pro tier, first sheet, up to 500 responses.
ReadTransform a spreadsheet with Key and language columns into i18n-ready JSON translation files for React, Vue, or Next.js. Free.
Turn an Excel spreadsheet with key and value columns into a flat or nested i18n JSON file. Free, browser-only — ideal for next-intl, react-i18next, vue-i18n.
ReadTurn an Excel translation spreadsheet into next-intl compatible JSON message files for Next.js internationalisation. Free, browser-only.
ReadConvert an Excel translation spreadsheet to correctly formatted react-i18next JSON with dot-notation key expansion. Free, browser-only.
ReadCompare generating i18n JSON from Excel vs using Lokalise, Phrase, or Crowdin. Excel is free for small teams; paid platforms add workflow features for large projects.
ReadConvert an Excel key-value translation spreadsheet to flat or nested JSON for vue-i18n, Nuxt i18n, or Quasar i18n. Free, browser-only.
ReadPaste an Excel formula and instantly see every nested function, argument, and logical step explained — by a deterministic parser, not an AI that can hallucinate. No sign-up, no upload, runs in your browser.
Paste any Excel formula and get a deterministic, step-by-step plain-English breakdown of every nested function and argument — built by a real parser, not an AI that can hallucinate. Pro tier, browser-only, no file needed.
ReadInherited a financial model and need to reverse-engineer its formulas? Paste any cell's formula for a deterministic, step-by-step plain-English breakdown — no AI guessing, no upload. Pro tier, browser-only.
ReadNew to INDEX/MATCH and array formulas? Paste one in and get a friendly, step-by-step breakdown of every piece — built by a real parser, never an AI guess. Pro tier, browser-only, no file needed.
ReadExcel's Evaluate Formula dialog shows intermediate values, not what the formula means. This tool prints a deterministic plain-English breakdown of the structure instead. Pro tier, browser-only, no file needed.
ReadPaste any nested IFERROR / VLOOKUP / INDEX-MATCH chain from an inherited workbook and get a deterministic, step-by-step plain-English breakdown. No AI guessing, no upload. Pro tier, browser-only.
ReadScan every cell for #REF!, #N/A, #VALUE!, #DIV/0!, #NAME?, #NULL!, and #NUM! errors. Report with cell addresses. Free.
Detect and list all formula errors (#REF!, #DIV/0!, #N/A, #VALUE!, #NAME?) across every sheet in an Excel workbook. Free, browser-only.
ReadScan an Excel workbook for #REF! errors after column or row deletion. Free tool — lists every affected cell address across all sheets. Browser-only.
ReadScan every cell in an Excel financial model for #REF!, #N/A, #VALUE!, and #DIV/0! errors before presenting to board or investors. Free, browser-only.
ReadGet a multi-sheet error report for all #REF!, #N/A, and #VALUE! errors across an entire workbook — Go To Special only finds errors on one sheet. Free, browser-only.
ReadScan an Excel workbook for all #N/A errors produced by VLOOKUP and INDEX/MATCH formulas. Free tool — reports cell address and formula for each error.
ReadTrace circular reference chains in Excel workbooks using graph traversal. Pro tier. Browser-local.
Excel's status bar shows one circular reference at a time and points only at the active cell. The Circular Reference Finder reads the stored formulas from your .xlsx, builds a directed dependency graph across every sheet, and runs depth-first cycle detection so every loop is reported as a full path — A1 → B2 → C3 → A1 — in one pass, browser-local, no recalculation.
ReadVLOOKUP whose range includes its own cell, and SUMIF/SUMIFS whose sum range overlaps the result cell, are the classic accidental circular references. The Circular Reference Finder maps the stored formulas to a graph and reports the exact cells — but range-based and whole-column patterns have a real catch you must know about.
ReadDCF, LBO and three-statement models develop circular references as interest, cash sweeps and WACC feed back into income. The Circular Reference Finder maps stored formulas to a graph and lists every loop — but you must know that whole-column refs and named ranges (common in models) are not followed, so audit with bounded ranges.
ReadEvery circular reference is a cell dependency, but most dependencies are perfectly normal. This guide explains the difference using the actual graph both tools build — the Circular Reference Finder looks for loops in the dependency graph, while the Cell Dependency Map traces the precedent tree of one cell.
ReadNo Excel installed, or the workbook hangs on open because it iterates a circular reference every load? The Circular Reference Finder reads the stored formulas straight from the .xlsx and runs graph cycle detection in your browser — no recalculation, no Excel, any OS. Caveats apply for whole-column and dynamic references.
ReadRecursively trace and display all precedent cells for any target cell in an XLSX workbook. Pro tier. Browser-local.
Recursively trace the precedents of any cell in an XLSX workbook into one readable, indented text tree — up to 8 levels deep, following cross-sheet references, marking hardcoded inputs and shared cells. Replaces clicking Excel's Trace Precedents arrows one level at a time. Browser-local, Pro tier.
ReadTrace which assumptions drive a valuation, EBITDA, or DCF output by mapping the precedent chain of any cell in an XLSX model. Hardcoded assumptions are tagged, cross-sheet links are followed, and the result is a readable text tree — up to 8 levels deep. Browser-local, Pro tier.
ReadGenerate a copy-pasteable text dependency tree for any key output in an XLSX model, so a new owner can understand the formula logic without reverse-engineering it. Follows cross-sheet links, tags hardcoded inputs, traces up to 8 levels. Drops cleanly into Confluence, Notion, or a README. Pro tier, browser-local.
ReadExcel's Trace Precedents draws arrows one level at a time and stalls on cross-sheet links; this tool walks the whole chain recursively up to 8 levels and prints a copy-pasteable text tree. A side-by-side comparison of what each does, where each wins, and the real limits of the recursive trace. Pro tier, browser-local.
ReadProduce a traceable, copy-pasteable record of every input feeding a reported financial figure in an XLSX workbook — the formula-chain evidence SOX Section 404 reviews ask for. Tags hardcoded plugs, follows cross-sheet links, traces up to 8 levels, runs entirely in the browser so confidential figures never leave the machine. Pro tier.
ReadIdentify cells formatted as text that contain numeric or date values — a common source of Excel calculation errors. Free.
Scan Excel files for cells where numeric values are stored as text strings. Free, browser-only — fixes the green-triangle warning at the source.
ReadFind all cells where numeric values are stored as text — the most common cause of SUM and AVERAGE returning zero in Excel. Free, browser-only tool.
ReadDetect cells where numbers or dates are stored as text — the cause of pivot table missing values and incorrect aggregation. Free, browser-only.
ReadFind all text-stored numbers in Excel and fix them faster than the Text to Columns wizard. Free browser-based inspection report shows every cell to fix.
ReadScan Excel for cells where date values are stored as text before importing into Power BI. Prevents date hierarchy and timeline visual failures. Free, browser-only.
ReadColor-code every cell in an Excel workbook: formula cells in one colour, hardcoded values in another. ExcelJS. Pro tier.
Apply a blue fill to every formula cell and an amber fill to every hardcoded value across all sheets of an XLSX workbook, in one pass, entirely in your browser. ExcelJS-powered, Pro tier, no upload. The download is a copy named formula-highlighted.xlsx with two fixed colours (FFBDD7EE blue, FFFFEB9C amber) and a count of formula vs hardcoded cells.
ReadColour-code every formula cell blue and every hardcoded assumption amber across a financial model in one pass, in your browser. ExcelJS-powered, Pro tier, no upload. Output is a copy (formula-highlighted.xlsx) with fixed blue FFBDD7EE / amber FFFFEB9C fills and a formula-vs-hardcoded count to gauge model integrity.
ReadBefore a budget peer-review session, colour every hardcoded value amber and every formula blue across the workbook in one pass, in your browser. ExcelJS-powered, Pro tier, no upload. Reviewers question the amber cells and trust the blue ones; output is a copy (formula-highlighted.xlsx) with fixed FFFFEB9C/FFBDD7EE fills and cell counts.
ReadCtrl+~ shows formulas as text and resets on close. The JAD Formula Highlighter writes permanent blue fills on formula cells and amber on hardcoded values across all sheets in one pass, in your browser. ExcelJS-powered, Pro tier, no upload. Output is a copy (formula-highlighted.xlsx) with fixed FFBDD7EE/FFFFEB9C fills.
ReadMark input/assumption cells amber and formula cells blue across an Excel model in one pass, in your browser, so a new analyst sees 'change the amber, never touch the blue'. ExcelJS-powered, Pro tier, no upload. Output is a copy (formula-highlighted.xlsx) with fixed FFFFEB9C/FFBDD7EE fills and cell counts.
ReadRun up to 1,000 iterative calculation steps to find the input value that produces a target output. Developer tier.
Excel Goal Seek runs only in the desktop app. This browser tool replicates the single-variable case: name the target cell (it must hold a formula), the value you want it to equal, and the input cell to vary. A bisection solver runs up to 1,000 iterations using the workbook's cached cell values and returns a text report with the converged input, output, residual, and iteration count.
ReadBreak-even analysis asks how many units you must sell to cover costs. Point this browser-based Goal Seek at your profit cell, set the target to 0, and vary the units cell — a bisection solver returns the exact units sold that drive net profit to zero, no trial and error and no Excel install required.
ReadGiven a loan amount, term, and target monthly payment, what rate is implied? This browser Goal Seek reverses the amortization math — but PMT is not a supported function, so you must write the payment formula out using arithmetic and POWER. Set the payment cell as the target and the rate cell as the input, and the bisection solver returns the implied rate.
ReadGiven your cost structure, what price hits a 40% gross margin? This browser Goal Seek varies the price cell until the margin cell equals your target — but the margin formula must use supported arithmetic (and single-cell references, not ranges or lookups). Set the margin cell as the target, the price cell as the input, and the bisection solver returns the price in seconds.
ReadGoal Seek solves one equation for one unknown; Solver handles many variables with constraints and an objective to maximise or minimise. This guide draws the line clearly — and explains exactly what this browser Goal Seek tool reproduces (the single-variable case via bisection) and what it deliberately does not (the multi-variable Solver problem).
ReadAnalyse which sheets, named ranges, images, and data areas contribute most to your XLSX file size. Pro tier.
A 90 MB workbook that holds 4,000 rows of numbers is almost never the numbers. The Workbook Weight Analyzer opens your .xlsx as the ZIP it really is, measures every internal file decompressed, and tells you exactly which of eleven components — images, styles, shared strings, worksheet XML, VBA — is eating the megabytes, so you fix the right thing instead of guessing.
ReadWhen the Weight Analyzer reports `shared_strings` as your biggest category, `xl/sharedStrings.xml` is the culprit — Excel's single workbook-wide table of every unique text value. This guide explains exactly what fills it, why numbers and dates never do, and how to shrink it.
ReadEmbedded images are the number-one cause of unexpectedly huge Excel files — Excel stores them at full resolution inside `xl/media/`. The Weight Analyzer reports the `embedded_media` category and names the exact image files by size, so you know which picture to compress or delete.
ReadConditional-formatting rules live inside each sheet's XML (`xl/worksheets/sheet*.xml`). Applied to whole columns or duplicated by copy-paste, they swell that XML far beyond the data it holds. The Weight Analyzer flags an oversized sheet XML under `worksheet_data` — the classic fingerprint of formatting bloat.
ReadExcel Online slows noticeably on large workbooks and co-authoring suffers. Before you push a file to SharePoint or Teams, run the Weight Analyzer to see exactly which component is bloating it — images, macros, formatting, shared strings — and fix the right one so it opens and co-authors smoothly.
ReadPerform Left Join or Inner Join between two sheets in an Excel workbook (or two files) on a common key column. Pro tier.
Perform a SQL-style left or inner join between two Excel files using a shared key column — entirely in the browser. Pro tier, no upload, no Power Query.
ReadLeft-join a CRM customer export with an orders export on Customer ID, in the browser. Pro tier, no VLOOKUP, no upload — values-only .xlsx output.
ReadReplace a stack of VLOOKUP formulas pulling different columns with one SQL-style join between two Excel files. Pro tier, browser-only, values-only output.
ReadLeft or inner join two Excel files without Power Query, an add-in, or a desktop install. Pro tier, browser-only — values-only .xlsx, no data model.
ReadPre-join two Excel files into one flat table before Power BI to avoid many-to-many relationship pain. Pro tier, browser-only, values-only .xlsx output.
ReadTransform columns-as-variables (wide format) into rows-as-observations (long format). Required for Power BI, Tableau, and pandas. Pro tier.
Reshape wide Excel data — one column per period or category — into long (tall) format where each value becomes its own row. Browser-only, Pro tier, equivalent to pandas melt() or SQL UNPIVOT. You name the ID columns, the value columns, and the two output columns; the tool emits one .xlsx sheet called Unpivoted.
ReadConvert wide-format sales data (years or months as columns) to long format — one row per period — so Power BI and Tableau can build a real date axis. Browser-only, Pro tier. You map ID columns, year columns, and the output Year and Revenue column names; download a clean unpivoted.xlsx.
ReadConvert wide Excel data to the long (tidy) shape R's tidyverse expects, so read_xlsx() pipes straight into group_by, ggplot2, and dplyr. Browser-only, Pro tier. You name ID columns, value columns, and the variable/value column names; download a clean unpivoted.xlsx.
ReadGet Power Query's Unpivot Columns result without Excel Desktop or a data-model refresh. Browser-only, Pro tier. Name your ID columns, value columns, and the two output columns; download a clean static unpivoted.xlsx with no embedded query.
ReadReshape a wide-format Excel budget (years as columns) into the long shape pandas melt() produces, so read_excel pipes straight into groupby, resample, and matplotlib/seaborn. Browser-only, Pro tier. Name ID columns, year columns, and the Year/Budget output columns; download unpivoted.xlsx.
ReadDrag-and-drop pivot table builder powered by HyperFormula. Runs entirely in your browser. Developer tier.
Cross-tabulate a flat XLSX or CSV into a pivot-table workbook (one row dimension, one column dimension, one aggregated value) without installing Excel — runs 100% in your browser via SheetJS, outputs a downloadable pivot-table.xlsx on the first sheet only. Developer-tier tool.
ReadTurn a flat sales-transaction sheet into a Region x Product revenue cross-tab with a Grand Total row and column — no Excel pivot pane. Type Region as the row, Product as the column, Revenue as the value, pick SUM, and download pivot-table.xlsx. Developer-tier, runs in-browser via SheetJS.
ReadExcel's classic pivot can't do distinct count without Power Pivot. This browser tool offers COUNT DISTINCT as a first-class aggregation — point valueField at a customer-ID column, pick countdistinct, and get unique customers per segment and period as a downloadable pivot-table.xlsx. Developer-tier, in-browser via SheetJS.
ReadSkip the Excel fields pane. Upload a CSV or XLSX, type three exact column-header names and pick one aggregation, and download a pivot-table.xlsx cross-tab. Browser-native via SheetJS, six aggregations including count distinct. Developer-tier.
ReadSummarise date-based transactions by month or quarter with a browser pivot generator. Add an ISO period column (2026-01, 2026-Q1) so columns sort chronologically, then pivot with the period as the column field. In-browser via SheetJS, Developer-tier.
ReadApply custom regular expressions to any column and extract matching substrings into new columns. Pro tier. Browser-local.
Apply a regular expression to an Excel column and extract matching text into a new column. Pro tier, browser-only — zero upload.
ReadApply an email regex pattern to an Excel column and extract addresses into a new clean column. Pro tier, browser-only — full JavaScript regex syntax.
ReadApply a regex pattern to extract order IDs, SKUs, or tracking numbers embedded in Excel text columns. Pro tier, browser-only — adds a clean extracted column.
ReadExtract variable-length patterns from Excel cells using regex — more flexible than LEFT(), MID(), and RIGHT() for dynamic or variable-length content. Pro tier, browser-only.
ReadApply regex patterns to extract UK postcodes (SW1A 1AA format) and phone numbers from Excel text columns into a clean new column. Pro tier, browser-only.
ReadSplit one Excel or CSV file into separate output files based on the unique values in a selected column. Pro tier.
Group the rows of one Excel or CSV file by the unique values in a column you name, and download a single `.xlsx` workbook with one sheet per value. Browser-only, Pro tier — your file never leaves the page. The tool reads the first sheet of your upload, buckets every row by the split column, and writes each bucket to its own tab named after the value (sanitised to 31 characters).
ReadTurn one flat sales export into a multi-tab workbook with a sheet per region. Name your `Region` column and the tool groups every row by its value and writes one tab per region into a single `split-output.xlsx`. Browser-only, Pro tier — sales figures never upload. Headers are copied to every tab and row counts per region are reported so you can reconcile against the company total before distribution.
ReadGroup a consolidated payroll sheet by the `Department` column and produce a multi-tab workbook with one sheet per department — so a line manager sees only their team's pay data, never the whole company's. Runs entirely in your browser via SheetJS, so payroll never uploads to a server. Pro tier. Headers are copied to every tab and per-department row counts are shown for verification before you distribute.
ReadReplace the manual Advanced Filter → Copy to New Location loop, repeated once per group value, with a single operation that buckets every row by a column you name and writes one tab per value into a single `split-output.xlsx`. Browser-only via SheetJS, Pro tier — no macros, no VBA, no upload. Headers are copied to every tab and the per-group counts are reported so you can verify the split.
ReadGroup a flat product catalogue by the `Category` column and produce a multi-tab workbook with one browsable sheet per category — Electronics, Clothing, Home & Garden — in one click. Browser-only via SheetJS, Pro tier, no macros or manual filtering. Headers are copied to every tab and the per-category SKU counts are reported so you can verify coverage before handoff.
ReadUpload two Excel or CSV files and get a colour-coded diff highlighting every changed, added, and removed cell. Pro tier.
Upload an original and a revised XLSX or CSV and get a colour-coded diff workbook plus a text report flagging every changed (amber), added (green), and removed (red) cell. Runs entirely in your browser via ExcelJS and SheetJS — files never leave your machine. Pro tier; needs exactly two files.
ReadCompare an original and a revised Excel budget cell-by-cell and get a colour-coded diff workbook flagging every changed assumption, added line, and removed figure. Browser-only via ExcelJS/SheetJS — model data stays on your machine. Pro tier; exactly two files.
ReadCompare two versions of an Excel contract schedule cell-by-cell to surface every changed price, service level, and payment term for legal review. Colour-coded diff workbook plus a text change log, generated in-browser via ExcelJS/SheetJS. Pro tier; two files.
ReadA browser-based alternative to Microsoft's Inquire add-in and Spreadsheet Compare for diffing two Excel files. Get a colour-coded diff workbook and a text change list, generated locally via ExcelJS/SheetJS. Works on Mac, Windows, and Chromebook. Pro tier; two files.
ReadCompare last week's and this week's Excel export cell-by-cell to produce a colour-coded change audit trail and a text change log. Runs in-browser via ExcelJS/SheetJS — data stays on your machine. Pro tier; exactly two files; XLSX or CSV.
ReadMerge two Excel datasets on approximate string similarity (Levenshtein distance) when exact key matching fails. Developer tier.
Exact JOIN on company names fails when one file says 'Google LLC' and another says 'Google Inc.' Fuzzy Merger scores Levenshtein string similarity and joins on the single best match — adding a __match_score column for review.
ReadYour CRM says 'Amazon Web Services' and your ERP says 'AWS LLC'. Exact join fails. Fuzzy Merger scores name similarity, joins the two exports, and stamps a __match_score so finance can validate each pairing.
Read'123 Main St' and '123 Main Street' never join exactly. Fuzzy Merger scores address-string similarity and appends reference data — coordinates, delivery zones, census tracts — to each best match, with a confidence score.
ReadSupplier and internal catalogs rarely share SKUs. Fuzzy Merger joins on product name similarity — pairing 'USB-C Hub 7-Port' with 'USB Type-C 7 Port Hub' — and appends supplier pricing with a confidence score.
ReadExact joins are fast and false-positive-free when you have a clean shared key. Fuzzy joins are for text keys with formatting variation. Learn which to use, how they differ, and how to chain them.
Read