Best/recommended way to export selected contacts from Google Contacts to Kobo Forma

droopy · 08-01-2020, 04:58 PM

I'd like to save some contact information from selected contacts in my Google Contacts to my Kobo Forma.
It looks like Google Contacts can export as:
1. Google CSV
2. Outlook CSV
3. vCard (for iOS contacts)

1. Which should I choose?
2. After I choose one of the 3, what would be the next steps?

BetterRed · 08-01-2020, 05:10 PM

Moderator Notice

I can't fathom how this is relevant to the calibre application

If someone wants to tell me where they think it should be, I'll move it.

BR

droopy · 08-01-2020, 05:18 PM

BetterRed, I guess it's because I thought Calibre would be the middleman.

BetterRed · 08-01-2020, 06:28 PM

Quote:

Originally Posted by droopy

BetterRed, I guess it's because I thought Calibre would be the middleman.

Could be - one of the kobo experts might know,

Curious, why would you want Contacts (phone numbers etc, email addresses etc) on an e-reader, they don't have voice or SMS functionality - or do they?

BR

droopy · 08-01-2020, 06:29 PM

Quote:

Originally Posted by BetterRed

Could be - one of the kobo experts might know,

Curious, why would you want Contacts (phone numbers etc, email addresses etc) on an e-reader, they don't have voice or SMS functionality - or do they?

BR

who's "they"? the people and stores I want to add to my ereader ?
or are you referring to my Kobo device?

BetterRed · 08-01-2020, 06:31 PM

Kobo e-readers

droopy · 08-01-2020, 06:35 PM

thanks for clarifying. Yes, my Kobo Forma ereader doesn't have sms/voice functionality. but that's okay. I want phone numbers, hours of operation, addresses, other notes from Google Contacts just stored on my Kobo, simply because I can't remember them all. If I need to phone someone, I'd use a regular phone.

skb · 08-01-2020, 07:06 PM

If it were me and I had LOTS of names etc, I'd export them as a CSV (something that can be imported into Excel/OO maybe? Google?) and then import the CSV into a spreadsheet.

Once in the spreadsheet you could mail merge into a Word/OO document. You can either order them in the spreadsheet (for indexing) or Word. Spreadsheet would be easier. You can add Indexes/TOC in Word if required.

Import the Word/OO document into Calibre.

OR

If you want to bypass the mail merge, you could export the spreadsheet as an RTF and import that into Calibre.

Edited: OH...wait. You probably can't save a spreadsheet as an RTF. But you could do a HTML file. That may be it. Do the spreadsheet, format, remove superfluous fields and save as HTML.

droopy · 08-01-2020, 07:12 PM

Quote:

Originally Posted by skb

If it were me and I had LOTS of names etc, I'd export them as a CSV (something that can be imported into Excel/OO maybe? Google?) and then import the CSV into a spreadsheet.

Once in the spreadsheet you could mail merge into a Word/OO document. You can either order them in the spreadsheet (for indexing) or Word. Spreadsheet would be easier. You can add Indexes/TOC in Word if required.

Import the Word/OO document into Calibre.

OR

If you want to bypass the mail merge, you could export the spreadsheet as an RTF and import that into Calibre.

My Google Contacts has thousands of contacts, but I just want about 20 or 30 contacts on my Kobo Forma.
Because it's gonna be a small list, i don't need indexing. Maybe each contact can have its own page, and each contact can be listed in a Table of Contents.

JSWolf · 08-01-2020, 07:31 PM

Quote:

Originally Posted by BetterRed

I can't fathom how this is relevant to the calibre application

If someone wants to tell me where they think it should be, I'll move it.

BR

I think this thread would be best in the ePub forum as the contacts would be best as ePub. So it's a matter of getting the contacts into ePub.

But to be honest, I think manually editing an ePub is beyond Droopy at this point.

DNSB · 08-01-2020, 08:37 PM

Quote:

Originally Posted by droopy

I'd like to save some contact information from selected contacts in my Google Contacts to my Kobo Forma.
It looks like Google Contacts can export as:
1. Google CSV
2. Outlook CSV
3. vCard (for iOS contacts)

1. Which should I choose?
2. After I choose one of the 3, what would be the next steps?

Choose either of the CSV exports. Open the CSV file with Excel, remove the contacts and columns you don't want. Select and copy the content. Open Word with a blank document, paste the copied content. Save as .docx and import the .docx file into calibre. Convert to epub.

If you are feeling enthused, you can reformat the .docx before importing to calibre.

