Call Support: +1 (647) 557 5884

PDF-to-Excel Conversion Settings

Follow

Starting from version 11.0 of Able2Extract Professional, we embedded several new functionalities which are able to deal efficiently with pretty complicated table structures. To access these options, open a PDF file in Able2Extract application, select the data and click on the Excel button on the main toolbar. Then in the Convert to Excel dialog that will appear click on the gear icon – the following dialog will open, containing sub-options that will allow you to further modify your PDF to Excel conversions.

image92.png

 

Automatic Settings

   Simple Analysis – This option allows Able2Extract to automatically designate the rows and columns of the PDF to Excel conversion. Use this option when your PDF content contains simple table structures with basic rows and columns. In some cases, the Simple Analysis option can help to fix problematic conversions when converting in Full Analysis mode.

   Full Analysis – This is the default for Automatic PDF to Excel conversions. By using this option, Able2Extract will perform a deeper analysis of your PDF tables to produce more accurate conversion results.

Note that when you save your conversion options using the Save as Default setting, the Automatic conversion options you select here will also affect the PDF to Excel conversions done through the Batch conversion feature.

Custom Settings

   Page Ranges

The options in this category specify how Page Ranges for Custom Excel conversions are created. Page Ranges are groups of pages that have similarly structured content and can, thus, have the same table structures applied to them for conversion. They help Able2Extract in performing complex PDF to Excel conversions. Hence, the following options will give Able2Extract some direction as to how the source document is structured.

You will be able to choose from the following options:

  • Each Page Has Its Own Table Set
    When checked on, Able2Extract will create separate table structures for each individual page.
  • All Consecutive Pages Have The Same Table Set
    Selecting this option will allow Able2Extract to create table structures that are appropriate for all consecutively selected pages.
  • Automatic
    When this option is turned on, Able2Extract will attempt to analyze the selected pages and automatically determine which pages can share the same table structures needed for the conversion process.

   Single Table Per Range

With this option checked on, Able2Extract will generate tables around the selection for which you can specify the Custom options noted above.

If the Single Table Per Range checkbox is left unchecked, then Able2Extract's conversion algorithm will perform a detailed analysis on the content of the pages and determine if several tables have to be created to more accurately convert the document.

   Save As Default

This check box allows you to save your conversion settings as a default. Select this option and click on OK.

 

This article refers to Able2Extract Professional.

Have more questions? Submit a request

Comments

Powered by Zendesk