Maqaalkani wuxuu ku tusi doonaa sida loo soo saaro miisaska waraaqaha PDF^{(extract tables from PDF documents)} . Waxaa laga yaabaa inaad haysato faylal badan oo PDF ah oo ay ku jiraan miisas badan oo aad rabto inaad si gaar ah u isticmaasho. Koobiyaynta^(Copying) iyo dhajinta miisaskaas maaha doorasho wanaagsan sababtoo ah waxaa laga yaabaa inaysan siin wax soo saarka la filayo, sidaas darteed waxaad u baahan tahay qaar ka mid ah doorashooyin kale oo fudud oo ka soo saari kara miisaska faylka PDF oo u keydin kara miisaska faylal kala duwan.

Inta badan qalabkan miiska soo saara ee PDF^{(PDF table extractor tools)} ma caawin karaan haddii miiska PDF la sawiro. Xaaladdan oo kale, waa inaad marka hore ka dhigtaa PDF-ka mid la raadin karo^{(make the PDF searchable)}  ka dibna isku day doorashooyinkan.

Shaxda ka saar dukumeenti PDF

Maqaalkan, waxaan ku darnay 2 adeeg oo khadka ah oo bilaash ah iyo 3 software bilaash ah si aan miisaska uga soo saarno faylka PDF :

1. PDF ilaa XLS
2. PDFtoExcel.com
3. Tabula
4. ByteScout PDF Multitool
5. Sida PDF Desktop.

1] PDF ilaa XLS

PDF ilaa XLS waa mid ka mid ah xulashooyinka ugu fiican ee miisaska laga soo saari karo PDF . Waxay leedahay laba astaamood oo ka dhigaya mid waxtar leh. Waxaad miiska ka soo qaadan kartaa 20 dukumeenti oo PDF^{(20 PDF)} ah. Sidoo kale, soo saarista miiska PDF waa mid toos ah. ^(PDF)Waxay soo saartaa wax soo saarka sida faylka XLSX . Haddii PDF leeyahay miisas badan, markaas miis kasta si gaar ah ayaa lagu kaydiyaa xaashi kala duwan ee wax soo saarka XLSX file.

Fur bogga hore^{(Open the homepage)} ee adeeggan. Taas ka dib, jiid n drop PDF files ama isticmaal badhanka UPLOAD FILES . PDF kasta oo la soo geliyo waxa si toos ah loogu rogaa qaabka XLSX. Marka faylalka wax soo saarka ay diyaar yihiin, waxaad soo dejisan kartaa mid mid ama waxaad soo dejisan kartaa faylka ZIP oo ka koobnaan doona dhammaan faylasha wax soo saarka.

2] PDFtoExcel.com

Adeegga PDFtoExcel.com^{(PDFtoExcel.com)} waxa uu hal mar ka soo saari karaa miisaska hal PDF laakiin waxa ay taageertaa meelo badan oo PDF ah . Waxay taageertaa OneDrive , desktop , Google Drive , iyo aaladaha Dropbox^(Dropbox) si loo soo geliyo PDF . Sidoo kale, habka beddelka waa si toos ah.

Bogga hore ee adeegga waa halkan^(here) . Halkaa, dooro ikhtiyaarka soo dejinta si aad ugu darto PDF . Intaa ka dib, waxay si toos ah u dhejisaa oo u beddeshaa PDF ilaa faylka Excel ( XLSX ). Marka wax soo saarku diyaar yahay, waxaad heli doontaa isku xirka soo dejinta si aad u badbaadiso faylka wax soo saarka ee uu ku jiro miiska PDF

Fiiro gaar ah:^{(Note: )} Inkastoo adeegani sheegayo inuu ka soo saari karo miisaska faylasha PDF -ka ee la sawiray sidoo kale, aniga iimay shaqayn. Waxaad weli isku dayi kartaa in loo sawiro PDF .

3] Tabula

