Can I bring my old customer list and past booking records across from my spreadsheets into your CRM?
General QuestionsCan I bring my old customer list and past booking records across from my spreadsheets into your CRM?
Can I bring my old customer list and past booking records across from my spreadsheets into your CRM?
Yes, in most cases you can bring your old customer list across, but how neatly it lands depends on how you have been keeping it.
The usual way is to export your spreadsheet or your old system into a single file with one row per customer, then match each column to the matching field in the CRM, so names, contact details, addresses, travel document details and past trips go to the right place. Clean, separate columns transfer well. Where people run into trouble is free text, because years of notes typed into one wide column usually arrive as a single block of notes sitting against the customer rather than as separate, searchable entries. That is still useful for your staff to read before they call, but it will not drive reminders or filters the way properly separated fields do.
Old bookings are the other thing to be honest about. Records that came from a different reservation system normally come in as history you can look at and report on, not as live bookings you can amend or cancel inside the new system, because the supplier reference still sits with whoever made the original booking. Attachments such as scanned documents and old invoices are often handled separately from the main import, and what is covered can vary with the plan you are on, so it is worth asking rather than assuming.
Duplicates are worth thinking about before you start, since the same person is often in a spreadsheet more than once with slightly different spellings. The sensible next step is to send over a small sample of your records with a short note explaining what each column holds, run that through first, check how the matching behaved, and only then hand over the whole list.