PRIVATE MEMBER WORKSPACE
Spreadsheet Workbench
Turn a messy spreadsheet into a file you can use.
Import CSV, TSV or XLSX files, edit cells, preview cleaning changes and check your data before exporting. Save your work and repeat the same steps on next month’s file.
Create a free account to get started in less than a minute.
Create a free accountAlready a member? Sign inTry a generated sample workbook
This sample uses generated supplier rows, formulas, an incoming schema and a checkpoint. It has no file imports or private account connection. Use the member editor for your own files and saved workbooks.
How to use Spreadsheet Workbench
Import, edit and save a small workbook
Sign in to open CSV, TSV or XLSX files in the member editor. Check separators, encoding and headings before accepting an import. Identifiers such as 00124 remain text. Use the selected-cell formula bar, multiple sheets, sorting, filtering and range fill. Preview native cleanup operations before applying them. Add validation rules, save a checkpoint, record a reusable recipe and choose an export when ready.
The interactive public sample uses generated supplier rows only and has no file imports or private account connection. Open the member workbench for your own files. Account save uploads workbook data privately; local exports remain in this browser until downloaded.
Original bounds remain: ten saved workbooks, eight sheets each, 2,000 data rows plus a heading row, fifty columns and 10,000 characters per cell. Imports are up to 5 MB; stored workspace data has limits of four million characters and 7.5 MB. Original twenty-edit Undo/Redo, three checkpoints, thirty recipe steps, fifty validation rules, private account conflict checks and device recovery remain available.
Safe structural previews
In the English editor, Insert/Delete row or column and adjacent column moves now prepare a review before changing the workbook. The same actions are available under Advanced workbook review settings. Inspect every formula rewrite, then Apply reviewed structural edit. Relative and absolute addresses follow the moved cells, including supported cross-sheet references and rectangular ranges. Quoted string contents are preserved. Insertion expands ranges when appropriate; deletion shrinks them. Deleted cell/range references become #REF! error nodes, preserving the calculator’s IF and IFERROR handling.
The small formula grammar cannot express every Excel reference. Unsupported syntax or a move that would make a rectangle noncontiguous is refused without applying the edit. Position-based styles on the edited sheet are cleared, as in the original editor. Sorting and structural recipe cleanup do not use this rewrite. Validation rules and recipes remain column-based; review their mappings after structural changes. Checkpoints and Undo provide separate recovery.
Formula reports, dependencies and workbook names
Advanced settings starts closed. Choose Formula compatibility and dependencies to inspect the selected sheet or every workbook formula, or follow the selected cell’s references. Complete records are available in downloads; tables display fifty records per page. Dependency graphs include syntactic references in inactive IF branches and identify cycles, with bounds of 1,000 cells and 10,000 edges. Calculation results and unsupported grammar are reported separately.
The existing calculator still supports its documented arithmetic, comparisons, concatenation, ranges and functions: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, IF, IFERROR, AND, OR, ROUND, TRIM, CLEAN, LOWER, UPPER, LEFT, RIGHT, MID, LEN and CONCAT. Existing bounds remain 1,000 formula characters, 300 tokens, 10,000 cells in one range and bounded recursion/calculation work. There is no JavaScript evaluation, external data connection or full Excel compatibility.
Workbook named ranges add up to fifty case-insensitive names for one-sheet rectangles of up to 10,000 cells. Names use 1–40 ASCII letters, digits or underscores, starting with a letter/underscore. Cell addresses, reserved functions and ambiguous reference prefixes are refused. Define Prices for C2:C5, then enter =SUM(Prices) in the original formula bar. Supported names are expanded through the unchanged calculator. Deleted names/ranges are marked invalid; redefine or remove them.
Names are private workbook review metadata, not imported Excel defined names. Raw CSV/XLSX exports keep literal formula text; calculated exports contain values. Native XLSX exports store strings rather than creating a full live Excel formula model. Keep a review backup when you need the name definitions and editable review data.
Sheet renaming, sorting and structural cleanup use the original operations and do not rewrite formula references. Review affected formulas afterward.
Sheet renaming, sorting and structural cleanup use the original operations and do not rewrite formula references. Review affected formulas afterward.
Sheet renaming, sorting and structural cleanup use the original operations and do not rewrite formula references. Review affected formulas afterward.
Recurring imports and recipe execution
Keep the new file in the original import preview, then choose Recurring import mapping and recipe report. Match each expected heading to one distinct incoming column by index. Repeated and blank headings need explicit choices. Unique exact headings can be matched automatically. Every unselected incoming column is listed as excluded; all supported mapped rows are retained.
Preview mapped recipe execution runs the recorded native steps on a private copy and reports each step’s status, row/column dimensions, native change count and changed matrix positions. Native change counts have operation-specific meaning. A failure leaves the workbook unchanged and marks later steps not run. Apply complete recipe result only after reviewing the output. Structural cleanup requires explicit formula review and invalidates names on the affected sheet rather than keeping stale pointers.
Validation libraries, charts, history and comparisons
Save current native validation rules as a named library, download it, or import it in another workbook. Map its headings explicitly to current columns before replacing the workbook’s rules. Libraries contain headings and rules, not data rows. Up to twenty libraries and fifty rules per library fit within the overall 256 KiB review-metadata allowance. Portable library files can be up to 512 KiB.
Basic charts are optional local bar or line SVGs. Select 1–100 existing rows, a label column and a numeric result column. Blank/nonnumeric values are refused. Every chosen point is retained; long labels are shortened only on the image, with full labels in its data table and CSV. Imported Excel charts and live data connections are not preserved.
Start structured history only when wanted. It records recent action and change-count summaries, retaining the latest two hundred with explicit total and dropped counts. It is not a complete copy of every old value or a tamper-proof server audit trail. Original Undo/Redo and checkpoints remain separate. Compare a checkpoint with the current workbook to see every changed raw value, formula string and cell format. Missing cells differ from empty strings. Old checkpoints contain sheets, not historical named-range definitions.
Download editable review backup keeps this workbook’s data, names, validation libraries, history and checkpoints. Opening a validated backup replaces the current workbook contents while retaining its account identity. Backup files can be up to 8 MB, subject to the original stored-library limits. Review metadata is limited to 256 KiB inside those existing limits. Reports and backups may contain private workbook information; inspect them before sharing.
Review operations run locally, stop after eight seconds and can be cancelled. File reads stop after five seconds. Failed or cancelled unchanged jobs retain matching prior results. Source or selected-cell changes clear stale previews. Closing Advanced keeps settings and prepared results. Account-save and recovery status remain visible in the original member editor.
Example: prepare next month’s supplier file
A supplier sends Code, Product name and Price in a new order, with an extra note column. Preserve codes such as 00124 as text. Map the expected headings to their incoming column indices, explicitly exclude the note, then preview the saved trim and number-cleaning steps. Review the complete execution report before applying all rows.
Define Prices for the numeric price cells and try =SUM(Prices). Preview a row insertion and check the changed range. A saved checkpoint shows the original formula strings beside the revised ones. Create a small price chart and download its SVG plus full data table; these are design artifacts, not imported Excel charts.
About spreadsheet cleanup and formula review
Small CSV/XLSX cleanup work often needs predictable identifiers, a clear schema and repeatable steps more than a full spreadsheet suite. Column names alone can be ambiguous when headings repeat or drift. Explicit index mapping and full execution reports make exclusions and changes reviewable.
Formulas point to positions. Inserting or deleting a position may move its source cells; rearranging a rectangle can require references that this small grammar cannot express. Refusing an unsupported rewrite is safer than silently changing its meaning. Compatibility reports describe this workbench’s supported grammar, not general Excel behavior.
Private workbook saves include entered cell values and compatible review metadata. Original imported files are not retained. Device recovery can be cleared or fill up; download a backup for important work. Closing or reloading the public sample clears its generated workbook. The member editor keeps its existing account, autosave and conflict controls.
Related tools
CSV column mapper · CSV duplicate remover · CSV and JSON converter