Convert invoices that write amounts as 1.234,56
Many invoices write two thousand five hundred euros as 2.500 or 2.500,00. A converter that assumes the US style can turn that into 2.5 without warning. This guide explains how the tool works out which style an invoice uses and what it does when it cannot tell.
Your file is never uploaded. The PDF is read in your browser and makes no network requests while it works.
Open the Invoice PDF to CSV tool
Steps
- Drop the invoice PDF into the tool as usual. There is no setting to choose.
- The tool looks at the amounts on that invoice to decide its number style.
- Check the Notes column. If the style was unclear or mixed, it says so.
- Correct any flagged amount in the preview.
- Leave Plain numbers in CSV ticked to get amounts like 2500.00 in the CSV, or untick it to keep them as printed.
Good to know
How the style is detected
A comma before the last one or two digits, or a dot followed by exactly three digits, points to the 1.234,56 style. Each invoice in a batch is judged on its own amounts, so mixed batches work.
Ambiguous on purpose
A lone value such as 1.500 could mean one and a half or fifteen hundred. When nothing else on the invoice settles it, the tool flags the invoice in Notes rather than guessing.
German labels
Field labels such as Rechnung Nr. for the invoice number, Fällig for the due date and MwSt for tax are recognised alongside the English ones.
Questions
What does the XLSX contain?
Readable amounts become number cells, so your spreadsheet shows them in your own locale's style.
Are currency symbols kept?
The number is extracted without the symbol when Plain numbers is on. Untick it to keep the printed form.
Working with bank statement PDFs too? 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.