Tabula waa software awood leh oo si toos ah u ogaan kara jaantusyada ku jira PDF ka dibna kuu ogolaanaya inaad u kaydiso miisaska sida TSV , JSON , ama CSV . Waxaad dooran kartaa ikhtiyaarka aad ku kaydin karto faylalka CSV ee kala duwan miis kasta oo ^(CSV)PDF ah ama waxaad ku kaydin kartaa dhammaan miisaska hal fayl CSV ah.^(CSV)

Si aad u soo dejiso isha furan ee^{(open-source)} miiska soo saarta PDF, guji halkan^{(click here)} . Waxay sidoo kale u baahan tahay Java^{(requires Java)} si ay u shaqeyso oo u isticmaasho si guul leh.

Soo saar faylka ZIP ee aad soo dejisay, oo socodsii faylka ^(ZIP)tabula.exe . Waxay furi doontaa bog browserkaaga caadiga ah. Haddii bogga aan la furin, dabadeed ku dar http://localhost:8080 browserkaaga oo tabo Gelida^(Enter) .

Hadda waxaad arki doontaa interface-keeda halkaas oo aad isticmaali karto ikhtiyaarka Browse si aad ugu darto ^(Browse)PDF . Intaa ka dib, taabo badhanka Import . Marka PDF lagu daro, waxaad ku arki kartaa bogag PDF ah interface-keeda.^(PDF)

Isticmaal batoonka Autodetect Tables oo waxay si toos ah u iftiimin doontaa dhammaan jaantusyada ku jira PDF -kaas . Waxa kale oo aad gacanta ku iftiimin kartaa miis adiga oo dooranaya miis gaar ah. Haddii aad rabto, waxaad sidoo kale ka saari kartaa miisaska la doortay^{(remove selected tables)} ee aad dooratay.

Tani waxay kaa caawin doontaa inaad kaydiso oo kaliya miisaska aad rabto. Marka miisaska PDF la iftiimiyo, dhagsii badhanka Xogta la soo Saaray ee Horu-u-dhigga & Dhoofinta^{(Preview & Export Extracted Data)} .

Ugu dambeyntii, isticmaal liiska hoos-u-dhaca ee laga heli karo qaybta sare si aad u doorato qaabka wax soo saarka, oo taabo badhanka dhoofinta . ^(Export)Tani waxay kaydin doontaa miisaska PDF ee qaabka wax soo saarka ee aad dooratay.

4] ByteScout PDF Multitool

Sida magacaba ka muuqata, software-kani waxa uu la socdaa qalabyo badan. Waxay leedahay aalado ay ka mid yihiin u beddelo PDF una beddelo TIFF badan^{(convert PDF to multipage TIFF)} , beddel dukumeenti PDF^{(rotate PDF document)} , ka dhigaan PDF aan la baadhi karin^{(make PDF unsearchable)} , kor u qaad PDF^{(optimize PDF)} , ku dar sawir PDF ah^{(add an image to PDF)} , iyo in ka badan. Muuqaalka miiska PDF^(PDF) -ka ayaa sidoo kale jira kaas oo ah mid aad u fiican. Faa'iidada qalabkani waa inaad sidoo kale ka soo saari kartaa miisaska PDF ee la sawiray^{(extract tables from scanned PDF)} . Waxaad ku ogaan kartaa shaxanka bogag badan ka dibna kala soo bixi miisaskaas sida CSV , XLS , XML , TXT , ama qaabka JSON . Kahor soo saarista, waxay sidoo kale kuu ogolaaneysaa inaad dejiso kala duwanaanta bogga^{(page range)}si loo soo saaro shaxanka bogag cayiman oo keliya.

Waxaad ka qaadan kartaa software-kan halkan^(here) . Waa u bilaash isticmaalka aan ganacsiga ahayn^{(free for non-commercial use)} oo keliya. Ka dib marka la rakibo, socodsii software-kan oo isticmaal ikhtiyaarka Dukumentiga Furan si aad ugu darto ^{(Open Document)}PDF . Intaa ka dib, dhagsii aaladda Detect tables sida lagu muujiyey sawirka kore. Qalabkani waxa uu ku hoos jiraa qaybta Soo saarista Xogta^{(Data Extraction)} .

