Forum Discussion
pdf to excel
NikolinoDE UGH! I tried this, since I was trying to do this. It did not work as expected.
It tried to create multiple tables and none of the data was present, it was all ascii chars.
Using Adobe cloud to convert was accurate and less painfull - no need to select tables or data or whatever MS excel was tring to do.
Yes, I do have Office 365 subscription.
I would really like this feature to be painless or seamless - now that every thing has AI - this mundane task can be handled properly without too much of human input.
Also, if we are working with sensitive data or financial information, using cloud is out of quesiton.
Can You Import Formulas from a PDF into Excel and Use Them?
Not automatically.
Excel’s “Get Data > From PDF” feature can import tables or text data from PDFs, but it does not recognize or extract formulas as usable Excel formulas.
Summary…
Excel's “Get Data from PDF” won’t import formulas as usable Excel logic
Adobe Acrobat (paid, offline) is better at preserving formula-like text
For highly sensitive documents, use manual or code-based extraction offline
No perfect solution yet—but with increasing demand and AI tools, it’s a space worth watching
Hope this information helps you a little.
Have a look at online ((OCR based) converters like https://www.onlineocr.net.
These can produce quite a 1-to-1 representation; no formules, I guess.
Works way better than copy&paste (as importing PDF-data gets mis-aligned lines/data when pasting).
