Cannot upload some type of charachters

For special characters, make sure that the file you are importing from is saved in UTF-8 format.

Thanks for starting this thread. The same thing applies to Spanish language characters. Is there any way to allow the special characters to upload? This can have a significant impact on the word
Laura

Linl has it right - you need to use UTF-8 to import.

I am using OpenOffice calc (http://www.openoffice.org/product/calc.html) to save to CSV, it does a very nice job and is OSS. It uses quotes and escapes correctly. When saving to CSV change the character set to 'Unicode (UTF-8)' and the extended characters will be properly imported. There are no other options you need to change, and you should use the default CSV import options in node_import.

I can confirm that I've uploaded properly-formatted UTF-8 CSV files which included a variety of non-English characters with no problem. This is a problem with the CSV file which is beyond the scope of the node import module. However, end-user documentation describing how to create correctly formatted files with common programs such as Microsoft Excel written by someone who actually uses them would be helpful for many people, I'm sure.

Could somebody please explain how you can correctly create a CSV file that stores the special characters with excel?

Alternatively, it would also help if somebody could explain how the special characters need to be escaped. If excel can not do it, at least I can do it by hand with a search and replace.

To be fair, isn't that an excel issue; not related to node_import. The problem is your file is not UTF-8, nothing else.

Marking fixed as there is now a message on the upload form: #714682: Add a message to the file upload form about UTF-8 encoding