Hi, I wanted to export all my contacts (for later use in Excel) from the Android 9 phone and found out that there are some unexpected (at least for me) limitations. I don't know if they are bugs or features, but users should be informed that they lost some informations when they select particular file format.
Here is as example real contact in different formats:
Export as VCF or by Extras -> Create backup: All 5 phone numbers backuped
BEGIN:VCARD
N;CHARSET=UTF-8:€;GoMobil;;;
FN;CHARSET=UTF-8:GoMobil €
TEL;HOME;X-SYNCMLREF1147:+420 799 505 505
TEL;CELL;X-SYNCMLREF1148:+420 799 505 525
TEL;CELL;X-SYNCMLREF1149:+420 840 215 315
TEL;LABEL=Tarifomat - Petra Machová;X-SYNCMLREF8675:+420 778 760 138
TEL;LABEL=O2;X-SYNCMLREF8678:+420 800 020 202
CATEGORIES:Firma
X-IRMC-LUID:000000000107
X-ACCOUNT:com.google;****
END:VCARD
Export as LDIF: Only 2 phone numbers
dn:: Y249R29Nb2JpbCDigqw=
objectclass: top
objectclass: person
objectclass: organizationalPerson
objectclass: inetOrgPerson
objectclass: mozillaAbPersonAlpha
givenName: GoMobil
sn:: ****
cn:: ****
modifytimestamp: 0Z
homePhone: +420 799 505 505
mobile: +420 799 505 525
Export as CSV: Only 2 phone numbers
"Title",... (I cut this header, not important)
,"GoMobil","€","+420 799 505 525","+420 799 505 505",,,,,,,,,,,,,,,,,,,,,"Firma","Google",,
Export as XML: Only 2 phone numbers
<?xml version="1.0" encoding="UTF-8"?>
<mpe_contacts creation_time="12.5.2021 14:12:17" mpe_user="LG V30" mpe_version="1.8.15" contactcount="1">
<contact>
<name>GoMobil</name>
<surname>€</surname>
<cell>+420 799 505 525</cell>
<home>+420 799 505 505</home></contact></mpe_contacts>
Export as Fritzbox XML: Now 3 phone numbers
<?xml version="1.0" encoding="UTF-8"?><phonebooks><phonebook>
<contact><person><realName>GoMobil €</realName></person><telephony nid="3"><number type="home" id="1">0799505505</number><number type="mobile" id="2">0799505525</number><number type="mobile" id="3">0840215315</number></telephony></contact>
</phonebook></phonebooks>
Export as CONTACT file: Only 2 phone numbers
<?xml version="1.0" encoding="UTF-8"?>
<c:contact c:Version="1" xmlns:c="http://schemas.microsoft.com/Contact" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:MSP2P="http://schemas.microsoft.com/Contact/Extended/MSP2P">
<c:CreationDate>2021-05-12T12:14:23Z</c:CreationDate>
<c:Extended xsi:nil="true"/>
<c:ContactIDCollection><c:ContactID c:ElementID="0265b4aa-aa4e-45ff-a825-982f692a0a23"><c:Value>32f05818-fd54-4668-ae17-cb8c6892c27d</c:Value></c:ContactID></c:ContactIDCollection><c:NameCollection><c:Name c:ElementID="6b22c12e-d957-45e8-b686-ac80aee12179"><c:GivenName c:Version="1" c:ModificationDate="2021-05-12T12:14:23Z">GoMobil</c:GivenName><c:FamilyName c:Version="1" c:ModificationDate="2021-05-12T12:14:23Z">€</c:FamilyName></c:Name></c:NameCollection><c:PhoneNumberCollection><c:PhoneNumber c:ElementID="cd2472d7-1b4f-4452-8a45-687b01c11835"><c:Number c:Version="1" c:ModificationDate="2021-05-12T12:14:23Z">+420 799 505 505</c:Number><c:LabelCollection><c:Label>Voice</c:Label><c:Label>Personal</c:Label></c:LabelCollection></c:PhoneNumber><c:PhoneNumber c:ElementID="1b3e025a-bc99-4225-84d8-6c3d656ace7e"><c:Number c:Version="1" c:ModificationDate="2021-05-12T12:14:23Z">+420 799 505 525</c:Number><c:LabelCollection><c:Label>Cellular</c:Label></c:LabelCollection></c:PhoneNumber><c:PhoneNumber c:ElementID="34a67e13-25b7-4228-b6c9-61aa0f9fc8b2"><c:Number c:Version="1" c:ModificationDate="2021-05-12T12:14:23Z" xsi:nil="true"/><c:LabelCollection><c:Label>Fax</c:Label><c:Label>Business</c:Label></c:LabelCollection></c:PhoneNumber></c:PhoneNumberCollection></c:contact>