Indlela yokuguqula i-PDF ibe yi-Excel: Izindlela ezisebenza ngempela

Unedatha evaleleke ku-PDF futhi uyidinga ku-Excel. Mhlawumbe umbiko wezezimali, i-invoyisi, noma ithebula ledatha yomkhiqizo. Inkinga? Ama-PDF awakhelwanga ukuhlelwa—akhelwe ukubukeka efana yonke indawo.

Nansi indlela yokuthola leyo datha kuspredishithi ongasebenza ngaso.

Kungani ukuguqula i-PDF ibe yi-Excel kukhohlisa

Ama-PDF namaspredishithi e-Excel anezinhloso ezihluke ngokuphelele. I-PDF igcina ukuhleleka kokubukwayo—empeleni iwukuphrinta kwedijithali. I-Excel ihlela idatha ibe yimigqa namakholomu ukuze kubalwe futhi kuhlaziywe.

Inselele? Ama-PDF awanalo ulwazi lwesakhiwo njengoba kwenza amathebula e-HTML. Azikho omaka be-<table>, <tr>, noma <td> abatshela isofthiwe ukuthi imigqa namakholomu aqala kuphi futhi agcine kuphi. Isiguquli kufanele siqagele ngokusekelwe ekubekweni kokubukwayo.

Lokhu kungafani okuyisisekelo yingakho ukuguqula okuqondile kuvame ukukhiqiza imiphumela engahlelekile: amakholomu ayahlangana, izinombolo zigcina zingumbhalo, futhi ukufometha kuyonakala.

Indlela yoku-1: Ukungenisa okwakhelwe ngaphakathi kwe-Microsoft Excel

Uma une-Excel 2019 noma eyakamuva (kuhlanganise ne-Microsoft 365), ungangenisa idatha ye-PDF ngqo usebenzisa i-Power Query.

Indlela yokukwenza

1. Vula i-Excel bese uya ku-Data → Get Data → From File → From PDF
2. Khetha ifayela lakho le-PDF
3. I-Power Query ibonisa amathebula atholakalayo—khetha lelo olidingayo
4. Chofoza u-Transform Data ukuze uhlanze ukungenisa, noma u-Load ukuze ulingenise ngqo kuspredishithi sakho

Ubuhle nokubi

Isebenza kahle ku: Ama-PDF ahlanzekile, ahleleke kahle anamathebula alula

Inobunzima ku: Izinhlelo eziyinkimbinkimbi, amaseli ahlanganisiwe, amathebula anamakhasi amaningi

Qaphela: Lesi sici asitholakali ezinguqulweni ze-Mac ze-Excel.

Indlela yesi-2: I-Adobe Acrobat

I-Adobe Acrobat (inguqulo ekhokhelwayo, hhayi i-Reader nje kuphela) ingakhipha ama-PDF ngefomethi ye-Excel ngqo.

Indlela yokukwenza

1. Vula i-PDF yakho ku-Acrobat
2. Ya ku-File → Export To → Spreadsheet → Microsoft Excel Workbook
3. Khetha indawo ozogcina kuyo

I-Adobe iphinde inikeze isiguquli se-inthanethi samahhala esinokusetshenziswa okulinganiselwe.

Ubuhle nokubi

Isebenza kahle ku: Ama-PDF adalwe ngamathuluzi we-Adobe, amadokhumenti omdabu (hhayi askanyiwe)

Inobunzima ku: Amadokhumenti askanyiwe, ukufometha okuyinkimbinkimbi

Indlela yesi-3: Iziguquli ze-inthanethi

Amathuluzi amaningana wamahhala aku-inthanethi aguqula i-PDF ibe yi-Excel ngaphandle kokudinga ukufakwa kwesofthiwe.

Izinketho ezidumile

Ithuluzi	Ilungele	Imikhawulo
Smallpdf	Ukuguqula okusheshayo	Imikhawulo yansuku zonke kuleveli yamahhala
iLovePDF	Ukucubungula ngamaqoqo	Imikhawulo yosayizi wefayela
PDF2Go	Amathebula alula	Ingase ibe nobunzima ngezinhlelo eziyinkimbinkimbi