Waxay furi doontaa sanduuq aad ku dejin karto shuruudaha lagu ogaanayo miisaska. Tusaale ahaan, waxaad dejin kartaa tirada ugu yar ee tiirarka, safafka, xariiqda ugu yar ee inta u dhaxaysa miisaska, dejiso qaabka ogaanshaha miis xuduudeed ama xuduud la'aan, iwm. Isticmaal ikhtiyaarrada ama ilaali goobaha caadiga ah.

Taas ka dib, taabo Badhanka soo ogow batoonka miiska^{(Detect next table)} ee sanduuqaas. Waxay aqoonsan doontaa oo dooran doontaa shax ku yaal bogga hadda. Habkaas, waxaad u guuri kartaa bog kale oo waxaad ogaan kartaa miisas badan.

Markaad dhammayso, isticmaal sii wad si aad u soo^{(Proceed to extraction)} saarto badhanka, oo dooro qaabka wax soo saarka. Ugu dambeyntii, waxaad isticmaali kartaa ikhtiyaarrada si aad u badbaadiso jaantusyada bogga hadda ama aad qeexdo xadka bogga, oo aad badbaadiso wax soo saarka.

Qalabku wuxuu bixiyaa wax soo saar lagu qanco. Laakiin mararka qaarkood, waxaa laga yaabaa inay ogaato waxyaabo kale oo ku jira PDF , waxaana laga yaabaa inay awoodi waayaan inay ka soo saaraan miisaska bogag badan. Xaaladdaas, waa inaad isticmaashaa si aad u soo qaadato oo aad u kaydiso miisaska mid mid.

5] Sejda PDF Desktop

Sejda PDF Desktop sidoo kale waa software ujeedooyin badan leh. Waxay hagaajin kartaa ama isku dhejin kartaa PDF^{(compress PDF)} , ku dar watermark si PDF, ka saar xaddidaadaha PDF^{(remove restrictions from PDF)} , wax ka beddel dukumeenti PDF , iwm. Si kastaba ha ahaatee, qorshaheeda bilaashka ah ayaa xaddidan. Qorshaha xorta ah, kaliya 3 hawlood maalintii ayaa la qaban karaa. Sidoo kale, xadka cabbirka PDF waa ^(PDF)50 MB ama 10 bog^{(10 pages)} .

Waxaad isticmaali kartaa PDF ilaa qalab beddelka Excel^{(PDF to Excel)} si aad u soo saarto miisaska PDF . Waxay si toos ah u ogaanaysaa jaantusyada boggaga PDF waxayna kuu ogolaanaysaa inaad u kaydiso miisaska sida XLSX ama CSV .

Isku xirka ay soo dejiso waa halkan^(here) . Ka dib markii la rakibo, isticmaal PDF ilaa qalab Excel oo ka soo jeeda interfacekeeda ugu weyn. Ka dib markaad doorato qalabkaas, isticmaal Dooro faylasha PDF^{(Choose PDF files)} badhanka. Hal PDF kaliya ayaa lagu dari karaa qorshaha bilaashka ah.

Marka PDF lagu daro, waxay ku siin doontaa Beddel PDF ilaa CSV^{(Convert PDF to CSV)} oo U Beddel PDF una beddelo badhamada Excel . ^{(Convert PDF to Excel)}Isticmaal badhan ka dibna waxaad kaydin kartaa wax soo saarka goobta aad rabto ee PC-gaaga.

Qalabkeeda ogaanshaha miiska PDF waa wanaagsan yahay. ^(PDF)Uma baahnid inaad gacanta ku ogaato miisaska. Weli, mararka qaarkood waxaa laga yaabaa inay ku jirto qoraal kale sida miiska PDF oo ay ku kaydiso wax soo saarka. Laakiin natiijada guud waa wanaagsan tahay.

Waa intaas.

