Preview CSV files and Excel spreadsheets in Visual Studio Code.
Fork notice: This extension is a fork of gc-excelviewer by GrapeCity/MESCIUS.
The original extension requires a paid Wijmo license. This fork replaces Wijmo with
free, open-source alternatives: AG Grid Community (MIT)
for the data grid, and SheetJS (Apache 2.0) for Excel parsing.
Usage
CSV files
Open any .csv, .tsv, or .tab file. Use the explorer context menu or editor title menu to invoke Open Preview. Columns support sorting and filtering via their headers.
For plain text files with a non-standard extension, open the file in an editor and execute the CSV: Open Preview command from the command palette. You can also right-click a file tab and use Reopen Editor With → CSV Viewer.
Excel files
Open any .xlsx or .xlsm file. The custom editor opens automatically. Use the sheet tabs at the bottom to switch between sheets.
Configuration
Setting
Default
Description
csv-preview.separator
,
Column separator character
csv-preview.quoteMark
"
Quote character for cell values
csv-preview.hasHeaders
true
Treat first row as column headers
csv-preview.capitalizeHeaders
true
Capitalize header names
csv-preview.resizeColumns
none
Auto-resize columns: all, first, or none
csv-preview.lineNumbers
none
Show line numbers: ordinal, source, or none
csv-preview.commentCharacter
#
Character that marks comment lines
csv-preview.skipComments
false
Omit comment lines from the preview
csv-preview.formatValues
never
Apply number formatting: always, unquoted, or never
