Hey @Olu_Emmanuel so these are the some steps you need to follow to extract the data and write into the excel.
First create your excel format for example -your column names using build data table
after this use for each file in folder activity -so it will give you all the pdf file from the folder inside the for each use read pdf/read pdf ocr activity based on your pdf format
now use string manipulation or regex to extract specific content from your pdf now use add data row activity and pass the output . for string manipulation/regex you use assign activity and that assign variable you have to pass in the add data row activity also that build datatable vriable you hav to pass in the add data row activity so it will store the data in that datatable variable now use write range activity to write the data i the excel.
cheers