May 09 2024 12:12 AM
How to convert pdf to excel?
I have received a quotation as a table displayed in a PDF file. I want to convert this quotation into an Excel so that I can edit it easily. I have tried to do this in Excel by selecting Get Data - From File - From PDF, but the data is scattered in a mess of cells and requires a lot of manual changes. Need a lot of manual modification.
Are there any other ways to convert PDF to Excel? Thanks for your help.
May 09 2024 12:25 AM
You can try converting the PDF to a Word document and then try to copy the table and paste it on Excel.
If not, you can also try to directly convert the PDF file to an Excel file and see if it works. For instance: This one
May 09 2024 12:48 AM - edited May 09 2024 12:58 AM
Hi AlfCrawford,
Generally speaking, you can import table data in PDF directly through Get Data - From File - From PDF in Excel.
If the layout is not consistent with the original one in the PDF, one possible reason might be the complex layout. For such situations, try to get a professional PDF editor, which usually provides a PDF to Excel function and can perform such tasks better.
Best Regards,
Brad
May 09 2024 02:22 AM
@Brad_Castro Are there any recommended PDF editors to do this?
May 09 2024 02:36 AM
May 09 2024 03:07 AM
SolutionThank you for your suggestion.
I tried PDFGear since it is free. It's good for me. There are still some minor differences in Excel comparing to the original form in the PDF but it is mucb better than the Get Data function in Excel.
This is going to be my new tool to convert PDF to Excel. I will test more PDFs on it and see if it is always stable.
Thank you!
May 09 2024 03:07 AM
SolutionThank you for your suggestion.
I tried PDFGear since it is free. It's good for me. There are still some minor differences in Excel comparing to the original form in the PDF but it is mucb better than the Get Data function in Excel.
This is going to be my new tool to convert PDF to Excel. I will test more PDFs on it and see if it is always stable.
Thank you!