← Tools

PDF se Excel

PDF ki tables ko Excel spreadsheet mein badlein.

Aapki file surakshit tarike se upload hoti hai, convert hoti hai, phir turant delete ho jaati hai.

ya yahan drop karein

50 MB tak ki files.

Kaise kaam karta hai

  1. Apni files chunein.
  2. Chahein to settings badlein.
  3. Result download karein, ya BroAllDone se doosre device par bhejein.

PDF ko Excel mein kaise convert kare, bina ek bhi number dobara type kiye

PDF ko Excel mein kaise convert kare, yeh sawal aksar ITR ke time aata hai. CA sahab ne bola "pichhle chhe mahine ka bank statement Excel mein bhej do", aur bank ne diya hai PDF. Har page par 40 transactions. PDF se copy-paste karo toh saara text ek lambi column mein ulta-seedha chipak jaata hai. Haath se type karo toh poori shaam jaayegi, aur kahin September mein do digit aage-peeche ho hi jaayenge.

Yeh converter wahi boring kaam karta hai. PDF dijiye, yeh tables dhoondhta hai aur har value ko XLSX file ke alag cell mein likh deta hai. Amounts asli numbers bante hain, jinhe SUM formula samajhta hai. Neeche bataya hai ki yeh tables kaise padhta hai, kahan andaza lagata hai, aur jo do-chaar cheezein galat aayein unhe kaise theek karein.

PDF ki table Excel mein kaise pehchani jaati hai?

PDF ko pata hi nahi hota ki uske andar table hai. Woh bas itna yaad rakhti hai: "yeh shabd, is jagah, is font mein". Isliye table ko do tarah ke ishaaron se dobara banana padta hai.

Kheenchi hui lines. Table mein borders ya shaded rows hain, toh wahi lines cells ki seema bata deti hain. Yeh sabse bharosemand case hai: merged cells Excel mein bhi merged rehte hain, shaded cells ka rang bana rehta hai, aur borders bhi saath aate hain.

Columns mein line se lage words. Bahut se bank statements mein ek bhi line nahi hoti, bas text columns mein seedha laga hota hai. Yahan converter har seedhi column ko spreadsheet ka column maanta hai aur har line ko ek row. Agar description doosri line mein chali jaaye (jaise koi lamba UPI merchant ka naam), toh woh line upar wali row se jud jaati hai, alag row nahi banti.

Table ke aas-paas jo bhi hai, jaise bank ka naam, aapka address ya neeche ka koi note, woh table ke upar ya neeche apni alag rows mein aata hai. Page ki koi cheez chupke se gaayab nahi hoti. Haan, logo aur pictures chhod diye jaate hain.

Kya Excel mein numbers, rupaye aur dates sahi chalenge?

Spreadsheet kaam ki hai ya nahi, yeh isi se tay hota hai. Har cell check hota hai, aur jo bhi number, amount, percentage ya date jaisa dikhe, woh asli value ki tarah, matching Excel format ke saath save hota hai:

PDF mein Excel cell mein
1,250.50 Number 1250.5, thousands separator ke saath
$853.34, £853.34, Rp 1.500.000, 12,800円 Asli number, symbol ke saath money format mein (symbol aage ho ya peeche)
₹1,20,000 120000, Indian lakh wali grouping ke saath
(450.00) -450, brackets mein, jaise accounts mein likhte hain
12.5% 0.125, percentage format mein
31/03/2026, 2026-03-31, 2026/03/05, 31 Mar 2026, 5 de marzo de 2026 Asli date, jise sort aur filter kar sakein
00123 (koi ID ya code) Text hi rehta hai, taaki aage ke zero na udein
16 digit ka card ya account number Text hi rehta hai, taaki Excel use round na kare

