PDF aṭanga Excel-a thlak dan: Kawng hlawk takte

PDF-ah data i nei a, Excel-a dah i duh a nih chuan—chu chu sum leh pai report pawh ni se, invoice emaw, thil hrang hrang list pawh ni se—harsatna pakhat a awm. PDF hi chu siamrem (edit) tura siam a ni lo va, khawiah pawh a hmelhmang ngai renga lang tura siam a ni.

He data hi i hman theih tura spreadsheet-a dah luh dan dik tak chu hetiang hi a ni.

Engvanga PDF aṭanga Excel-a thlak hi harsa nge a nih?

PDF leh Excel spreadsheet-te hian hna hrang hlak an thawk a. PDF chuan a hmelhmang (layout) a vawng reng a—digital-a print chhuah ang deuh a ni. Excel erawh chuan data-te chu chhut leh zirchian theih turin row leh column-ah a rem khawm thung.

A harsatna chu? PDF-ah hian HTML table-a kan hmuh ang <table>, <tr>, emaw <td> tag-te a awm ve lo va, column leh row inṭanna leh tawpna a hrilh thei lo. Thlakna hmanrua (converter) khan a lan dan aṭangin a lo riruat ve tawp a ngai a ni.

He inthlauhna avang hian thlak tawp hian a chhuak hnawk duh hle: column-te a lo inzawm a, nambar-te chu thuziak (text) angin a lo lang a, a hmelhmang a lo chhia thin a ni.

Kawng 1-na: Microsoft Excel-a hmanraw awmsa hman

Excel 2019 emaw a aia thar (Microsoft 365 telin) i hman chuan, Power Query hmangin PDF data i la lut (import) thei a ni.

Tihdan tur

1. Excel hawng la, Data → Get Data → From File → From PDF-ah kal rawh
2. I PDF file thlang rawh
3. Power Query-in table awm thei angte a rawn tarlang ang a—i duh ber thlang rawh
4. Transform Data hmetin i duh angin siamrem la, emaw Load hmetin i spreadsheet-ah dah lut rawh

A ṭhatna leh ṭhat lohna

He mi tan hian a ṭha: PDF felfai tak leh table simple tak nei tan

He mi-ah hian a harsa: Layout riruang mumal lo, cell inzawm (merged cells), leh table phek tam tak daih tan

Hriat tur: He feature hi Mac-a Excel-ah a la hman theih loh.

Kawng 2-na: Adobe Acrobat

Adobe Acrobat (a man chawi chi, Reader mai ni lo) hian PDF chu Excel format-ah a thlak thei nghal a ni.

Tihdan tur

1. I PDF chu Acrobat-ah hawng rawh
2. File → Export To → Spreadsheet → Microsoft Excel Workbook-ah hmet rawh
3. I dahna tur hmun thlang rawh

Adobe hian free online converter tlem hman theihna a nei bawk.

A ṭhatna leh ṭhat lohna

He mi tan hian a ṭha: Adobe hmanrua hmanga siam PDF-te leh document dik tak (scanned ni lo) tan

He mi-ah hian a harsa: Document scan chawpte leh formatting riruang mumal lo tak tan

Kawng 3-na: Online-a thlakna hmanruate

Software install ngai lova PDF aṭanga Excel-a thlakna hmanrua free-a hman theih tam tak a awm.

Hmanraw lar zualte

Hmanrua	A ṭhatna	A tlin lohna
Smallpdf	Thlak zung zung nan	Free-ah ni khata hman zat bituk a awm
iLovePDF	A ruala tam tak thlak nan	File size bituk a awm
PDF2Go	Table simple tak tan	Layout riruang mumal lo-ah a harsa thei

Privacy ngaihtuah tur

Online hmanrua i hman hian i file chu an server-ah i upload tih hria la. Sum leh pai chungchang data pawimawh tak a nih chuan, offline-a tihdan emaw i browser-a thawk thei hmanruate hman a him zawk ang.

Kawng 4-na: Copy leh Paste (Kut ngeia tih)

A chang chuan tihdan awlsam ber hi a thawk ṭha ber thin—a bik takin data tlem te tan.

Tihdan tur

1. PDF chu hawng la, i mouse hmangin table chu thlang (select) rawh
2. Copy rawh (Ctrl+C emaw Cmd+C)
3. Excel-ah paste rawh (Ctrl+V emaw Cmd+V)
4. Data → Text to Columns hmangin a hmelhmang (formatting) dik lo lai siamrem rawh

He mi hman hun chu

He tihdan hi table simple tak, phek khat chauhva awm, lak chhuah zawk i duh hunah a ṭha ber. A chhuak hnawk lai siamrem nan hun i hman deuh erawh a ngai ang.

Harsatna tlangpui leh tihdan turte

Nambar-te thuziak (text) anga a luh hian

Excel hian i nambar-te kha thuziak (text) angin a lo ngai thei a, chu chuan chhutna (calculation) a tibuai thin.

A siamreman: Column kha thlang la, Data → Text to Columns-ah kalin Finish hmet rawh. Emaw, cell-te kha 1-in va puntir (multiply) rawh.

Column-te a lo inzawm hian

