Format a spreadsheet for mass import
When using our mass import tool to import a spreadsheet, be sure to have row 1 as your header row, listing the column names. This will help CATS auto-detect which columns match to which fields and also make it easier for you to change this during the mass import process.
Phone numbers should include the country code and dates should be in the ISO 8601 format of YYYY-MM-DD.
|First Name||Last Name||Cell Phone||Date Available|
|David||Hendersonfirstname.lastname@example.org||+1 (555) 624-1768||2019-01-01|
|Janice||Jacobsemail@example.com|| +1 (555) 748-8371
|John||Allanfirstname.lastname@example.org|| +44 20 7025 7161
and so on...
Be sure to separate fields like name and location into separate first name, last name, city, and state columns.