Date Format Handling
Learn how BillToSheet handles different date formats from international invoices. Tips for ensuring correct date parsing and formatting.
Frequently Asked Questions
What date formats are supported?
We support all common date formats including DD/MM/YYYY (UK/EU), MM/DD/YYYY (US), YYYY-MM-DD (ISO), and written formats like '15 January 2025'. Our system automatically detects the format.
How are dates formatted in the CSV output?
Dates are exported in ISO format (YYYY-MM-DD) by default, which is universally recognized by spreadsheets and accounting software. This prevents confusion between DD/MM and MM/DD formats.
What if a date is extracted incorrectly?
Occasionally, ambiguous dates like '01/02/2025' (which could be January 2nd or February 1st) may be misinterpreted. Review extracted dates and correct any errors before importing.
How do I change date format in Excel?
Select the date column, right-click, choose 'Format Cells', select 'Date', and choose your preferred format. Excel will automatically reformat all dates in that column.
Do you extract due dates as well as invoice dates?
Yes, when present in the invoice, we extract both the invoice date and the payment due date, displaying them in separate columns.
Related Invoice Converters
Amazon Invoice Converter
Convert Amazon invoices to Excel with line items
Stripe Invoice Converter
Convert Stripe invoices to Excel with line items
PayPal Invoice Converter
Convert PayPal invoices to Excel with line items
More Help Articles
Getting Started with BillToSheet
Learn how to convert your first invoice PDF to CSV or Excel format with BillToSh...
Supported Invoice Formats
Learn which invoice formats and types are supported by BillToSheet. Compatible w...
Understanding Credits
Learn how the BillToSheet credits system works. Information about free conversio...
Downloading Your Converted Files
Learn how to download your converted invoice files in CSV and Excel formats. Acc...