Kuwani waa qaar ka mid ah qalabyada wanaagsan ee laga soo saaro miisaska PDF . Software-ka Tabula^(Tabula) wuu ka waxtar badan yahay qalabka kale. Weli, waxaad isku dayi kartaa dhammaan agabyada oo aad hubiso kan ku caawinaya.

Akhris la mid ah:^{(Similar reads:)}

• Ka soo saar lifaaqyada PDF^{(Extract attachments from PDF)}
• Ka soo saar qoraalka la iftiimiyay ee PDF^{(Extract highlighted text from PDF)} .

How to extract Tables from PDF documents

This article will show you how to extract tables from PDF documents. You might have many PDF files that contain multiple tables that you want to use separately. Copying and pasting those tables is not a good option as it may not give the expected output, therefore you need some other simple options that can extract tables from a PDF file and save those tables as separate files.

Most of these PDF table extractor tools can’t help if the PDF table is scanned. In such a case, you should first make the PDF searchable and then try these options.

Extract Tables from PDF documents

In this post, we have added 2 free online services and 3 free software to extract tables from a PDF file:

1. PDF to XLS
2. PDFtoExcel.com
3. Tabula
4. ByteScout PDF Multitool
5. Sejda PDF Desktop.

1] PDF to XLS

PDF to XLS is one of the best options for extracting tables from PDF. It has two features that make it handy. You can fetch tables from 20 PDF documents together. Also, the PDF table extraction is automatic. It generates the output as an XLSX file. If a PDF has multiple tables, then each table is stored separately in different sheets of output XLSX file.

Open the homepage of this service. After that, drag n drop PDF files or use UPLOAD FILES button. Each uploaded PDF is converted to XLSX format file automatically. When the output files are ready, you can download them one by one or download a ZIP file that will contain all the output files.

2] PDFtoExcel.com

PDFtoExcel.com service can extract tables from one PDF at once but it supports multiple platforms to upload PDF. It supports OneDrive, desktop, Google Drive, and Dropbox platforms to upload a PDF. Also, the conversion process is automatic.

This service homepage is here. There, select an upload option to add PDF. After that, it automatically uploads and converts PDF to Excel (XLSX) file. When the output is ready, you will get the download link to save the output file containing PDF table(s).

Note: Though this service mentions that it can extract tables from scanned PDF files also, it didn’t work for me. You can still try it for scanned PDF.

3] Tabula

Tabula is a powerful software that can automatically detect tables present in a PDF and then lets you save those tables as TSV, JSON, or CSV file. You can select the option to save separate CSV files for each PDF table or save all the tables in a single CSV file.

To download this open-source PDF table extractor, click here. It also requires Java to run and use it successfully.

Extract the ZIP file that you downloaded, and run tabula.exe file. It will open a page in your default browser. If the page is not opened, then add http://localhost:8080 in your browser and press Enter.

Now you will see its interface where you can use the Browse option to add a PDF. After that, press Import button. When the PDF is added, you can see PDF pages on its interface.

Use Autodetect Tables button and it will highlight all the tables present in that PDF automatically. You can also manually highlight a table by selecting a particular table. If you want, you can also remove selected tables of your choice.

This will help you save only those tables that you want. When PDF tables are highlighted, click on the Preview & Export Extracted Data button.

Finally, use the drop-down menu available on the top part to select an output format, and press Export button. This will save PDF tables in the output format file selected by you.

4] ByteScout PDF Multitool

As the name suggests, this software comes with multiple tools. It has tools such as convert PDF to multipage TIFF, rotate PDF document, make PDF unsearchable, optimize PDF, add an image to PDF, and more. PDF table detector feature is also there which is pretty awesome. The advantage of this tool is you can extract tables from scanned PDF too. You can detect tables in multiple pages and then extract those tables as CSV, XLS, XML, TXT, or JSON format file. Before extraction, it also lets you set a page range to extract tables from specified pages only.

You can grab this software here. It is free for non-commercial use only. After installation, run this software and use Open Document option to add a PDF. After that, click on the Detect tables tool as highlighted in the image above. This tool is present under Data Extraction category.

