Business Cards to Excel: CSV Columns and Example

To put business cards in Excel, review the contacts in Folocard and export all cards as CSV. Use Excel to import the file. This page gives information about the CSV columns and gives a fictional example. For the full import procedure, see the business card to Excel procedure.

How do I export business cards for Excel?

1. Review each contact against its card image.
2. Open Settings in Folocard.
3. In Data, select Export all to CSV.
4. Select a destination in the system share sheet.
5. Check that the destination contains the CSV file.

The export contains all cards in the card directory. It does not offer card selection. Check the file before you give it to a different person because it contains contact data.

For a stack of cards, see the batch capture procedure. Review the contacts before export.

Which columns are in the Folocard CSV?

The file has 20 columns. The table shows the current column names and their values.

Current CSV columns

Columns	Values and checks
id, createdAt	Card ID and creation time. The time uses UTC.
firstName, lastName, fullName	The last word in the full name becomes lastName. Check names with more than two parts.
honorific, title, company, email, website, notes	Contact fields. A field can be empty. Notes contain the contact notes, not the full text from the card.
phoneMobile	The contact phone field. The column name does not prove that the number is a mobile number.
addressStreet, addressCity	The first address line is in addressStreet. More lines are together in addressCity. Check the address before import.
phoneOffice, phoneOther, addressState, addressPostalCode, addressCountry, vcardText	These columns are empty in the current export. The CSV does not contain a vCard.

Can I download an example CSV?

Download the fictional contact example CSV. It contains two invented contacts and the current 20-column header. It is an example, not a customer export or the missing 2021 file.

The first phone value, 02079460000, starts with 0. The second phone value starts with an apostrophe before +44. Folocard adds that apostrophe to values that start with spreadsheet formula characters, for example, a plus sign.

How do I keep phone numbers correct in Excel?

1. In desktop Excel, select Data > From Text/CSV.
2. Select the CSV file.
3. Select Transform Data.
4. Set the phone columns to the Text data type.
5. If Excel shows the Change Column Type dialog, select Replace Current.
6. Select Close & Load.
7. Check the phone values against the CSV file.

Microsoft gives these steps in Keeping leading zeros and large numbers. The full Excel import procedure also gives information about the delimiter and workbook format.

Does CSV export update my CRM automatically?

No. CSV export supplies a file. Your destination system controls the import and column mapping. Check names, phone values, addresses, and empty fields before you import your contacts.

Folocard keeps first-touch context with the contact. See the current Folocard functions and privacy policy for more information.