Skip to content
| Marketplace
Sign in
Visual Studio Code>Visualization>Sheetwise XLSX EditorNew to Visual Studio Code? Get it now.
Sheetwise XLSX Editor

Sheetwise XLSX Editor

Theo EwzZer

|
1 install
| (0) | Free
View and edit .xlsx spreadsheets in VS Code with their real formatting: formulas (recalculated), number formats, merges, borders, frozen panes, multiple sheets.
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
Copied to clipboard
More Info

Sheetwise — XLSX Viewer & Editor for VS Code

License: MIT VS Code

Open .xlsx workbooks directly in VS Code with their real formatting, edit them like you would in Excel, and save with Ctrl+S.

No more opening Excel just to check a value, fix a typo or tweak a formula: Sheetwise renders fonts, colors, borders, merged cells, number formats and frozen panes, recalculates formulas as you type, and plugs into VS Code's native undo/redo, dirty state and hot exit.

Features

Faithful rendering

  • Fonts & text — font family and size, bold / italic / underline / strikethrough, colors (including theme colors and tints), rich text
  • Cells — solid and gradient fills, borders (thin, medium, thick, dashed, dotted, double), horizontal / vertical alignment, indent, wrap text, vertical text
  • Layout — merged cells, column widths, row heights, hidden rows / columns, frozen panes, gridlines, sheet zoom, tab colors, hidden sheets (greyed out)
  • Number formats — every Excel format: currency, percentage, dates, times, scientific, conditional colors ([Red]…), in French or English conventions
  • Extras — hyperlinks (Ctrl+click), notes (red corner + tooltip), data validation dropdown lists, text overflowing into empty neighbouring cells just like Excel
  • Fast — the grid is rendered progressively, so large sheets open quickly

Editing

Action How
Enter data Just type, or F2 / double-click to edit, or use the formula bar
Confirm / cancel Enter, Tab (with Shift to go backwards) / Esc. Alt+Enter inserts a line break
Formulas =SUM(A1:A3) — French function names and ; separators also work (=SOMME(A1;A3))
Navigate Arrows, Ctrl+arrows, Home, Ctrl+Home, Ctrl+End, PgUp / PgDn
Select Shift+arrows, drag, click headers, Ctrl+Space / Shift+Space, Ctrl+A
Copy / cut / paste Ctrl+C / X / V — Excel-compatible TSV; formulas and formats are kept within the workbook
Fill down / right Ctrl+D / Ctrl+R
Clear Delete (contents), context menu (formats, all)
Format Toolbar: font, size, bold / italic / underline / strikethrough (Ctrl+B / I / U / 5), colors, alignment, wrap text, merge, borders, number format
Rows / columns Right-click to insert / delete — formulas, merges, data validations and conditional formats are shifted accordingly
Width / height Drag a header edge; double-click to autofit the column
Sheets Tabs: click to switch, double-click to rename, right-click to insert / delete, + button to add
Undo / redo Ctrl+Z / Ctrl+Y (VS Code's own history)
Find Ctrl+F
Zoom Zoom dropdown or Ctrl+mouse wheel

Formula recalculation

Formulas that depend on edited cells are recalculated incrementally, using fast-formula-parser extended with COUNTIFS, SUMIFS, AVERAGEIFS, MAXIFS, MINIFS, TEXTJOIN, XLOOKUP, SWITCH and VALUE.

Untouched formulas keep the value Excel last computed. If a function isn't supported, the last known value is kept. Saved files are flagged so that Excel fully recalculates them on open.

Installation

Sheetwise is not on the Marketplace yet. Build the VSIX from source and install it:

git clone https://github.com/TheoEwzZer/sheetwise.git
cd sheetwise
npm install
npm run package
code --install-extension dist/sheetwise.vsix

Then open any .xlsx file — Sheetwise is registered as its default editor. To switch back to another editor, use Reopen Editor With… from the editor title menu.

Settings

Setting Values Description
xlsxEditor.locale auto (default), fr, en Conventions used to display and enter numbers, dates and booleans. auto follows the VS Code display language
xlsxEditor.gridTheme excel (default), vscode excel: white grid like Excel. vscode: cells without a fill use the VS Code theme colors
xlsxEditor.recalculate true (default), false Recalculate formulas that depend on edited cells

Command: XLSX: New Excel Workbook (.xlsx).

Known limitations

Saving rewrites the file through ExcelJS. The following are lost on save: charts, pivot tables, slicers, macros, shapes / text boxes and form controls. A warning banner is shown when a file contains any of them — don't save it from Sheetwise in that case (or work on a copy).

Also:

  • Conditional formatting is preserved but not rendered
  • Images are not displayed
  • Defined names and external references are not fully recalculated
  • Inserting / deleting columns inside an Excel Table object is refused

Development

npm install
npm run build      # bundle the extension and the webview (esbuild)
npm run watch      # rebuild on change
npm run typecheck
npm test           # unit and integration tests (node:test)
npm run package    # build dist/sheetwise.vsix

Press F5 in VS Code to launch an Extension Development Host with the extension loaded.

Project structure

Path Role
src/extension.ts Activation, command registration
src/provider.ts CustomEditorProvider and messaging with the webview
src/xlsxDocument.ts Document model: loading, edit operations, undo/redo, save, backups
src/serialize.ts ExcelJS → view model (resolved styles, formatted text)
src/recalc.ts, src/formulaFunctions.ts Incremental formula recalculation and extra functions
src/refs.ts, src/structure.ts Reference rewriting when inserting / deleting rows and columns
src/numfmt.ts, src/parseInput.ts, src/colors.ts Number formats, input parsing, color resolution
src/protocol.ts Message types shared by the extension and the webview
webview/ HTML grid: progressive rendering, selection, editing, clipboard, menus
test/ node:test test suites

Contributing

Issues and pull requests are welcome. Please run npm run typecheck and npm test before submitting a PR.

License

MIT. Bundled third-party libraries (ExcelJS, SSF, fast-formula-parser…) and their licenses are listed in ThirdPartyNotices.txt.

  • Contact us
  • Jobs
  • Privacy
  • Manage cookies
  • Terms of use
  • Trademarks
  • Your Privacy Choices
  • Consumer Health Privacy
© 2026 Microsoft