How do I clean up my CSV file?

When importing your CSV file, the below formats  will be accepted for mobile numbers:

  • International format: 61400304770
  • Local without spaces: 0400304770
  • Local with spaces: 0400 304 770
  • Local without zero: 400304770

The mobile numbers MUST be in the first column in order for the upload to be successful.  If your mobile numbers aren't in the above format, do not fret! You will be able to clean this up in a few easy clicks.

The most common issue is needing to remove invalid characters such as +, / or  - out of the column. To clean these characters out follow the below steps:

1. Identify which characters are included in the list that you need to remove

2. Highlight the first column that contains your mobile numbers

highlighting.png

3. Using your keyboard enter: Ctrl and F

4. Click on Replace

5. Enter the character that you want to clean from your data

6. Leave "Replace with" blank

 

find_and_replace.png

7. click "Replace All" option

replace_disclaimer.png

 

All numbers that previously included the unwanted character will now be removed! Repeat this process until all unwanted characters are removed.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk