| Table of Contents |
|---|
...
The conversion from PDF to spreadsheet is not always the smoothest process. The tools are getting better, but there may be strange row and column merges in the resulting spreadsheet that the user may have to cleanup. This is due to the nature of the content PDF document which can be rendered in many different ways
Always examine the resulting spreadsheet and make sure it looks usableto verify the contents are what they should be!.
In many cases takes just a few minutes to reformat to make the spreadsheet usable, which which is far easier and more reliable than cutting and pasting pdf fields into a spreadsheet by hand (a process which can also be fraught with peril since the order that things appear in the order of pdf file are not always the order they get pasted...)
Manually Cutting and Pasting from PDF to Spreadsheets
When manually cutting and pasting pin Information from a PDF DataSheet into a spreadsheet, cadEnhance recommends using the free Foxit Reader PDF reader available
from: https://www.foxitsoftware.com/products/pdf-reader/ instead of the Adobe Acrobat reader.
The Foxit Reader provides more controls for selecting data fields, and does a much better job of maintaining the source data formatting in cut and paste operations. Acrobat tends to mangle the order and format of the data.
**In all cases, be sure to verify that the order of information that you selected is maintained when you paste it into the spreadsheet. Due to the nature of pdf file structure, the pasted data may come in out of order!
...