How to Format Phone Numbers for Import into Gorilla 4.x
QUESTIONS THAT APPLY TO THIS TOPIC
- How do I format phone numbers for import into Gorilla?
ANSWER
In order for phone numbers to be imported into Gorilla, they need to be in the correct format.
To prep your phone numbers for import:
- Scroll through your list and look for any phone numbers with an extension, or multiple numbers listed in one field. Delete all extensions. Only the 10 digit number will import. If you have multiple numbers you’ll need to either decide which of the numbers you want to import, or move the phone number to another phone field. If you do this the number will be imported as the phone number listed in the column heading.
- For example: a common scenario is that a day and evening phone are listed in the Home Phone Number field. If there isn’t a business number listed, you could move the day time phone number into the business phone number field. If you do this, the phone number you move will import as a business number. If you already have a business number listed, you would need to decide which of the two numbers listed in the home phone field you want to import.
- You’ll need to clear all the formatting for the phone numbers. To clear the formats, highlight the cells in question (It is recommended to do this for all of the phone numbers at once) then on the home tab click the “Clear” drop down arrow and select clear formats.
- With the cells still highlighted remove all of the following characters.
The easiest way to remove those characters is with the “Find and Replace” function. With the cells still highlighted click “CTRL+F.” Click the Replace Tab. In the “Find what” field type the first character, leave the “Replace with” field empty then click replace all.
Repeat this process for every character listed above, then move on to step 4. - With the cells still highlighted right click anywhere in the highlighted cells and choose Format Cells.
- Click the Number Tab, then select Custom from the left column. In the Type Field, type the following format: ### ###-#### (pound 3x, space, pound 3x, hyphen, pound 4x)
- When you’re done all of your phone numbers should be only ten digits, and appear in this format: 123 456-7891. If they look like this, they’re ready to import. If they don’t, you’ll need to start the process over.
Related Articles
How to Import a Text File in Gorilla 4.x
QUESTIONS THAT APPLY TO THIS TOPIC How do I import a text file into Gorilla? How do I get a purchased mailing list into Gorilla? How do I use a third-party client list in Gorilla? ANSWER Gorilla can import text files through the “Text Import Wizard.” ...How to Import Information into a Gorilla 4.x Worksheet
QUESTIONS THAT APPLY TO THIS TOPIC How can I import data that doesn’t match any of the existing Gorilla fields? I have custom information on a spreadsheet I want to import with my CG’s. ANSWERTo import data that does not match existing Gorilla ...How to Download and Import a Campaign in Gorilla® 4.x
QUESTIONS THAT APPLY TO THIS TOPIC How can I download a campaign in Gorilla from the BGM website? How do I unzip a file folder in Microsoft Office®? How do I import a campaign to Gorilla 4.x? ANSWER Before you’re able to run a campaign, you’ll first ...Adjusting Windows' Date format to Work With Gorilla 4.x
PROBLEM Why does Scheduler not seem to recognize dates correctly? Why are some items set to the incorrect date in Scheduler? Why are my events disappearing from my Scheduler? Why is Gorilla saying my ESP has run out when it hasn’t? Why does my ...How to Install the Condolence Speedbutton in Gorilla 4.x
QUESTIONS THAT APPLY TO THIS TOPIC How can I get the updated Condolence-Death is Nothing At All Speedbutton into Gorilla? How do I add the Condolence-Death is Nothing At All to the Goodwill Speedbutton Group? ANSWER This speedbutton is actually ...