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
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.
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
.xlsx, .xls, .xlsm, aur .ods workbooks drag aur drop karein
Ek dropdown se ek multi-tab workbook ki koi bhi sheet pick karein
Header row se keyed objects ka ek array, ya ek plain 2-D array output karein
File ko re-import kiye bina header row on ya off toggle karein
Types rakhta hai: numbers numeric hi rehte hain, checkboxes booleans ban jaate hain
Date cells reliable parsing ke liye ISO 8601 strings mein convert hote hain
Empty aur duplicate column headers rename ho jaate hain taaki keys unique rahein
JSON ek click mein copy karein ya use ek .json file ke roop mein download karein
Excel to JSON Converter kaise use karein
Apni .xlsx ya .xls file drop zone par drop karein, ya browse karne ke liye click karein
Sheet dropdown se jo sheet chahiye woh chunein
'Array of objects' ya '2-D array' pick karein aur header row toggle karein
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
Header row object keys ban jaati hai; number aur boolean cells apna type rakhte hain.
Common errors aur troubleshooting
JSON keys asli names ke bajaye 'Column 1', 'Column 2' hain. — Aapki header row blank hai ya aapne 'First row is header' off kar diya. Use on karein taaki pehli non-empty row keys supply kare.
Dates ek date ke bajaye 44197 jaise bade numbers mein aati hain. — Woh ek Excel serial number hai. Yeh tool date-formatted cells ko asli dates ke roop mein padhta hai aur ISO strings emit karta hai; agar koi cell plain number ke roop mein dikhe to column ko Excel mein Date ke roop mein reformat karein.
Do columns ek hi header share karte hain aur ek value doosri ko overwrite karti rehti hai. — Duplicate headers automatically suffix ho jaate hain (name, name_2, name_3) taaki har value ek unique key ke tehat preserve rahe.
Output empty hai ya sirf kuch rows dikhata hai. — Check karein ki aapne sahi sheet select ki — ek workbook mein kai ho sakti hain. Poori tarah blank rows skip ho jaati hain, isliye sheet ke gaps hat jaate hain.
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
CSV to JSON Converter — CSV ya TSV ko type inference aur nesting ke saath saaf JSON mein badlein, sab browser mein.
JSON se CSV — Flat JSON objects ke array ko CSV mein convert karein.
Excel to CSV Converter — Ek Excel workbook ki kisi bhi sheet ko delimiter aur date options ke saath saaf CSV mein export karein.
CSV to Markdown Table — CSV ya TSV ko ek GitHub-flavored Markdown table mein badlein
JSON Formatter — JSON ko beautify, minify aur validate karein, error ki location ke saath.
HTML Table to JSON — Ek HTML table paste karein aur har table ko headers ke saath JSON aur CSV mein convert karein.
JSON ke aur tools
Excel to CSV Converter — Ek Excel workbook ki kisi bhi sheet ko delimiter aur date options ke saath saaf CSV mein export karein.
CSV to SQL Converter — CSV ko MySQL, PostgreSQL, SQLite ya SQL Server ke INSERT statements mein badlein, browser mein.
HTML Table to JSON — Ek HTML table paste karein aur har table ko headers ke saath JSON aur CSV mein convert karein.
JSON Patch Generator — Do JSON docs ke beech RFC 6902 patch banayein ya apply karein
JSON Repair — Toota hua ya LLM JSON — fences, trailing commas, single quotes — theek karein
JSON to GraphQL — JSON sample se GraphQL SDL types generate karein
JSON to SQL — JSON array ko CREATE TABLE aur batched INSERTs mein badlein.
JSON Formatter — JSON ko beautify, minify aur validate karein, error ki location ke saath.
JSON Tree Viewer — JSON ko ek collapsible, typed tree ki tarah explore karein.
JSON Viewer — Text aur collapsible tree viewer, expand/collapse aur node paths ke saath.
JSON se TypeScript — Ek JSON sample se TypeScript interfaces generate karein.
JSON se CSV — Flat JSON objects ke array ko CSV mein convert karein.