Sheetwise — XLSX Viewer & Editor for 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 |
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.
| |