The table below shows the first few lines from your file after the Wizard has applied what it considers to be the appropriate formatting.

The data in the table should be laid out into rows and columns and you should be seeing the correct data in each column. Check each row carefully! When importing from a file, the most common delimiter is comma and the most common text qualifier is inverted comma. When importing from clipboard, the most common delimiter is tab and the text qualifier is irrelevant.

A delimiter is a character that separates two fields (or columns) within the file. Your file must contain delimiters otherwise all the fields would just run together, unless you are simply importing a list of names and each entire line is a field, in which case the delimiter does not apply.

A text qualifier appears at either side of a field just in case the field happens to contain a delimiter character, in which case the Wizard will know whether to treat the character as a delimiter or just part of normal text. For example, if your delimiter is a comma but you have a field which contains a comma (such as a comments field) then the Wizard will know to treat the comma as a comma and not to split the comments into two fields.