Uko wahindura PDF mo Excel: Uburyo bukora neza

Ufite amakuru afungiye muri PDF kandi uyakeneye muri Excel. Wenda ni raporo y'imari, fagitire, cyangwa imbonerahamwe y'amakuru y'ibicuruzwa. Ikibazo? PDF ntizagenewe guhindurwa—zagenewe kugaragara kimwe aho ari ho hose.

Dore uko wahuza ayo makuru n'imbonerahamwe ushobora gukoresha.

Kuki guhindura PDF mo Excel bigora

PDF n'imbonerahamwe za Excel bifite intego zitandukanye rwose. PDF ibungabunga uko inyandiko igaragara—ni nk'inyandiko yacapishijwe mu buryo bwa dijital. Excel yo itunganya amakuru mu mirongo n'inkingi kugira ngo ibarurwa n'isesengura bikoreke.

Imbogamizi? PDF ntiziba zifite amakuru y'imiterere nk'uko imbonerahamwe za HTML zimeze. Ntabwo habamo utumenyetso twa <table>, <tr>, cyangwa <td> tubwira porogaramu aho imirongo n'inkingi bitangirira n'aho birangirira. Porogaramu ihindura igomba kugereranya ishingiye ku hantu ibintu bishyizwe mu buryo bugaragara.

Iri tandukaniro ni ryo rituma guhindura mu buryo butaziguye akenshi bitanga ibintu bitatunganye: inkingi zirivanga, imibare ikaza imeze nk'inyandiko, n'imiterere ikangirika.

Uburyo bwa 1: Gukoresha uburyo bwa Excel bwo kwinjiza amadosiye

Niba ufite Excel 2019 cyangwa nshya (harimo na Microsoft 365), ushobora kwinjiza amakuru ya PDF mu buryo butaziguye ukoresheje Power Query.

Uko bikorwa

1. Fungura Excel maze ujye kuri Data → Get Data → From File → From PDF
2. Hitamo dosiye yawe ya PDF
3. Power Query izerekana imbonerahamwe zishoboka—hitamo iyo ukeneye
4. Kanda kuri Transform Data kugira ngo utunganye ibyinjiye, cyangwa Load kugira ngo bijye mu mbonerahamwe yawe ako kanya

Ibyiza n'ibibi

Bikora neza kuri: PDF zisobanutse, zifite imbonerahamwe zoroshye

Bigora kuri: Imiterere igoye, uturemangingo (cells) twivanze, imbonerahamwe ziri ku mapaji menshi

Icyitonderwa: Ubu buryo ntibuboneka kuri Excel ikoreshwa kuri Mac.

Uburyo bwa 2: Adobe Acrobat

Adobe Acrobat (iyo wishyurirwa, atari Reader gusa) ishobora guhindura PDF mo Excel mu buryo butaziguye.

Uko bikorwa

1. Fungura PDF yawe muri Acrobat
2. Jya kuri File → Export To → Spreadsheet → Microsoft Excel Workbook
3. Hitamo aho ushaka kuyibika

Adobe inatanga urubuga ruhindura amadosiye ku buntu rufite imipaka ku nshuro rwakoreshwa.

Ibyiza n'ibibi

Bikora neza kuri: PDF zakozwe n'ibikoresho bya Adobe, inyandiko za dijital (atari izascanwe)

Bigora kuri: Inyandiko zascanwe, imiterere igoye

Uburyo bwa 3: Imbuga zihindura amadosiye kuri interineti

Hariho ibikoresho byinshi byo kuri interineti by'ubuntu bihindura PDF mo Excel bitabaye ngombwa ko ushyira porogaramu muri mudasobwa yawe.

Amahitamo akunzwe

Igikoresho	Icyo cyiza ho	Imipaka
Smallpdf	Guhindura vuba	Imipaka ya buri munsi ku buntu
iLovePDF	Guhindura amadosiye menshi icyarimwe	Imipaka y'ubunini bwa dosiye
PDF2Go	Imbonerahamwe zoroshye	Bishobora kugora ku miterere igoye

