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


  • 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.





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

Popular Posts


Latest Comment

  • Mary      Adeoye Mary Adeoye
    Good day, please I want to know when there will be ONENAIRADAY unit?


  • psirsjos psirsjos
    Good morning, Please can i purchase over 100,000 worth using at a go and get instant ...


  • kingsley kingsley
    I made a payment but I have not been credited


  • Jaykay hotel Jaykay hotel
    I have made use of the corporate route yet all DND numbers refused to deliver


  • segunbalogun737 segunbalogun737
    Pay in this account 1395407799 access bank mr balogun segun tumini or contact me


Blog Calendar

« January 2021 »
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 31