How to Extract Nigerian Phone Numbers from a Comma Separated Values (.csv) file

  18 January 2016

In previous articles under the features of SmartSMSSolutions unique phone number extractor, we discussed how to extract phone numbers saved in Microsoft word, Microsoft Excel, Plain Text file, Open document text format and Rich text format. Another file type that merits attention is the Comma Separated Values (.csv) files.

 

Comma Separated Values (.csv) files are files in which tabular data are stored in plain text format, with each record separated by a comma. Files saved in CSV format is yet another kind of file on which SmartSMSSolutions phone number extractor has the capability to extract phone numbers from. Here is a brief tutorial on how to go about this.

 

 

  • Save the CSV file on your computer, either on the desktop or on another desired location.

 

  • How do you know a Comma Separated Values (.csv) file? When CSV documents are saved, you’ll see the suffix .CSV attached to the file name.

 

  • Once you’ve saved the document in a location you’ve chosen, launch the phone number extractor using the web address www.xmx1.com/extract.

 

  • When you get there, scroll down on the first page you see and click on ‘Extract from File’. You’ll be required to login to your bulk SMS account if you’ve not done so already. Don’t have an account? Sign up now for free.

 

 

  • Then, in front of the box tagged select a file, click on ‘Browse’

 

 

  • A dialog box will pop-up where you now go to the folder or location where you’ve saved the CSV file and select it, or input the name of the saved file inside the box tagged ‘File Name’. That’s why it’s important to note where it is saved and the name used to save it.

 

  • Once you’ve located it, click on ‘Open’ and the file transfers to the application.

 

  • At this point, select one among the options for saving to a phoneBook or not that follows. If you want to add the number to an existing phoneBook or a new one. If not, click on ‘Don’t save’.

 

  • If you do not desire to separate the extracted numbers by network, then proceed to the next box. If you do, click inside the box next to it.

 

  • Once this is done, click on ‘Extract’.

 

 

 

  • If you have phone numbers saved inside the file you’ve selected, the numbers becomes extracted instantly and you get a success alert. If there are no phone numbers saved inside the document, you get an error alert and you need to revisit the file to ensure the numbers are there and correct the discrepancy.

 

 

  • Thus, you have the numbers extracted from the Comma Separated Values (.csv) file and you can then access them at later times.

 

So, you have the numbers saved in your bulk SMS account and you can then use them for what you desire at later times.

 

If you do not have a registered bulk SMS account yet with SmartSMSSolutions, register here now and get free SMS units instantly.

 

Do you have any question or inquiry on the use of the phone number extractor for extracting Nigerian phone numbers from a Comma Separated Values file type? Let us know in the comment box below.

 

 

 

REGISTER FREE

  • 10 Free SMS on Sign-Up
  • 5% Bonus on First Purchase
  • Delivery Report Available
  • Most Affordable Pricing
  • Easy Payment Channels

Popular Posts

Headlines

Latest Comment

  • Okeleye Thomas Okeleye Thomas
    Hi Smart Team, it's been a while one naira day came up hope it has not been scrapped?!!! Please bring ...

    Read more...

     
  • gcube212 gcube212
    When I try to input the otp code sent to my number it gives me pin tries exceeded, I’ve been trying to ...

    Read more...

     
  • ADEROJU SIKIRU ADENIYI ADEROJU SIKIRU ADENIYI
    i want to buy SMS units at any ATM in ECOBANK

    Read more...

     
  • Emmanuel Emmanuel
    Is the corporate route available via API now?

    Read more...

     
  • omokejimi omokejimi
    Good morning sir ,congrats you just won it

    Read more...

Blog Calendar

« November 2019 »
Mon Tue Wed Thu Fri Sat Sun
        1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30