Ibijyanye n'ibanga ry'amakuru

Iyo ukoresheje imbuga zihindura amadosiye, dosiye yawe ijyanwa kuri seriveri zabo. Ku makuru y'imari yihariye, koresha uburyo bwa mudasobwa idafite interineti cyangwa ibikoresho bitunganyiriza amadosiye muri mushakanyigisha (browser) yawe.

Uburyo bwa 4: Gukoporora no kometse (N'intoki)

Rimwe na rimwe uburyo bworoshye ni bwo bukora—cyane cyane ku makuru make.

Uko bikorwa

1. Fungura PDF maze uhitemo imbonerahamwe ukoresheje imbeba (mouse)
2. Koporora (Ctrl+C cyangwa Cmd+C)
3. Kometse muri Excel (Ctrl+V cyangwa Cmd+V)
4. Koresha Data → Text to Columns kugira ngo ukosore ibibazo by'imiterere

Igihe ubu buryo bukora

Ubu buryo ni bwiza ku mbonerahamwe zoroshye, ziri ku paji imwe, aho ukeneye gusa gukuramo amakuru make. Witegure gukoresha igihe utunganya ibyavuyemo.

Ibibazo bikunze bukaho n'uko wabikemura

Imibare yinjiye nk'inyandiko

Excel ishobora gufata imibare yawe nk'inyandiko (text), ibyo bigatuma imibare idashobora kubarurwa.

Igisubizo: Hitamo inkingi, jya kuri Data → Text to Columns, kanda Finish. Cyangwa ukube uturemangingo na 1 kugira ngo bihinduke imibare.

Inkingi zivanze

Amakuru yo mu nkingi nyinshi aza mu karemangingo kamwe.

Igisubizo: Koresha Text to Columns ukoresheje akamenyetso (umwanya, akitso, cyangwa ubugari budahinduka) kugira ngo utandukanye amakuru.

Amakuru abura

Bimwe mu birimo ntibigaragara nyuma yo guhindura.

Igisubizo: Gerageza ikindi gikoresho—buri kimwe gitunganya imiterere mu buryo butandukanye. Kuri PDF zascanwe, ukeneye ubushobozi bwa OCR (optical character recognition).

Imiterere yangiritse

Amabara, imyandikire (fonts), n'imipaka y'uturemangingo birabura.

Igisubizo: Ibikoresho byinshi byibanda ku makuru, si ku miterere igaragara. Bizagusaba gusubizaho imiterere n'intoki muri Excel.

Inama zagufasha kubona ibyavuyemo byiza

Koresha PDF za dijital igihe bishoboka

PDF zakozwe mu buryo bwa dijital (zivuye muri Word, Excel, cyangwa porogaramu z'ibaruramari) zihinduka neza cyane kurusha inyandiko zascanwe ku mpapuro. Niba ufite amahitamo, saba inyandiko za dijital.

Reba niba hari ubushobozi bwa OCR

Niba PDF yawe ari ishusho yascanwe, ukeneye igikoresho gifite OCR. Shaka ubu bushobozi by'umwihariko—Smallpdf na Adobe Acrobat byose birabufite.

Buri gihe genzura ibyavuyemo

Nta gikoresho na kimwe gitunganye 100%. Nyuma yo guhindura:

• Genzura niba umubare w'imirongo n'inkingi uhuye n'umwimerere
• Genzura imibare mike uyigereranya n'inkomoko
• Shaka amakuru yivanze cyangwa abura

Ibi bifata umunota umwe ariko bikurinda amasaha menshi yo gukosora amakosa nyuma.

Huza uburyo n'ubwoko bw'inyandiko

Ubwoko butandukanye bwa PDF bukenera uburyo butandukanye:

Ubwoko bw'inyandiko	Uburyo bwiza
Raporo za banki	Ibikoresho byihariye by'imari
Fagitire	Adobe Acrobat cyangwa ibikoresho byo kuri interineti
Raporo z'amakuru	Power Query (iri muri Excel)
Inyandiko zascanwe	Ibikoresho bifite OCR

Iyo guhindura bidahagije

Rimwe na rimwe nta gikoresho gishobora gukuramo amakuru yawe neza. Ibi bikunze kubaho kuri:

• Inyandiko zifite imiterere igoye cyane
• PDF zifite amakuru akwirakwiriye mu nkingi nyinshi mu buryo budahuye
• Inyandiko zascanwe zifite ishusho itagaragara neza
• Amadosiye arinzwe n'ijambo ry'ibanga (banza ukureho uburinzi)

Muri ibi bihe, kwandukura n'intoki cyangwa porogaramu zihariye zagenewe ubwo bwoko bw'inyandiko ni ryo hitamo ryonyine ryo kwizerwa.

Ibibazo bikunze kubazwa

Mbese nshobora guhindura PDF irinzwe n'ijambo ry'ibanga mo Excel?

Bizagusaba kubanza gukuraho uburinzi bw'ijambo ry'ibanga. Niba uzi ijambo ry'ibanga, fungura PDF muri porogaramu nka Adobe Reader, uyicapishe nka PDF (print to PDF) itagira uburinzi, hanyuma uyihindure. Niba utazi ijambo ry'ibanga, baza uwayikoze.

Kuki imibare yanjye igaragara nk'inyandiko muri Excel?

PDF ntizitandukanya imibare n'inyandiko—byose biba ari inyuguti gusa ku rupapuro. Iyo Excel yinjiye aya makuru, ishobora guhita iyashyira mu miterere y'inyandiko. Koresha Data → Text to Columns cyangwa ukube na 1 kugira ngo bihinduke.

Ni ubuhe buryo butanga ibyavuyemo byizewe neza?

Biterwa n'inyandiko yawe. Kuri PDF za dijital zifite imbonerahamwe zoroshye, Power Query ya Excel ikora neza. Ku nyandiko zigoye, Adobe Acrobat cyangwa ibikoresho byihariye bikunze gukora neza kurushaho. Uburyo bwonyine bwo kubimenya ni ukugerageza dosiye yawe.

Mbese nshobora guhindura PDF nyinshi icyarimwe?

Yego, ariko uburyo buratandukana. Ibikoresho bimwe byo kuri interineti nka iLovePDF bishobora guhindura amadosiye menshi icyarimwe. Power Query na yo ishobora kwinjiza amadosiye menshi ubanje kuyitunganya. Ku madosiye menshi ya buri gihe, porogaramu nka Adobe Acrobat Pro ni yo ikora neza.

Hari uburyo bwo kwikora (automate) bwo guhindura PDF mo Excel?

Ihuza rya Power Query rishobora kwivugurura (refresh) mu buryo bwikora iyo PDF y'inkomoko ihindutse. Ku buryo buhanitse, ibikoresho by'uburimbane nka Python hamwe n'amasomero nka Tabula cyangwa Camelot bishobora gutunganya PDF mu buryo bwa porogaramu.

Incamake

Guhindura PDF mo Excel ntibyoroshye buri gihe, ariko ufite amahitamo:

• Excel Power Query ku mbonerahamwe zoroshye kandi zitunganyije neza
• Adobe Acrobat ku byavuyemo byizewe kuri PDF za dijital
• Imbuga zihindura amadosiye ku bintu byihuse kandi bidahoraho
• Gukoporora no kometse n'intoki ku makuru make kandi oroshye

Icy'ingenzi ni uguhuza uburyo ukoresha n'ubwoko bw'inyandiko yawe—kandi buri gihe ugenzure ibyavuyemo mbere yo gukoresha amakuru wahinduye.