Guide for Lighten PDF to Excel Converter for Mac
Guide for Lighten PDF to Excel Converter for Mac Lighten PDF to Excel Converter for Mac helps you quickly and accurately extract data from PDF to Excel Spreadsheet.
Step 1. Launch PDF to Excel Converter
After downloading, open .dmg file and drag the app icon to ‘Applications’ folder. Double click on the icon in Application folder to launch PDF to Excel Converter.
Step 2. Import PDF files
Click ‘Add Files’ button to browse your finder, select the files you want to convert.
Step 3. Select output option
Click ’Setting’, you can customize output options. Set an output folder to store the output file.
Step 4. Click ‘Convert’ button
Click ‘Convert’ button, conversion will begin instantly. Go to the output folder to find the converted file, or open the output Excel file by clicking on the hyperlink in file list.
PDF created by Microsoft Excel with table data can be extremely complex, and the style and formatting may be quite different. In order to convert any types of PDF table to excel, you can mark a table or field manually.
Go to ’Setting', select ‘Detect table base on table borders’.
Table with borders Click ‘Show table’ button in built-in PDF Reader toolbar. The app will show table automatically. Table will be covered by blue color box, borders will be displayed as blue lines.
If some rows and columns are missing, you can click ‘Add horizontal line’ or ‘Add vertical line’, and then move your mouse cursor on the table, move to the place you want to add line and press left mouse to place the line.
The app will not detect table automatically in ‘Detect table base on table borders’ mode. You need to manually mark table areas.
After finding table elements, you can mark it for accurate conversion.
1. Place your mouse cursor on the built-in PDF file, press left mouse click and keep it.
2. Drag the cursor from top-left corner to the bottom-right corner to cover the whole table. While dragging you will see blue color box. If you didn’t mark the element accurately you can change its size or position by selecting the marked areas.
3. When you release the left mouse click, PDF to Excel Converter will perform table recognition to the selected areas, adding rows and columns lines to it.
Or you can go to ‘Setting’, click ‘Detect table base on data structure’. PDF to Excel Converter will divide the table lines and columns base on the data position. This is a fully auto table detection, marking table manually in PDF reader will not affect output file in this mode.
Modify Table Areas
Lighten PDF to Excel Converter will automatically attempt to detect where the rows and columns are when you mark a table area. But for some table with complex table structures, you might need to modify the lines for accurate results. In this case, you can adjust the rows and column lines, merge or split cells.
Adjust the table lines
If you want to move the position of lines, place your cursor over the line, the cursor will change into a double head arrow. Press and hold your mouse left click and drag the cursor up/down, left/right to adjust the line position.
Merge and Split cells
After marking table area, you can select cells in the field you mark. Click left-click to select a cell, hold and drag the mouse cursor to select multiple cells, click ‘Merge cell’ button to merge cells you selected into one cell.
If you want to split a cell into multiple cells, select that cell and click ‘Split cell’.
In the output file, if you find there’s a little green triangle at the left-top corner, that means Excel doesn’t know the cell type. Move your cursor over that cell, you will got a notice sign. Click on it and click ‘Convert to number’, then you can calculate data without problems. You can select the whole columns or multiple cells then convert all cells to number at one time.