Users may frequently encounter the need to convert PDF documents containing large number of pages (e.g. 500+). While the speed of Able2Extract's PDF to Excel conversion is very good, conversion will inevitably take a little more time when a large number of pages are being processed.
Here are a few quick tips to speed up conversion:
- Turn off the "Excel Fonts" Option in the View Menu.
The "Excel Fonts" command turns on/off Excel fonts for the PDF-to-Excel conversion. When turned on (which is the default setting), this feature attempts to replicate the size, colour and type of font from the PDF to Excel.
When turned off, the standard Excel font is used. Hence, Able2Extract spends less time attempting to replicate the fonts found in the PDF document.
- Turn off the "Excel Spacing" Option in the View Menu.
The "Excel Spacing" command turns on/off the automatic spacing for the to-Excel conversion. Turning this option off, in addition to turning off the Excel Fonts, will speed up conversion.
- Excel Spreadsheet Limitation.
Prior to Excel 2007, Excel spreadsheets could contain only 65,000 rows. In cases of very large PDF documents that require conversion from PDF to Excel, it is possible that the number of rows in Excel could be exceeded. This may cause Excel to crash or freeze. In this case, it is suggested that PDF-to-Excel conversion is done in several turns. This will ensure that the 65,000 row limit is not exceeded. Also, you may try changing Excel format from Default to Excel 2007, in order speed the conversion process up. To do so, please follow these steps:
- Go to "View --> Conversion Options...".
- On Conversion Options dialog select Excel Tab.
- On Excel Tab change the Format from Default to Excel 2007.
- Click on the OK button.
- Now open your PDF file in Able2Extract, select the data and convert it to Excel in a ususal way.
This article refers to Able2Extract and Able2Extract Professional.