How to convert pdf to csv?
I have a large 600 page pdf document. Each page contains a set of data in the same order eg. Name, Address, DOB, etc. Is there a way to quickly extract this data to a spreadsheet or csv file without manually typing it?
- IvyLv 59 years agoFavorite Answer
Hmm, hv u tried to copy the pdf to excel? Maybe u can try this firstly and if the pdf is not allowed copying, then u can turn to a pdf to excel converter for help.
And i think this pdf tool can help u, it can export pdf to .csv format as developer's description, http://download.cnet.com/Simpo-PDF-to-Excel/3000-1...
u can give it a try if you need.
- Robert JLv 79 years ago
To start with, open the PDF, 'select all' the text and copy it, then create a new plain text file (with notepad or whatever) and paste the text into it.
You now have a file you can read simply, rather than a PDF that needs special handling.
Depending on how it looks once you have done that, you may be able to do a direct import in it using fixed width columns.
Another thing to try is copy and paste from the PDF into Word. That is more likely to keep the formatting intact.
There is an option in Word to create a table by drawing it on the document; if the original columns are intact, you can draw a table with each text field in it's own column, then copy & paste the whole table into Excel.
You may need to try a bit of creative find & replace to juggle the column spacings while in text form, or set the page size up to get the lines in intact.
Another trick is to select all (once in word) and change the font to Courier. That is a fixed-width font so puts every character effectively in a grid, preserving spacings on each line. Just about all other fonts are proportional & groups of spaces get compressed, throwing column alignments out.
- 9 years ago
Of course, you need a plugin to help you make this conversion from pdf files to spreadsheet in excel.
As for the online one usually has the limitation of file amount and size, you can try the standalone one. It supports to batch conversion mode.
hope this will helpful http://www.pdftoexcel.net/
- Anonymous9 years ago
I used a converter to convert pdf to excel.
But it didn't support csv.
You could try it first if you like:
- How do you think about the answers? You can sign in to vote the answer.
- 9 years ago
download a converter?Source(s): google