Ukucatshangelwa kobumfihlo

Lapho usebenzisa iziguquli ze-inthanethi, ifayela lakho liyalayishwa kumaseva azo. Ngodatha yezimali ebucayi, cabanga ngezindlela ezingaxhunyiwe ku-inthanethi noma amathuluzi acubungula amafayela endaweni yakho kusiphequluli sakho.

Indlela yesi-4: Kopisha bese unamathisela (Ngokwenza)

Ngezinye izikhathi indlela elula iyasebenza—ikakhulukazi ngenani elincane ledatha.

Indlela yokukwenza

1. Vula i-PDF bese ukhetha ithebula ngegundane lakho
2. Kopisha (Ctrl+C noma Cmd+C)
3. Namathisela ku-Excel (Ctrl+V noma Cmd+V)
4. Sebenzisa u-Data → Text to Columns ukuze ulungise izinkinga zokufometha

Lapho lokhu kusebenza khona

Le ndlela ingcono kakhulu kumathebula alula, anekhasi elilodwa lapho udinga kuphela ukukhipha okusheshayo. Lindela ukuchitha isikhathi uhlanza imiphumela.

Izinkinga ezivamile nokuthi zingalungiswa kanjani

Izinombolo ezingeniswe njengombhalo

I-Excel ingase iphathe izinombolo zakho njengemichungechunge yombhalo, okumisa ukubala.

Ukulungisa: Khetha ikholomu, uya ku-Data → Text to Columns, chofoza u-Finish. Noma phindaphinda amaseli ngo-1 ukuze uphoqe ukuguqulwa.

Amakholomu ahlanganiswe ndawonye

Idatha evela kumakholomu amaningi igcina iseli elilodwa.

Ukulungisa: Sebenzisa u-Text to Columns ngesihlukanisi (isikhala, ukhefana, noma ububanzi obugxilile) ukuze uhlukanise idatha.

Idatha engekho

Okunye okuqukethwe akuveli ekuguqulweni.

Ukulungisa: Zama ithuluzi lokuguqula elihlukile—ngalinye liphatha izinhlelo ngendlela ehlukile. Kuma-PDF askanyiwe, udinga ikhono le-OCR (optical character recognition).

Ukufometha okulahlekile

Imibala, amafonti, nemingcele yamaseli kuyanyamalala.

Ukulungisa: Iziguquli eziningi zigxila kudatha, hhayi ukufometha okubukwayo. Uzodinga ukufaka kabusha ukufometha ngokwakho ku-Excel.

Amathiphu emiphumela engcono yokuguqula

Sebenzisa ama-PDF omdabu lapho kungenzeka khona

Ama-PDF adalwe ngedijithali (kusuka ku-Word, Excel, noma isofthiwe yokubala) aguquka kangcono kakhulu kunamadokhumenti ephepha askanyiwe. Uma unenketho, cela izinguqulo zedijithali.

Hlola ikhono le-OCR

Uma i-PDF yakho iyisithombe esiskanyiwe, udinga isiguquli esine-OCR. Bheka lesi sici ngokukhethekile—Smallpdf kanye ne-Adobe Acrobat zombili ziyasinikeza.

Njalo qinisekisa okukhiphayo

Asikho isiguquli esiphelele. Ngemva kokuguqula:

• Hlola ukuthi inani lemigqa namakholomu liyahambisana yini nelokuqala
• Qinisekisa izinombolo ezimbalwa uziqhathanisa nomthombo
• Bheka idatha ehlanganisiwe noma engekho

Lokhu kuthatha umzuzu futhi konga amahora wokuxazulula izinkinga kamuva.

Cabangela uhlobo lwedokhumenti

Izinhlobo ezahlukene zama-PDF zidinga izindlela ezahlukene:

Uhlobo lwedokhumenti	Indlela engcono kakhulu
Izitatimende zasebhange	Iziguquli zezimali ezikhethekile
Ama-invoyisi	I-Adobe Acrobat noma amathuluzi e-inthanethi
Imibiko yedatha	I-Power Query (eyakhelwe ngaphakathi ku-Excel)
Amadokhumenti askanyiwe	Amathuluzi anamandla we-OCR

Lapho ukuguqula kunganele khona

Ngezinye izikhathi asikho isiguquli esingakhipha idatha yakho kahle. Lokhu kuvame ukwenzeka nge:

• Amadokhumenti aklanywe kakhulu anezinhlelo eziyinkimbinkimbi
• Ama-PDF anedatha ehlanganisa amakholomu amaningi ngokungaguquki
• Amadokhumenti askanyiwe anekhwalithi yesithombe ephansi
• Amafayela avikelwe ngephasiwedi (susa isivikelo kuqala)

Kulezi zimo, ukufaka idatha ngokwakho noma isofthiwe ekhethekile eklanyelwe uhlobo lwedokhumenti yakho ethile kungase kube ukuphela kwenketho ethembekile.

Imibuzo Evame Ukubuzwa

Ngingakwazi yini ukuguqula i-PDF evikelwe ngephasiwedi ibe yi-Excel?

Uzodinga ukususa isivikelo sephasiwedi kuqala. Uma uyazi iphasiwedi, vula i-PDF kusibukeli esifana ne-Adobe Reader, phrinta ku-PDF ngaphandle kwesivikelo, bese uyaguqula. Uma ungenayo iphasiwedi, xhumana nanoma ubani odale idokhumenti.

Kungani izinombolo zami zivela njengombhalo ku-Excel?

Ama-PDF awehlukanisi phakathi kwezinombolo nombhalo—wonke angamagama nje ekhasini. Lapho i-Excel ingenisa le datha, ingase ikhethe ukufometha kombhalo ngokuzenzakalelayo. Sebenzisa u-Data → Text to Columns noma uphindaphinde ngo-1 ukuze uguqule.

Iyiphi indlela enikeza imiphumela enembe kakhulu?

Kuncike kudokhumenti yakho. Kuma-PDF omdabu anamathebula alula, i-Power Query ye-Excel ivame ukusebenza kahle. Kuma-dokhumenti ayinkimbinkimbi, i-Adobe Acrobat noma iziguquli ezikhethekile zivame ukusebenza kangcono. Ukuphela kwendlela yokwazi ukuzama ifayela lakho elithile.

Ngingakwazi yini ukuguqula ama-PDF amaningi ngesikhathi esisodwa?

Yebo, kodwa izindlela ziyahlukahluka. Amanye amathuluzi e-inthanethi afana ne-iLovePDF asekela ukuguqulwa kwamaqoqo. I-Power Query ingangenisa namafayela amaningi ngokuhlelwa okuthile. Ngokucubungula amaqoqo okuvamile, isofthiwe yedeskithophu efana ne-Adobe Acrobat Pro isebenza kahle kakhulu.

Ingabe ikhona indlela yokuzenzakalela ukuguqulwa kwe-PDF ibe yi-Excel?

Ukuxhumana kwe-Power Query kungavuselelwa ngokuzenzakalelayo lapho umthombo we-PDF uvuselelwa. Ngokuzenzakalelayo okuthuthuke kakhulu, amathuluzi wokuhlela afana ne-Python anemitapo yolwazi efana ne-Tabula noma i-Camelot angacubungula ama-PDF ngokohlelo.

Isifinyezo

Ukuguqula i-PDF ibe yi-Excel akuhlali kuqondile, kodwa unezinketho:

• Excel Power Query yamathebula alula, ahleleke kahle
• Adobe Acrobat yemiphumela ethembekile kuma-PDF omdabu
• Iziguquli ze-inthanethi zezidingo ezisheshayo, zezikhathi ezithile
• Kopisha-namathisela ngokwakho kokukhishwayo okuncane, okulula

Isihluthulelo siwukufanisa indlela yakho nohlobo lwedokhumenti yakho—futhi njalo uqinisekise imiphumela ngaphambi kokuthembela kudatha eguquliwe.