Skip to Content
This question has been flagged
importdateexcelodooimporting data from excel file
1 Reply
1912 Views
Avatar
Vo Nguyen Phuc Ngan

I have data from excel as follows, in the "Used date" column in excel I have the value "01/01/1995" but when importing to Odoo, Odoo reads it as 1995-01-01 so when I click "Test" I get the error "time data '1995-01-01' does not match format '%d/%m/%Y')"

Avatar
Discard
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

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 (1995-01-01), 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)


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

Avatar
Discard
Related Posts Replies Views Activity
Importing data in Odoo
import odoo importing data from excel file odoo15
Avatar
Avatar
1
May 25
19401
Import product data from Amazon to Odoo
python import data excel odoo
Avatar
0
May 24
1700
How to ignore rows?
import excel odoo ignore odoo16features
Avatar
Avatar
1
Jan 24
1960
Odoov13 How to use odoo import excel feature in custom module Solved
import excel sale.order importing data from excel file odooV13
Avatar
Avatar
2
Aug 22
7204
How can I write data from Odoo in an existing Excel file, while maintaining the cells format ?
excel odoo
Avatar
Avatar
2
Nov 16
6554