How Do You Convert PDF Files Into An Excel File?
How Do You Convert PDF Files Into An Excel File?
There are several aspects that affect whether you even can [fully accurately] achieve this on any individual file. Some of the factors (I'll try to think of others):
- If the .PDF source is an optical scan, you are at the mercy of OCR.
- In my understanding, if the .PDF recognizes numbers as being in tables, you might get 100% success there; but if not a "table" chances diminish.
- The presence or not of commas may affect your results.
I have had very mixed success considering the above factors so, while it's a downer, wanted to warn this up front.
How to do it:
- Scrape 'n' paste
- Export from Adobe
- 3rd party PDF-to-Excel
Both of the first two have been highly erratic in my experience. Often it seems that manually typing in the data would have been easier than cleaning up the errors.
Export is dependent on Adobe version.
I haven't tried all 3rd party products but in trials still haven't achieved 100% accurate translation. You can google for reviews of these. Here are some to try - https://www.google.com/search?hl=en&...q=pdf+to+excel.
Note: Adobe Version XI claims to work ( http://www.adobe.com/products/acroba...converter.html )
I haven't tried it.
I'd be interested if you hit a home run on a 3rd party solution. It would be a huge timesaver if one of the utilities works well.
Chip, if you can read this, you're STILL making the world a better place with your immeasurably valuable gifts. Every week, you continue to help me (and untold numbers of others) tremendously. Practically no alternative outlets can match your effectiveness, even over the vast number of topics you demystify and empower usage of. You were, and still are, amazing.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks