How to convert pdf into excel which is in tabular format

Help Automation Ops
,
1

How to convert pdf into excel which is in tabular format.
The pdf is in tabular form, how to convert that into excel

2

you can use Read PDF Text + Data Scraping (For Simple Tables)

3

Hi @anjani_priya

  • Use the Read PDF Text or Read PDF with OCR activity to extract text from the PDF and store the result in a variable.
  • Pass this variable to the Generate Data Table from Text activity to convert the extracted text into a DataTable. Store the output in a DataTable variable.
  • Finally, use the Write Range Workbook activity to write the DataTable into an Excel file.

Hope this helps!

4

Hi @anjani_priya

Please check below link,

Happy Automation!

5

Hey @anjani_priya to get data from pdf use get text or get ocr text related to your document requirement then use Generate datatable activity and modify the table accordingly. finally use write range .
cheers

6

the table data is not coming as rows and columns

7

A code editor displays an error message indicating that a required assembly, , is missing from the project. (Captioned by AI)
A code editor displays an error message indicating that a required assembly, , is missing from the project. (Captioned by AI)1081×540 40.3 KB

error

8

after generate, the table data is not in rows and columns

9

@anjani_priya did you try with document understanding?

10

no i haven’t tried with DU

11

Hi @anjani_priya

I have slightly modified the code check this!
PDF_To_Excel.zip (96.2 KB)

Hope this helps!

12

Hey!

If your PDF is in a tabular format, there are a few ways you can convert it to Excel pretty smoothly:

  1. Use UiPath’s PDF Activities – If you’re working in UiPath, try using the Read PDF Text or Read PDF with OCR activities (depending on whether your PDF is native or scanned). Then, you can parse the extracted text and use string manipulation or regex to structure it into a DataTable.
  2. Third-Party Libraries – You can also integrate libraries like Tabula (Java-based) or PDF to Excel converters via API. These can detect tables more accurately and give structured outputs.
  3. Manual Clean-Up (if needed) – Sometimes the conversion needs a bit of post-processing. You can write logic in UiPath to clean and align the data before writing it to Excel using the Write Range activity.
  4. Try Exporting with Tools First – If this is a one-time task, you might consider using Adobe Acrobat or free online tools to export the table to Excel and then refine it in UiPath.

Let us know what kind of PDF you’re dealing with (native or scanned) and we can suggest a more tailored approach!

13

Hi @anjani_priya

Could you provide the PDF file?
and, do you have access to AI Units ?, as we can use GenAI activities to attain the result you need.

14

I don’t have access to it.

15

@anjani_priya
If your table in pdf is bit complex

The image displays the "Get Data" dropdown menu in Microsoft Excel, showcasing various file import options organized under different categories. (Captioned by AI)
The image displays the "Get Data" dropdown menu in Microsoft Excel, showcasing various file import options organized under different categories. (Captioned by AI)568×560 28.1 KB

Click on From PDF and chose the pdf
you can try this way!
Hope this helps!

1 Like
16

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.