Forum Discussion
Get data from file from PDF
I am a O365 user. How can I insert the option Get data/From file/From PDF in the option list? is missing... Thank you in advance, Rui
I could be mistaken about this, but I've never seen that option and doubt that it's available. I have seen situations where people have written small programs to extract data from PDF files. But not a simple option in the Get Data menu.
For one thing, PDF files can take multiple forms, one of which is to be a simple image of a page of text, which generally isn't even searchable. Even PDF that consists of a searchable/editable text can be tricky. I have found, in one-off situations, that I can use Copy and Paste to take data from a PDF page where it appears as a table and paste it into Excel......so you might try that.
I'm happy to be corrected, if there are others here who know better about this topic.