Thursday, October 2, 2008
By Dinesh Ravishanker
Customers often call our support line asking: "How do I prepare an Excel spreadsheet to be uploaded to CallFire?". Here's an easy receipe to get rid of bad records that could cause upload problems:
- Copy your phone numbers into Column-A, using Excel.
- Sort your list in Excel, by Column-A.
- Visually scan Column-A for bad numbers that have less than 10 digits, more than 10 digits, odd characters & so forth. Delete the row entirely by right-clicking on the row number, and selecting 'delete.' (Many records with bad numbers are at the very top and bottom of the sorted list. Ex: "1111111111" or "9999999999".)
- Lastly, go to FILE > SAVE AS and Save a copy in *.CSV format. Always rename your final CSV file to prevent mixups!