Cosmovex/tools

Convert a US-format invoice PDF with MM/DD/YYYY dates to Excel

US-format invoice to Excel with Invoice to Spreadsheet

This page opens with month-first date order selected, for invoices where 11/05/2026 means 5 November. Drop your own text invoice PDF to read the dates the right way round and get one row per line item.

  1. Check the date order setting at the top: it starts as Month / day / year.
  2. Tap Choose a PDF and pick the invoice.
  3. Read the invoice date shown as yyyy-mm-dd on the card.
  4. If it looks wrong, change the setting to Day / month / year.
  5. Download Excel; the invoice date is a real date cell.
invoice pdf to excel mm/dd/yyyy us invoice date format excelmonth first invoice datesinvoice date 11/05/2026convert invoice dates correctly
Open Invoice to Spreadsheet Free to start · no account

What to know

A date such as 11/05/2026 is ambiguous: it is 5 November in a day-first country and 11 May in a month-first one, and a spreadsheet that guesses wrong makes every date in the file wrong without telling you. If the file contains a date with a day above 12, such as 11/25/2026, that settles the order for the whole document. When no date does, the tool says so and uses the order you chose.

On this page month first is selected from the start, so a US-format invoice is read correctly without you touching anything. Written dates such as Nov 5, 2026 or 5 November 2026 are never ambiguous and are read as they are. The result is written as a real Excel date, so it sorts and filters correctly and does not depend on the computer's regional settings.

Free reads one invoice at a time, the first 3 pages, up to 15 line items per export and 3 exports a day, which is enough to try the tool on a real invoice. Pro merges many invoices into one sheet, reads up to 30 pages per invoice and removes the line and export limits.

Updated · Cosmovex

Questions

How does the tool decide between day first and month first?

A day above 12 in either position settles it for the whole document. If none does, it uses your setting, which is month first on this page, and tells you when a file could be read either way.

Can I change it after reading the file?

Yes. Changing the date order re-reads the dates straight away, without choosing the file again.

What about dates written in words?

Dates such as Nov 5, 2026 and 5 November 2026 are unambiguous and are read as written.

Is the date a real date in Excel?

Yes. It is a date cell formatted yyyy-mm-dd, so sorting and filtering work and your regional settings do not change it.

The free plan covers everything on this page. Invoice to Spreadsheet Pro ($9/mo, billed monthly) is described on the Invoice to Spreadsheet page.