Many users are faced with a situation where the phone book is in an outdated format or stored on the computer in the form of a table. Importing contacts from a CSV file is a standard procedure that allows you to quickly restore the number database to a new one device or after a factory reset. Unlike manual entry, this method saves hours of time and eliminates typos when transferring hundreds of records.
However, the process is not always smooth due to differences in encodings and delimiter formats. Android smartphones, whether budget Redmi or flagship Samsung Galaxy, use different shells, but the basic mechanism for working with data remains the same. In this guide, we will look at all the nuances of converting and loading data so that your calls are always at hand.
The main difficulty is that a simple text file with commas can be misinterpreted by the system. For successful import, the file must be saved in UTF-8 encoding, otherwise Russian names will turn into a set of incomprehensible characters. Let's look at proven ways to solve this problem.
Preparing a contacts file for import
Before loading data into your phone, you need to make sure that the file is structured correctly. Most errors occur when creating or saving a document in Excel or LibreOffice. Standard CSV (Comma Separated Values) assumes the use of a comma as a separator, but Russian versions of tables often use a semicolon.
Open your file in a spreadsheet editor and check the first line. It should contain column headers such as Name, Phone, Email. If you see hieroglyphs instead of letters, then the problem is in the encoding. When saving the file, select the “Save As” option and specify UTF-8in the encoding options. This is a critical step for the correct display of Cyrillic on Android.
It is also worth paying attention to the format of phone numbers. It is advisable that they begin with a country code, for example, +7 for Russia. This will ensure correct operation of the caller ID and synchronization with instant messengers. Extra spaces, parentheses, or dashes within a number may result in the contact being saved but unable to be called.
Use Find and Replace in a text editor to remove extra spaces from phone number cells before saving the CSV.
⚠️ Attention: If your file has a .xls extension or .xlsx, you won’t be able to directly upload it to contacts. First, be sure to convert the document to CSV format (UTF-8).
Method 1: Import via Google Contacts in the browser
The most reliable and universal method of transferring data is to use the web version of the Google Contacts service. This method ensures that the data goes to the cloud and is automatically synchronized with all your devices linked to one account. You do not need to connect your phone to your computer with cables.
Go to the website contacts.google.com and log in with your Gmail account. In the menu on the left, find the “Import” button. The system will prompt you to select a file from your computer. After loading the CSV document, Google will try to automatically map the table columns to its fields.
You may need to manually specify which column corresponds to the name and which column corresponds to the phone number. If the file structure is complex, the system will create contacts with empty fields, which will then have to be edited. After confirming the import, wait a few minutes until the data appears on your smartphone if you have internet.
- 🌐 Open a browser on your PC and go to the Google Contacts website.
- 📂 Click the "Import" button in the side menu.
- ✅ Select the CSV file and confirm the comparison fields.
- 🔄 Wait for synchronization on your phone in the account settings.
Method 2: Direct import through the Contacts application
If you do not have access to a computer or you prefer to work directly with files on your smartphone, you can use the built-in application. The interface may differ depending on the phone model, but the logic of actions remains similar for most versions of Android, including pure Android 14 and shell One UI.
Copy the prepared CSV file to the internal memory of the phone. Then open the Contacts application, click on the three dots in the corner of the screen (menu) and select Import/Export Contacts or simply Import. You will be asked to select the source of the file - indicate “Device memory” or “Internal storage”.
At the next stage, the system will ask where exactly to save the contacts: to a SIM card, to the phone memory or to a Google account. Highly recommended Select a Google account, as this will provide backup. When importing to a SIM card, long names are often truncated and additional fields such as addresses or emails are lost.
Settings → Accounts → Google → Synchronization → ContactsMake sure that the switch next to the “Contacts” item is active. This will force a database update. If the numbers do not appear after importing, try clearing the cache of the Contacts application through the smartphone settings.
☑️ Check after import
Solving problems with encoding and delimiters
One of the most common problems is the situation when, after import, all names are displayed as question marks or a meaningless set of characters. This is a classic sign of an encoding mismatch. Windows Standard Encoding (ANSI) is not compatible with Android expectations, which requires UTF-8.
To fix the error, open the CSV file in Notepad on your computer. Click File → Save As. At the bottom of the save window, find the “Encoding” drop-down list and change the value to UTF-8. Save the file under a new name and repeat the import procedure.
Another common mistake is data “sticking together” into one cell. This occurs if the file uses a semicolon instead of a comma and the system expects the opposite. In this case, you can use the Find and Replace function in a text editor to swap the delimiters before loading.
| Problem | Probable cause | Solution |
|---|---|---|
| Hieroglyphs instead of names | Incorrect file encoding | Resave the file in UTF-8 |
| All data in one field | Invalid delimiter | Replace ; on , in a text editor |
| Contacts are not synchronized | Synchronization is disabled | Enable synchronization in the account settings |
| Numbers without a country code | Incorrect format | Add +7 or +380 at the beginning of the number |
What to do if Google Contacts does not see the file?
Make sure the file has the extension .csv, not .txt. Sometimes browsers download text files with the wrong extension. Rename the file manually by adding .csv at the end of the name.
Import features on different smartphone models
Smartphone manufacturers often modify the standard contacts application, adding their own functions or changing the menu layout. Owners of devices Xiaomi and Poco should look for the import function in the Contacts application under the menu button, which may look like three horizontal stripes.
On smartphones Samsung the process can be moved to general settings. Go to Settings → Accounts and archiving → Import or export contacts. Here the interface is more detailed and allows you to select specific fields for transfer, which is convenient when working with large databases.
Devices from Huawei and Honor also have their own manager contacts. Always check in which storage the data is saved.
⚠️ Attention: Application interfaces and settings menus may be updated by developers. If you do not find the described item, use the search in the phone settings by entering the word “Import”.
Always choose to save contacts to your Google account and not to the phone memory, so as not to lose the database if the device breaks down.
Alternative methods and third-party applications
If standard system tools for some reason reasons do not work, you can use specialized utilities from the store Google Play. Applications like “Copy My Data” or “Smart Transfer” allow you to transfer contacts not only from files, but also directly from another phone via Wi-Fi.
Some users prefer to use VCF (vCard) instead of CSV. This is a more secure format for contacts as it supports embedded data and profile photos. You can convert CSV to VCF using online converters, and then simply open the resulting file on your phone - the system will offer to add all contacts at once.
Using third-party database managers (for example, by connecting your phone to a PC in debug mode) gives maximum control, but requires technical skills. For the average user, the optimal balance of complexity and reliability remains working through the Google web interface.
- 📱 Install a converter application if you need to change the file format.
- ☁️ Use cloud storage to transfer the file to your phone.
- 🔒 Check application permissions when accessing contacts.
Is it possible to restore deleted contacts after an unsuccessful import?
Yes, Google Contacts has a “Undo Changes” function. It allows you to roll back the state of the phone book back by 30 days.
Frequently asked questions (FAQ)
Why are contacts duplicated after import?
This happens if the file contains entries that match those already existing in the phone memory, but with slight differences (for example, a number is written with a code countries and without it). Use the Merge Duplicates feature in the Google Contacts app to clean up your list.
What is the maximum size of a CSV file to import?
Google Contacts typically handles files with several thousand entries without problems. If the file is too large (more than 10-15 thousand lines), it is recommended to split it into several parts to avoid a timeout during loading.
Is it possible to import contact photos from CSV?
The standard CSV format does not support storing images. Photos can only be added via VCF format or manually after importing text information. In CSV, you can only specify a link to a photo if the service supports this function.
What to do if the phone does not see the CSV file?
Make sure that the file is in the root directory or in the Download folder. Some file managers may hide certain types of files. Try opening the file through any text editor on your phone to check its integrity.
Is it safe to upload contacts to online services?
Using official services such as Google Contacts is safe because the data is encrypted and protected by the company's privacy policy. Avoid using little-known online converters that may save your database.