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

Reflections on the Apple Watch

Apple Watch

Last fall, after the announcement of the Apple Watch, we did a post with our speculations regarding the product. How the sales would go, the features, so on and so forth, were covered. Let’s be honest: the Galaxy Gear (Samsung) didn’t work out well; and really, who has any of the Android Wear lineup? But our conclusion was this: the Apple Watch isn’t going to be a flop — and that still holds true. However, there are some pros and some cons to this new device.

Apple announced the release of the three Watch models (Sport, Watch, Edition) on April 6th, and opened the store for pre-ordering on April 10th at 3:01 AM Eastern Time. Since then, as reported by the LA Times and USA Today, the Watch is back-ordered four months, putting shipping dates into the summer. Jeff Perkins, VP for PGi, a web conferencing company based in Atlanta, GA, counts himself one of the lucky few who were able to beat the rush by ordering at 7 AM. Despite this, his Watch doesn’t ship until some time in May.

Pros:

The features of the Apple Watch are, well, jaw-droppingly good. Heart rate monitoring, texting, fitness tracking, notifications, telecommunications, just to name a few. The usability of the Watch is also good. The “digital crown” (scroll wheel) is seamlessly integrated into the Watch’s interface. It serves as a home button, a scroll wheel, and more.

Another well-designed feature of the Watch is the display. Besides being a touch screen, it is also pressure sensitive, which allows for a much better level of user interaction with the device. Press firmly on the screen while inside of most apps for access to menus, such as the search and layers dialogue when in Google Maps. You can even send your heart rate to a friend if you like! (Although the usefulness of this feature is beyond me) Despite all the great things about the Watch, there are a few issues.

Cons:

The main problem with the Watch is obvious: the price. We all know that Apple products are expensive, but thankfully, iPhones can be subsidized with the purchase of a contract with the phone; not the case with the Watch. The Sport edition is the only one I would consider buying, at $349 for the 38mm case model and $399 for the 42mm model. Prices continue to go up from there: the Watch model ranges from $549 to $1,099, which is pretty expensive for a watch! But it doesn’t stop there. The Edition model ranges from $10,000 to $17,000; yes, that’s still less than a Breguet Tourbillon Perpetual Calendar, but that’s more than a pre-owned Rolex Men’s President Yellow Gold Fluted Custom Champagne Diamond Dial from Luxury of Watches!

Interestingly enough, this doesn’t seem to be a deterrent for most customers. LA Times reports that, “Pre-orders for Apple’s smartwatch began at 12:01 a.m. PDT Friday…By 12:40 a.m., the Apple Watch Edition — the most high-end of the three models — in rose gold showed a ship date of July. For the yellow-gold version, which ranges in price from $10,000 to $17,000 depending on the strap, it was even longer: August. By 8:30 a.m., the yellow-gold with a red strap and the rose-gold case with a matching strap no longer had an option to buy.”

There is one final con: the compatibility of the Apple Watch. Apple notification emails had a small blurb at the bottom of the message to inform users of some sad news: “Apple Watch requires iPhone 5, 5c, 5s, 6, or 6 Plus and iOS 8.2 or later.” So if you were planning to use this with your iPad mini (whether with cellular or not), sorry. If you have an iPhone 4S, too bad. And if you’ve been resisting the update to iOS 8 but you want the Watch — well, you have a decision to make.


All in all, the Apple Watch doesn’t have the appearances of a flop. The Watch isn’t officially available for purchase until the 24th, but the volume of pre-orders has sent the delivery dates skyrocketing into August. Perhaps we’ll be able to get one to review; keep your fingers crossed!

Until then, be sure to subscribe to Handz Studioz via email so you can be notified about all of our new posts! Please share us with your community, and keep on the lookout for our next post, which will most likely be an in-depth review of the Fitbit Charge HR.

-The Editor

External Links:
http://www.usatoday.com/story/tech/personal/2015/04/09/apple-watch-pre-orders/25522489/
http://www.latimes.com/business/technology/la-fi-tn-apple-watch-20150410-story.html
http://www.apple.com/watch/

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/