It will open a box where you can set conditions to detect tables. For example, you can set a minimum number of columns, rows, minimum line breaks between tables, set table detection mode to bordered or borderless table, etc. Use options or keep the default settings.

After that, press Detect next table button in that box. It will identify and select a table on the current page. In that way, you can move to another page and detect more tables.

When you’re done, use Proceed to extraction button, and select the output format. Finally, you can use options to save the tables from the current page or define a page range, and save the output.

The tool gives a satisfactory output. But sometimes, it might detect other content in PDF, and might not be able to extract tables from multiple pages. In that case, you should use it to fetch and save tables one by one.

5] Sejda PDF Desktop

Sejda PDF Desktop is also a multipurpose software. It can optimize or compress PDF, add watermark to PDF, remove restrictions from PDF, edit PDF document, etc. However, its free plan has limitations. In the free plan, only 3 tasks per day can be done. Also, the PDF size limit is 50 MB or 10 pages.

You can use its PDF to Excel conversion tool to extract PDF tables. It automatically detects the tables in PDF pages and lets you save those tables as XLSX or CSV.

Its download link is here. After installation, use PDF to Excel tool from its main interface. After selecting that tool, use Choose PDF files button. Only one PDF can be added to the free plan.

When the PDF is added, it will provide Convert PDF to CSV and Convert PDF to Excel buttons. Use a button and then you can save the output to the desired location on your PC.

Its PDF table detection tool is good. You don’t have to manually detect tables. Still, sometimes it might include other text content as a PDF table and store it in the output. But overall results are good.

That’s all.

These are some good tools to extract tables from PDF. Tabula software is more effective than other tools. Still, you can try all the tools and check which helps.

Similar reads:

• Extract attachments from PDF
• Extract highlighted text from PDF.

Related posts

• Beddelista Dukumentiga: Beddel DOC, PDF, DOCX, RTF, TXT, faylasha HTML

• Waa maxay faylka PPS? Sidee PPS loogu beddelaa PDF gudaha Windows 11/10?

• Qoraalka PDF wuu baaba'aa marka la tafatirayo ama kaydinayo faylka Windows 11/10

• Aaladaha Intarneedka ee Tifaftiraha PDF ee Bilaashka ah ee ugu Wanaagsan ee ku saleysan Daruuraha

• Aalad Online ah oo Tifaftirayaasha PDF ah oo bilaash ah si aad u saxdo faylasha PDF - PDF Haa

• Sida erayga sirta ah loogu ilaaliyo oo loo ilaaliyo dukumeenti PDF LibreOffice

• Sida loo dayactiro PDF iyadoo la isticmaalayo Qalabka Fixer PDF ee Windows 10

• Abuuraha PDF24 waa abuure PDF bilaash ah si uu u abuuro, u beddelo, loogu daro faylasha PDF

• Daar qaabka laba bog ee PDF ee Google Chrome PDF Viewer

• U beddelo faylka JPG PDF Online Free

• Sida dukumeentiga PDF loogu beddelo sawir TIFF badan oo gudaha Windows ah

• Sida loo sahlo Layout-ka laba-bog ee PDF-yada browserka Edge

• Akhristayaasha Codka bilaashka ah ee PDF ee ugu fiican Windows 10

• Ku dar, ka saar ama wax ka beddel Hyperlinks gudaha faylalka PDF oo wata PDF Link Editor

• Hal-abuurka ugu fiican ee PDF Stamp Free ee Windows 10

• Compressor PDF bilaash ah si loo yareeyo cabbirka faylka PDF gudaha Windows 10

• Adobe Reader kuma shaqaynayo Windows 11/10

• Is barbar dhig PDF, HTML, PPT, iwm. Documents Online isticmaalaya qalabkan bilaashka ah

• Sidee looga soo saaraa qoraalka la iftiimiyay PDF ahaan qoraal ahaan?

• Sida faylka Excel loogu beddelo PDF onlayn addoo isticmaalaya Google Drive