Basically what the title says. I have a pdf for which the source files are unattainable, and in the pdf is a grid, a list of factors really with column and row headers. And what i’d really love to NOT have to do, is to manually enter all of the factors into a grid in excel. So i’m wondering if adobe or some other OCR software is out there which can be used to help copy/paste from a pdf into an excel grid. Could save me a lot of time.
There’s a weird thing where sometimes I can copy text from a PDF, paste it into a text editor (notepad), then copying from there and then pasting into excel allows you to past a table with the data wizard thing:
Cntl+V to paste
Cntl to open paste options menu
‘U’ to use the wizard
‘Finish’…usually…sometimes you may want to go through the actual wizard prompts.
This doesn’t always work though, and I don’t know how to tell ahead of time when it will/won’t work.
My experience copying from PDF is that it reads the numbers and puts all of them in a single cell.
Doesn’t Excel for Android have a feature now where you can take a picture of something and it will import the data into a table? Maybe that would work.
Toss it in Tabula (link in a prior post), select the first table, click the “repeat this section” button (to repeat the selection on each page), click “Preview and Export Selected Data”, switch it to the “Lattice” method on the next page, and then export the CSV. You’ll have to clean it up a bit and possibly add page titles, but it gets you 90% of the way there.
Unfortunately, this forum doesn’t allow CSV uploads, otherwise it would be attached to this message.