Hi,

This error happens because Odoo is trying to parse the date using the format you specified (%d/%m/%Y), but the actual date in the file is already in the format YYYY-MM-DD (2025-01-31), which doesn't match.

solution:

1. Adjust the date format in Excel to match odoo import format

Select the date column in Excel. Format -> Number -> Custom date and time

set custom date as (%d/%m/%Y)

OR,

2. Adjust the date format in Odoo to match in Excel

Setting -> Translations->Language

Select your language and change the date format.

Hope it helps

I meant in the Odoo import dialog:

>>  The fact that it shows 2025-01-31 tells me that in first instance Odoo is correctly interpreting the date

Are you sure Odoo isn't just showing you what is stored in the field?  

What is shown when you click the Formula Bar?

(example to show how Excel can display and store two different values)

Try either of these two options:

A column with no format containing and displaying 31/01/2025

A column with the following format containing and displaying 31/01/2025