PDF to Excel reads text positions, detects rows and columns, and exports the extracted table data. It works best when the source has selectable, aligned text.
InputA text-based PDF
OutputXLSX or CSV
RequirementsA text-based PDF works best. Choose pages, a detection mode, and XLSX or CSV output.
Step-by-Step Instructions
Follow these essential instructions to achieve optimal results when using PDF to Excel:
Upload the PDF containing a table or aligned text.
Choose pages, column detection, and output format.
Use Preview Table to inspect the extracted rows.
Select Export to Excel and verify totals and column alignment.
Interactive Tutorial
Visual Step-by-Step Walkthrough
Follow these real interface screenshots captured directly from PDF to Excel. Every step highlights the exact buttons, selections, and downloads. Click any screenshot or "Launch Fullscreen Viewer" to inspect in high resolution.
Step 1 of 7 Upload Drop Zone (#drop)
Open PDF to Excel
What to do:
Open PDF to Excel to extract tables, invoices, and ledgers into spreadsheet rows and columns.
What you will see:
The upload drop area accepts PDF documents containing tabular data.
Next:
Click to select or drop your PDF document into the workspace.
Tip:
The tool detects column boundaries and row delimiters automatically.
Step 2 of 7 File Browser (#fin)
Upload Tabular Document
What to do:
Select your financial report or tabular PDF from your device.
What you will see:
The document loads and total page count is detected.
Next:
Configure the table detection options below.
Tip:
Documents with clear line borders or consistent column spacing yield the cleanest sheets.
Step 3 of 7 Detection Mode & Format (#colmode, #outfmt)
Configure Column Detection
What to do:
Select column detection mode ("Automatic" or "Strict") and output format (.xlsx or .csv).
What you will see:
The detection engine adjusts cell splitting sensitivity to handle borderless tables.
Next:
Select "Automatic" for standard reports or "Strict" for structured invoices.
Tip:
Choosing .xlsx preserves multiple worksheets and numeric formatting.
Step 4 of 7 Preview Button (#prevBtn)
Preview Extracted Columns
What to do:
Click the "Preview Extraction" button to inspect parsed table cells.
What you will see:
A live table preview renders showing detected column splits and row data.
Next:
Verify that columns align correctly with your numbers.
Tip:
Checking the preview allows you to tweak column settings before full file generation.
Step 5 of 7 Convert Action Button (#goBtn)
Click Convert to Excel
What to do:
Click the primary "Convert to Excel" button.
What you will see:
The client-side engine packages the extracted cells into an authentic Excel XML workbook.
Next:
Wait for the workbook container to compile.
Tip:
Numbers are converted into real numeric types so Excel formulas can sum them immediately.
Step 6 of 7 Review Section (#generatedPreview)
Review Generated Workbook
What to do:
Check the review confirmation panel displaying the generated workbook.
What you will see:
The review panel confirms the spreadsheet name and table cell counts.
Next:
Click "Continue to download" to proceed.
Tip:
Ensure that the final file name describes your report accurately.
Step 7 of 7 Download Dialog (#dlModal .btn-success)
Download Excel Spreadsheet
What to do:
Click "Download" to save your Excel workbook (.xlsx).
What you will see:
The download modal confirms your spreadsheet file is ready.
Next:
Open the file in Microsoft Excel, Google Sheets, or Numbers.
Tip:
Your data is now ready for calculations, pivot tables, and chart graphing.
Tips & Best Practices
Try Auto first, then Tab/space or Each line if the table structure is unusual.
Always compare important totals with the source PDF.
Common Mistakes to Avoid
Using a scanned PDF without OCR.
Treating visual spacing as guaranteed spreadsheet columns.
Troubleshooting & FAQ
If no data appears, run OCR first or choose a text-based source.
If columns shift, change the detection mode and preview again.