Exporting Contacts from Windows Mobile to Android (Without Outlook or Google Sync)

1. Do as msullivan suggests, all the way up through creating the .csv file. Open the resulting .csv file in Libreoffice calc (or MS Excel?).
2. Create a new macro module, if necessary, and paste in the two functions in code below. In Libreoffice Calc it's
   Tools->Macros->Organize macros->Libreoffice Basic...->
   and then add a new module if necessary. Open it for edit. Copy and paste the code below into the macro text editor and then close the editor.
3. Back in your opened spreadsheet, insert a new column to the right of the Notes column. In my spreadsheet, that's after column BG.
4. Fill that column with "=w2str(BGn)" where BG is whatever column where your hex encoded notes are, and n is the row number. You should now see your recovered notes.
5. Select the new column, copy it, and "paste special" text only over the old Notes column (BG, in my case). Your notes as text strings should now be in that column, and the new column with the formula should turn to blanks or gibberish. That's OK. Delete the new column (BH, in my case).
6. Add a column header "Notes" to the column, and save as... a new .csv file. You can now clean it up and proceed as msullivan suggests.

Function w2str (orig as string) as string
	wrk = split(orig,",")
	w2str = ""
	for indx = 1 to Ubound(wrk) step 2
		w2str = w2str + chr$(hVal(right(wrk(indx),2) + right(wrk(indx-1),2)))
	next
End Function

Function hVal (hStr as string) as integer
	dim c as integer
	hVal = 0
	for ndx = 1 to len(hStr)
		c = Asc(mid(hStr,ndx,1))
		if c >= 48 and c <= 57 then
			hVal = hVal * 16 + c - 48
		elseif c >= 65 and c <= 70 then
			hVal = hVal * 16 + c - 55
		elseif c >= 97 and c <= 102 then
			hVal = hVal * 16 + c - 87
		elseif c <> 32 then
			hVal = 0
			exit for 
		endif
	next
End Function

tanzemyu said:

Bluetooth worked for me. From wm device contacts (select all) to sd card of android, via bt. Later done ``import contacts from sd card``.

Click to expand...

Click to collapse

darcyhebe said:

It's pretty easy, because your Android phone will sync to Google Contacts.
1. Sync your Windows Mobile phone to your computer (outlook, outlook express, whatever you normally sync to)
2. Export your contacts from there to a CSV. ( Go To file menu on the top left in the out look, click on Import and Export, click on Export file to, Click Next, click on Comma Separated Values (Windows), click on Next, click on Contacts, click on Browse Select drive and Folder Where you want to save file, click on Next.) You are DONE
3. Use Google Contacts to import the CSV (import is in the upper right from

Click to expand...

Click to collapse