To achieve the best possible result when importing a CSV file, there are a few things you should check prior to the import.
1) Column delimiter
Fields in CSV files are usually separated by commas or semicolons but other delimiters (e.g. tab) can also be used. It is important to check which delimiter has been used and set the CSV filter accordingly.
2) Translatable text
CSV files often contain texts that do not need to be translated (e.g. codes). It is therefore useful to review your file first and decide which columns and rows actually need translation, and then import only those. This can be done by specifying the columns and rows in the CSV filter.
Incorrect encoding may lead to corrupted characters. Make sure to check the encoding (for example in Notepad++) and then specify it under Character Set - Input encoding.
If your file contains HTML, make sure to use the HTML subfilter.
Additionally, you can also select context notes, max. target length or choose to convert text to Memsource tags (using Regexp).