xlsx
A JavaScript library for reading, writing, and processing spreadsheet data across Excel, CSV, and other formats.
What is xlsx?
SheetJS is a JavaScript library that provides tools for reading, writing, and manipulating spreadsheet data in various formats like Excel, CSV, and OpenDocument. It solves the problem of extracting structured data from complex spreadsheets and generating new ones that work across different software platforms.
Developers and data engineers who need to integrate spreadsheet data processing into web applications, Node.js backends, or data pipelines.
Developers choose SheetJS for its battle-tested reliability, broad format support, and truly open-source Apache 2.0 license, offering a free alternative to commercial spreadsheet automation tools.
Overview
📗 SheetJS Spreadsheet Data Toolkit -- New home https://git.sheetjs.com/SheetJS/sheetjs
Use Cases
Best For
- Extracting data from Excel files for web applications
- Generating downloadable spreadsheets from JSON data in Node.js
- Converting between spreadsheet formats (e.g., XLSX to CSV)
- Parsing complex spreadsheet templates in browser-based tools
- Automating spreadsheet data processing in serverless functions
- Building data import/export features for SaaS platforms
Not Ideal For
- Projects requiring advanced Excel features like styling, graphs, or PivotTables without purchasing the Pro version
- Real-time collaborative spreadsheet editing applications, as it focuses on file-based processing
- Applications where bundle size is critical and only basic CSV handling is needed, as SheetJS adds overhead for full format support
Pros & Cons
Pros
The README emphasizes it as 'battle-tested,' ensuring proven stability for production use in extracting data from complex spreadsheets.
Handles XLSX, XLS, CSV, OpenDocument, and more, making it versatile for legacy and modern spreadsheet interoperability.
Licensed under Apache 2.0 with no vendor lock-in, allowing free commercial use and community contributions.
Easily parses spreadsheet files into JavaScript objects, enabling quick integration for data processing in web or Node.js apps.
Cons
Community Edition lacks styling, template editing, graphs, and formula evaluation—these are exclusive to the paid Pro version.
Source and issues moved to git.sheetjs.com, while GitHub is a mirror, potentially confusing users accustomed to GitHub workflows.
Processing large or complex spreadsheets can be memory-intensive, with no built-in streaming support in the free version for optimal scaling.
Open Source Alternative To
xlsx is an open-source alternative to the following products:
Google Sheets API is a programming interface that allows developers to read, write, and update spreadsheet data programmatically.
LibreOffice Calc scripting refers to the ability to automate and extend Calc functionality using macros and scripts written in languages like Python, Basic, or JavaScript.
Microsoft Excel automation libraries are programming interfaces and tools that allow developers to automate Excel tasks, manipulate spreadsheets, and integrate Excel functionality into applications.
Frequently Asked Questions
Related Projects
webtorrent⚡️ Streaming torrent client for the web
Brain.js🤖 GPU accelerated Neural networks in JavaScript for Browsers and Node.js
Cytoscape.jsGraph theory (network) library for visualisation and analysis
PDFKitA JavaScript PDF generation library for Node and the browser
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.