Europe wale numbers, jaise 1.234,56, bhi pehchane jaate hain. Converter dekhta hai ki poore document mein numbers kaise likhe hain, aur usi hisaab se decimal ka nishaan chunta hai. Dot se likhe poore amounts, jaise 1.250.000 ya 250.000, bina decimal wale document mein bhi sahi padhe jaate hain: 250.000 ka matlab 250000 hi hota hai. $ € £ ¥ ₹ ₩ ₽ ₺ ₫ ৳ ke saath Rs, Tk, Rp, TL, USD, EUR, INR jaise code bhi amount ke aage ya peeche pehchane jaate hain. Akela "TL" likha cell text hi rehta hai.

Asli dikkat 03/04/2026 jaisi dates mein hai. Har column ko pehle din, phir mahina maankar padha jaata hai, jab tak us column mein koi aisi date na mile jo sirf mahina-pehle mein hi sense banati ho, jaise 04/23/2026. Hamare yahan ke statements mein yeh theek baithta hai. Lekin US ka koi statement jiske ek column ki saari dates 12 tareekh ya usse pehle ki hon, din-pehle wale tareeke se padha jaayega. Isliye dates par ek nazar zaroor daal lijiye.

Bank statement PDF ko Excel mein kaise convert kare

Zyadatar statements kai pages ke hote hain, aur aapko chahiye ek lambi list, har page ka alag tukda nahi. Jab table agle page par same columns ke saath chalti rehti hai, toh converter use usi sheet mein jod deta hai. Agar agle page par column titles dobara chhape hain, toh woh repeat wali header row hata di jaati hai. Sheets ka naam pages ke hisaab se padta hai, jaise "Page 1" ya "Pages 2-5".

Yeh jodna tabhi hota hai jab naya page table se hi shuru ho. Agar bank page 2 par table ke upar koi summary box ya "continued" wali patti chhaapta hai, toh us page ki alag sheet banegi, aur uski rows aapko khud pehli table ke neeche copy karni hongi.

Karna kya hai:

  1. Ek PDF chunein par tap kijiye, ya file box mein drop kar dijiye. 50 MB aur 300 pages tak ki files chalti hain.
  2. Excel mein convert karein dabaiye. Upload hote waqt percentage badhta dikhega, phir page par "Convert ho raha hai…" aa jaayega.
  3. Download par tap kijiye. SBI_statement_march.pdf wapas aati hai SBI_statement_march.xlsx banke. Jin phones mein option hai, wahan Share se file seedhe Excel, Google Sheets ya email mein bhej sakte hain.

Kya scanned PDF ko Excel mein convert kar sakte hain?

Haan, ek had tak. Agar page sirf ek photo hai (scan kiya statement, mobile se kheencha bill), toh tables dhoondhne se pehle us par OCR, yaani text pehchanne ka kaam, chalta hai. Table ki lines scan ke andar hi dhoondhi jaati hain, toh kaagaz par lines wali table bhi asli cells ban sakti hai. Tedhe ya karwat wale scans pehle seedhe kiye jaate hain. Agar scanner ne pehle se chhupi hui text layer daal di hai, toh wahi text use hota hai.

Pech yeh hai ki OCR sabse kamzor digits par hota hai, aur aapko chahiye bhi wahi. Dhundhla 8 ban jaata hai 3, aur Excel kuch nahi bolega. Isliye totals kaagaz se milaiye. Ek file mein 100 scanned pages tak padhe jaate hain. Bada scan ho toh pehle PDF Split Karein se tod lijiye. Is Hinglish page par scans Hindi (Devanagari) aur English dono mein padhe jaate hain. Statement kisi aur bhasha mein ho, jaise Bangla ya Arabic, toh convert karne se pehle page ke neeche wale menu se site ki language badal lijiye. Har language version apni lipi aur English padhta hai.

Excel mein PDF wali table ko saaf kaise kare

Achhe conversion ke baad bhi aam taur par paanch minute ki safai lagti hai. Yeh fixes zyadatar kaam sambhal lete hain.

