: Use the utils.json_to_sheet() function, which automatically maps JSON keys to column headers.
Exporting JSON data to a downloadable Excel file in JavaScript is a standard requirement for modern web applications. Whether you are building an admin dashboard or a data reporting tool, users often need to move data from a browser into a spreadsheet for offline analysis.
You can manually construct an HTML table string from your JSON and encode it into a data URI. While this technically creates a file that Excel can open, it is often saved as a legacy .xls format (XML spreadsheet), which may trigger a "file format mismatch" warning in modern versions of Microsoft Excel. Iterate through JSON objects to build and tags. json to excel download javascript
: Use the built-in writeFile() method to save the file locally. javascript
This method uses the and a temporary download link to trigger the browser's save functionality. : Use the utils
: For a better user experience, calculate the maximum length of the data in each column and adjust the worksheet's !cols property to prevent text truncation. Javascript JSON to Excel file download - Stack Overflow
import * as XLSX from 'xlsx'; function downloadExcel(jsonData) { // 1. Create a worksheet from the JSON data const worksheet = XLSX.utils.json_to_sheet(jsonData); // 2. Create a new workbook and add the worksheet const workbook = XLSX.utils.book_new(); XLSX.utils.book_append_sheet(workbook, worksheet, "Report"); // 3. Export the workbook as an .xlsx file XLSX.writeFile(workbook, "DataReport.xlsx"); } Use code with caution. 2. The Lightweight Alternative: Exporting to CSV You can manually construct an HTML table string
SheetJS (also known as the xlsx library) is the industry standard for spreadsheet operations in JavaScript. It handles complex tasks like multiple sheets, cell formatting, and creating true .xlsx files rather than just text-based CSVs.
: You can use a CDN like cdnjs or install it via npm.
If you don't need formatting (like bold headers or colored cells) and want to keep your application's bundle size small, exporting to (Comma-Separated Values) is the fastest method. Excel can open CSV files natively.