📊 Excel to JSON Converter

Easily convert Excel (.xlsx, .xls, .csv) files into JSON format using this lightweight and efficient package and a simple and lightweight npm package that allows you to convert JSON data into an Excel (.xlsx, .xls) file using the xlsx (SheetJS) library.

🚀 Installation

Install the package using npm or yarn:

1npm install quick-excel-json
2yarn add quick-excel-json

📖 Usage

1import { useState } from 'react';
2import { fileHandler, handleExportHandler } from "quick-excel-json";
3
4// JSON data for testing
5const jsonData = [
6  { id: 1, name: "Ali", age: 25 },
7  { id: 2, name: "Vali", age: 30 },
8  { id: 3, name: "Hasan", age: 28 }
9];
10
11function Example() {
12  const [excelFile, setExcelFile] = useState(null);
13  const [jsonFile, setJsonFile] = useState(null);
14  const [data, setData] = useState([]);
15
16  // excel to json
17  const handleFile = async () => {
18    try {
19      const result = await fileHandler(excelFile);
20      setData(result);
21    } catch (error) {
22      console.error("Error reading file:", error);
23    }
24  }
25
26  // json to excel
27  const handleExport = () => {
28    if (jsonFile) {
29      handleExportHandler(jsonFile); // sending json data
30    }
31  };
32
33  // json to excel
34  const handleExportWithoutFile = () => {
35    handleExportHandler(jsonData); // sending json data
36  };
37
38  return (
39     <>
40      <div>
41        <div style={{ display: "flex", alignItems: "center", justifyContent: "space-between", gap: "12px" }}>
42          <div>
43            <input
44              type="file"
45              accept='.xls, .xlsx, .csv'
46              id='upload_file'
47              onClick={e => e.target.value = null}
48              onChange={event => setExcelFile(event.target.files[0])}
49            />
50            <button type='button' onClick={handleFile}>Convert to JSON format</button>
51          </div>
52
53          <div style={{ width: "2px", height: "30px", background: "#000" }}></div>
54
55          <div style={{ display: "flex", alignItems: "center", gap: "12px" }}>
56            <input
57              type="file"
58              accept='.json'
59              id='upload_file'
60              onClick={e => e.target.value = null}
61              onChange={event => setJsonFile(event.target.files[0])}
62            />
63            <button onClick={handleExport}>Export to Excel with file</button>
64            <button onClick={handleExportWithoutFile}>Export to Excel without file</button>
65          </div>
66        </div>
67
68        <pre>
69          {data}
70        </pre>
71      </div>
72    </>
73  )
74}
75
76export default Example;

Example

Click here to view. here

🎯 Features

✅ Supports .xlsx, .xls, .csv formats ✅ Works in both React and Node.js ✅ Fast and lightweight ✅ Convert JSON to Excel (.xlsx) format
✅ Easy to use with React & Node.js
✅ No external dependencies (only xlsx)

Development

To contribute or make changes, clone the repository and install dependencies:

1git clone https://github.com/hikmatjan1/from_excel_to_json.git
2cd from_excel_to_json
3npm install

Run the development server:

1npm run dev

Keywords

quick-excel-json, excel, xlsx, xls, csv, json, excel-to-json, json-to-excel, json, json-to-sheet, xlsx-to-json,convert json to excel, csv-to-json, excel-parser, convert excel to json, spreadsheet to json, json to spreadsheet, spreadsheet, data-converter, excel-to-json-converter,json-to-excel-converter, exceljs, sheetjs,jsonjs, json extractor, fast excel parser,fast json parser, react excel parser, react json parser, sheet-to-json, exceljs-transform,xlsx-json-parser, json-xlsx-parser, excel-to-json-converte"

📜 License MIT