xl
View and edit Excel and CSV files in VS Code. Fast on huge files, and it keeps your workbook's formatting intact.


Features
- Opens
.xlsx, .xlsm, .csv and .tsv in a canvas grid that stays smooth on very large files.
- Edit cells with undo/redo; formulas recalculate live (about 150 functions).
- XLSX is saved by patching the original file, so styles, charts, drawings and conditional formatting are preserved.
- Sheet tabs, merged cells, frozen panes, number formats, hyperlinks.
- Find, go to cell, formula bar, selection statistics (sum, average, count, min, max).
- Sort and filter any column. This changes the view only, never the file.
Install
Search for xl in the Extensions view, or run ext install vs-office.xlv.
If the older "Spreadsheet Viewer" extension is installed, disable it so the two do not compete for the same files.
Use
- Excel files open in the Excel Editor automatically.
- CSV / TSV: right-click the file, choose Open With..., then CSV Editor (or make it the default, see Configuring VS Code). For a read-only view run
CSV: Open Preview (Shift+Cmd/Ctrl+V).
| Action |
Shortcut |
| Edit cell |
type, or F2 |
| Find |
Ctrl/Cmd+F |
| Go to cell |
Ctrl/Cmd+G |
| Fill down / right |
Ctrl/Cmd+D / Ctrl/Cmd+R |
| Zoom |
Ctrl/Cmd + mouse wheel |
| Sort or filter |
right-click a column header |
Limitations
- No row or column insert/delete in XLSX. Charts, images and validation are kept but cannot be edited.
- Array and dynamic-array formulas show cached results and update when the file is opened in Excel.
- Back up important files before editing.
Settings
Configuring VS Code
You can make xl the default editor for your spreadsheet files by setting workbench.editorAssociations in settings.json:
{
"workbench.editorAssociations": {
"*.csv": "xl-csv-editor",
"*.tsv": "xl-csv-editor",
"*.xlsx": "xl-excel-editor"
}
}
Without it, Excel files already open in xl and CSV files open in the regular text editor (use Open With... to switch).
Configuring xl
Open Settings and search for csv-preview to change the separator, header row, line numbers, number format and more. For example:
{
"csv-preview.separator": ";",
"csv-preview.lineNumbers": "ordinal"
}
Development
See CONTRIBUTING.md for the full workflow.
npm ci --ignore-scripts
npm run check # format check, lint, type check, tests
npm run vsce-package # builds xlv.vsix
Press F5 to debug.