Convert Pdf File to Excel

Topic:

Macros and VBA Excel

2. chito79000 wrote: 10/02/2017 at 11:24 am

Convert PDF file to Excel

1. Good morning everyone,
2. After a lot of searching on Google, I can’t find a code to convert a PDF file to Excel…
3. Do you have a solution to propose me or does someone from the forum have a beginning of code to propose me?
4. Thank you in advance.
5. I keep looking anyway.
7. kiki29 wrote: 10/02/2017 at 11:42am

1. Hi, after reading this: Alternative to Acrobat’s slowness for extracting Text from a PDF
2. It’s up to you:
3. Extracting Text from a PDF list via the Clipboard
   • Alternative to Acrobat : Extraction of Text from a PDF List ( P-Paper )(2)
4. Generation, with duplicate management, of individual text files in a TXTs folder.
   Merge, if desired, these text files into a MERGERS folder.
   • Alternative to Acrobat : Extracting Text from a PDF List (2)
5. This allows the extraction of text from the pdf, the formatting and selection of useful information will remain your responsibility. For your information
6. sths stats on the different methods
8. Alex70 wrote: 02/10/2017 at 11:44am.

1. Good morning
2. You can use a program that will convert the PDF to Excel directly, but again the result can be very approximate.
3. Edit : finally you have a solution above
5. rtzrhjty wrote: 03/09/2018 at 05:13am

1. Hello
2. There is software to convert PDF files to excel. If your pdf file is not very big, you can use them for free.
4. sogedic wrote: 03/09/2018 at 8:52 pm

1. a trick I use because Excel and pdf is not the best.
2. Open the pdf from word … which is much better
   copy/paste the result in excel – table by table retrieved in word
   It often works not too bad