XLSX Viewer & CSV Editor - VS Code Extension

This is an open-source project that allows you to view XLSX files with styles, fonts, and colors from Excel files, supporting multiple sheets. Additionally, it provides a table view and editing capabilities for CSV files directly in VS Code.

📌 Overview

XLSX Viewer & CSV Editor is a powerful Visual Studio Code extension that allows users to open and view Excel files (.xlsx) and edit CSV files directly within VS Code. It provides a seamless, lightweight experience without requiring external software like Microsoft Excel or Google Sheets.

🚨 Important Note: This extension was previously named XLSX Viewer. It has now been renamed to XLSX Viewer & CSV Editor to reflect the added support for CSV file editing.

🚀 Features

XLSX Viewing

✅ Fast & Lightweight - View Excel spreadsheets quickly within VS Code
✅ Retains Formatting - Keeps cell styles, colors, and text formatting
✅ Multiple Sheet Support - View all sheets in your Excel workbook
✅ Toggle Background Mode - Easily switch between dark and light backgrounds
✅ Interactive Table View - Display spreadsheet data in a structured HTML table
✅ Color Detection & Conversion - Converts ARGB Excel colors into CSS-compatible formats

🆕 Merged Cells & Resizing Support (v1.5.0)

✅ Merged Cell Support - Full support for both horizontal and vertical merged cells from Excel files, with proper content alignment and original Excel formatting
✅ Interactive Resizing - Drag column/row borders to resize, with visual resize handles, hover effects, and real-time size indicators
✅ Auto-Fit Functionality - Auto-fit button and double-click to auto-fit columns/rows based on content, with smart content-based sizing and width limits

🆕 Excel-like Multi-Selection & Copy (v1.4.0)

✅ Multi-Selection for Rows/Columns - Hold Ctrl to select/deselect multiple rows or columns, Shift to select a range
✅ Excel/Google Sheets Compatible Copy - Copying and pasting preserves cell structure in Excel/Google Sheets
✅ Improved Selection Management - Visual feedback for multi-row/column selection and selection size info box in the bottom right corner.

CSV Editing

✅ Table View - Edit CSV files in a structured table format
✅ Toggle View - Switch between table and raw text views
✅ Easy Navigation - Intuitive interface for viewing and editing CSV data

🛠️ Installation

1. Open VS Code
2. Go to the Extensions Marketplace (Ctrl+Shift+X)
3. Search for XLSX Viewer & CSV Editor
4. Click Install
5. Open any .xlsx or .csv file to start viewing or editing!

Alternatively, you can install it manually using:

code --install-extension muhammad-ahmad.xlsx-viewer

📖 Usage

For XLSX Files

1. Open VS Code
2. Open an .xlsx file
3. View and analyze your data in an HTML table format
4. Use the toggle button to switch the background color
5. Navigate between sheets using the sheet selector

For CSV Files

1. Open any .csv file
2. Edit data directly in the table view
3. Use the Toggle View button to switch between table and text views
4. Changes are saved automatically

🛠️ Contributing

We welcome contributions! Feel free to submit issues, feature requests, or pull requests in the GitHub repository.

📜 License

This project is licensed under the MIT License - feel free to use and modify it.

⭐ Support

If you find this extension helpful, please rate it on the VS Code Marketplace and share it with others!

📢 Follow us for updates!
🔗 GitHub: XLSX Viewer & CSV Editor Github Link
🔗 Marketplace: VS Code Extension Link