phone book > csv

nosyncho

New Member
Joined
Mar 13, 2016
Messages
10
Reaction score
3
Android 5.1: I went into "Contacts" to export my phone book. There was no format option for csv. ?? I don't want to use Google for this right now. Also, the app did not appear to enable naming the export file. It was assigning the name and location. That is fine (can rename in computer), but I'm curious why.
 

Mustang02

Diamond Member
Joined
Aug 8, 2010
Messages
7,531
Reaction score
5,017
Location
Ohio
Current Phone Model
Nexus 6P/5X
I've only seen vcf or Vcard formats when extracting on a phone. CSV is windows format not android. You should be asked where you want to save, then the name.



Sent from my Nexus 6P using Tapatalk
 
OP
N

nosyncho

New Member
Joined
Mar 13, 2016
Messages
10
Reaction score
3
Why would "Export" be limited to a single, native format? CSV is a universal format, not tied to an OS or other vendor.
 

Mustang02

Diamond Member
Joined
Aug 8, 2010
Messages
7,531
Reaction score
5,017
Location
Ohio
Current Phone Model
Nexus 6P/5X
CSV is not a universal format for Android, which is based on Linux.

Sent from my Nexus 6P using Tapatalk
 
OP
N

nosyncho

New Member
Joined
Mar 13, 2016
Messages
10
Reaction score
3
CSV: Comma separated values. Loads into all kinds of spreadsheet programs, not only Microsoft Excel. Loads into Matlab, Mathematica, and other processing platforms. My computer is Linux, and works fine with CSV files. I am pretty sure there is no compatibility problem between the Android OS and CSV files. Maybe it's the particular "Contacts" app/version.

Am I overlooking the function in "Contacts"? Is the function elsewhere in the Android system? I think I saw some apps for purchase with CSV export, but aren't there some widely shared apps for this basic function?
 
OP
N

nosyncho

New Member
Joined
Mar 13, 2016
Messages
10
Reaction score
3
I connected the phone to computer with USB. Looking through the phone, there is no file of contact data evident. Maybe the data are in some inaccessible binary file. There are probably linux apps to import a csv file from the phone. Pointers anyone? And, it still seems reasonable to find a function in android or an app to export the phone book ahead of copying it to the computer. Suggestions are appreciated.
 

Jonny Kansas

Administrator
Staff member
Rescue Squad
Joined
Jan 21, 2010
Messages
16,740
Reaction score
7,355
Location
Michigan's Upper Peninsula
Website
www.google.com
Current Phone Model
Pixel XL
Twitter
jonny_ks
I would imagine contacts are stored at the system level. Without root access, I doubt you'd find them.

Sent from my Nexus 6P using Tapatalk
 

bkdodger

Administrator
Staff member
Joined
Dec 13, 2011
Messages
15,576
Reaction score
12,715
Location
Staten Island, New York
Current Phone Model
Note 10+
I'd just search the play store ..I'm sure there is an app you can download contacts and export in xml or csv


6s Plus
 

Miller6386

Developer
Developer
Joined
Oct 22, 2011
Messages
2,642
Reaction score
1,907
Location
Beer Tent Capital of The World
Current Phone Model
Note 8
Twitter
CoreyFMiller
There is a way/app to do just this. I have done it in the past I just don't recall exactly how I did it.

Sent from my SM-N910V using Tapatalk
 

Mustang02

Diamond Member
Joined
Aug 8, 2010
Messages
7,531
Reaction score
5,017
Location
Ohio
Current Phone Model
Nexus 6P/5X
I would imagine contacts are stored at the system level. Without root access, I doubt you'd find them.

Sent from my Nexus 6P using Tapatalk
In a database that you'll need sqllite to get to.

Found this.
Contacts = /data/data/com.android.providers.contacts/databases/contacts.db
SMS = /data/data/com.android.providers.telephony/databases/mmssms.db
Bookmarks = /data/data/com.android.browser/databases/browser.db

You can get them off the emulator using the adb pull command. E.g.

adb pull /data/data/com.android.providers.contacts/databases/contacts.db d:\contacts.db

Let me plug my phone in and see.
 

Mustang02

Diamond Member
Joined
Aug 8, 2010
Messages
7,531
Reaction score
5,017
Location
Ohio
Current Phone Model
Nexus 6P/5X
Marshmallow changed the db name.


1fbe469858112322ee61507700485c4d.jpg
 
Top