Import csv to mongodb database

Question

I am using this code to import my data from csv to mongodb:

./mongoimport -d <db_name> -c <collection_name> --type csv --file <file_location/file.csv> --headerline

But I get the following error:

Failed: line 1, column 2446: extraneous " in field

How to resolve this issue?

Answer 1

Well without showing us your problematic CSV data it is difficult to give you a definitive answer but the error is usually caused when you have a CSV column wrapped in double quotes which contain a double quote within the wrapped text e.g.

C1,C2  
57,"This is a double quote:""

To solve the issue you have to escape the double quote with another one like so

C1,C2  
57,"This is a double quote:"""