How to extract data from PDF and save it in excel

[Vincent_Nuestro]

How to Extract data from PDF and save it in excel file.

I have some records the i need to get inside PDF file.
Please see image below

here is the output i copied and paste in the notepad

how can i arrange them and write it in excel

Thank you in advance
Vincent

[GANESH_BALAGAM (GANESH KUMAR BALAGAM)]

Hi @Vincent_Nuestro
If you have bulk items better to choose Document understanding process to extract data from documents and import to datatable.

[Vincent_Nuestro]

hi this process only runs every monday and around 30 to 50 Item per monday.

[GANESH_BALAGAM (GANESH KUMAR BALAGAM)]

If the documents have fixed format like Structured or unstructured you can get the data by using Regex or String manipulation and also doc understanding processes.

[supermanPunch (Arpan)]

@Vincent_Nuestro

I have some records the i need to get inside PDF file.
Please see image below

Hi @Vincent_Nuestro ,

If the Table always contains values and will not have any blank values, We could adopt the regex method of retreiving the records and adding the records to a Datatable, then write it to an Excel sheet.

Could you gives us a Confirmation whether the data will always be present for each column in the PDF table ? If you have the case of empty values, Could you provide that case data along with the case which has non-empty values in columns.

Providing samples of different scenarios would help us better analyse the problem and suggest the appropriate approach.

[Vincent_Nuestro]

Hi, to confirm the data will always present for each column in the PDF table.

Thank you

[supermanPunch (Arpan)]

Hi @Vincent_Nuestro ,

Could you check the workflow provided in the below post :

PDF TABLES EXTRACTION EVEN WHEN ROWS ARE DYNAMIC

Hi @bhanusai_sajja , I believe the Sample PDF shared is a sample data only and not of confidential data. If it is confidential, Do Let me know. However, I am excluding the PDF sample that was provide to me in private. Check the below workflow : PDF_To_Excel_Corrected.zip (4.0 KB) The Data that you have provided, seemed to have some problem with the column name, and hence it was throwing out error. I did correct that part by implementing a counter/index to the column names if it was already h…

If the PDF has a Simpler table, this workflow should be able to extract and save it in Excel. This might not work for all types of PDF.

However, Do try this and let us know if you get any errors.

Also, for the regex method extraction, we would require a Sample PDF or the exracted text to check further the patterns, analyse and provide a better solution. You could also research on the regex part as there are many tutorials available in the Forum :

Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

THE PURPOSE OF THIS POST IS TO HELP NEW REGEX USERS If you need help with Regex be sure to provide in your post, a Sample, the Output and the Pattern (as much as you know). CONTENTS: Section : I need a Regex Pattern ASAP! - My first Regex Post Section : Regex samples that you can use! Section : I need help applying regex in UiPath Section : Regex Matches and Groups Section : Le…

[CheatSheet] - System.Text.RegularExpressions | RegEx

This CheatSheet introduces the basic use of regex functions. With further examples also special cases are presented. Introduction From the namespace System.Text.RegularExpressions following methods are offered: Regex.Match Regex.Matches Regex.isMatch Regex.Replace Regex.Split A simple usage for example would look like this: [grafik] Recommendation: add System.Text.RegularExpressions to the imports: [grafik] it allows to use the shortened statement, as the namespace part can be ommited…