Ek cell mein do values chipki hain. Kabhi date aur description, ya amount aur "Cr" saath aa jaate hain. Column select kijiye, phir Data → Text to Columns, Delimited chunein, Space par tick lagaiye (ya jo bhi cheez dono ko alag karti hai), aur Excel unhe agle columns mein baant dega. Pehle right side mein ek khaali column daal lijiye, taaki kuch overwrite na ho.

Amounts jud nahi rahe. SUM 0 de raha hai, matlab woh cells text hain. Aam wajahein: peeche laga minus (450.00-), number se chipka "Cr" ya "Dr", ya koi aisa currency shabd jo converter ki list mein nahi hai. Find and Replace (Ctrl+H) se " Cr" jaisi cheezein hataiye, phir us column par Text to Columns → Finish chalaiye. Isse Excel cells ko dobara numbers ki tarah padhta hai. Peeche wale minus ke liye Text to Columns mein Advanced button hai, jisme "Trailing minus for negative numbers" milta hai.

Dates ulti hain ya text bani hui hain. Bina saal wali dates ("31 Mar") ya mahine ke naam ke baad do digit wale saal ("31-Mar-26") text hi rehti hain. 26.03.31 jaisi chhoti dotted dates din-mahina-saal maani jaati hain. Phir se Text to Columns, aur step 3 mein Date chunkar sahi order (DMY ya MDY) lagaiye.

Beech mein header rows dohraayi hui hain. Agar kisi page ke titles repeat ki tarah pehchane nahi gaye, toh woh beech mein ek extra row ban jaate hain. Data → Filter on kijiye, pehle column ko header shabd (jaise "Date") se filter kijiye, dikh rahi rows delete kijiye, aur filter hata dijiye.

Number format. Column select karke Ctrl+1 dabaiye aur Number, Currency ya Accounting chunein. Andar ki values wahi rehti hain.

PDF se Excel ki limitations jo pata honi chahiye

  • Bina lines wali aur ubad-khabad spacing wali tables sabse mushkil hain. Columns toot ya jud sakte hain, khaaskar jab ek column ka text agle se sata ho.
  • Charts kuch nahi bante. PDF mein chart ke peeche ke numbers data ki tarah save nahi hote, sirf drawing ki tarah.
  • Har page par aane wale header aur footer, jaise bank ka address ya "Page 3 of 6", aam taur par spreadsheet mein nahi aate.
  • Password wali PDF par aata hai "Yeh file convert nahi ho paayi. Ho sakta hai file kharab ho ya password se protected ho." Pehle PDF Unlock Karein se password hataiye. Kharab file PDF Repair Karein ke baad shayad khul jaaye.
  • "Koi table ya text nahi mila…" ka matlab hai kisi bhi page par padhne layak kuch nahi tha, aksar aisa scan jo padha nahi ja saka.
  • Lambe scans par "Is file ko convert hone mein bahut time laga…" aa sakta hai. Chhote tukdon mein convert kijiye.

Har file par ek suraksha check bhi chalta hai: converter dekhta hai ki PDF ke shabd spreadsheet tak pahunche ya nahi. Agar bahut zyada chhoot gaye, toh woh ek simple table reader se dobara koshish karta hai aur jis result mein kam nuksaan hua, wahi rakhta hai.

Kya bank statement PDF online convert karna safe hai?

Statement kahan jaata hai, yeh aapko saaf pata hona chahiye. Yeh converter aapke browser mein nahi, hamare server par chalta hai, isliye aapki PDF encrypted connection se upload hoti hai. Convert hote waqt woh ek temporary folder mein rehti hai. Result wapas bhejte hi woh folder, aapki PDF aur spreadsheet samet, delete ho jaata hai. Conversion service ka internet tak koi raasta nahi hai, koi account nahi hai, aur na kuch rakha jaata hai na dekha jaata hai.

