User Manual
Contents
1. OtherStreet 1 2 3 OtherCity OtherState OtherZIP OtherCountry If you edit excel in Separate style then no particular format required in cells But for Mixed style the values in the cells of these properties should follow specific format Phonenumbers Addressed EmailAddresses WebsitURLs InstantMessagelDs AssociatedDates The format is shown as Figure 3 2 the Country Code should be an ISO 3166 country code for example gb United Kingdom us United States If Empty use default country on your iPhone The size of input for Note is limited to 4KB The part in excess will lose If cells date type is set to TEXT when you enter date information five ways for your choice MM DD YYYY YYYY MM DD YYYYMMDD DD MM YYYY DD MM YYYY Figure 3 2 Format 30 ExcelContacts User Manual Column headers Format Groupname 1 group name1 group name2 Phonenumbers lt label1 gt lt phone number1 gt lt label2 gt lt phone number2 gt Mobile 1 2 3 Single line No formatting iPhone 1 2 3 WorkPhone 1 2 3 HomePhone OtherPhone Custom Phone HomeFax WorkFax OtherFax WebsiteURLs abel1 URL name1 lt label2 gt URL name2 WebsiteURL 1 2 Single line No formatting Example 1 Groupname Friends Business 1 Phonenumbers Mobile 802 2222 222 Work 802 1111 111 2 1 Mobile1 Mobile Mobile3 15654641545 16568456554 13544748943 1 iPhone1 iPhone2 iPhone2. Cou ntry Code1 lt Label2 gt Street lt street name2 gt City lt city name2 gt State lt state name2 gt ZIP lt Zip code2 gt 1 Addresses Work Street 1001 Parker St City Berkeley State CA ZIP 654321 CountryCode us Cottage street 1001 E City Surrey State England ZIP 123456 CountryCode gb CountryCode Country Code2 gt 2 WorkStreet 1 2 Single line 1 WorkStreet1 WorkStreet2 WorkCity WorkState WorkCity No formatti ng 2 1001 Parker 1006 Parken Berkeley England WorkState WorkZIP WorkCountry Home Street 1 2 1 HomeStreet1 HomeStreet2 HomeCity HomeState HomeCity 2 1001E 1004E Surrey England Home State HomeZIP HomeCountry OtherStreet 1 2 1 OtherStreet1 OtherStreet2 OtherCity OtherState OtherCity 2 1001 E 1004 E Surrey England OtherState OtherZIP OtherCountry 1 Country code should be an ISO 3166 country code 32 WorkZIP WorkCountry 654321 us HomeZIP HomeCountry 123546 gb OtherZIP OtherCountry 123546 gb InstantMessagelDs InstantMessagelD 1 2 AssociatedDates AssociatedDate 1 2 RelatedNames RelatedName 1 2 SocialProfiles SocialProfile 1 2 ExcelContacts User Manual lt Label1 gt 1 InstantMessagelDs Service name1 Instant message id1 gt Work Label2 MSN Kelvin msn com Home Service name2 Instant message id2 Yahoo Kelvin yahoo com 2 Single line 1 InstantMessagelD1 InstantMessagelD2 No formatting 2 MSN Kelvin
3. 2012 19 10 33 19 ExcelContacts User Manual Step 6 The app will ask you to confirm you can tap the Import button to continue or tap the Cancel button to exit Step 7 Wait until the app finish the import there is a progress bar during the import 20 ExcelContacts User Manual 2 3 Transfer contacts between iPhone and Gmail 2 3 1 Transfer contacts from iPhone to Gmail Step 1 Launch ExcelContacts app In the app s Exporting page set the Property Style to Gmail Style Then tap the start button E Z uut Panta T Mixed y Separate i Outlook NEW wet 2 Gmail 7 Step 2 Export the contacts on your iPhone via USB WIFI Email Dropbox Read more about how to export contacts in chapter 2 1 1 2 1 4 Step 3 Extract a csv file from the export zip file The csv file is a UTF 8 encoding txt file and it may look like a mess if you open it using MS Excel directly Don t try to edit it Step 4 Import contacts into Gmail by CSV 1 Sign in to Gmail 2 Click Contacts located above the Compose Mail button on any Gmail page 3 From the More actions dropdown menu select Import 4 Click the Choose File button 5 Select the csv file you ve got in step 2 upload it and click the Import button 6 When it s done Gmail will display the number of contacts imported 21 ExcelContacts User Manual 2 3 2 Transfer contacts from Gmail to iPhone Step 1 Export your Gmail contacts list into a CSV file
4. Surrey England 123456 United Kingdom November 30 2001 January 1 2012 Kelvin msn com MSN Me Kelvin yahoo com Yahoo 25 1 D Phonenumbers Work 802 1111 111 Mobile 802 222 2 222 AAA 802 3333 333 BBB 802 4444 444 Emailaddresses Work Kelvin gmail com CCC Kelvin hotmail com DDD Kelvin msn com H WebsiteURLs HomePage Kelvin warnerbos com HHH Kelvin warner com F Addresses Work Street 1001 Parker St City Berkeley State CA ZIP 654321 FFF Street 1001 E City Surrey State England ZIP 123456 CountryCode gb AssociatedDates Anniversary 11 30 01 I 1 1 12 G InstantMessagelDs Work MSN Kelvin msn com GGG Yahoo Kelvin yahoo com ExcelContacts User Manual As shown in the picture above the left is an example contact on the iPhone the right is the export excel file The mixed style has features as follows Mixed style contains six multiple value properties They are Phonenumbers Emailaddresses Addresses WebsiteURLs AssociatedDates and InstantMessagelDs The six multiple value properties have specific format If the input value is not in exactly the expected format It will not be imported All custom labels for example the custom phone number labels AAA BBB can both be exported and imported 26 3 2 Separate format ee work 802 111 1111 AAA 802 333 3333 BBB 802 444 4444 work Kelvin amp gmail com ccc Kelvin hotmail co
5. 21 2 3 1 Transfer contacts from iPhone to GhYOll uade Fe ot RARE ER A VERE Ce TORRE EE FERRE FARE TEE dE EVE REN TERR ME 21 2 3 2 Transfer contacts from Gmail to iPhone esses eene nennen nnne e ea esee eene 22 2 4 Transfer contacts between iPhone and Outlook eeesssssseseeeeeeeeeeeeeee enne nnne 23 2 4 1 From JPhoDe TO OU TOON sies ecet utum ende dumb auten tuse bacis Udc END cud PED CUNT PU ITEM RES EU DE 23 2 4 2 Fron Outlook TO IPNONC me 24 FORIVIAD emm O HM 25 3T Ice c TOR cenre etit etui Daci alui d oS ctlee cute a or idest A tue EcL d s Cab ee Deb srt cT dion 25 3 2 Separate OL d necdsiices dte eed A tee eh recent nce fete en rarer secas edet s 27 3 3 Format your excel Tor MIMD ONING ria ext oetestk termed bar iom us ec Ereer id euet ri re sit st ette vet iria cames iet us 29 3 3 1 COOMAN OO CIS cata REIR RO E E 29 3043 YAO A CONTAGL ONO LOS estados su eei ide del edi oo ncaa ioe were OR ate anata ced ot alio eines nese dex the Dae 34 SETTING PAGE e M M 35 FAQ m M 37 Ol Howtoagccessthe export TILE MUMS 0st ai pencntespesetuvi e oi A RPM er eo eser tepore mE ETE OU E DUE 37 Q2 How to put the import file to File Sharing folder in iTunes eeseee 37 Q3 How to senerate the Import leq s esatct us edendi rcen uda bi veta te none nter be ase
6. 4 The import page will be displayed in the browser select the import file and press the Import button 30 Import Contacts 4 gt brtp 192 168 1 158 8081 C Q7 Google lo e 2 2 SQLite icon Apple Developer iOS Developer Library Stack Overflow CocoaChina Please select a ExcelContacts contacts zip or excel file then press the Import button Choose File contacts 20100724 zip Import Step 5 Return to your iPhone in import screen the app will ask you to confirm you can tap the Import button to continue or tap the Cancel button to exit Step 6 Wait until the app finishes the import There is a progress bar during the import 15 ExcelContacts User Manual 2 2 3 Import iPhone contacts and photos from PC via Email Step 1 Open your email which contains the import Step 2 Tap the attachment for 2 3 seconds Then file tap the Open In button From yangyang yu gt My Contacts March 2 2012 17 47 Please import the attachment using ExcelContacts contacts xls 369 KH Quick Look Open in ExcelSMS Cancel Cancel 16 ExcelContacts User Manual Step 4 The app will ask you to confirm you can tap the Import button to continue or tap the Cancel button to exit Step 5 Wait until the app finish the import there is a progress bar during the import 17 ExcelContacts User Manual 2 2 4 Import iPhone contacts and photos from PC via Dropbox Step 1 Upload your fil
7. 4 Privet Drive Little Whinging City Surrey State England Work arrypotter gmail com 2 Home harrypotter msn com 34 J K InstantMessages Image Work MSN harrypotter msn com Home Yahoo harrypotter yahoo com 1 jpg Password protected ExcelContacts User Manual 4 SETTING PAGE Password protected OFF Change password gt Account Dropbox gt Export Language Italiano All Properties OFF Photos _on Order by Group First name Delete files in File Sharing gt Import Erase iPod contacts Erase iPod groups EN Duplicates comparison Full name Merge duplicates Setting On Password protects your export zip file You need to enter password when extract export file Off No password protected Change password When Password protected is on you can set or change your password here Set and change your dropbox accounts here Select the language of exporting excel file 35 ExcelContacts User Manual Francais 0e Italiano e AAR Portugu s PyccKun e HAM e XPM All Properties On All contact properties will be exported to contacts xls Off Only not null properties will be exported to contacts xls Photos On Contact photos will be exported Off Don t export the contact photos Order by Set the sort order of contacts in the export file e Group Lastname e Group Firstname e ast name e First name Delete files in File Sharing See a
8. Websiteurls InstantMessagelDs AssociatedDates properties compared with Mixed format 1 2 ou RO Addresses is separated to Street City State ZIP Phonenumbers is separated to Mobile WorkPhone HomePhone WorkFax HomeFax OtherPhone Emailaddresses is separated to EmailAddress1 EmailAddress2 Websiteurls is separated to Websiteurl1 Websiteurl2 InstantMessagelDs is separated to Instant Message1 InstantMessage2 AssociatedDates is separated to AssociatedDate1 AssociatedDate2 Only the custom labels for phone numbers can be imported and exported while Other contact properties custom labels Email addresses Addresses etc cannot For example the two custom labels CCC DDD for email addresses will be transfers to OtheEmailAddresses1 OtherEmailAddresses2 in the export excel file The property name for custom phone number should be CustomLable Phone For example CarPhone 28 ExcelContacts User Manual 3 3 Format your excel for importing The contents of excel spreadsheet can mainly divided into two parts column headers in the first row and the rest contacts detail information rows Each column header name must be a valid property name Each row represents one contact if firstname middlename lastname and company are all empty this row cannot be imported First row should contain column headings A B C D E F G H 1 Groupname Lastname Fwstnarne Mobile WorkPhone HomePhone Compan
9. a Export Step 3 Select the USB export option mE Export Contacts x USB WiFi More eee The export file will be saved in File Sharing folder you can access it in iTunes s File Sharing pane Export iPhone contacts and photos to PC via USB Step 2 Wait until the app generates the export file There is a progress bar during the export r Export Contacts x Generating 715 3109 AntonelloLacopete Property Style Separate 4 Export Step 4 Wait until the export file was saved in File Sharing folder successfully The file contacts 20120405 zip has been saved in File Sharing folder successfully OK Cancel m ExcelContacts User Manual Step 5 Access the export file in iTunes 1 Connect your iPhone to your computer via the Dock Connector USB cable 2 Launch iTunes and go to the Apps tab for your iPhone Scroll down to the File Sharing section at the bottom of the window 3 From the left column of the File Sharing section select ExcelContacts app 4 Fromthe right column select the export file you want to transfer Click the Save to button 5 Alternatively you can drag the desired document to any Finder location Step 6 The last step is to wait There will be several seconds lag as iTunes prepares to do the transfer Finally iTunes initiates a sync and copies the selected file to your computer Summary 79 Musk Movies TVShows Photos In
10. cy fweerites Pdpauum YOR V iw I expert cemtects X E a a aa 73 7 a aie ee 0 QU Osa Level gi Font Size A Encodisg Centent Control Translate please cick the following link to download your contacts zip file generated by ExcelContacts contacts 20100724 zip 149 7 Kb Up Sevicnter Ri Magic Full Screen Capture CJ Clean Mistery AA Find Gown Net gp Prev X d i Multi Yerd Match Case Fhile Ford x x Seni de Tos bar mex F a na O olme Step 6 The downloaded zip file contains a file named contacts xls and a folder named images mages contacts contacts 20100724 ExcelContacts User Manual 2 1 3 Step 1 Launch ExcelContacts app and tap the Start button in export screen E Export Contacts 3 v Em me i If Contact EC V O Property Style Separate ay 4 Export Step 3 Select the More export option Import Contacts The import file will be transferred from your computer to this iPod over your local WiFi network Export iPhone contacts and photos to PCvia Email Step 2 Wait until the app generates the export file There is a progress bar during the export Export Contacts aj x Generating 715 3109 AntonelloLacopete Property Style Separate Export Step 4 Tap the Email button Other APP Cancel ExcelContacts User Manual Step 5 Enter the desired email address and tap the Send button cancel contac
11. msn com Yahoo Kelvin yahoo com Label1 lt date1 gt 1 AssociatedDates Label2 date2 Anniversary 11 30 01 Meet 1 1 12 2 Single line 1 AssociatedDate1 AssociatedDate2 No formatting 2 11 30 2001 1 1 2012 lt Labell gt lt name1 gt A lt Label2 gt lt name2 gt i RelatedNames sister Lily gt brother Tom Single line A B No formatting 1 RelatedName1 RelatedName2 gt sister Lily brother Tom Service name1 profile 1 Service name2 gt profile 2 SocialProfiles Twitter twitter gmail com 9 Facebook facebook gmail com Single line A B No formatti ng 1 SocialProfile1 SocialProfile2 2 Twitter twitter gqmail com Facebook facebook qmail com 33 ExcelContacts User Manual 3 3 3 Add contact photos Step 1 Copy contacts photos to the folder images Tools Help File Edit View Favorites Back gt 2 Search Folders Ez Address C contacts Folders X Name a Size Type Date Modified 3 Desktop images File Folder 7 31 2010 9 43 PM B my Documents BE contacts 20KB Microsoft Office Exc 7 30 2010 9 44 PM zi P Mv Computer E A 314 Floppy 4 Se Local Disk C O contacts D images Documents and Settings i 3 Program Files i O Project i O WINDOWS Step 2 Enter the photo filename H 1 Emailaddresses Addresses Home Street 4 Privet Drive Little Whinging City Surrey State England Work Street
12. name of the document and hit the Delete key on your computer s keyboard 4 When done you can disconnect the iPhone from the computer Summary 7779 Musk Movies TV Shows Photos Info File Sharing The apps listed below can transfer documents between your iPod touch and this computer ExcelContacts Documents Apps Today 11 19 2012 2 19 22 42 Sl contacts 20120405 zip 5 yuyy largenote xis Eee c ExcelMail 2 ExcelPhotos ExcelSMS S NM HoursTracker T iMovie 1 v AGO S Step 2 Launch ExcelContacts app and tap start button in import screen 12 8 KB 64 KB Save 1o Sae Step 3 Select the USB import option MOr oss ExcelContacts User Manual Step 4 Select a file for importing in File Sharing list Es Nov 3 2010 7 06 52 contacts 20120401 zip Apr 1 2012 16 06 56 contacts 20120405 zip Apr 5 2012 11 19 15 contactsm 20120321 zip Mar 21 2012 12 56 23 contactso 20120321 zip Mar 21 2012 13 39 39 Step 5 The app will ask you to confirm you can tap the Import button to continue or tap the Cancel button to exit Step 6 Wait until the app finish the import there is a progress bar during the import 13 ExcelContacts User Manual 2 2 2 Import iPhone contacts and photos from PC via Wi Fi Step 1 Launch ExcelContacts app and tap start Step 2 Select the Wi Fi import option button in import screen 14 ExcelContacts User Manual Step
13. 3 2 1111 222 2222 333 3333 444 1 WorkPhone1 WorkPhone2 WorkPhone3 1111 222 2222 333 3333 444 1 HomePhone HomePhone2 HomePhone3 2 1111 222 2222 333 3333 444 1 OtherPhone1 OtherPhone2 OtherPhoen3 2 1111 222 2222 333 3333 444 1 CottagePhone WeekendPhone HelpPhone 2 1111 222 2222 333 3333 444 1 MHomeFax1 HomeFax2 HomeFax3 1111 222 2222 333 3333 444 1 WorkFax1 WorkFax2 WorkFax3 2 1111 222 2222 333 3333 444 1 OtherFax1 OtherFax2 OtherFax3 1111 222 2222 333 3333 444 1 WebsiteURLs Work Kelvin warnerbos com Business Kelvin warner com 2 1 WebsiteURL 1 WebsiteURL2 2 Kelvin warnerbos com Kelvin warner com 1 When you enter multiple lines in one cell use ALT Enter to make a line break 31 ExcelContacts User Manual Emailaddresses abel1 email address1 gt lt label2 gt lt email address2 gt 1 Emailaddresses Work Kelvin gmail com Home Kelvin hotmail com 2 EmailAddress 1 2 Single line 1 EmailAddress1 EmailAddress2 No formatting 2 Kelvin gmail com Kelvin hotmail com WorkEmailAddress 1 2 1 WorkEmailAddress1 WorkEmailAddress2 2 Kelvin gmail com Kelvin hotmail com HomeEmailAddress 1 2 1 HomeEmailAddress1 HomeEmailAddress2 2 Kelvin gmail com Kelvin hotmail com OtherEmailAddress 1 2 1 OtherEmailAddress1 OtherEmailAddress2 2 Kelvin gmail com Kelvin hotmail com Label1 Street street name1 Addresses City city name1 State state name1 ZIP Zip code1 gt CountryCo de
14. P 654321 Since only custom labels defined for phone numbers can be imported and exported in Separate properties style Mixed would be a better choice if you want to keep all the customs labels 29 ExcelContacts User Manual f you find the format a little too complicated we suggest you edit an example contacts with all the properties you need on your iPhone then export it to get a template excel file Next time you can enter contact information directly without worrying about the column headers validness Figure 3 1 valid column headers Part Part Il Part Ill For Both Mixed Only Separate Only Groupname Phonenumbers Firstname Addresses Lastname Middlename EmailAddresses Prefix Suffix WebsitURLs Nickname InstantMessagelDs FirstnamePhonetic LastnamePhonetic AssociatedDates MiddlenamePhonetic RelatedNames Jobtitle Department SocialProfiles Company Birthday Note Image 3 3 2 Enter contacts information Mobile 1 2 3 eg Mobilet Mobile2 iPhone 1 2 3 HomePhone 1 2 3 WorkPhone 1 2 3 OtherPhone 1 2 3 CustomLabel Phone 1 2 5 HomeFax 1 2 3 WorkFax 1 2 5 OtherFax 1 2 3 WorkStreet 1 2 3 HomesStreet 1 2 5 WorkCity HomecCity WorkState HomeState WorkZIP HomeZIP WorkCountry HomeCountry EmailAddress 1 2 3 WebsiteURL 1 2 3 InstantMessagelD 1 2 3 AssociatedDate 1 2 3 RelatedName 1 2 3 SocialProfile 1 2 3
15. Sign in to Gmail Click Contacts along the side of any Gmail page From the More actions drop down menu select Export Choose whether to export all contacts or only one group Select the Google CSV format Click Export Choose Save to Disk then click OK Select a location to save your file and click OK COND MN 3 0 N20 L2 Step 2 Launch ExcelContacts app Import the CSV file you get in step 1 via USB WIFI Email Dropbox Read more about how to import contacts in chapter 2 2 1 2 2 4 22 ExcelContacts User Manual 2 4 Transfer contacts between iPhone and Outlook 2 4 1 From iPhone to Outlook Step 1 Launch ExcelContacts app In the app s Exporting page set the Property Style to Outlook Then tap the start button Cerei f nntartc jon Mixed d Separate 4 _ Outlook v CEJ Gmail Step 2 Export the contacts on your iPhone via USB WIFI Email Dropbox Read more about how to export contacts in chapter 2 1 1 2 1 4 Step 3 Extract the export zip file and get the contacts xls file Step 4 Import contacts to Outlook from excel 1 Under the File menu select Import and Export 2 In the Import and Export Wizard choose the Import from another program or file option 3 Click the Next button and choose the file type Microsoft Excel 97 2003 and then click Next 4 Now browse and select the contacts xls file you get in step3 5 Hit Next and select and choose the Destination Folder 6 Fi
16. User Manual ExcelContacts Version 2 4 Contacts Samapp net samyuservice 2gmail com 1 2 ExcelContacts User Manual Content EXCELCONTACTS OVERVIEW siaitescassssiscsssadiscaicuesschascuacccdeacuacatescviced duis eaaa ea Tase ea iaaa aa ea e ei asiasana 3 BASICE OPERATIONS sciscsicceacscsrtesacideteceactlavcosnstenececctensussedtacsseatesetdevenswancitsdsaumeucaccalusaasetecuanauerceoasteecsueetoons 4 2 1 EXISONG CONTACTS mU UE 4 2 1 1 Export iPhone contacts and photos to PC via USB cceccecceccneceecnecneceeceeceecsecsecsecseesecseeseeseneeaeeaeeaeeges 4 2 1 2 Export iPhone contacts and photos to PC via Wi Fi cesses enne nennen enean 6 2 1 3 Export iPhone contacts and photos to PC via Email csse eene 8 2 1 4 Export iPhone contacts and photos to PC via DrOPDOX scceccecceecnecnecnecnecsecsecsecseeseeeeeseeseesenseneegees 10 2 2 MPOC OVA US Dr 12 2 2 1 Import iPhone contacts and photos from PC via USB ccceccecceeceecneceecnecneesecseceeceeeseeseeseeseeseeseaeenees 12 2 2 2 Import iPhone contacts and photos from PC via Wi Fi sees nnne nnne 14 2 2 3 Import iPhone contacts and photos from PC via Email cesses 16 2 2 4 Import iPhone contacts and photos from PC via Dropbox cceccecceecnecnecnecneceecseceeeseeseeseeseesenseneenaes 18 2 3 Transfer contacts between iPhone and Gmdil ccccccccccccssssssecccccceseeeeesseececceessaeeessceseesseaaeessess
17. bers or multiple work phone numbers how can label these in column headings The column headings should be mobile1 mobile2 workphone1 workphone2 etc You can also label multiple email addresses in column headings emailaddress1 emailaddress2 Label multiple instant message ids in column headings instantmessageid1 instantmessageid2 Q6 Howto select Separate Mixed Gmail Outlook property style On the app s Exporting page tap the green arrow set the Property Style to Mixed Separate Outlook Gmail Then export your contacts Mixed Separate v Outlook NEW Gmail CI 38 ExcelContacts User Manual Q7 How to assign multiple groups to a contact If you want to assign multiple groups to a contact 3 ways for your choice 1 Add groups in the Groupname cell The format is Groupna me group na me1 gt A lt group name2 gt 1 Groupname Business Friends Workmates 2 Enter Alt Enter to make a line break 2 Add another columns named Groupna me and then enter group name in each cell eg B C i Groupname Groupname Groupname 2 Business Friends Workmates 3 Use a mix of approach1 and approach2 eg B 1 Groupname Groupname Business 2 Friends Workmates 39
18. e to Dropbox 1 Log in to your Dropbox account Select the Apps folder Find an app folder na med ExcelContacts click and open it Click the Upload button select the file you need in your pc and upload it When it s done you can find the file in Dropbox file list E E on 3 Get Started Files Events Sharing Help 2 Dropbox Apps ExcelContacts Upload LO New folder i Show deleted files More V File Name Size Modified XK Parent folder al conctacts 20120305 zip 1 91KB 3 5 2012 2 14 PM Gl conctacts 20120306 zip 3 32KB Yesterday 12 42 PM 2 Dropbox Apps ExcelContacts a Upload Cg New folder 5 Show deleted files More V File Name Size Modified amp Parent folder Gl conctacts 20120305 zip 1 91KB 3 5 2012 2 14 PM amp L conctacts 20120306 zip 3 32KB Yesterday 12 42 PM amp L conctactsTest zip 22 75KB 2 secs ago Sl contacts 20111227 zip 44 95KB 12 27 2011 10 57 AM Gl contactsc 20120104 zip 23 43KB 1 4 2012 7 10 PM 18 ExcelContacts User Manual Step 2 Launch ExcelContacts app and tap start Step 3 Select the More import option button in import screen Step 4 Tap the Dropbox button Step 5 Select the file you want to import on Dropbox website and tap the continue button contacts 20120401 zip Apr 1 2012 17 26 56 contacts 20120403 zip Apr 3 2012 7 21 59 contacts 20120405 zip 2012 13 38 19 A pr 5 contactsc_20120104 zip Jan 4
19. fo File Sharing Apps ExcelContacts Documents x ExcelContacts Sl contacts 20120405 zip Today 11 19 _ yuyy largenote xis 2012 2119 22 42 Ex ExcelContacts c3 ExcelMail B ExcelPhotos ExcelSMS 3 FileApp HoursTracker iMovie _ Add 8 KB 64 KB ExcelContacts User Manual 2 1 2 Step 1 Launch ExcelContacts app and tap the Start button in export screen Export Contacts Jo j et A wa p 9 La erin isl w Property Style Separate pev Export Step 3 Select the Wi Fi export option Export Contacts B x USB WiFi More ees The export file will be transferred from this iPod to your computer over your local WiFi network Export iPhone contacts and photos to PC via Wi Fi Step 2 Wait until the app generates the export file There is a progress bar during the export F Export Contacts Generating 715 3109 AntonelloLacopete Property Style Separate Step 4 You will see an address in export screen enter this address in the browser in your computer Export Contacts Please enter the above address in the browser in your computer ExcelContacts User Manual Step 5 The export page will be displayed in the browser click the only link to download the export file a zip file Qexport cent acts Eaxthen 2 6 12 File View m Toda dels Cie Ox id gt 5 0806 8 9 FS i5 1921681195800 3 3 2 ED
20. m mobile 802 222 2222 DDD Kelvin msn com home page Kelvin warnerbos com HHH Kelvin warner com Berkeley CA 654321 United States FFF 1001E Surrey England 123456 United Kingdom i work 1001 Parker St anniversary November 30 2001 It January 1 2012 Im uus LS EE E work Kelvin amp msn com MSN Me h GGG Kelvin amp yahoo com Yahoo ExcelContacts User Manual Phone numbers D Mobile WorkPhone 802 2222 222 802 1111 111 F G AAAPhone BBBPhone 802 3333 333 802 4444 444 Email Addresses WorkEmailAddress OtherEmailAddress1 Kelvin gmail com Kelvin hotmail com J OtherEmailAddress2 Kelvin msn com Web site URLs WebsiteURL1 WebsiteURL2 Kelvin warnerbos com Kelvin warner com Addresses K L M N 0 WorkStreet WorkCity WorkState WorkZIP WorkCountry Ld 1001 Parker St Berkeley CA 654321 us P a NCC RN OtherStreet OtherCity OtherState OtherZIP OtherCountry F 1001 E Surrey England 123456 gb Instant message IDs Y Z AssociatedDate1 AssociatedDate2 11 30 2001 1 1 2012 Associated dates U V InstantMessagelD1 InstantMessagelD2 MSN Kelvin msn com Yahoo Kelvin yahoo com 27 ExcelContacts User Manual The picture above is an example of export file in Separate format The Separate property style has features as follows Property values are single lines Separate Addresses Phonumbers Emailaddresses
21. nally confirm the action and hit the Finish button Here you can change the destination as well Your Excel sheet contacts will be imported to your destination folder 23 2 4 2 ExcelContacts User Manual From Outlook to iPhone Step 1 Export contacts from Outlook to Excel 1 Click Export to a file and then click Next Click Microsoft Excel 97 2003 and then click Next In the folder list click the Contacts folder and then click Next Browse to the folder where you want to save the contacts as an Excel file xls Type a name for the exported file and then click OK Click Next Click Finish CON DM BW N In Outlook on the File menu click Import and Export Step 2 Launch ExcelContacts app In the app s importing page set the Outlook to Yes Then tap the start button d gt P P 2d CHR p a 7 r Step 3 Import contacts from the excel file you ve got in step 2 via USB WIFI Email Dropbox Read more about how to import contacts in chapter 2 2 1 2 2 4 24 ExcelContacts User Manual 3 FORMAT 3 1 Mixed format work mobile AAA BBB work CCC DDD home page HHH work FFF anniversary work GGG Bob Kelvin 802 111 1111 802 222 2222 802 333 3333 802 444 4444 Kelvin gmail com Kelvin hotmail com Kelvin msn com Kelvin warnerbos com Kelvin warner com 1001 Parker St Berkeley CA 654321 United States 1001 E
22. nd delete files existing in File Sharing Erase iPhone contacts On All contacts in iPhone will be removed first and then contacts in the import file will be added to iPhone Off Don t remove iPhone contacts when import 10 Erase iPhone groups On All groups in iPhone will be removed first and then contacts in the import file will be added to iPhone Off Don t remove iPhone contact groups when import 11 Duplicate comparison Set which property will be used in duplicate detection e Full name e Mobile e Email 12 Merge duplicates On If the contact is existed in iPhone it will be overwritten by the contact in import excel file Off All contacts in import file will be added to iPhone 36 ExcelContacts User Manual 5 FAQ How to access the export file in iTunes Connect your iphone to your computer via the Dock Connector USB cable Launch iTunes and go to the Apps tab for your iPhone Scroll down to the File Sharing section at the bottom of the window From the left column of the File Sharing section select ExcelContacts app From the right column select the export file you want to transfer Click the Save to button Alternatively you can drag the desired document to any Finder location The last step is to wait There will be a several second lag as iTunes prepares to do the transfer Finally iTunes initiates a sync and the selected file is copied to your computer iTunes Select applications
23. orized before the app will skip this step message ExcelContacts The file contacts 20120405 zip ExcelContacts wants access to a folder in has been uploaded to Dropbox successfullv your Dropbox uccessfulh s yaegmail com Change Cancel Allow OK Step 7 Access the export file on Dropbox 1 Log in to your dropbox account 2 Select the Apps folder 3 Find an app folder named ExcelContacts click and open it 4 Fromthe file list on your dropbox select the export file you want and download it contacts 20120405 zip 4 Download o Delete at Rename o Move More 2 34 KB m conctacts 20120306 2p archive 3 6 2012 12 42 PM conctactsTest zip archive 3 7 2012 1 29 PM contacts_20111227 zip archive 12 27 2011 10 57 AM bud contacts 20 20401 2 zip archive 4 1 2012 5 27 PM contacts 20120401 zip archive 4 1 2012 5 26 PM contacts 20120403 zip archive 4 3 2012 7 21 AM 1 4 2012 7 10 PM contactsc 20120104 zip archive contactsTest zip archive 7 2012 3 25 PM 11 ExcelContacts User Manual 2 2 Import Contacts 2 2 1 Import iPhone contacts and photos from PC via USB Step 1 Transfer the import file from your computer to your iPhone in iTunes 1 Connect the iPhone to your computer and go to the File Sharing section in iTunes 2 Click the Add button locate the file you want to transfer and click Choose 3 To delete documents from iTunes File Sharing list select the
24. s ALL of your contacts in a convenient easy format ExcelContacts protects you from iTunes sync accidents which can delete your contacts if for example you no longer have access to an Exchange server Restoring or changing contacts from the spreadsheet is as simple as uploading the file to your phone via USB email or web It couldn t be easier Youcan print a hardcopy of your iPhone contacts You can now export iPhone contacts to an Excel file which can then be imported to Outlook Contacts directly Youcan also import contacts from an Excel file that has been exported from Outlook to your iPhone You can now export iPhone contacts to a csv file Gmail format which can then be imported to Gmail Contacts directly You can upload export files to Dropbox or download import files from Dropbox Youcan password protect your export file All Contact fields except Ringtones can be exported imported You can organize your contacts into groups easily on a spreadsheet and also assign a contact to multiple groups Youcan remove all iPhone contacts or groups before importing your organized contacts ExcelContacts can support 10 000 contact entries ExcelContacts User Manual 2 BASICE OPERATIONS 2 1 Export Contacts 2 1 1 Step 1 Launch ExcelContacts app and tap the Start button in export screen E Export Contacts n NEM ont A Groun r Property Style Separate oy
25. t te UR Re Sram S dEedut 38 Q4 Canthe app export all phone numbers to separate columns mobile workphone homephone etc instead of a combined column phonenumbers cccccssecccessccccsecceececeescceeeseceseeceseusceseeceseuecessueeeeeees 38 Q5 If have multiple mobile numbers or multiple work phone numbers how can I label these in COENE aN E aeusuradema ub deca pda esM cadant CM MM LI ML A ED MM ILE 38 1 ExcelContacts User Manual Q6 Howto select Separate Mixed Gmail Outlook property style eee 38 Q7 How to assign multiple groups to a contact eesssesssssessseeeeeeeene nennen nennen nnns 39 ExcelContacts User Manual 1 EXCELCONTACTS OVERVIEW ExcelContacts is not only the best way to transfer contacts to and from your iPhone without iTunes it s the only way No other app lets you so easily control your iPhone s most valuable data Features Update modify and maintain your contacts easily and conveniently on your computer using Excel Open Office or any other Excel compatible application ExcelContacts sends all of your contacts to you from your iPhone in a convenient zip file by email USB or through a webpage seen only on your local wifi network Contact photos are sent too Never again rely on iTunes as your only local source of back up Nor do you need to share your contacts with Yahoo or Google in order to have a backup ExcelContacts zip file contain
26. to ba nttalled on your Pod or dag to a zpecf home zorsan Dep to resrranpe apchbcuden kon or hore Screens File Sharing Apps ExcelContacts Documents Ex Bie WII ME contacts 201008289 7p Yesterday 7 29 328 kB y1 5u9ng7 zm Today 20 54 332 KB l 3 FleApp A9 How to put the import file to File Sharing folder in iTunes Connect the iPhone to your computer and go to the File Sharing section in iTunes Click the Add button locate the file you want to transfer and click Choose To delete documents from iTunes File Sharing list select the name of the document and hit the Delete key on your computer s keyboard When done you can disconnect the iPhone from the computer 37 ExcelContacts User Manual Q3 Howto generate the import file 1 Make sure all contact information are stored in an excel file named contacts xls Make sure contacts xls is saved as a 97 2003 workbook 2 Make sure all contact photo files are stored in a folder named images The folder images and the file contacts xls must be in the same folder 3 Compress the file contacts xls and the folder images to a zip file Q4 Canthe app export all phone numbers to separate columns mobile workphone homephone etc instead of a combined column phonenumbers Yes the app can You should set the Property Style to Separate in exporting page just click the green arrow icon And then export again Q5 IfI have multiple mobile num
27. ts exporte To Cc Bcc From samyuservice qmail com Subject contacts exported from my iPhone Please find the attached file which was generated by ExcelContacts contacts zip Sent from my iPhone Step 6 Wait until the app display the following message Am E n s n d ib c Sending Email our email has been sent OK ExcelContacts User Manual 2 1 4 Step 1 Launch ExcelContacts app and tap the Start button in export screen Export Contacts As M H Property Style Separate y 4 xport Step 3 Select the More export option Export Contacts aj x The export file will be saved in File Sharing folder you can access it in iTunes s File Sharing pane A Export Export iPhone contacts and photos to PCvia Dropbox Step 2 Wait until the app generates the export file There is a progress bar during the export Export Contacts a x Generating 715 3109 AntonelloLacopete Property Style Separate X x Export Step 4 Tap the Dropbox button Cancel 10 ExcelContacts User Manual Step 5 The app will open a page to ask you to authorize the app access your dropbox You can tap Step 6 After tapping Allow it will return to the app again Wait until the app display the following Allow to continue tap Cancel to exit and tap Change to change dropbox account If you have already auth
28. y Emailaddress image Friend Potter Harry 1234567 890 ABC harypotterf gmas com 1 jpg Make each row a record 3 3 1 Column headers Column headers must be valid property names otherwise the app will beep on error when you import Figure 3 1 is a list of all valid column headers Mixed Just choose the column headers you need from Prat amp Part Il in Figure 3 1 Separate choose the column headers you need from Prat I amp Part III in Figure 3 1 You have to define your own column headers if you want to make custom labels for phone numbers The format is CustomLabel Phone eg CarPhone PrivatePhone If you have multiple mobile numbers the column headers should be Mobile1 Mobile2 etc Similarly column headers for multiple work phone numbers are WorkPhone1 WorkPhone 2 etc Column headers for multiple email addresses are EmailAddress1 EmailAddress2 etc Similarly for multiple website urls are WebsiteURLs1 WebsiteURLs2 etc Tips You can use Mixed column headers and Separate column heads in one excel spreadsheet for importing which means column headers as follows is allowed A B D N O P a B 1 Groupname Firstname Lastname WorkPhone1 WorkPhone2 Mobile ingle li mutiple lines Work Test eee Street 1001 Parker St Friends Work Kelvin gmail com City Berkeley Business CCC Kelvin hotmail com State CA 2 Workmates Bob Kelvin 602 1111 111 802 222 2222 602 3333 333 DDD Kelin msn com ZI
Download Pdf Manuals
Related Search