Convert PDF to CSV

Turn PDF tables into real spreadsheets

Bank statements, price lists, invoices, timetables and financial reports usually arrive as PDFs – but you need the numbers in Excel to sort, filter and add them up. Copy-and-paste from a PDF typically produces one long column of jumbled text. Fileopia detects the rows and columns on each page and writes them into proper spreadsheet cells, with numbers stored as numbers.

• Free OCR for scanned PDFs – iLovePDF lists OCR as a Premium feature. Here, scanned and photographed pages are read on your device with Tesseract in 12 languages, at no cost.
• Automatic mode – pages that already contain text are converted directly; only image-only pages go through OCR, which keeps conversion fast.
• Choose your sheet layout – one sheet per page, one sheet per table, or everything on a single sheet.
• XLSX or CSV – Excel workbooks for Excel, Google Sheets and LibreOffice, or CSV for databases and scripts.
• Private – financial data never leaves your browser.

How table detection works

For digital PDFs the converter reads every text fragment with its exact position. Fragments on the same baseline become a row; consistent gaps between fragments become column boundaries. Ruled lines, when present, help confirm the grid. Numbers with thousands separators, currency symbols, percentages and negative values in brackets are recognised and stored as numeric cells so formulas work immediately.

For scanned pages the page is rendered at 300 DPI, OCR returns every word with its bounding box, and the same row/column logic is applied. The result screen tells you how many pages were read with OCR so you know which ones to double-check.

Getting the cleanest result

• Pick the right OCR language for scans – accents and non-Latin scripts depend on it.
• Straight, sharp scans work best. If a scan is skewed or dark, try PDF Scanner to clean it up first.
• One sheet per table is ideal for reports with several tables per page; one sheet is ideal for long statements spanning many pages.
• Check merged headers – multi-line column titles may land in two rows; merge them in Excel in seconds.
• Need only the text? PDF to Text is faster. Need an editable document? Use PDF to Word.

XLS vs XLSX vs CSV

Common uses

• Reconciling bank and credit-card statements.
• Importing supplier price lists into inventory systems.
• Analysing financial statements and annual reports.
• Digitising old printed tables with OCR.
• Converting timetables and schedules into editable sheets.

Step by step: PDF to Excel

• Drop your PDF onto the page – digital or scanned.
• Choose the format – XLSX for Excel and Google Sheets, or CSV.
• Choose the sheet layout – per page, per table, or one sheet.
• Leave OCR on Auto so scanned pages are recognised automatically, and pick the document language.
• Convert and download, then open the file in Excel, Google Sheets, Numbers or LibreOffice Calc. Spot-check totals against the PDF before relying on the figures.