edit: Personally, I can't think of any forum this really belongs in other than possibly General Discussions. It's not really a calibre, epub, Kobo, etc. issue.

BetterRed · 08-01-2020, 09:06 PM

Moderator Notice

I'll move it to the Workshop

BR

BetterRed · 08-01-2020, 09:17 PM

@droopy - if the other suggestions don't work out, you could try loading the CSV into Nirsoft's CSVFileView, do any necessary column trimming/rearranging etc, save as HTML and use it to make an epub.

BR

droopy · 08-02-2020, 04:56 PM

hi betterred,
i'm on linux.

droopy · 08-02-2020, 04:57 PM

Quote:

Originally Posted by JSWolf

But to be honest, I think manually editing an ePub is beyond Droopy at this point.

Correct, JSWolf.

08-01-2020, 04:58 PM	#1
droopy Guru Posts: 833 Karma: 2912460 Join Date: Apr 2009 Device: Kobo Forma	Best/recommended way to export selected contacts from Google Contacts to Kobo Forma I'd like to save some contact information from selected contacts in my Google Contacts to my Kobo Forma. It looks like Google Contacts can export as: 1. Google CSV 2. Outlook CSV 3. vCard (for iOS contacts) 1. Which should I choose? 2. After I choose one of the 3, what would be the next steps?

08-01-2020, 07:06 PM	#8
skb Evangelist Posts: 401 Karma: 1597305 Join Date: Mar 2010 Device: Ipod G4, MacOS 10.12, Calibre, Pocketbook Touch HD 3	If it were me and I had LOTS of names etc, I'd export them as a CSV (something that can be imported into Excel/OO maybe? Google?) and then import the CSV into a spreadsheet. Once in the spreadsheet you could mail merge into a Word/OO document. You can either order them in the spreadsheet (for indexing) or Word. Spreadsheet would be easier. You can add Indexes/TOC in Word if required. Import the Word/OO document into Calibre. OR If you want to bypass the mail merge, you could export the spreadsheet as an RTF and import that into Calibre. Edited: OH...wait. You probably can't save a spreadsheet as an RTF. But you could do a HTML file. That may be it. Do the spreadsheet, format, remove superfluous fields and save as HTML. Last edited by skb; 08-01-2020 at 07:10 PM. Reason: Too long since I used a spreadsheet

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Google contacts question	jlmwrite	Nook Developer's Corner	7	03-19-2011 07:33 PM
Contacts (-application) how to sync with google gmail contacts?	mduijkers	enTourage Archive	0	09-09-2010 03:57 AM
contacts	Monty	enTourage Archive	0	06-29-2010 08:09 AM
Loading contacts	dnipper	enTourage Archive	7	05-03-2010 08:43 PM
Contacts	kren	Alternative Devices	0	04-20-2009 05:32 AM

08-01-2020, 05:10 PM	#2
BetterRed null operator (he/him) Posts: 20,590 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	Moderator Notice I can't fathom how this is relevant to the calibre application If someone wants to tell me where they think it should be, I'll move it. BR

08-01-2020, 05:18 PM	#3
droopy Guru Posts: 833 Karma: 2912460 Join Date: Apr 2009 Device: Kobo Forma	BetterRed, I guess it's because I thought Calibre would be the middleman.

08-01-2020, 06:31 PM	#6
BetterRed null operator (he/him) Posts: 20,590 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	Kobo e-readers

08-01-2020, 06:35 PM	#7
droopy Guru Posts: 833 Karma: 2912460 Join Date: Apr 2009 Device: Kobo Forma	thanks for clarifying. Yes, my Kobo Forma ereader doesn't have sms/voice functionality. but that's okay. I want phone numbers, hours of operation, addresses, other notes from Google Contacts just stored on my Kobo, simply because I can't remember them all. If I need to phone someone, I'd use a regular phone.

08-01-2020, 09:06 PM	#12
BetterRed null operator (he/him) Posts: 20,590 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	Moderator Notice I'll move it to the Workshop BR

08-01-2020, 09:17 PM	#13
BetterRed null operator (he/him) Posts: 20,590 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	@droopy - if the other suggestions don't work out, you could try loading the CSV into Nirsoft's CSVFileView, do any necessary column trimming/rearranging etc, save as HTML and use it to make an epub. BR

08-02-2020, 04:56 PM	#14
droopy Guru Posts: 833 Karma: 2912460 Join Date: Apr 2009 Device: Kobo Forma	hi betterred, i'm on linux.

Advert

Advert