Click the button to change the output folder OR you can checked the option "Save target files(s) in source folder"Ĭlick the "Options" button on the main interface to open the Options dialog box for detailed settings of the output files.įinally, click "Convert" button on the main interface. The program supports drag and drop behaviors which facilitate a fast import of multiple files.īefore converting the files, you can customize the output settings in the output setting area under the file list.Ĭhoose an output format from "Select output format" combo box.Ĭlick the icon to open the folder where the output files are saved. Or click " Add Folder" to add all files in the selected folder.
Add PDF filesĬlick "Add Files" on the main interface or "Add Files" in the "File" menu to browse your computer and add all supported files (PDF) to the program.
(At least, I haven't found any yet!) Although there are workarounds - such as copying the Excel file into Word and then reimporting it or even manually reformatting individual cells and re-typing all incorrect dates in Excel, this really should not be necessary.Step by Step Tutorial to convert PDF to Excel document Free Download Abex PDF to Excel ConverterĪfter downloading the program, please install and launch the program.
Is there a solution to this issue? There seems to be no way to influence the number/date formatting for the Excel output within the Acrobat Pro 10 settings. It seemed a great new feature to be able to export directly to Excel as a single worksheet from Acrobat Pro 10 - but unfortunately this date issue kind of kills the beauty. I handle a lot of data processing and converting from one format to another.
The result is that in any given exported Excel document created by "save as spreadsheet," the date formatting will vary between these two formats, and about half will have an incorrect date value. This makes it impossible to rely on these dates for sorting, filtering or any other processing in Excel. It simply causes a reversal of the displayed numbers to. Reformatting the cell to "US English, mm/dd/yyy" of course does not change the underlying date. For some reason, Acrobat Pro 10 is deciding to selectively recognize and export just these dates (with day-of-the-month 12 or lower) to Excel with the number format "Armenian, dd/mm/yyyy." (Yes, Armenian!) Although the appearance is the same as in the original PDF (), the actual underlying date value in Excel is wrong for US English. However, it could be read as Novemif another formatting set (dd/mm/yyyy) were applied. For example, a date appearing in the PDF as "" is Januin US English. In the very same PDF conversion, Acrobat Pro 10 will behave differently when a numeric value for the day-of-the-month is 12 OR LESS. or ) Adobe recognizes and exports the date correctly as "mm/dd/yyy"). If a day-of-the-month value is HIGHER THAN 12 (i.e. However, when I use "save as spreadsheet" in Adobe Pro 10, the dates come out formatted inconsistently and about 50% incorrect in the resulting Excel file.
The PDFs are generally created outside my company, directly to PDF from spreadsheet programs. Problem exporting or converting PDF to Excel - dates inconsistently and incorrectly recognized and formattedĪs a rule, in my work, I'm converting PDFs which contain dates in the US English date format (for example, "" would be January 11, 2012).