Skip to Content
Menu
This question has been flagged
1 Reply
10718 Views

Hello,

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 ?

 

Avatar
Discard
Best Answer

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.

 

Avatar
Discard
Related Posts Replies Views Activity
0
Mar 25
921
3
Sep 24
2124
2
Nov 24
1731
2
Nov 24
1273
2
Jul 24
1001