How To Convert iCloud (iPhone, iOS, etc) Contacts to Google Sheets/Excel

Hey everyone! It’s been a while, I know. Life has been busy lately and I’ve been slammed with a lot of things to do, and unfortunately Handz Studioz has needed to become a back burner project. That said, I have some useful information for you all today, and this was just so good that I couldn’t keep it to myself.

Here’s a bit of back story: about a month and a half ago, my laptop (which I use for everything: photo/video, writing, school…the whole nine yards) died. We’re talking six feet under, bit the dust type of dead. Due to some issues (which I won’t get into) with the company which I purchased my new laptop from, I was without a PC for a total of about four weeks. Thus, I managed everything from my iPhone, which was very difficult, to say the least.

One of the main issues that I ran into when setting up my new PC was integrating my contacts, for two primary reasons:

  1. My old laptop is quite dead. It doesn’t like to boot :( That makes importing contacts from the old laptop fairly difficult, and I didn’t want to take apart the machine to get a separate HDD reader.
  2. I also gained new contacts in the month that I was without a computer. I attended multiple conferences during that time, and met some great people. So at this point, I’ve got old contacts on my old laptop, as well as new contacts on my phone that aren’t on the old laptop.

The saving grace of the whole issue was that all the contacts that were on my laptop were also stored on my phone and in iCloud, so I had access to all my contacts on my phone. Thus, I needed to transfer my contacts from iCloud onto my new PC. The best way to perform this operation was, in my mind, to convert those contacts into a spreadsheet. So how do we do this? I’m glad you asked. (Please note that, in order to maintain my contacts’ privacy, I have redacted portions of the following screenshots.)

Start by accessing your contacts in iCloud. Go to http://icloud.com/ and click on “Contacts”, or use this direct link: http://icloud.com/#contacts/ You may be prompted to log in if you haven’t visited the site recently. You can see the full size images by clicking on these thumbnails.
iCloud Contacts

Next, click on the Settings toggle in the bottom left corner, and click Select All.
Select All Contacts

Once all your contacts are selected, click Export vCard.
Export vCard File

This will create a .vcf document containing all your contacts; this is commonly referred to as a contact card. Think of .vcf like a compressed text document. Just save this file to your desktop.
Save VCF File

At this point, you’ve downloaded a .vcf file, AKA contact card, which is very useful in its own right. This .vcf file can be imported into your Windows Contacts natively on your PC, so that you’ll have them for use in your address book. This is a pretty straightforward process: just open the .vcf file and follow the prompts. However, I wanted to put all my contacts into a spreadsheet, and that’s what this tutorial is all about, so we aren’t quite done yet. vCard files cannot be read by Excel/Google Sheets, so we need to convert the file into a readable format. That format is .csv, or Comma Separated Values. We’ll use an online converter for this; a quick Google search will yield a wide selection of results, but this converter is the one I prefer to use: http://labs.brotherli.ch/vcfconvert/

It’s imperative that you input the correct settings before converting, so pay close attention here. Click “Choose File”, and once you’ve uploaded the .vcf file, set Format to “CSV”, change the dropdown menu beside Format to “Comma”, and make sure the “Add Header Line” box is ticked. Set Encoding to “Unicode (UTF-8)”, and leave Filter and Modifications alone. See the screenshot below for reference.
Convert VCF to CSV

Download the resulting .csv file to your PC. This file can be opened directly in Microsoft Excel, edited, and saved as a .xlxs spreadsheet file. In order to open this in Google Sheets, follow these instructions: upload the file to your Google Drive, and then open the file. A preview window will open, and you’ll be able to see all your contacts in the .csv file, formatted as a spreadsheet. However, this is not a Google Sheets file, and you can’t edit it. To remedy this, click on “Open with Google Sheets” at the top of the screen.
CSV File In Google Drive

This will open a new tab in your browser, with all your contacts in a Google Sheets document. You can edit this, export it, or do pretty much anything you like with it. Sometimes it’s helpful to be able to see all your contacts on a page, and that’s exactly what this allows you to do.
Contacts In Google Sheets File

If you found this tutorial helpful, let us know by dropping a comment down below! Please be sure to share this with your contacts (see what I did there :) ) who might find it helpful too. Thanks for reading! We look forward to hearing from you. If you so desire, you can sign up for email notifications every time we write a new post. Your contact info (see what I did there…again :) ) will not be published.

– The Editor

New YouTube Video — Sony Vegas Tutorial – How to Mask in Movie Studio!

Here’s our latest video on our YouTube channel! In this tutorial we show you how to achieve masking if you don’t have Sony Vegas Pro or Adobe After Effects and are stuck using Sony Vegas Movie Studio.

Be sure to both subscribe to our YouTube channel and to subscribe to the website so you’ll be notified every time we release a new video or post! Also be sure to check us out on Google+!

GIMP download: http://www.gimp.org/downloads/

Windows Releases Information About Its Newest OS — Windows 10

Yes. They skipped a number, we know. Hopefully this is an indication of where Microsoft is going with Windows.

With Windows 10, Microsoft did a combination of Windows 7 and Windows 8. You still have the tiles and apps of Windows 8, but the start menu is back! Joe Belfiore of Microsoft said the company wanted to bring back the familiarity of Windows 7 and the functionality of Windows 8. Maybe so, but personally I find 7 a lot more functional than 8; navigation is much easier. Whereas 8 was more of a tablet OS, Microsoft has moved back towards a computer-geared OS model for Windows 10.

Check out this video from Microsoft that shows the new OS in action!


This video shows seamless integration between Windows 10 as a tablet and a PC operating system. In PC mode, the start menu opens the “Windows 7 Start Menu” with the familiar quick launch icons, and the applications over to the side. Switch to tablet mode, and you get the Windows 8 tiles OS. Now you don’t have to use your laptop as a tablet. That was one of my biggest frustrations with the tile system of 8. Thank you Microsoft!

Windows 10 features a new “task view” that is reminiscent of the Mac taskbar, and resizing windows that automatically fill the screen or change layout to match the window size. Users will get keyboard shortcuts that were missing in Windows 8 back, and although that might not be the most groundbreaking news, ctrl+c and other shortcuts can be the most powerful functions on a machine.

Is Microsoft feeling guilty about 8, so they skipped straight to double digits with 10? Perhaps. Microsoft only revealed a few thing about Windows 10, but we will keep you up to date as Microsoft releases more information. You can’t get 10 yet for about a year, unfortunately; Windows 10 is due to release in late 2015.

If you enjoyed this post, please like and follow! Please share this post with others in your community (online or physical) you think would enjoy it!

-The Editor