Hey!
If your PDF is in a tabular format, there are a few ways you can convert it to Excel pretty smoothly:
- 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.
- 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.
- 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.
- 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!