Convert CSV to SPB

Older Samsung phones managed with Samsung Kies may require a Kies-generated SPB phonebook backup rather than the CSV exported by an address-book service. The conversion is useful when contacts must be imported into Kies and then restored to a compatible device.

What the CSV format is

CSV (comma-separated values) is a plain-text table used to exchange contact records. Each row normally represents one contact, with columns for names, companies, telephone numbers, email addresses, and postal addresses. Excel, LibreOffice Calc, Google Sheets, Outlook, Thunderbird, CRM systems, and phone-management software can create or export CSV files.

CSV has no universal contact-field definition. A file may use separate First Name and Last Name columns or one Name column; its separator may be a comma, semicolon, or tab. The encoding and quoting rules also affect whether accented names, commas in addresses, and line breaks import correctly.

What the SPB format is

For contacts and address books, SPB is the proprietary Samsung Kies phonebook backup format. Kies generates it when contacts are backed up for restoration to a compatible Samsung device or Kies installation. SPB is not a general-purpose exchange format, and its internal specification is not broadly supported by other contact applications.

An SPB backup is intended for the Kies restore workflow, while CSV remains easier to inspect, edit, archive, and move between unrelated applications. SPB may preserve information in a form that Kies understands, but it should not be treated as a portable or human-editable contact format.

How to convert CSV to SPB

1. Prepare a working copy. Open the CSV in LibreOffice Calc or Excel and verify the delimiter, header row, character encoding, and number of records. Import the file with the correct separator instead of opening it blindly; otherwise all fields may appear in one column. Save a UTF-8 copy if the contacts contain non-ASCII characters. Do not let spreadsheet software convert telephone numbers into numbers or remove leading plus signs and zeroes.
2. Try Kies's direct import first. Install the Kies version compatible with the target Samsung phone, connect the phone if required, and open its contacts view. Use the available Contacts → Import, Import/Export, or similarly named command and select the CSV file. Kies releases differ: some accept CSV and provide a field-mapping dialog, while others accept only vCard or provide limited contact import options.
3. Use vCard when direct CSV import is unavailable. Thunderbird is a suitable desktop intermediary. Import the CSV into a Thunderbird address book, map each source column to the correct contact field, select the imported records, and export them as a vCard file such as contacts.vcf. LibreOffice can clean and reorganize the table, but it does not by itself create a correctly structured vCard file.
4. Import contacts.vcf into Kies through its contacts import command. Kies menu names vary by release, so use the contacts import function rather than relying on an exact menu path. If Kies accepts CSV directly, skip the vCard step.
5. Inspect the imported contacts in Kies before making the backup. Check the contact count, names, phone-number types, email addresses, duplicate records, and non-ASCII characters. Correct errors in the source or in Kies before proceeding.
6. Run Kies's contact backup command, commonly under Backup/Restore or Tools → Backup, and select contacts. Kies creates the phonebook backup with the .spb extension. Keep the complete backup location if Kies creates accompanying metadata or additional files, rather than moving only the SPB file.

Online and desktop conversion options

No reputable general-purpose service can reliably convert arbitrary CSV data directly into a Samsung Kies SPB backup, because SPB is proprietary and tied to Kies compatibility. For non-sensitive data, an established CSV-to-vCard web converter such as ConvertCSV can create the intermediate .vcf file; import that file into Kies and let Kies create SPB. Do not upload personal names, phone numbers, or email addresses to an online service unless its privacy terms and data handling are acceptable.

For private address books, use LibreOffice Calc or Excel for CSV cleanup and Thunderbird for CSV-to-vCard conversion. These desktop tools keep the source data local, but they still require manual field mapping and verification.

Quality and compatibility limits

CSV commonly loses or rearranges contact photos, categories, notes, custom fields, distribution lists, multiple addresses, and multiple telephone numbers. A single CSV column may also combine values that Kies expects to receive as separate fields. Compare the source and imported record counts and inspect representative contacts before creating SPB.

Samsung Kies is discontinued, and many newer Samsung devices use Smart Switch or account synchronization instead of SPB. A current phone may not restore a Kies backup even if the file has the correct extension. Confirm that the target model and installed Kies release support SPB restoration; retain the original CSV and, preferably, the vCard as portable source copies.