Excel to JSON Converter

Ek .xlsx ya .xls file drop karein aur kisi bhi sheet ko saaf JSON mein badlein, seedhe aapke browser mein. Aapki spreadsheet kabhi aapke device se bahar nahi jaati.

Excel to JSON converter aapke workbook ko poori tarah aapke browser mein parse karta hai. File aur uska har cell aapke device par rehte hain aur kabhi ArrayKit ko upload nahi hote.

CSV to JSON converter kholein

Excel to JSON Converter ke baare mein

Excel to JSON converter ek workbook ko browser chhode bina structured JSON mein badal deta hai. Ek .xlsx ya .xls file drop karein, jo sheet chahiye woh pick karein, aur shape chunein: header row se keyed objects ka ek array, ya har row ka ek raw 2-D array. Cell values apna type rakhti hain — numbers numbers hi rehte hain, checkboxes true ya false ban jaate hain, aur date cells ISO 8601 strings ke roop mein emit hote hain taaki woh downstream saaf parse hon. Blank rows skip ho jaati hain aur duplicate ya empty header names automatically unique ban jaate hain, isliye output seedhe ek API request, ek seed script, ya ek test fixture mein girta hai. Yeh un developers, analysts aur QA engineers ke liye bana hai jo stakeholders se spreadsheets paate hain aur seconds mein JSON chahiye. Poora workbook aapke device par parse hota hai — kuch upload nahi hota.

Features

Excel to JSON Converter kaise use karein

  1. Apni .xlsx ya .xls file drop zone par drop karein, ya browse karne ke liye click karein
  2. Sheet dropdown se jo sheet chahiye woh chunein
  3. 'Array of objects' ya '2-D array' pick karein aur header row toggle karein
  4. JSON copy karein ya use ek .json file ke roop mein download karein

Example

Input

Sheet1:
name   age  active
Ada    36   TRUE
Linus  54   FALSE

Output

[
  { "name": "Ada", "age": 36, "active": true },
  { "name": "Linus", "age": 54, "active": false }
]

Header row object keys ban jaati hai; number aur boolean cells apna type rakhte hain.

Common errors aur troubleshooting

Aksar pooche jaane wale sawaal

Main ek Excel .xlsx file ko JSON mein kaise convert karoon?
.xlsx file drop zone par drop karein, jo sheet chahiye woh chunein, aur har row ko header row se key karne ke liye 'Array of objects' pick karein. Phir JSON copy karein ya use ek .json file ke roop mein download karein. Sab kuch aapke browser mein chalta hai.
Kya yeh numbers, dates, aur TRUE/FALSE ko unke asli types ke roop mein rakhta hai?
Haan. Numeric cells numbers hi rehte hain, boolean cells true ya false ban jaate hain, aur date-formatted cells ISO 8601 strings mein convert hote hain taaki woh kisi bhi language mein sahi parse hon. Blank cells null ban jaate hain.
Kya main chun sakta hoon ki multi-tab workbook ki kaunsi sheet convert karni hai?
Haan. Jab workbook mein ek se zyada sheet ho, ek Sheet dropdown dikhta hai taaki aap tabs switch kar sakein; selected sheet ke liye JSON file re-import kiye bina turant update hota hai.
'Array of objects' aur '2-D array' mein kya farak hai?
'Array of objects' pehli row ko keys ke roop mein use karta hai aur har baad ki row ko ek object mein badalta hai. '2-D array' bina header handling ke har row ko cell values ke ek array ke roop mein return karta hai, raw grid se matching.
Empty ya duplicate column headers ka kya hota hai?
Empty headers apni position se 'Column 1', 'Column 2' waghairah naam paate hain, aur repeated headers ek numeric suffix (name, name_2) paate hain, taaki har object key unique rahe aur koi data na khoye.
Kya meri spreadsheet convert karne ke liye ek server par upload hoti hai?
Nahi. Workbook poori tarah aapke device par ek in-browser reader se parse hota hai. File aur uska content kabhi aapke computer se bahar nahi jaate aur ArrayKit ya kahin aur nahi bheje jaate.

Related tools

Saare ArrayKit tools