Odoo Help


Import preview failed

regis guevel
on 5/26/14, 10:30 AM 3,041 views


I'm trying to import my database which is in .xlsx, so I converted it in CSV format. 

I try and I get the following message: 

Import preview failed due to: new-line character seen in unquoted field - do you need to open the file in universal-newline mode?. The issue is usually an incorrect file encoding. 

Here is the start of the file we could not import


I've already been in the settings to allow imports of users !


Can you help me ?


Eva Pinter
On 1/7/15, 10:04 AM

I found the following answer on another site:

"I had the exact same issue! It had to do with the way it is saved on a mac! Resave your csv and scroll down and you should see two other kinds of .csv files you can save it as. 

Save it under the windows version and it will now be read fine!!"

It worked for me, so I copied it here.


About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 5/26/14, 10:30 AM
Seen: 3041 times
Last updated: 3/16/15, 8:10 AM