Ale si woatrɔ PDF zu Excel: Mɔnu siwo dɔna ŋutɔŋutɔ
Srɔ̃ mɔnu nyuitɔ siwo dzi nàto atrɔ PDF-fagbalẽwo zu Excel-fagbalẽwo evɔ wò nyatakakawo kple wo ƒe nɔnɔmewo magblẽ o.
Nyatakaka aɖewo le asiwò le PDF me eye nèdi be yàatsɔ wo ade Excel me. Ðewohĩ gakɔnta ƒe nyatakakae, fexexe ƒe gbalẽ (invoice), alo nusiwo nèdzrana ƒe tatae. Kuxia? Womewɔ PDF be woatrɔ nusiwo le eme o—wowɔe be wòanɔ nenema ke le afi sia afi.
Ale si nàwɔ atsɔ nyatakaka mawo ade Excel-fagbalẽ si nàte ŋu awɔ dɔ le eme lae nye esi.
Nu si tae PDF trɔtrɔ zu Excel sesẽna
PDF kple Excel-fagbalẽwo ƒe dɔwɔwɔwo tovo kura. PDF dzraa ale si nuwo dze le ŋku me la ɖo—ele abe kɔmpiuta dzi nuŋɔŋlɔ si woɖe ene. Excel ya ɖoa nyatakakawo ɖe fliawo kple sɔtiwo me be woate ŋu abu akɔnta alo adzro wo me.
Kuxia? PDF-fagbalẽwo meɖoa nyatakakawo ɖe ɖoɖo me abe HTML aɖakawo (tables) ene o. <table>, <tr>, alo <td> dzesi aɖeke mele eme si fiaa kɔmpiuta dɔwɔnuwo afi si fliawo kple sɔtiwo dze egbe tsoe alo afi si wogbe tsoe o. Dɔwɔnu si trɔa fagbalẽa la nɔa ebuam le ale si nuwo dze le ŋku me dzi.
Esiae nye nu si tae fagbalẽa trɔtrɔ tẽe tea ŋu gblẽna: sɔtiwo bla ɖe wo nɔewo ŋu, xexlẽmewo va zua nuŋɔŋlɔwo, eye fagbalẽa ƒe nɔnɔme gblẽna kura.
Mɔnu 1: Microsoft Excel ƒe dɔwɔnu si le eme xoxo
Ne Excel 2019 alo esiwo va emegbe (le Microsoft 365 me) le asiwò la, àte ŋu atsɔ nyatakakawo tso PDF me tẽe to Power Query dzi.
Ale si nàwɔe
- Ʋu Excel eye nàde Data → Get Data → From File → From PDF
- Tia wò PDF-fagbalẽa
- Power Query afia aɖaka (tables) siwo le eme—tia esi nèdi
- Zi Transform Data dzi be nàɖɔ nyatakakawo ɖo, alo Load be nàdee wò Excel-fagbalẽa me tẽe
- Nyuiwo kple vɔ̃wo
Enyo na: PDF siwo me kɔ eye aɖakawo le eme bɔbɔe
Esesẽna na: Fagbalẽ siwo ƒe ɖoɖo sesẽ, aɖaka siwo bla, alo aɖaka siwo le axa geɖe dzi
De dzesii: Dɔwɔnu sia mele Excel ƒe Mac tɔwo me o.
Mɔnu 2: Adobe Acrobat
Adobe Acrobat (esi nàƒle, menye Reader o) te ŋu trɔa PDF zu Excel tẽe.
Ale si nàwɔe
- Ʋu wò PDF le Acrobat me
- Yi File → Export To → Spreadsheet → Microsoft Excel Workbook
- Tia afi si nèdi be nàdzrae ɖo
Adobe ganyea internet dzi dɔwɔnu si womexea fe na o hã si nàte ŋu azã zi ʋee aɖewo.
Nyuiwo kple vɔ̃wo
Enyo na: PDF siwo wowɔ kple Adobe dɔwɔnuwo, fagbalẽ siwo wowɔ le kɔmpiuta dzi (menye esiwo woɖe tso pepa dzi o)
Esesẽna na: Fagbalẽ siwo woɖe tso pepa dzi (scanned), fagbalẽ siwo ƒe ɖoɖo sesẽ
Mɔnu 3: Internet dzi dɔwɔnuwo
Internet dzi dɔwɔnu geɖe li siwo trɔa PDF zu Excel evɔ nàhiã be nàde dɔwɔnu aɖeke wò kɔmpiuta me o.
Dɔwɔnu siwo bɔ
| Dɔwɔnu | Enyo na | Seɖoƒewo |
|---|---|---|
| Smallpdf | Trɔtrɔ kpata | Seɖoƒe li na gbesiagbe zãzã |
| iLovePDF | Fagbalẽ geɖe trɔtrɔ zi ɖeka | Fagbalẽ ƒe lolome ƒe seɖoƒe |
| PDF2Go | Aɖaka bɔbɔewo | Esesẽna na fagbalẽ siwo ƒe ɖoɖo sesẽ |
Be nàdze si
Ne èzã internet dzi dɔwɔnuwo la, wò fagbalẽa yia woƒe kɔmpiutawo dzi. Ne gakɔnta ƒe nyatakaka siwo nye ɣaɣlae le asiwò la, zã dɔwɔnu siwo nèzãna le wò kɔmpiuta dzi alo esiwo mewɔa dɔ le internet dzi o.
Mɔnu 4: Kɔpi kple Paste (Wò ŋutɔ nàwɔe)
Ɣeaɖewoɣi la, mɔnu bɔbɔetɔe dɔna—vevietɔ ne nyatakaka ʋee aɖewo koe le asiwò.
Ale si nàwɔe
- Ʋu PDF-fagbalẽa eye nàtia aɖakaa kple wò mouse
- Kɔpi (Ctrl+C alo Cmd+C)
- Paste dee Excel me (Ctrl+V alo Cmd+V)
- Zã Data → Text to Columns be nàɖɔ nɔnɔmea ɖo
Ɣekaɣie esia dɔna
Mɔnu sia nyo na aɖaka bɔbɔe siwo le axa ɖeka dzi pɛ eye nèdi be nàɖe wo kpata. Àhiã be nàzã ɣeyiɣi aɖe atsɔ aɖɔ emetsonuawo ɖo.
Kuxi siwo bɔ kple ale si woakpɔ wo gbɔ
Xexlẽmewo va zua nuŋɔŋlɔ
Excel ate ŋu abu wò xexlẽmewo abe nuŋɔŋlɔ ene, si ana nàte ŋu abu akɔnta o.
Ale si nàkpɔe gbɔ: Tia sɔtia, yi Data → Text to Columns, eye nàzi Finish dzi. Alo nàtsɔ 1 azã xexlẽme siwo le aɖakaa me be wòatrɔ azu xexlẽme ŋutɔŋutɔ.
Sɔtiwo bla ɖe wo nɔewo ŋu
Nyatakaka siwo tso sɔti vovovowo me la va bla ɖe aɖaka ɖeka me.
Ale si nàkpɔe gbɔ: Zã Text to Columns eye nàtia dzesi aɖe (space, comma, alo lolome si nèɖo) atsɔ ama nyatakakawo.
Nyatakaka aɖewo bu
Nu aɖewo medze le fagbalẽ si nètrɔ la me o.
Ale si nàkpɔe gbɔ: Te internet dzi dɔwɔnu bubu kpɔ—wo dometɔ ɖe sia ɖe trɔa fagbalẽwo tovo. Na PDF siwo woɖe tso pepa dzi la, èhiã dɔwɔnu si me OCR (optical character recognition) le.
Fagbalẽa ƒe nɔnɔme gblẽ
Amadede, nuŋɔŋlɔ ƒe nɔnɔme, kple aɖakaa ƒe liƒowo bu.
Ale si nàkpɔe gbɔ: Dɔwɔnu geɖe ƒe taɖodzinue nye nyatakakawo, menye ale si wozena o. Àhiã be nàɖɔ wo ɖo wò ŋutɔ le Excel me.
Aɖaŋuɖoɖo siwo ana nàkpɔ emetsonu nyuiwo
Zã PDF siwo wowɔ le kɔmpiuta dzi
PDF siwo wowɔ tso Word, Excel, alo gakɔntadɔwɔnuwo me la trɔna nyuie wu esiwo woɖe tso pepa dzi. Ne mɔnukpɔkpɔa le asiwò la, bia kɔmpiuta dzi tɔ.
Kpɔe ɖa be OCR le eme hã
Ne wò PDF-fagbalẽa nye nɔnɔmetata si woɖe tso pepa dzi la, èhiã dɔwɔnu si me OCR le. Di dɔwɔnu sia tɔxɛ—Smallpdf kple Adobe Acrobat siaa te ŋu wɔa esia.
Kpɔ emetsonua ɖa ɣesiaɣi
Dɔwɔnu aɖeke mede blibo o. Ne ètrɔe vɔ la:
- Kpɔe ɖa be fliawo kple sɔtiwo ƒe xexlẽme sɔ kple gbãtɔa hã
- Kpɔ xexlẽme ʋee aɖewo ɖa be wosɔ hã
- Di nyatakaka siwo bla alo bu
Esia axɔ miniti ɖeka pɛ gake wòaɖe wò tso kuxi geɖe me emegbe.
Bu fagbalẽ ƒe nɔnɔme ŋu
PDF vovovowo hiãa mɔnu vovovowo:
| Fagbalẽ ƒe nɔnɔme | Mɔnu nyuitɔ |
|---|---|
| Gadzraɖoƒe ƒe nyatakakawo | Gakɔntadɔwɔnu tɔxɛwo |
| Fexexegbalẽwo (Invoices) | Adobe Acrobat alo internet dzi dɔwɔnuwo |
| Nyatakakagbalẽwo | Power Query (si le Excel me) |
| Fagbalẽ siwo woɖe tso pepa dzi | Dɔwɔnu siwo me OCR le |
Ne fagbalẽa trɔtrɔ mesɔ o
Ɣeaɖewoɣi la, dɔwɔnu aɖeke mate ŋu aɖe wò nyatakakawo nyuie o. Esia dzɔna zi geɖe ne:
- Fagbalẽa ƒe ɖoɖo sesẽ ŋutɔ
- PDF si me nyatakakawo le sɔti geɖe me eye womesɔ o
- Fagbalẽ siwo woɖe tso pepa dzi eye womedze nyuie o
- Fagbalẽ siwo ŋu woɖo password ɖo (ɖe password-a ɖa gbã)
Le nɔnɔme siawo me la, wò ŋutɔ nàŋlɔ wo alo nàzã dɔwɔnu tɔxɛ si wowɔ na fagbalẽ ma ƒomevi koe nye mɔnu nyuitɔ.
Biabia siwo bɔ
Àte ŋu atrɔ PDF si ŋu woɖo password ɖo azu Excel-a?
Àhiã be nàɖe password-a ɖa gbã. Ne ènya password-a la, ʋu PDF-fagbalẽa le Adobe Reader me, eye nàzi "print to PDF" dzi evɔ password maganɔ eŋu o, emegbe nàtrɔe. Ne mènya password-a o la, yi ame si wɔ fagbalẽa gbɔ.
Nu si tae nye xexlẽmewo dze abe nuŋɔŋlɔ ene le Excel me?
PDF-fagbalẽwo meɖea vovototo le xexlẽmewo kple nuŋɔŋlɔwo dome o—wo katã nye dzesiwo le axaa dzi. Ne Excel le nyatakaka siawo ɖem la, ate ŋu abu wo abe nuŋɔŋlɔ ene. Zã Data → Text to Columns alo nàtsɔ 1 azã wo be wòatrɔ.
Mɔnu kae na emetsonu nyuitɔ wu?
Ele wò fagbalẽa dzi. Na PDF siwo wowɔ le kɔmpiuta dzi eye aɖakawo le eme bɔbɔe la, Excel ƒe Power Query dɔna nyuie. Na fagbalẽ siwo sesẽ la, Adobe Acrobat alo dɔwɔnu tɔxɛwo dɔna nyuie wu. Mɔnu ɖeka koe li nàto anyae, eye esiae nye be nàte wò fagbalẽa kpɔ.
Àte ŋu atrɔ PDF geɖe zi ɖeka?
Ɛ̃, gake mɔnuwo tovo. Internet dzi dɔwɔnu aɖewo abe iLovePDF ene te ŋu trɔa fagbalẽ geɖe zi ɖeka. Power Query hã te ŋu ɖea fagbalẽ geɖe ne èɖo eŋu nyuie. Na dɔ sia wɔwɔ ɣesiaɣi la, kɔmpiuta dzi dɔwɔnu abe Adobe Acrobat Pro ene nye esi dɔna nyuie wu.
Mɔ aɖe li si nàto awɔe be PDF trɔtrɔ zu Excel nawɔ eɖokui-a?
Power Query te ŋu ɖɔa eɖokui ɖo ɣesiaɣi si gbãtɔa trɔ. Na dɔ sesẽwo la, kɔmpiuta dzi dɔwɔnuwo abe Python kple eƒe dɔwɔnu siwo nye Tabula alo Camelot te ŋu trɔa PDF-fagbalẽwo le ɖoɖo nu.
Kpuotɔ
PDF trɔtrɔ zu Excel menye nu bɔbɔe ɣesiaɣi o, gake mɔnu geɖe li:
- Excel Power Query na aɖaka bɔbɔe siwo le ɖoɖo nyui me
- Adobe Acrobat na emetsonu nyuiwo le PDF siwo wowɔ le kɔmpiuta dzi me
- Internet dzi dɔwɔnuwo na dɔ kpatawo
- Kɔpi kple paste na nyatakaka ʋee aɖewo
Nu vevietɔe nye be nàtia mɔnu si sɔ na wò fagbalẽa—eye nàkpɔ emetsonuawo ɖa ɣesiaɣi hafi nàzã nyatakaka siwo nètrɔ.