It blows my mind that I haven't seen anyone else with this issue yet, but here is the situation: I'm looking for the best method to convert a PDF into a Google Sheet (or how to scrape the data).

I've come across different plug-ins, but the free versions are very limited (and the work-flow moves rather slow).

Is there not a Sheets function that can directly scrape data from a file link? Something like ImportHTML, but for PDFs? I've yet to come across something that Google Sheets cannot do, so I think I am just missing something here.

Right now, I'm using a PDF -> Excel converter tool (because it isn't limiting the # of conversions) and then uploading into a Google Sheet. The converter moves very slow as well, making this process quite tedious.

Would anyone be able to shed some light here? Are these plug-ins (which like I said, are slow and not free) the only option?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.