Agar koi document device se bahar jaana hi nahi chahiye, toh use na yahan upload kijiye na kahin aur. PDF se Text poori tarah aapke browser mein chalta hai aur raw text de deta hai. Use sheet mein paste karke Text to Columns se baant lijiye.

PDF se data nikalne ke aur tareeke

  • PDF mein zyada paragraphs hain aur beech-beech mein table: PDF se Word text ko flow mein aur tables ko editable rakhta hai.
  • Sirf shabd chahiye, jaldi aur private: PDF se Text.
  • Spreadsheet theek ho gayi aur wapas PDF bhejni hai: Excel se PDF XLSX, XLS ya CSV ko print-ready PDF bana deta hai.

Aksar poochhe jaane wale sawal

PDF ko Excel mein free mein kaise convert kare?

Apni PDF chunein, Excel mein convert karein par tap karein, phir Download. Tables ek XLSX file ban jaati hain jiska naam aapki PDF jaisa hi hota hai. Na sign-up, na watermark.

Kya bank statement PDF ko Excel mein badal sakte hain?

Haan. Lines wale aur bina lines wale, dono tarah ke statements chalte hain. Jo table same columns ke saath agle pages par chalti hai, woh ek hi sheet par judti hai aur dohraaye gaye column titles hata diye jaate hain. Bharosa karne se pehle dates aur totals check kar lijiye.

Kya numbers Excel formulas mein chalenge?

Haan. 1,250.50, $853.34, ₹1,20,000 ya Rp 1.500.000 jaise amounts, percentages aur 31/03/2026 ya 2026/03/05 jaisi dates asli values ki tarah matching format ke saath save hoti hain, toh SUM, sort aur filter turant chalte hain.

Kuch amounts text kyun ban gaye?

Peeche minus wali values (450.00-), "Cr" ya "Dr" chipke amounts, ya koi anjaan currency shabd numbers ki tarah nahi padhe jaate. Aage zero wale codes aur 15 digit se lambe numbers jaan-boojhkar text rakhe jaate hain, taaki kuch round ya kate nahi.

Kya scanned PDF Excel mein convert hoti hai?

Haan. Scanned pages pehle OCR (text pehchanne) se padhe jaate hain, aur lines wali tables scan ke andar hi dhoondhi jaati hain. Ek file mein 100 scanned pages tak padhe jaate hain, aur digits dobara check karna achha hai.

Kya bina lines wali tables bhi convert hoti hain?

Haan. Columns mein seedha laga text rows aur columns mein dobara banaya jaata hai, aur doosri line mein gayi description apni row se jud jaati hai. Ubad-khabad spacing wali tables sabse mushkil hain, unme thoda sudhaar lag sakta hai.

Meri dates ulti kyun aa rahi hain?

Number wali dates pehle din, phir mahina maankar padhi jaati hain, jab tak column mein koi aisi date na ho jo sirf mahina-pehle mein sense banaye. US style column ki saari dates 12 tareekh ya usse pehle ki hon, toh Text to Columns se MDY chunkar column theek kar lijiye.

Kya bank statement upload karna safe hai?

PDF encrypted connection se upload hoti hai, convert hoti hai, aur result wapas bhejte hi spreadsheet ke saath delete ho jaati hai. Jo file device se bahar jaani hi nahi chahiye, uske liye PDF se Text use kijiye, jo browser mein chalta hai.

File size aur pages ki limit kya hai?

50 MB aur 300 pages tak ki files. Isse badi file ho toh PDF Split Karein se todiye ya PDF Compress Karein se chhoti karke hisson mein convert kijiye.

Meri PDF Excel mein convert kyun nahi ho rahi?

Password wali PDF convert nahi hoti, toh pehle PDF Unlock Karein se password hataiye. "Koi table ya text nahi mila" ka matlab hai pages par padhne layak kuch nahi tha, aksar aisa scan jo padha nahi ja saka.

Aur free PDF tools

Saare tools dekhein