Move a PDF table into your spreadsheet app
Online and desktop spreadsheet apps can all import CSV and XLSX, but none of them read a PDF table cleanly on their own. Converting first, then importing, saves a lot of retyping.
Your file is never uploaded. The PDF is read in your browser and makes no network requests while it works.
Open the PDF table to Excel / CSV tool
Steps
- Convert your PDF with the tool, choosing CSV for web-based apps or XLSX for desktop ones.
- In your spreadsheet app, use its Import or Open command and select the downloaded file.
- When asked, state that the separator is a comma.
- Turn on automatic number and date detection if the import screen offers it, or convert those columns afterwards.
- Remove title rows, footers and repeated headers left over from the PDF.
Good to know
Why numbers may look like text
The tool writes values as they appear in the PDF. In XLSX they are stored as text, so set the column format or use a value-conversion function before you total them.
Dates
Dates keep the PDF's own style, such as 03/04/2026. Check which order your app expects for day and month before converting.
Negative amounts
Amounts shown in brackets, like (45.00), stay that way. A find-and-replace turns them into a leading minus sign.
Questions
Which format should I choose?
CSV is the most widely accepted. XLSX avoids encoding questions when you open it in Excel.
Will formatting from the PDF carry over?
No. Only the text in each cell is exported.
Have bank statements as PDFs instead? RowSmith converts text-based PDF statements to CSV or Excel in your browser.
This guide was written with AI assistance and reviewed against the tool's behaviour. Always review your output before using it.