To achieve the best possible result when importing a CSV file, there are a few things you should check prior to import.
1) Column Delimiter
Fields in CSV files are usually separated by commas or semicolons, but other delimiters (e.g. tabs) can also be used. It is important to check which delimiter has been used and set the CSV filter accordingly. You can do this when you add a new file to your project. in the CSV Section, select the appropriate radio button as shown below.
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 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++). You can then specify this under the Character Set section and choosing the correct Input encoding.
If your file contains HTML, make sure to use the HTML subfilter in the CSV section.
Additionally, you can also select context notes, the max. target length or choose to convert text to Memsource tags (using Regexp).