Delimiter: Don't use '~' or ':' if you use advanced category definition (ie 'parent~slug:name')
This is a comma by convention in most countries, but you may wish to change to ';' or some other character. Please use caution! This setting should always be the same for export and import!
Enclosure:
This character will be used to further define each field. If your delimiter is a comma, but it appears between two enclosure characters, it will be ignored, thereby allowing you to use it. Please use caution! This setting should always be the same for export and import!
CSV Path:
This is where your WP CSV files will be stored. Must be writable. Must not be publicly accessible. Iow, you can't use '/home/se6qg0aj42x03xog/public_html' or any sub-folders of it.
Date format: US (MM/DD/YYYY)English (DD/MM/YYYY)
Dates are exported as 'YYYY-MM-DD HH:MM:SS' but your spreadsheet will change them automatically. Please specify the format dates will be in when you re-import a CSV file.
Encoding: UTF-8 UTF-8 (with BOM) ISO-8859-1 (Latin 1) ISO-8859-2 (Latin 2) ISO-8859-3 (Latin 3) ISO-8859-4 (Baltic) ISO-8859-5 (Cyrillic) ISO-8859-6 (Arabic) ISO-8859-8 (Hebrew) ISO-8859-9 (Turkish) ISO-8859-15 (Latin 9) WINDOWS-1252
Please leave this set to UTF-8 unless you're having problems with non-english characters not displaying correctly in old versions of Excel. Excel 2007+ should be able to open UTF-8 correctly.
If your data is important, then you should always have a full database backup so you can quickly recover if something goes wrong. I have taken every precaution to protect your data, but it's impossible for me to test every combination of plugins and themes. If you're unsure how to backup your database, then please talk to your web hosting provider.
The best way to start is to export your current pages and posts so you can see what column headings you need and what values Wordpress expects in each column.