Excel Export / SmartFTP Import of URLs etc.

I have an Excel spreadsheet of my FTP users' server information, using database headers as follows -
Name:Host:Port:User:Remote Path:Last Connected:Passwor
I have attempted exporting XML, XLS, and .txt formats from Excel, but cannot get any of them to import to SmartFTP.
I there a special format I need to get the Excel database into SmartFTP?
Many thanks, in advance!

Hello ...

Did you create the XLS sheet by your own or does it come from an export of the favorites/sites from another FTP client?


I created the spreadsheet manually.

This should work, thanks!