Column hrang hranga data-te kha cell pakhatah a lo awm khawm vek thin.

A siamreman: Text to Columns hmang la, a inrina (space, comma, emaw a len dan bituk) hmangin data-te chu phel rawh.

Data kim lo

Thil ṭhenkhat thlaknaah khan a lo lang ve lo a nih chuan.

A siamreman: Hmanraw dang han chhin rawh—hmanrua hrang hrang hian layout an hmuh dan a inang lo hlawm a. PDF scan chawp a nih chuan OCR (optical character recognition) hman theihna i mamawh ang.

A hmelhmang (formatting) a bo hian

A rawng, a font, leh a cell border-te a bo vek thei.

A siamreman: Thlakna hmanrua tam tak hian data chauh an ngaihtuah a, a lan dan an ngaihtuah lo. Excel-ah i siamrem leh deuh a ngai ang.

Thlak fuh lehzual nana thurawnte

A theih hram chuan PDF dik tak (Native) hmang rawh

Digital-a siam (Word, Excel, emaw accounting software aṭanga siam) PDF-te hi paper scan chawp aiin thlak an awlsam zawk daih. I thlan theih chuan digital version dil hram rawh.

OCR a hman theih leh theih loh en rawh

I PDF chu thlalak scan chawp a nih chuan, OCR nei hmanrua i mamawh ang. Smallpdf leh Adobe Acrobat hian he feature hi an nei ve ve a ni.

A chhuak kha en nawn ziah rawh

Hmanraw ṭha ber pawh hi a famkim lo thei. I thlak zawhah:

• Row leh column zat a inzat em tih en rawh
• Nambar ṭhenkhat a dik em tih en rawh
• Data inzawm emaw bo a awm em tih en rawh

Hemi en nan hian minute khat chauh a ngai a, nakina harsatna tam tak lakah a chhan thei che a ni.

Document chi hrang hrangte ngaihtuah rawh

PDF chi hrang hrang hian tihdan hrang an mamawh:

Document Chi	Tihdan ṭha ber
Bank statement-te	Sum leh pai tana hmanraw bik (specialized converters)
Invoice-te	Adobe Acrobat emaw online tools
Data report-te	Power Query (Excel-a awmsa)
Document scan chawpte	OCR nei hmanruate

Thlak theih loh chang a awm em?

A chang chuan hmanraw eng mah hian data chu felfai takin an la chhuak thei lo thin. Hetiang hunah hian a ni tlangpui:

• Layout riruang mumal lo leh design nasa lutukah
• PDF-ah data-te kha column hrang hrangah a inrem kawi nuai hian
• Document scan chawp, a thlalak fiah lo lutukah
• Password-vawng (password-protected) file-ah (a venna hlih hmasak a ngai)

Hetiang a nih chuan, kut ngeia chhut luh emaw document chi bik tana siam software hman a ngai tawh thin.

Zawhna tlangpuite

Password-vawng PDF kha Excel-ah ka thlak thei em?

A password venna kha i hlih hmasak a ngai ang. Password i hriat chuan Adobe Reader-ah hawng la, venna awm lova PDF-ah print leh la, tichuan i thlak thei ang. Password i hriat loh chuan a siamtu va be rawh.

Engvanga ka nambar-te kha Excel-ah thuziak (text) anga lang nge an nih?

PDF hian nambar leh thuziak a thliar hrang ve lo va—phek pakhata thuziak (character) awm vek angin a ngai a ni. Excel-a i dah luh hian text format-ah a lo dah tawp thei a. Data → Text to Columns hmang la emaw 1-in va puntir rawh.

Khawi tihdan ber hian ni chhuak dik ber ang?

I document a zir a ni. PDF felfai tak leh table simple tak tan chuan Excel Power Query a ṭha. Document riruang mumal lo tan Adobe Acrobat emaw hmanraw bik dangte an ṭha zawk. I file ngei kha han chhin phawt mai rawh.

PDF tam tak a rualin ka thlak thei em?

Thei e, mahse a tihdan a inang lo hlawm. iLovePDF ang chi online tool ṭhenkhat hian a ruala thlak (batch conversion) an phal a. Power Query pawh hian file tam tak a lak luh theih bawk. Nitina tih a ngai a nih chuan Adobe Acrobat Pro ang chi desktop software a hlawk ber.

PDF aṭanga Excel-a thlak hi amaha thawk tura siam (automate) dan a awm em?

Power Query connection-te hi a source PDF a in-update hian amaha in-refresh tura siam theih a ni. Automation sang zawk tan chuan Python programming leh library hrang hrang Tabula emaw Camelot ang chite hman theih a ni.

Khaikhawmna

PDF aṭanga Excel-a thlak hi a awlsam reng lo mahse, kawng hrang hrang i nei a:

• Excel Power Query table simple leh felfai tak tan
• Adobe Acrobat PDF dik tak (native) rintlak taka thlak nan
• Online converters hman thut mamawh hun nan
• Manual copy-paste data tlem te lak chhuah nan

A pawimawh ber chu i document nena inrem tihdan thlan thiam a ni—leh i data thlak tawh hnu kha a dik em tih en nawn ziah a ni.