Pdf conversion to excel

[A_3]

Hi Everyone,

I do a lot of manual data entry at my job from PDF, today I learned that VBA Can convert text files to excel, can I use it to do the same for PDFs? If not what can I use? , Python?

 

[Marc L]

Hi,​

​

Excel can't but you can manually copy / paste the data …​

​

Or if you have the appropriate Adobe software or from other sources or sometimes online on some websites.​

 

[kweaver]

Microsoft built a "PDF data connector" for Excel 365, which imports PDF table data using the Data tab in Excel, then "Get Data" option. Have you tried that?
I found it works somewhat OK but not perfect and large files take a bit of time for Excel 365 to analyze and find tables. It's worth a try.

 

[Marc L]

​

Good to know for 365 users !​