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.
Rui_Coelho Have a look at this link:
https://docs.microsoft.com/en-us/officeupdates/release-notes-office-insider
Scroll down a bit until you see this:
If you are on this version (or later), you should find it here:
By the way: Windows only!!
mathetes Consider running W10 virtually on your Mac and find out more about Excel. It costs a few bucks to set it up, but if you have an O365 license left (mine came with 5 users), it's worth it.
I could not find in latest Excel 365 which has been confirmed up to date Riny_van_Eekelen
Kejing_Gu1220 Please see the attached article. Towards the end of it you'll find some fairly recent comments from people asking why they can't see the PDF Connector. From your picture it looks like you are not an MS365 subscriber.
You can update to Windows 10 with your W7 key.
So you can get 365 on the version as Mr. Riny_van_Eekelen has described.
If you update to Windows 10 you should also update your PC to at least 8GB RAM and hard drive on SSD, otherwise it will slow down your PC.
Or you can download a "preliminary" converter software (which I don't recommend),
many problems could arise.
Files without sensitive data could also be converted online for the time being if this is absolutely necessary.
Here is a link: https://online2pdf.com/en/
As already said, there are many ways in Excel that could lead to a solution, but tailor-made solutions sometimes come with additional costs.
I hope I could help you a little bit further in your project.
Nikolino
I know I don't know anything (Socrates)
At least for Office apps I don't think it'll be significant difference in performance between Win7 and Win10 if use the same hardware.
In my humble opinion, I can say that it makes a huge difference.
I do hardware updates in four-digit range each year and the difference is significant.
SSD hard drive, more GB of RAM and BIOS with the latest updates really make a huge difference.
In all our office world, we must not forget that many users do not have huge computer power (motherboard, video card, etc.) or the latest processor.
I agree with you that it may be that if you only compare Office before and Office after that the difference is not that significant.
But, if we are honest with ourselves, which user measures according to such standards?
A user measures from the start of his PC until the worksheet appears, before and after.
He does not need a measuring device, he can see the difference with the bare eye.
In some cases (I would rather not name a PC company) it is like day and night.
It is obvious that it is not the office alone, but it makes a huge difference, even for the office,
when the user feels like switching from bicycle to motorcycle.
We should always keep in mind that Office does not live alone in our PC. Office is a part of our PC world, for some a very small part.
Anyway, that's my opinion and my experience ... but what are they worth? ... Because I and everyone else know that I don't know anything, and yet in some cases that can be a lot.
Thank you for taking the time to read my comment so far.
I wish you a pleasant evening
Niko
I know I don't know anything (Socrates)
- And so every translator can be seen that he tries to mediate this general intellectual trade and makes the exchange of bills a business. For whatever one may say about the inadequacy of translation, it is and remains one of the most important and worthy business in general world traffic. Johann Wolfgang von Goethe (1749 – 1832) Must understand English better than relying on the software translator Nikolino
