Most programs have the capability of exporting or saving data to "tab-delimited text" (.txt or .tab file) or "comma-delimited text" (.csv).
If you have your data in MS Excel or any other spreadsheet program, then you can do a File > Save As, and change the file type to either tab or comma-delimited text.
The file should have at least the following fields/columns: FNAME, LNAME, COMPANY, ADDRESS, CITY, STATE, ZIP, PHONE. There are other fields that could be there, but these are the main ones. There should be 1 row per record with no blank rows in between.
Once you have this file properly formatted, then from the pull-down menu in Camelot, choose Tools > Upgrade From > Custom Text (client records only) - or in Camelot 3.x, the option is Tools > Import > Custom Text (client records only).
Then browse to choose the tab or comma-delimited file you've created to import. It will show you a preview of the file on the left, and then Camelot field choices on the bottom right.
Double-click in those field choices at the bottom right so that the fields listed in the window on the left match the fields you will be importing into in the window on the upper right.
For the above example, the field choices would be [FNAME] [LNAME] [COMPANYNAME] [MAILINGADDRESS] [MAILINGCITY] [MAILINGSTATE] [MAILINGZIP] [HOMEPHONE].
Then click Import, and your data will be brought into Camelot. It does not check for duplicate records, so if necessary, you should do that in your import file before you bring it into Camelot.
importing custom text importing data from a spreadsheet excel import lotus import
Add to favorites