Thereâs no easy way I know of but having had to do that with a PDF report of lots of data (12 Pages), I had to select all tabular data on each page, copy it and paste into a text file. I then removed all commas before doing a find and replace on spaces and replacing them with commas. Finally I saved the file as a csv file and imported it into my spreadsheet. Even after all of that I spent a fair amount time aligning the data into proper columns. The previous assumes that PDF is text-based. If itâs image-based you need to OCR it first before doing what wrote. Then is it essential to carefully proofread everything to make sure the OCR didnât screw up some numbers.
Or make any mistake in the text or data. The best I have come up with is as follows: Read the document as is. Scan it, image it and OCR it. Then, save it as a PDF file. Open it in Excel and convert it to text using standard Excel text tools. Use the OCR to do a find and replace on the correct text. (Do this, not the OCR.) Write the text to a text file. And finally to a spreadsheet. The rest of the process is the same as before (inserting tables, merging data and so forth.) The main difference now is that I now have a set of data for each document. The data is as follows: — A comma separated list of the date, date format (Date + Year format), time, name, group, and user. — A table with all the information about the users of the computer. — A.