PDF ꯕꯨ Excel ꯗꯥ ꯀꯔꯝꯅꯥ ꯑꯣꯟꯊꯣꯛꯀꯅꯤ: ꯆꯠꯅꯕꯥ ꯌꯥꯕꯥ ꯃꯑꯣꯡꯁꯤꯡ
ꯅꯍꯥꯛꯀꯤ ꯗꯦꯇꯥ ꯑꯃꯁꯨꯡ ꯐꯣꯔꯃꯦꯇꯤꯡ ꯉꯥꯛꯇꯨꯅꯥ PDF ꯐꯥꯏꯜꯁꯤꯡꯕꯨ Excel ꯁ꯭ꯄ꯭ꯔꯦꯗꯁꯤꯠꯇꯥ ꯑꯣꯟꯊꯣꯛꯅꯕꯥ ꯈ꯭ꯕꯥꯏꯗꯒꯤ ꯐꯕꯥ ꯃꯑꯣꯡꯁꯤꯡ ꯇꯝꯕꯤꯌꯨ꯫
ꯅꯍꯥꯛꯀꯤ ꯗꯦꯇꯥꯁꯤꯡ PDF ꯑꯃꯗꯥ ꯂꯣꯠꯇꯨꯅꯥ ꯂꯩꯔꯤ ꯑꯃꯁꯨꯡ ꯅꯍꯥꯛꯅꯥ ꯃꯁꯤ Excel ꯗꯥ ꯃꯊꯧ ꯇꯥꯏ꯫ ꯃꯁꯤ ꯐꯥꯏꯅꯥꯟꯁꯤꯑꯦꯜ ꯔꯤꯄꯣꯔꯠ ꯑꯃꯥ, ꯏꯅꯚꯣꯏꯁ ꯑꯃꯥ, ꯅꯠꯇ꯭ꯔꯒꯥ ꯄꯣꯠꯊꯣꯛꯀꯤ ꯗꯦꯇꯥꯁꯤꯡꯒꯤ ꯇꯦꯕꯜ ꯑꯃꯥ ꯑꯣꯏꯕꯥ ꯌꯥꯏ꯫ ꯑꯋꯥꯕꯗꯤ? PDF ꯁꯤꯡꯁꯤ edit ꯇꯧꯅꯕꯥ ꯁꯦꯝꯕꯥ ꯅꯠꯇꯦ—ꯃꯈꯣꯌꯁꯤ ꯃꯐꯝ ꯈꯨꯗꯤꯡꯗꯥ ꯃꯥꯟꯅꯅꯥ ꯎꯅꯕꯥ ꯁꯦꯝꯕꯅꯤ꯫
ꯅꯍꯥꯛꯅꯥ ꯊꯕꯛ ꯇꯧꯕꯥ ꯌꯥꯕꯥ ꯁ꯭ꯄ꯭ꯔꯦꯗꯁꯤꯠ ꯑꯃꯗꯥ ꯗꯦꯇꯥ ꯑꯗꯨ ꯀꯔꯝꯅꯥ ꯄꯨꯊꯣꯛꯀꯅꯤ ꯍꯥꯏꯕꯗꯨ ꯃꯈꯥꯗꯥ ꯄꯤꯔꯤ꯫
PDF ꯕꯨ Excel ꯗꯥ ꯑꯣꯟꯊꯣꯛꯄꯥ ꯑꯁꯤ ꯀꯔꯤꯒꯤ ꯑꯔꯨꯕꯅꯣ
PDF ꯑꯃꯁꯨꯡ Excel ꯁ꯭ꯄ꯭ꯔꯦꯗꯁꯤꯠꯁꯤꯡꯅꯥ ꯑꯇꯣꯞꯄꯥ ꯄꯥꯟꯗꯝꯁꯤꯡ ꯐꯪꯍꯜꯂꯤ꯫ PDF ꯅꯥ ꯎꯕꯥ ꯐꯪꯂꯤꯕꯥ ꯂꯦꯑꯥꯎꯠ ꯑꯗꯨ ꯉꯥꯛꯇꯨꯅꯥ ꯊꯝꯃꯤ—ꯃꯁꯤ ꯃꯁꯦꯜꯗꯤ ꯗꯤꯖꯤꯇꯦꯜ ꯄ꯭ꯔꯤꯟꯇꯑꯥꯎꯠ ꯑꯃꯅꯤ꯫ Excel ꯅꯥ ꯗꯦꯇꯥꯁꯤꯡꯕꯨ ꯍꯤꯁꯥꯞ ꯇꯧꯅꯕꯥ ꯑꯃꯁꯨꯡ ꯅꯩꯅꯅꯕꯥ ꯔꯣ (rows) ꯑꯃꯁꯨꯡ ꯀꯣꯂꯝ (columns) ꯁꯤꯡꯗꯥ ꯁꯦꯝ-ꯁꯥꯏ꯫
ꯑꯋꯥꯕꯗꯤ? PDF ꯁꯤꯡꯗꯥ HTML ꯇꯦꯕꯜꯁꯤꯡꯒꯨꯝꯅꯥ ꯁ꯭ꯇ꯭ꯔꯀꯆꯔꯦꯜ ꯏꯅꯐꯣꯔꯃꯦꯁꯟ ꯌꯥꯎꯗꯦ꯫ ꯔꯣ ꯑꯃꯁꯨꯡ ꯀꯣꯂꯝꯁꯤꯡ ꯀꯗꯥꯏꯗꯒꯤ ꯍꯧꯕꯒꯦ ꯑꯃꯁꯨꯡ ꯀꯗꯥꯏꯗꯥ ꯂꯣꯏꯕꯒꯦ ꯍꯥꯏꯕꯗꯨ ꯁꯣꯐ꯭ꯇꯋꯦꯌꯔꯗꯥ ꯍꯥꯏꯕꯤꯕꯥ <table>, <tr>, ꯅꯠꯇ꯭ꯔꯒꯥ <td> ꯇꯦꯒꯁꯤꯡ ꯂꯩꯇꯦ꯫ ꯀꯅꯚꯥꯔꯇꯔ ꯑꯗꯨꯅꯥ ꯎꯕꯥ ꯐꯪꯂꯤꯕꯥ ꯄꯣꯖꯤꯁꯟ ꯑꯗꯨꯗꯥ ꯌꯨꯝꯐꯝ ꯑꯣꯏꯔꯒꯥ ꯑꯗꯨꯝ ꯂꯧꯒꯅꯤ꯫
ꯃꯁꯤꯒꯤ ꯃꯔꯝꯅꯥ ꯗꯥꯏꯔꯦꯛꯇ ꯑꯣꯟꯊꯣꯛꯄꯥ ꯃꯇꯝꯗꯥ ꯀꯔꯤꯒꯨꯝꯕꯥ ꯃꯇꯝꯗꯥ ꯐꯣꯔꯃꯦꯇꯤꯡ ꯀꯥꯏꯕꯥ ꯌꯥꯏ: ꯀꯣꯂꯝꯁꯤꯡ ꯄꯨꯟꯁꯤꯟꯅꯕꯥ, ꯃꯁꯤꯡꯁꯤꯡ text ꯑꯣꯏꯅꯥ ꯎꯕꯥ, ꯑꯃꯁꯨꯡ ꯐꯣꯔꯃꯦꯇꯤꯡ ꯀꯥꯏꯕꯥ ꯊꯣꯛꯏ꯫
ꯃꯑꯣꯡ ꯱: Microsoft Excel ꯒꯤ ꯃꯅꯨꯡꯗꯥ ꯌꯥꯎꯕꯥ Import ꯇꯧꯕꯥ
ꯅꯍꯥꯛꯀꯤ Excel 2019 ꯅꯠꯇ꯭ꯔꯒꯥ ꯃꯁꯤꯒꯤ ꯃꯊꯛꯀꯤ (Microsoft 365 ꯌꯥꯎꯅꯥ) ꯂꯩꯔꯕꯗꯤ, ꯅꯍꯥꯛꯅꯥ Power Query ꯁꯤꯖꯤꯟꯅꯗꯨꯅꯥ PDF ꯗꯦꯇꯥ ꯗꯥꯏꯔꯦꯛꯇ ꯄꯨꯁꯤꯜꯂꯛꯄꯥ ꯌꯥꯏ꯫
ꯃꯁꯤ ꯀꯔꯝꯅꯥ ꯇꯧꯒꯅꯤ
- Excel ꯍꯥꯡꯗꯣꯛꯎ ꯑꯃꯁꯨꯡ Data → Get Data → From File → From PDF ꯗꯥ ꯆꯠꯂꯨ
- ꯅꯍꯥꯛꯀꯤ PDF ꯐꯥꯏꯜ ꯑꯗꯨ ꯈꯟꯂꯨ
- Power Query ꯅꯥ ꯂꯩꯔꯤꯕꯥ ꯇꯦꯕꯜꯁꯤꯡ ꯎꯠꯀꯅꯤ—ꯅꯍꯥꯛꯅꯥ ꯃꯊꯧ ꯇꯥꯕꯗꯨ ꯈꯟꯂꯨ
- Import ꯑꯗꯨ ꯁꯦꯡꯗꯣꯛꯅꯕꯥ Transform Data ꯗꯥ ꯅꯝꯃꯨ, ꯅꯠꯇ꯭ꯔꯒꯥ ꯗꯥꯏꯔꯦꯛꯇ ꯁ꯭ꯄ꯭ꯔꯦꯗꯁꯤꯠꯇꯥ ꯄꯨꯁꯤꯜꯂꯛꯅꯕꯥ Load ꯗꯥ ꯅꯝꯃꯨ
ꯀꯥꯟꯅꯕꯁꯤꯡ ꯑꯃꯁꯨꯡ ꯑꯋꯥꯠꯄꯁꯤꯡ
ꯃꯁꯤꯒꯤꯗꯃꯛ ꯐꯩ: ꯁꯦꯡꯅꯥ ꯂꯩꯕꯥ, ꯇꯦꯕꯜ ꯂꯥꯏꯅꯥ ꯌꯥꯎꯕꯥ PDF ꯁꯤꯡ
ꯃꯁꯤꯗꯥ ꯑꯋꯥꯕꯥ ꯃꯥꯌꯣꯛꯅꯩ: ꯀꯝꯄ꯭ꯂꯦꯛꯁ ꯂꯦꯑꯥꯎꯠꯁꯤꯡ, ꯄꯨꯟꯁꯤꯟꯅꯕꯥ ꯁꯦꯜꯁꯤꯡ, ꯂꯃꯥꯏ ꯀꯌꯥ ꯄꯥꯟꯕꯥ ꯇꯦꯕꯜꯁꯤꯡ
ꯈꯪꯖꯤꯟꯒꯗꯕꯥ: ꯃꯁꯤꯒꯤ ꯐꯤꯆꯔ ꯑꯁꯤ Excel ꯒꯤ Mac ꯚꯔꯖꯟꯁꯤꯡꯗꯥ ꯐꯪꯗꯦ꯫
ꯃꯑꯣꯡ ꯲: Adobe Acrobat
Adobe Acrobat (ꯄꯥꯏꯗ ꯚꯔꯖꯟ, Reader ꯈꯛꯇꯥ ꯅꯠꯇꯦ) ꯅꯥ PDF ꯁꯤꯡꯕꯨ Excel ꯐꯣꯔꯃꯦꯠꯇꯥ ꯗꯥꯏꯔꯦꯛꯇ export ꯇꯧꯕꯥ ꯌꯥꯏ꯫
ꯃꯁꯤ ꯀꯔꯝꯅꯥ ꯇꯧꯒꯅꯤ
- ꯅꯍꯥꯛꯀꯤ PDF ꯑꯗꯨ Acrobat ꯇꯥ ꯍꯥꯡꯗꯣꯛꯎ
- File → Export To → Spreadsheet → Microsoft Excel Workbook ꯗꯥ ꯆꯠꯂꯨ
- ꯅꯍꯥꯛꯅꯥ ꯁꯦꯚ ꯇꯧꯅꯤꯡꯕꯥ ꯃꯐꯝ ꯑꯗꯨ ꯈꯟꯂꯨ
Adobe ꯅꯥ ꯁꯤꯖꯤꯟꯅꯕꯥ ꯈꯔꯥ ꯂꯦꯞꯄꯥ ꯐ꯭ꯔꯤ ꯑꯣꯅꯂꯥꯏꯟ ꯀꯅꯚꯥꯔꯇꯔ ꯑꯃꯁꯨ ꯄꯤꯔꯤ꯫
ꯀꯥꯟꯅꯕꯁꯤꯡ ꯑꯃꯁꯨꯡ ꯑꯋꯥꯠꯄꯁꯤꯡ
ꯃꯁꯤꯒꯤꯗꯃꯛ ꯐꯩ: Adobe ꯇꯨꯜꯁꯤꯡꯅꯥ ꯁꯦꯝꯕꯥ PDF ꯁꯤꯡ, ꯅꯦꯇꯤꯚ (ꯁ꯭ꯀꯦꯟ ꯇꯧꯗꯕꯥ) ꯗꯣꯀꯨꯃꯦꯟ꯭ꯇꯁꯤꯡ
ꯃꯁꯤꯗꯥ ꯑꯋꯥꯕꯥ ꯃꯥꯌꯣꯛꯅꯩ: ꯁ꯭ꯀꯦꯟ ꯇꯧꯔꯕꯥ ꯗꯣꯀꯨꯃꯦꯟ꯭ꯇꯁꯤꯡ, ꯀꯝꯄ꯭ꯂꯦꯛꯁ ꯐꯣꯔꯃꯦꯇꯤꯡ
ꯃꯑꯣꯡ ꯳: Online Converters
ꯁꯣꯐ꯭ꯇꯋꯦꯌꯔ install ꯇꯧꯗꯅꯥ PDF ꯕꯨ Excel ꯗꯥ ꯑꯣꯟꯊꯣꯛꯄꯥ ꯌꯥꯕꯥ ꯐ꯭ꯔꯤ ꯑꯣꯅꯂꯥꯏꯟ ꯇꯨꯜ ꯀꯌꯥ ꯂꯩꯔꯤ꯫
ꯃꯃꯤꯡ ꯆꯠꯄꯥ ꯑꯣꯄꯁꯟꯁꯤꯡ
| ꯇꯨꯜ | ꯃꯁꯤꯒꯤꯗꯃꯛ ꯐꯩ | ꯑꯀꯥꯏꯕꯁꯤꯡ |
|---|---|---|
| Smallpdf | ꯊꯨꯅꯥ ꯑꯣꯟꯊꯣꯛꯅꯕꯥ | ꯐ꯭ꯔꯤ ꯚꯔꯖꯟꯗꯥ ꯅꯣꯡꯃꯒꯤ ꯂꯤꯃꯤꯠ ꯂꯩ |
| iLovePDF | ꯐꯥꯏꯜ ꯀꯌꯥ ꯑꯃꯨꯛꯇꯗꯥ ꯑꯣꯟꯊꯣꯛꯅꯕꯥ | ꯐꯥꯏꯜ ꯁꯥꯏꯖꯒꯤ ꯂꯤꯃꯤꯠ ꯂꯩ |
| PDF2Go | ꯇꯦꯕꯜ ꯂꯥꯏꯕꯁꯤꯡꯒꯤꯗꯃꯛ | ꯀꯝꯄ꯭ꯂꯦꯛꯁ ꯂꯦꯑꯥꯎꯠꯁꯤꯡꯗꯥ ꯑꯋꯥꯕꯥ ꯊꯣꯛꯄꯥ ꯌꯥꯏ |
ꯄ꯭ꯔꯥꯏꯚꯦꯁꯤꯒꯤ ꯋꯥꯐꯝ
ꯑꯣꯅꯂꯥꯏꯟ ꯀꯅꯚꯥꯔꯇꯔꯁꯤꯡ ꯁꯤꯖꯤꯟꯅꯕꯥ ꯃꯇꯝꯗꯥ, ꯅꯍꯥꯛꯀꯤ ꯐꯥꯏꯜ ꯑꯗꯨ ꯃꯈꯣꯌꯒꯤ ꯁꯔꯚꯔꯗꯥ upload ꯇꯧꯏ꯫ ꯃꯔꯨꯑꯣꯏꯕꯥ ꯐꯥꯏꯅꯥꯟꯁꯤꯑꯦꯜ ꯗꯦꯇꯥꯁꯤꯡꯒꯤꯗꯃꯛꯇꯤ, ꯑꯣꯐꯂꯥꯏꯟ ꯃꯑꯣꯡꯁꯤꯡ ꯅꯠꯇ꯭ꯔꯒꯥ ꯅꯍꯥꯛꯀꯤ browser ꯗꯥ ꯗꯦꯇꯥ ꯄ꯭ꯔꯣꯁꯦꯁ ꯇꯧꯕꯥ ꯇꯨꯜꯁꯤꯡ ꯁꯤꯖꯤꯟꯅꯕꯥ ꯈꯟꯂꯨ꯫
ꯃꯑꯣꯡ ꯴: Copy ꯑꯃꯁꯨꯡ Paste (ꯃꯁꯥꯅꯥ ꯇꯧꯕꯥ)
ꯀꯔꯤꯒꯨꯝꯕꯥ ꯃꯇꯝꯗꯥ ꯈ꯭ꯕꯥꯏꯗꯒꯤ ꯂꯥꯏꯕꯥ ꯃꯑꯣꯡꯅꯥ ꯊꯕꯛ ꯇꯧꯏ—ꯃꯔꯨꯑꯣꯏꯅꯥ ꯗꯦꯇꯥ ꯈꯔꯥꯈꯛꯇꯥ ꯑꯣꯏꯔꯕꯗꯤ꯫
ꯃꯁꯤ ꯀꯔꯝꯅꯥ ꯇꯧꯒꯅꯤ
- PDF ꯑꯗꯨ ꯍꯥꯡꯗꯣꯛꯎ ꯑꯃꯁꯨꯡ ꯃꯥꯎꯁꯅꯥ ꯇꯦꯕꯜ ꯑꯗꯨ ꯈꯟꯂꯨ
- Copy ꯇꯧ (Ctrl+C ꯅꯠꯇ꯭ꯔꯒꯥ Cmd+C)
- Excel ꯗꯥ Paste ꯇꯧ (Ctrl+V ꯅꯠꯇ꯭ꯔꯒꯥ Cmd+V)
- ꯐꯣꯔꯃꯦꯇꯤꯡꯒꯤ ꯑꯁꯣꯌꯕꯁꯤꯡ ꯁꯦꯝꯒꯠꯅꯕꯥ Data → Text to Columns ꯁꯤꯖꯤꯟꯅꯨ
ꯃꯁꯤ ꯀꯩꯗꯧꯉꯩ ꯊꯕꯛ ꯇꯧꯕꯒꯦ
ꯃꯁꯤꯒꯤ ꯃꯑꯣꯡ ꯑꯁꯤ ꯂꯃꯥꯏ ꯑꯃꯈꯛꯇꯥ ꯄꯥꯟꯕꯥ ꯇꯦꯕꯜ ꯂꯥꯏꯕꯁꯤꯡꯒꯤꯗꯃꯛ ꯈ꯭ꯕꯥꯏꯗꯒꯤ ꯐꯩ꯫ ꯃꯍꯩ ꯑꯗꯨ ꯁꯦꯡꯗꯣꯛꯅꯕꯥ ꯃꯇꯝ ꯈꯔꯥ ꯆꯪꯒꯅꯤ ꯍꯥꯏꯕꯗꯨ ꯈꯪꯖꯤꯟꯂꯨ꯫
ꯇꯣꯌꯅꯥ ꯊꯣꯛꯄꯥ ꯑꯋꯥꯕꯁꯤꯡ ꯑꯃꯁꯨꯡ ꯃꯁꯤꯕꯨ ꯀꯔꯝꯅꯥ ꯁꯦꯝꯒꯠꯀꯅꯤ
ꯃꯁꯤꯡꯁꯤꯡ Text ꯑꯣꯏꯅꯥ Import ꯇꯧꯔꯛꯄꯥ
Excel ꯅꯥ ꯅꯍꯥꯛꯀꯤ ꯃꯁꯤꯡꯁꯤꯡꯕꯨ text ꯑꯣꯏꯅꯥ ꯂꯧꯕꯥ ꯌꯥꯏ, ꯃꯁꯤꯅꯥ ꯍꯤꯁꯥꯞ ꯇꯧꯕꯗꯥ ꯑꯋꯥꯕꯥ ꯄꯤ꯫
ꯁꯦꯝꯒꯠꯄꯥ: ꯀꯣꯂꯝ ꯑꯗꯨ ꯈꯟꯂꯨ, Data → Text to Columns ꯗꯥ ꯆꯠꯂꯨ, Finish ꯗꯥ ꯅꯝꯃꯨ꯫ ꯅꯠꯇ꯭ꯔꯒꯥ ꯁꯦꯜꯁꯤꯡ ꯑꯗꯨꯕꯨ 1 ꯅꯥ ꯃꯜꯇꯤꯄ꯭ꯂꯥꯏ ꯇꯧꯗꯨꯅꯥ ꯃꯁꯤꯡꯗꯥ ꯑꯣꯟꯊꯣꯛꯎ꯫
ꯀꯣꯂꯝꯁꯤꯡ ꯄꯨꯟꯁꯤꯟꯅꯕꯥ
ꯀꯣꯂꯝ ꯀꯌꯥꯒꯤ ꯗꯦꯇꯥꯁꯤꯡ ꯁꯦꯜ ꯑꯃꯈꯛꯇꯗꯥ ꯄꯨꯟꯁꯤꯜꯂꯛꯄꯥ꯫
ꯁꯦꯝꯒꯠꯄꯥ: ꯗꯦꯇꯥ ꯑꯗꯨ ꯈꯥꯏꯗꯣꯛꯅꯕꯥ delimiter (space, comma, ꯅꯠꯇ꯭ꯔꯒꯥ fixed width) ꯁꯤꯖꯤꯟꯅꯗꯨꯅꯥ Text to Columns ꯁꯤꯖꯤꯟꯅꯨ꯫
ꯗꯦꯇꯥ ꯃꯥꯡꯕꯥ
ꯑꯣꯟꯊꯣꯛꯄꯥ ꯃꯇꯝꯗꯥ ꯗꯦꯇꯥ ꯈꯔꯥ ꯎꯕꯥ ꯐꯪꯗꯕꯥ꯫
ꯁꯦꯝꯒꯠꯄꯥ: ꯑꯇꯣꯞꯄꯥ ꯀꯅꯚꯥꯔꯇꯔ ꯇꯨꯜ ꯑꯃꯥ ꯁꯤꯖꯤꯟꯅꯗꯨꯅꯥ ꯌꯦꯡꯉꯨ—ꯈꯨꯗꯤꯡꯃꯛꯅꯥ ꯂꯦꯑꯥꯎꯠꯁꯤꯡ ꯇꯣꯉꯥꯟ ꯇꯣꯉꯥꯟꯅꯥ ꯂꯧꯏ꯫ ꯁ꯭ꯀꯦꯟ ꯇꯧꯔꯕꯥ PDF ꯁꯤꯡꯒꯤꯗꯃꯛꯇꯤ, ꯅꯍꯥꯛꯅꯥ OCR (optical character recognition) ꯃꯊꯧ ꯇꯥꯏ꯫
ꯐꯣꯔꯃꯦꯇꯤꯡ ꯃꯥꯡꯕꯥ
ꯃꯆꯨ, ꯐꯣꯟ꯭ꯇ, ꯑꯃꯁꯨꯡ ꯁꯦꯜ ꯕꯣꯔꯗꯔꯁꯤꯡ ꯃꯥꯡꯕꯥ꯫
ꯁꯦꯝꯒꯠꯄꯥ: ꯀꯅꯚꯥꯔꯇꯔ ꯑꯌꯥꯝꯕꯅꯥ ꯗꯦꯇꯥꯗꯥ ꯃꯤꯠꯌꯦꯡ ꯊꯝꯃꯤ, ꯎꯕꯥ ꯐꯪꯂꯤꯕꯥ ꯐꯣꯔꯃꯦꯇꯤꯡꯗꯥ ꯅꯠꯇꯦ꯫ ꯅꯍꯥꯛꯅꯥ Excel ꯗꯥ ꯃꯁꯥꯅꯥ ꯐꯣꯔꯃꯦꯇꯤꯡ ꯑꯃꯨꯛ ꯍꯟꯅꯥ ꯇꯧꯕꯥ ꯃꯊꯧ ꯇꯥꯒꯅꯤ꯫
ꯍꯦꯟꯅꯥ ꯐꯕꯥ ꯃꯍꯩ ꯐꯪꯅꯕꯥ ꯄꯥꯎꯇꯥꯛꯁꯤꯡ
ꯌꯥꯔꯤꯕꯃꯈꯩ ꯅꯦꯇꯤꯚ PDF ꯁꯤꯡ ꯁꯤꯖꯤꯟꯅꯨ
ꯗꯤꯖꯤꯇꯦꯜ ꯑꯣꯏꯅꯥ ꯁꯦꯝꯕꯥ PDF ꯁꯤꯡ (Word, Excel, ꯅꯠꯇ꯭ꯔꯒꯥ accounting ꯁꯣꯐ꯭ꯇꯋꯦꯌꯔꯗꯒꯤ) ꯑꯁꯤ ꯁ꯭ꯀꯦꯟ ꯇꯧꯔꯕꯥ ꯗꯣꯀꯨꯃꯦꯟ꯭ꯇꯁꯤꯡꯗꯒꯤ ꯍꯦꯟꯅꯥ ꯐꯅꯥ ꯑꯣꯟꯊꯣꯛꯄꯥ ꯌꯥꯏ꯫ ꯅꯍꯥꯛꯇꯥ ꯑꯣꯄꯁꯟ ꯂꯩꯔꯕꯗꯤ, ꯗꯤꯖꯤꯇꯦꯜ ꯚꯔꯖꯟꯁꯤꯡ ꯈꯣꯃꯖꯤꯟꯂꯨ꯫
OCR ꯂꯩꯕ꯭ꯔꯥ ꯌꯦꯡꯉꯨ
ꯀꯔꯤꯒꯨꯝꯕꯥ ꯅꯍꯥꯛꯀꯤ PDF ꯑꯁꯤ ꯁ꯭ꯀꯦꯟ ꯇꯧꯔꯕꯥ ꯐꯣꯇꯣ ꯑꯃꯥ ꯑꯣꯏꯔꯕꯗꯤ, ꯅꯍꯥꯛꯅꯥ OCR ꯌꯥꯎꯕꯥ ꯀꯅꯚꯥꯔꯇꯔ ꯑꯃꯥ ꯃꯊꯧ ꯇꯥꯏ꯫ ꯃꯁꯤꯒꯤ ꯐꯤꯆꯔ ꯑꯁꯤ ꯈꯟꯂꯨ—Smallpdf ꯑꯃꯁꯨꯡ Adobe Acrobat ꯑꯅꯤꯃꯛꯅꯥ ꯃꯁꯤ ꯄꯤꯔꯤ꯫
ꯃꯍꯩ ꯑꯗꯨ ꯍꯃꯥꯡꯗꯥ ꯌꯦꯡꯁꯤꯟꯂꯨ
ꯀꯅꯚꯥꯔꯇꯔ ꯑꯃꯠꯇꯥ ꯃꯄꯨꯡ ꯐꯥꯗꯦ꯫ ꯑꯣꯟꯊꯣꯛꯂꯕꯥ ꯃꯇꯝꯗꯥ:
- ꯔꯣ ꯑꯃꯁꯨꯡ ꯀꯣꯂꯝ ꯃꯁꯤꯡ ꯑꯗꯨ ꯑꯁꯦꯡꯕꯥ ꯗꯣꯀꯨꯃꯦꯟ꯭ꯇꯀꯥ ꯃꯥꯟꯅꯕ꯭ꯔꯥ ꯌꯦꯡꯉꯨ
- ꯃꯁꯤꯡ ꯈꯔꯥ ꯑꯁꯦꯡꯕꯥ ꯗꯦꯇꯥꯀꯥ ꯌꯦꯡꯁꯤꯟꯅꯨ
- ꯄꯨꯟꯁꯤꯟꯅꯕꯥ ꯅꯠꯇ꯭ꯔꯒꯥ ꯃꯥꯡꯈꯤꯕꯥ ꯗꯦꯇꯥꯁꯤꯡ ꯂꯩꯕ꯭ꯔꯥ ꯌꯦꯡꯉꯨ
ꯃꯁꯤꯅꯥ ꯃꯤꯅꯤꯠ ꯑꯃꯈꯛꯇꯥ ꯆꯪꯒꯅꯤ ꯑꯃꯁꯨꯡ ꯇꯨꯡꯗꯥ ꯊꯣꯛꯀꯗꯕꯥ ꯑꯋꯥꯕꯥ ꯀꯌꯥ ꯀꯣꯛꯍꯟꯒꯅꯤ꯫
ꯗꯣꯀꯨꯃꯦꯟ꯭ꯇꯀꯤ ꯃꯈꯜ ꯑꯗꯨ ꯈꯟꯂꯨ
ꯇꯣꯉꯥꯟ ꯇꯣꯉꯥꯟꯕꯥ PDF ꯃꯈꯜꯁꯤꯡꯗꯥ ꯇꯣꯉꯥꯟꯕꯥ ꯃꯑꯣꯡꯁꯤꯡ ꯃꯊꯧ ꯇꯥꯏ:
| ꯗꯣꯀꯨꯃꯦꯟ꯭ꯇꯀꯤ ꯃꯈꯜ | ꯈ꯭ꯕꯥꯏꯗꯒꯤ ꯐꯕꯥ ꯃꯑꯣꯡ |
|---|---|
| ꯕꯦꯡꯛ ꯁ꯭ꯇꯦꯠꯃꯦꯟ꯭ꯇꯁꯤꯡ | ꯑꯈꯟꯅꯕꯥ ꯐꯥꯏꯅꯥꯟꯁꯤꯑꯦꯜ ꯀꯅꯚꯥꯔꯇꯔꯁꯤꯡ |
| ꯏꯅꯚꯣꯏꯁꯁꯤꯡ | Adobe Acrobat ꯅꯠꯇ꯭ꯔꯒꯥ ꯑꯣꯅꯂꯥꯏꯟ ꯇꯨꯜꯁꯤꯡ |
| ꯗꯦꯇꯥ ꯔꯤꯄꯣꯔꯠꯁꯤꯡ | Power Query (Excel ꯒꯤ ꯃꯅꯨꯡꯗꯥ ꯌꯥꯎꯕꯥ) |
| ꯁ꯭ꯀꯦꯟ ꯇꯧꯔꯕꯥ ꯗꯣꯀꯨꯃꯦꯟ꯭ꯇꯁꯤꯡ | OCR ꯌꯥꯎꯕꯥ ꯇꯨꯜꯁꯤꯡ |
ꯑꯣꯟꯊꯣꯛꯄꯥ ꯉꯝꯗꯕꯥ ꯃꯇꯝꯗꯥ
ꯀꯔꯤꯒꯨꯝꯕꯥ ꯃꯇꯝꯗꯥ ꯀꯅꯚꯥꯔꯇꯔ ꯑꯃꯠꯇꯅꯥ ꯅꯍꯥꯛꯀꯤ ꯗꯦꯇꯥ ꯑꯗꯨ ꯁꯦꯡꯅꯥ ꯄꯨꯊꯣꯛꯄꯥ ꯉꯝꯗꯦ꯫ ꯃꯁꯤ ꯑꯌꯥꯝꯕꯅꯥ ꯃꯈꯥꯒꯤꯁꯤꯡꯗꯥ ꯊꯣꯛꯏ:
- ꯀꯝꯄ꯭ꯂꯦꯛꯁ ꯂꯦꯑꯥꯎꯠ ꯌꯥꯎꯕꯥ ꯗꯣꯀꯨꯃꯦꯟ꯭ꯇꯁꯤꯡ
- ꯀꯣꯂꯝ ꯀꯌꯥꯗꯥ ꯃꯥꯟꯅꯗꯕꯥ ꯃꯑꯣꯡꯗꯥ ꯗꯦꯇꯥ ꯂꯩꯕꯥ PDF ꯁꯤꯡ
- ꯐꯣꯇꯣ ꯐꯠꯇꯕꯥ ꯁ꯭ꯀꯦꯟ ꯇꯧꯔꯕꯥ ꯗꯣꯀꯨꯃꯦꯟ꯭ꯇꯁꯤꯡ
- Password ꯊꯝꯂꯕꯥ ꯐꯥꯏꯜꯁꯤꯡ (ꯑꯍꯥꯟꯕꯗꯥ protection ꯑꯗꯨ ꯂꯧꯊꯣꯛꯎ)
ꯃꯁꯤꯒꯨꯝꯕꯥ ꯃꯇꯝꯗꯥ, ꯃꯁꯥꯅꯥ ꯗꯦꯇꯥ ꯏꯕꯥ ꯅꯠꯇ꯭ꯔꯒꯥ ꯑꯈꯟꯅꯕꯥ ꯁꯣꯐ꯭ꯇꯋꯦꯌꯔ ꯁꯤꯖꯤꯟꯅꯕꯥ ꯈꯛꯇꯅꯥ ꯑꯁꯦꯡꯕꯥ ꯃꯑꯣꯡ ꯑꯣꯏꯒꯅꯤ꯫
ꯇꯣꯌꯅꯥ ꯍꯪꯕꯥ ꯋꯥꯍꯪꯁꯤꯡ
ꯑꯩꯅꯥ password-protected PDF ꯑꯃꯥ Excel ꯗꯥ ꯑꯣꯟꯊꯣꯛꯄꯥ ꯌꯥꯕ꯭ꯔꯥ?
ꯅꯍꯥꯛꯅꯥ ꯑꯍꯥꯟꯕꯗꯥ password protection ꯑꯗꯨ ꯂꯧꯊꯣꯛꯄꯥ ꯃꯊꯧ ꯇꯥꯒꯅꯤ꯫ ꯀꯔꯤꯒꯨꯝꯕꯥ ꯅꯍꯥꯛꯅꯥ password ꯑꯗꯨ ꯈꯪꯂꯕꯗꯤ, Adobe Reader ꯒꯨꯝꯕꯥ viewer ꯑꯃꯗꯥ PDF ꯑꯗꯨ ꯍꯥꯡꯗꯣꯛꯎ, protection ꯌꯥꯎꯗꯅꯥ PDF ꯑꯣꯏꯅꯥ print ꯇꯧ, ꯑꯗꯨꯒꯥ ꯑꯣꯟꯊꯣꯛꯎ꯫ ꯀꯔꯤꯒꯨꯝꯕꯥ ꯅꯍꯥꯛꯇꯥ password ꯂꯩꯇ꯭ꯔꯕꯗꯤ, ꯗꯣꯀꯨꯃꯦꯟ꯭ꯇ ꯑꯗꯨ ꯁꯦꯝꯈꯤꯕꯥ ꯃꯤꯑꯣꯏ ꯑꯗꯨꯗꯥ ꯄꯥꯎ ꯐꯥꯎꯅꯨ꯫
ꯀꯔꯤꯒꯤ ꯑꯩꯒꯤ ꯃꯁꯤꯡꯁꯤꯡ Excel ꯗꯥ text ꯑꯣꯏꯅꯥ ꯎꯠꯂꯤꯕꯅꯣ?
PDF ꯁꯤꯡꯅꯥ ꯃꯁꯤꯡ ꯑꯃꯁꯨꯡ text ꯒꯤ ꯃꯔꯛꯇꯥ ꯈꯦꯟꯅꯕꯥ ꯊꯝꯗꯦ—ꯃꯈꯣꯌꯁꯤ ꯂꯃꯥꯏ ꯑꯃꯗꯥ ꯂꯩꯕꯥ ꯃꯌꯦꯛꯁꯤꯡ ꯈꯛꯇꯅꯤ꯫ Excel ꯅꯥ ꯗꯦꯇꯥ ꯑꯁꯤ import ꯇꯧꯕꯥ ꯃꯇꯝꯗꯥ, ꯃꯁꯤꯅꯥ text ꯐꯣꯔꯃꯦꯇꯤꯡ ꯑꯣꯏꯅꯥ ꯂꯧꯕꯥ ꯌꯥꯏ꯫ ꯑꯣꯟꯊꯣꯛꯅꯕꯥ Data → Text to Columns ꯁꯤꯖꯤꯟꯅꯨ ꯅꯠꯇ꯭ꯔꯒꯥ 1 ꯅꯥ ꯃꯜꯇꯤꯄ꯭ꯂꯥꯏ ꯇꯧ꯫
ꯀꯗꯥꯏꯗꯒꯤ ꯈ꯭ꯕꯥꯏꯗꯒꯤ ꯑꯁꯦꯡꯕꯥ ꯃꯍꯩ ꯐꯪꯒꯅꯤ?
ꯃꯁꯤ ꯅꯍꯥꯛꯀꯤ ꯗꯣꯀꯨꯃꯦꯟ꯭ꯇꯇꯥ ꯌꯨꯝꯐꯝ ꯑꯣꯏ꯫ ꯇꯦꯕꯜ ꯂꯥꯏꯕꯥ ꯅꯦꯇꯤꯚ PDF ꯁꯤꯡꯒꯤꯗꯃꯛꯇꯤ, Excel ꯒꯤ Power Query ꯅꯥ ꯑꯌꯥꯝꯕꯅꯥ ꯐꯅꯥ ꯊꯕꯛ ꯇꯧꯏ꯫ ꯀꯝꯄ꯭ꯂꯦꯛꯁ ꯗꯣꯀꯨꯃꯦꯟ꯭ꯇꯁꯤꯡꯒꯤꯗꯃꯛꯇꯤ, Adobe Acrobat ꯅꯠꯇ꯭ꯔꯒꯥ ꯑꯈꯟꯅꯕꯥ ꯀꯅꯚꯥꯔꯇꯔꯁꯤꯡꯅꯥ ꯍꯦꯟꯅꯥ ꯐꯅꯥ ꯊꯕꯛ ꯇꯧꯕꯥ ꯎꯕꯥ ꯐꯪꯏ꯫ ꯈꯪꯅꯕꯥ ꯑꯃꯈꯛꯇꯥ ꯉꯥꯏꯔꯕꯥ ꯃꯑꯣꯡꯗꯤ ꯅꯍꯥꯛꯀꯤ ꯐꯥꯏꯜ ꯑꯗꯨ ꯇꯦꯁ꯭ꯇ ꯇꯧꯕꯅꯤ꯫
ꯑꯩꯅꯥ PDF ꯀꯌꯥ ꯑꯃꯨꯛꯇꯗꯥ ꯑꯣꯟꯊꯣꯛꯄꯥ ꯌꯥꯕ꯭ꯔꯥ?
ꯍꯣꯌ, ꯑꯗꯨꯕꯨ ꯃꯑꯣꯡꯁꯤꯡꯗꯤ ꯇꯣꯉꯥꯟꯅꯥ ꯂꯩ꯫ iLovePDF ꯒꯨꯝꯕꯥ ꯑꯣꯅꯂꯥꯏꯟ ꯇꯨꯜ ꯈꯔꯅꯥ batch conversion ꯁꯧꯒꯠꯂꯤ꯫ Power Query ꯅꯥ ꯁꯦꯠꯑꯥꯞ ꯈꯔꯥ ꯇꯧꯔꯒꯥ ꯐꯥꯏꯜ ꯀꯌꯥ ꯑꯃꯨꯛꯇꯗꯥ import ꯇꯧꯕꯥ ꯌꯥꯏ꯫ ꯇꯣꯌꯅꯥ batch ꯇꯧꯅꯕꯒꯤꯗꯃꯛꯇꯤ, Adobe Acrobat Pro ꯒꯨꯝꯕꯥ desktop ꯁꯣꯐ꯭ꯇꯋꯦꯌꯔꯁꯤꯡ ꯈ꯭ꯕꯥꯏꯗꯒꯤ ꯐꯩ꯫
PDF ꯕꯨ Excel ꯗꯥ ꯑꯣꯟꯊꯣꯛꯄꯥ ꯑꯁꯤ automate ꯇꯧꯕꯥ ꯌꯥꯕꯥ ꯃꯑꯣꯡ ꯂꯩꯕ꯭ꯔꯥ?
Power Query connections ꯁꯤꯡꯅꯥ source PDF ꯑꯗꯨ update ꯇꯧꯕꯥ ꯃꯇꯝꯗꯥ ꯃꯁꯥꯅꯥ ꯑꯣꯇꯣꯃꯦꯇꯤꯛ ꯑꯣꯏꯅꯥ refresh ꯇꯧꯕꯥ ꯌꯥꯏ꯫ ꯍꯦꯟꯅꯥ ꯑꯦꯗꯚꯥꯟꯁ ꯑꯣꯏꯕꯥ automation ꯒꯤꯗꯃꯛꯇꯤ, Python ꯒꯨꯝꯕꯥ programming ꯇꯨꯜꯁꯤꯡ ꯑꯃꯁꯨꯡ Tabula ꯅꯠꯇ꯭ꯔꯒꯥ Camelot ꯒꯨꯝꯕꯥ library ꯁꯤꯡ ꯁꯤꯖꯤꯟꯅꯗꯨꯅꯥ PDF ꯁꯤꯡ ꯄ꯭ꯔꯣꯒ꯭ꯔꯥꯃꯦꯇꯤꯛ ꯑꯣꯏꯅꯥ ꯄ꯭ꯔꯣꯁꯦꯁ ꯇꯧꯕꯥ ꯌꯥꯏ꯫
ꯋꯥꯔꯦꯞ
PDF ꯕꯨ Excel ꯗꯥ ꯑꯣꯟꯊꯣꯛꯄꯥ ꯑꯁꯤ ꯇꯦꯝꯅꯥ ꯂꯥꯏꯕꯥ ꯊꯕꯛ ꯑꯣꯏꯗꯕꯥ ꯌꯥꯏ, ꯑꯗꯨꯕꯨ ꯅꯍꯥꯛꯇꯥ ꯑꯣꯄꯁꯟ ꯀꯌꯥ ꯂꯩꯔꯤ:
- Excel Power Query ꯂꯥꯏꯕꯥ, ꯁꯦꯡꯅꯥ ꯂꯩꯕꯥ ꯇꯦꯕꯜꯁꯤꯡꯒꯤꯗꯃꯛ
- Adobe Acrobat ꯅꯦꯇꯤꯚ PDF ꯁꯤꯡꯗꯥ ꯊꯥꯖꯕꯥ ꯌꯥꯕꯥ ꯃꯍꯩꯒꯤꯗꯃꯛ
- Online converters ꯊꯨꯅꯥ, ꯀꯔꯤꯒꯨꯝꯕꯥ ꯃꯇꯝꯗꯥ ꯃꯊꯧ ꯇꯥꯕꯒꯤꯗꯃꯛ
- Manual copy-paste ꯄꯤꯛꯄꯥ, ꯂꯥꯏꯕꯥ ꯗꯦꯇꯥꯁꯤꯡꯒꯤꯗꯃꯛ
ꯃꯔꯨꯑꯣꯏꯕꯗꯤ ꯅꯍꯥꯛꯀꯤ ꯗꯣꯀꯨꯃꯦꯟ꯭ꯇꯀꯤ ꯃꯈꯜꯒꯥ ꯃꯥꯟꯅꯕꯥ ꯃꯑꯣꯡ ꯑꯗꯨ ꯈꯟꯕꯅꯤ—ꯑꯃꯁꯨꯡ ꯗꯦꯇꯥ ꯑꯗꯨ ꯁꯤꯖꯤꯟꯅꯗ꯭ꯔꯤꯉꯩꯗꯥ ꯃꯇꯝ ꯄꯨꯝꯅꯃꯛꯇꯥ ꯃꯍꯩ ꯑꯗꯨ ꯌꯦꯡꯁꯤꯟꯕꯅꯤ꯫