JSON paste ya drop karein — API response, records ka array, yahan tak ki NDJSON bhi — aur nested keys ko columns mein flatten karke ek typed .xlsx workbook paayein, sab aapke browser mein.
JSON to Excel Converter
JSON paste ya drop karein — API response, records ka array, yahan tak ki NDJSON bhi — aur nested keys ko columns mein flatten karke ek typed .xlsx workbook paayein, sab aapke browser mein.
Aapka JSON aapke device par parse aur convert hota hai. ArrayKit ko kuch upload nahi hota, isliye private data wale API responses aur exports aapke paas hi rehte hain.
JSON to Excel Converter API, log ya database export se paste kiye gaye data ko aise workbook mein badal deta hai jise aap sort aur filter kar sakte hain. Yeh objects ka array, kai arrays rakhne wala object, arrays ka array, ek single record aur newline-delimited JSON sab accept karta hai. Nested objects ko address.city jaise naam wale columns mein flatten kiya jaata hai, aur record ke andar ki lists ke saath kya ho, yeh aap tay karte hain: unhe ek cell mein jodein, tags[0] jaise columns mein phailayein, har item ke liye ek row mein todein, ya parent_row column se jude child sheet par bhejein. Numbers numbers hi rehte hain, true aur false booleans rehte hain, null khaali cell ban jaata hai, aur ISO date strings asli Excel dates ban sakti hain. Agar JSON invalid ho to error line aur column ka naam batata hai. Bade documents tukdon mein process hote hain, poori tarah aapke device par.
Features
Objects ke arrays, arrays ke objects, arrays ke arrays, single records aur NDJSON accept karta hai
Nested keys ko aapke chune separator se flatten karta hai, jaise address.city
Record ki lists ke liye chaar tareeke: join, columns mein phailana, har item ke liye ek row, ya child sheet
Har top-level array ke liye ek sheet, aur baaki values ke liye optional Properties sheet
Numbers aur booleans typed rakhta hai, null ko khaali karta hai, aur ISO dates ko asli dates banata hai
Column order: jaise pehli baar dikhe, alphabetical, ya aapki apni list pehle
Aise error messages jo syntax galti ki line aur column batate hain
Styled, frozen header ke saath .xlsx, ya ek sheet ke liye CSV ya saari sheets ki zip download karein
JSON to Excel kaise use karein
JSON paste karein, .json ya .ndjson file drop karein, ya koi example load karein
Tay karein ki record ke andar ki lists kaise sambhaali jaayein aur preview mein flatten hue columns check karein
Chaahein to data.items jaisi start key set karein, columns ka order badlein aur header styling chunein
.xlsx download karein, ya sirf ek sheet chahiye to CSV
id | name | joined | address.city | tags
1 | Ann | 2024-03-05 | Leeds | admin, beta
2 | Bo | 2024-04-18 | Austin |
Nested city apna alag column ban gaya, list ek cell mein jud gayi, aur joined ek asli Excel date hai.
Common errors aur troubleshooting
Converter ek line aur column par error batata hai. — Us position par jaayein: aam wajah hain band hone wale bracket se pehle trailing comma, double quotes ke bajaye single quotes, bina quote wali key, ya do items ke beech comma ka na hona. Message batata hai ki inmein se kaun mila.
Sirf ek sheet dikhti hai, jabki JSON mein kai lists hain. — Records ke andar ki lists by default ek cell mein jud jaati hain. Lists inside a record ko Separate sheet par badlein taaki child sheet mile, ya woh object paste karein jo lists ko top level par rakhta ho.
Date 2024-03-05T09:30:00Z jaise text ke roop mein dikhti hai. — Dates become real dates on karein. Sirf poori ISO 8601 values convert hoti hain; 03/05/2024 jaise doosre formats text hi rehte hain kyunki unka order saaf nahi hota.
Spreadsheet mein JSON ke records se kahin zyada rows hain. — One row per item chuna hua hai, isliye har list item ek row ban gaya. Har record ke liye ek row rakhne ke liye Join into one cell ya Spread across columns chunein.
Aksar pooche jaane wale sawaal
JSON to Excel Converter nested objects ko kaise flatten karta hai?
Har nested key ek column ban jaati hai jiske naam mein path separator ke saath judta hai, isliye {"user": {"city": "Leeds"}} se user.city milta hai. Separator badla ja sakta hai, aur agar do keys ek hi naam mein flatten hoti hon to doosri ko pehli ko overwrite karne ke bajaye (2) suffix mil jaata hai.
JSON record ke andar objects ke array ka kya hota hai?
Aap chunte hain. Join use ek cell mein likhta hai, Spread across columns items[0].name style columns banata hai, One row per item har row par parent fields dohraata hai, aur Separate sheet items ko ek child sheet mein likhta hai jiske parent_row column mein parent record ka Excel row number hota hai.
Kya main newline-delimited JSON ko Excel mein convert kar sakta hoon?
Haan. Agar text mein har line par ek JSON value ho, to converter har line ko ek record ki tarah padhta hai, aur kharab line ki report uske line number se hoti hai. Isme .ndjson aur .jsonl exports aur log files aati hain.
JSON numbers numbers kyun rehte hain lekin digit strings text kyun rehti hain?
Converter har value ko wahi type deta hai jo JSON deta hai. 42 jaisa number numeric cell banta hai, jabki "02134" jaisi string text rehti hai, isliye strings ke roop mein likhe IDs aur ZIP codes kabhi nahi badalte.
JSON to Excel Converter bahut badi files kaise sambhaalta hai?
Yeh records ko tukdon mein process karta hai taaki page chalta rahe, aur pehli 50 rows ka preview dikhata hai. Vyavhaarik seema aapke device ki memory aur Excel ki har sheet mein 1,048,576 rows hai, jiske baare mein tool chetavni deta hai.
Spreadsheet ko wapas JSON mein kaun sa tool badalta hai?
Ulte rukh ke liye Excel to JSON, ya delimited text ke liye CSV to JSON use karein. Yeh tool sirf JSON se workbook ki taraf jaata hai, isliye aapka paste kiya hua original JSON kabhi nahi badalta.
Related tools
JSON se CSV — Flat JSON objects ke array ko CSV mein convert karein.
Excel to JSON Converter — Ek .xlsx ya .xls file drop karein aur kisi bhi sheet ko typed cells wale JSON mein badlein.
CSV to Excel — CSV ya TSV files ko browser mein formatted .xlsx workbook banayein: delimiter detection, header styling, column types aur kai sheets.
JSON Formatter — JSON ko beautify, minify aur validate karein, error ki location ke saath.
JSON to SQL — JSON array ko CREATE TABLE aur batched INSERTs mein badlein.
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 JSON Converter — CSV ya TSV ko type inference aur nesting ke saath saaf JSON mein badlein, sab browser mein.
Excel & Spreadsheets ke aur tools
Excel Data Cleaner — Ganda spreadsheet saaf karein: spaces trim, case theek, blanks aur duplicates hatayein, dates aur numbers standardise karke .xlsx ya CSV export karein.
VLOOKUP Formula Generator — Sahi VLOOKUP formula step by step banayein: IFERROR, exact ya approximate match, XLOOKUP aur INDEX MATCH alternatives aur live test.
INDEX MATCH Formula Generator — Left lookup, two-way lookup aur multiple criteria ke liye INDEX MATCH formulas banayein, live test table aur copy-ready output ke saath.
Excel Formula Explainer — Koi bhi Excel ya Google Sheets formula paste karein aur har function aur argument ka aasaan bhasha mein step-by-step breakdown paayein.
Excel Formula Generator — Conditional sums, lookups, dates, text splitting ya ranking jaisa task chunein aur paste-ready Excel ya Google Sheets formula paayein.
Excel Function Translator — Excel formulas ko English, German, French, Spanish, Italian, Portuguese, Dutch, Swedish aur Russian ke beech sahi separators ke saath translate karein.
Excel VBA Macro Generator — Tasks ki library se ready-to-run VBA macros banayein (loops, blank rows hatana, sheets PDF mein export, mail aur aur bhi) apni ranges aur naamon ke saath.
CSV to Excel — CSV ya TSV files ko browser mein formatted .xlsx workbook banayein: delimiter detection, header styling, column types aur kai sheets.