Do you want to carry out an SMS campaign on your iPhone contacts, but you don't know how to retrieve your contact database? Find below how to extract your mobile phone contacts into a usable Excel database. All the data on your phone (name, first name, company, etc.) can be exported in CSV format and used as you wish. How to export your iPhone contacts to an Excel file? Before sending your SMS campaign , you will need to export your contact database present in your iPhone in a Vcard format (via the I cloud platform) .
Upon receipt of this file, you will simply need to convert it using the brotherli software into an Excel file and your database will then be usable. You will find below the detailed actions to perform the manipulation. Step 1: Create a vCadr file It is necessary to get the contact list on a computer. So it is necessary to sync your contacts with ICloud. Once this is done, go to: / , then select “ Contact ”. After this, your contacts list will open. It will therefore be necessary to go to the settings icon located at the bottom left of your screen. Once this is done, you will need to click on “ Import a Vcard ”. This will allow you to retrieve your contacts from a database.
After that, you will need to save the file and click “ OK ” on the pop-up that will appear. Your Vcard database is created, but you cannot use it yet. It is necessary to change the bulgaria phone number data format of your file to convert it to a " CSV " format. Step 2: Create CSV file from Vcard file To do this, it will be necessary to go to a file conversion software such as (free software) With the "Browse" tab, select the Vcard file you just downloaded. Regarding the format, select the desired one, namely, " CVS ". It is titled " Gmail (CSV)". Finally, validate with the “ convert ” button and save your file. Step 3: Import your contacts into Excel When this is done, it is necessary to open your file with Excel. Once opened, go to the “ Data ” tab Select your data in the spreadsheet and then click “ Convert ”. Select the “ Delimited ” button and then click “ Next ”.
On the next page, specify the separators between the information given by your table. You can select several different separators if needed, between tab, semicolon, comma, space or other. Finally, check the “ Standard ” option, then choose a destination page on your Excel file. You can select the box located in A1 in order to correctly place your contact table. You can also choose another page from your file. When this is done, click “ Finish ”. You are now done! And your database is ready to use All you have to do now is go to the SMS Partner sending platform and import your contact database with the variables you want to use! To do this, you can go to our video tutorial Import a contact database.