Checking the format of a CSV made in Excel and comparing it to the sample.txt I have noticed that a lot of things are missed from documentation.

Example:

  1. Is need to put each column content within " "?
  2. Is username format validated with same Drupal registration settings or you can put whatever you want?
  3. Is password format validated with same Drupal registration settings or you can put whatever you want?
  4. Is email format validated with same Drupal registration settings or you can put whatever you want?
  5. Can fields content be duplicated?
  6. Any difference of using .txt file instead of .csv?

Note: I think setting like the column separator should be saved instead of having to set it each time, same thing for column titles.