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/

Official Handz Studioz Review — The Best Apps of 2014

logos

You’re probably aware that there are a lot of apps out there. But do you know how many there really are? The facts are pretty stunning — Android users have access to 1.3 million apps via Google Play, and Apple users have access to 1.2 million via the App Store (data from July 2014)! That’s a lot of apps, so we thought we’d simplify things for you a bit. As the year draws to a close, Handz Studioz presents you with our list of the best apps of 2014. We’ve broken them down into the top three for each category (such as games, note taking, education, etc). Enjoy! (Please note that this is mainly geared towards Apple users, but most of these apps are available on the other platforms)

We all like to play, but sadly, work comes before play — so let’s get right into Category 1: Productivity.

First place: Pages, by Apple, Inc. It’s essentially Microsoft Word for Apple products, and despite many other word processors, Pages is still the cream of the crop when it comes to word processing.

Pages

Second place: iA Writer, by Information Architects Inc. This app replaces the default iOS 8 keyboard and adds a new row of keys that let you skip lines and individual letters, parenthesize and quote without switching keyboards, and more. All in all a very good application, although perhaps not quite as good a deal — it’s $4.99; Apple users with newer devices can get Pages for free.

iA Writer

Third place: Evernote, by Evernote. This app is great. It syncs with your Mac or PC, keeps checklists, notes, pictures (they have a neat feature that lets you search the text in an image), and can use your calendar to help you plan. As always, Evernote continues to impress, whether on the computer or the tablet.

Evernote

Now that we’ve done some work, let’s play a little in Category 2: Games. This category is a bit tricky since there are so many different genres of games to choose from, but we’ve decided to rank these based on aspects they all share, such as graphics, performance, etc. Plus fun factor — personally we find Trial Xtreme 3 more interesting and fun than Candy Crush Saga, but that’s open to debate I suppose…

First place: Temple Run 2, by Imangi Studios. The second installment in the Temple Run saga, Temple Run 2 is loads of fun — and that’s not all. Good graphics, high frame rates (we videoed gameplay with a slow motion camera [which we reviewed here], and found it to go up to 60 fps), and a nearly spotless performance record round this app out at #1 on our list. Users around the world enjoy these apps — the first version, Temple Run, is the ninth-most-downloaded app on the App Store!

Temole Run 2

Second place: any of the Angry Birds versions, by Rovio Entertainment, Ltd. Angry Birds comes very close to Temple Run 2 for first place. Ultimately the thing that decided it for us was the challenges that Temple Run 2 does, such as the Daily Challenge and the Weekly Challenges. Maybe we’re just goal-oriented or something, but that little bit of “zip” that a challenge provides tipped a nearly level scale. Either way, you’ll want to have both of these on your phone or tablet.

Third place: Deer Hunter 2014, by Glu Games Inc. Third on our list, Deer Hunter 2014 is king of the castle when it comes to graphics. Let’s back up a little and say that Glu Games is king of the castle when it comes to graphics — every game of theirs that we looked at has stunning visuals, and DH 2014 is no exception. Looking at performance, the app can be slightly frustrating. Occasionally there can be a timer error that means your energy (which you need to go hunting) doesn’t replenish itself over time like it is supposed to do. Luckily, this problem is easy to fix — just connect to a network and start the app. DH 2014 also can take a while to load, sometimes up to two or three minutes; it’s usually faster when connected to a network. As for fun factor, it depends on your taste. Our nearly all-male staff finds playing with guns and shooting animals in Africa to be quite enthralling, although this may not appeal to all audiences.

Deer Hunter 2014

Honorable mention: Clash of Clans, by Supercell. There are so many good games out there that we just had to do one more. Clash of Clans isn’t the most engaging game, and that’s one of the reasons it’s on our list — it’s still fun without requiring all of a user’s brain function in order to operate it. Graphics are good and performance is stable. The only problem we have had is server maintenance, which results in temporary inability to play…which brings us to another point: you have to be connected to the internet in order to play Clash of Clans.

Bonus! Hardest game: Geometry Dash, by RobTop Games AB. Download it (or the Lite version). Try it. Fail. Try again. ‘Nuff said.

Let’s move on to Category 3: Document Management. So much of our lives now revolves around our documents — resumes, essays, letters, and or just plain grocery lists all have to be stored and managed. Here are Handz Studioz’ top three picks for document management from 2014.

First place: Documents, by Readdle. This app handles everything — it’s pretty incredible! If you can name it, Documents can handle it. .pdf’s, .zip’s, pictures, audio, .doc’s — they all work with this app — you should definitely get this app going into 2015.

Documents

Second place: Google Drive, by Google, Inc. We’re talking about Google Drive here, folks. What can you expect other than seamless integration and performance? The app doesn’t dissappoint — it’s every bit as functional and useful as the online drive — we highly recommend it.

Google Drive

Third place: iBooks, by Apple, Inc. iBooks isn’t particularly impressive as document managers go, but it’s still our favorite for managing .pdf’s. The sleek new look introduced in iOS 7 and the bug fixes in iOS 8 make handling .pdf’s a pleasure in iBooks — it now comes standard when upgrading to iOS 8, so if you haven’t upgraded yet, it’s something to consider. We reviewed iOS 8 in two installments this summer. Check out the first one here.

iBooks

We’ve arrived at our last category. With all the new camera abilities on recent Apple products, we feel that we should mention Category 4: Photo Editing.

First place: Autodesk Pixlr, by Autodesk Inc. This app is pretty nice, especially for the price ($free). While it’s certainly not Photoshop or Gimp, it gets the job done quite nicely on your devices. The UI is simple to use and powerful, with a wide range of effects, overlays, text, collages, and more. We highly recommend this to just about anyone, and it certainly suffices for the needs of the average consumer.

Autodesk Pixlr

Second place: Sketchbook Pro, by Autodesk Inc. This app might not be on the App Store anymore, unless it has been replaced with another name. Regardless, it’s pretty powerful, and we highly recommend it. Why is it second place? The UI is not helpful at all…there are no labels with the buttons, so you kind of have to guess at what they do until you learn them all. Other than that, it’s great.

There is no third place for this category. If you have a suggestion, please comment below. One app that we have not looked at is Apple’s App of the Year, Pixelmator. It’s a highly rated photo editor that we may look into eventually. If anyone has looked at this in depth and has any feedback on it, please let us know in the comments.

That concludes Handz Studioz’ Best Apps of 2014 Review! We hope you enjoyed this post; please share Handz Studioz with others in your community (online or physical). Disagree with any of our choices? Let us know in the comments!

Thanks for visiting Handz Studioz! If you find our content interesting, consider following us and we’ll let you know via email every time we release a new post!

-The Editor

What Is Alexa and Why Does It Matter?

Have you ever visited a website and wondered, “How popular is this site compared to others in the world?” Or perhaps, “What’s the most popular website in the world?” Alexa.com has the answer for you.

Alexa Logo (from Alexa.com)

Image from Alexa.com

Alexa is an Amazon.com company that tracks visitors to websites, and then ranks those sites based on the number of views that it gets. Not surprisingly, Google is #1, Facebook #2, and YouTube #3. The way Alexa works via a toolbar/plugin that users can install to their browser; Alexa looks to see, for instance, ‘OK. How many toolbars (equivalent to visitors) visit example.com? How many views does example.com get?’ Alexa is regarded pretty much as the gold standard in basic web analytics, along with Google Analytics.

Now, let’s look at the second part of the question: why does Alexa matter anyway? Well, let’s give an example. Let’s say that here at Handz Studioz we wanted to review a new camera. We would contact the manufacturer and say, “We have a tech website, and we’d like to review _________ product. What can you offer?” Now we wouldn’t be that blunt, of course, but that’s the general idea. The company would receive our request and most likely visit the site; they would want to know whether it’s worth giving a discounted product out in exchange for a review. Thus, they would use an analytics engine (either Alexa or Google Analytics, most likely both) to see how popular a particular site is. Then they would decide either to say, “Sure, here’s our offer,” or “Sorry, but we can’t help you.”

You can see how important Alexa is; if you have a good ranking, you’re much more likely to get better opportunities than if you don’t. Established sites with high rankings, such as Engadget.com, would be much more likely to receive a free iPhone 6 than a new tech website that someone just recently created. That’s not the only reason Alexa is important, however. Ranking on Alexa is a pretty big deal. You may have noticed that Ford says in all of its commercials, “…Best selling pickup in America for ______ number of years…” In the same way, one (Google) could say, “We have the #1 website in the whole world!”

Here’s where we could use your help. Handz Studioz’ current rank according to Alexa is 16,900,046; we do receive a fairly high amount of traffic, but unfortunately not many viewers have the Alexa toolbar installed, thus, a fairly low Alexa rank. If you enjoy Handz Studioz, please visit the Alexa.com toolbar download page and install it for your browser. As you visit Handz Studioz, Alexa will get more data for more accurate ranking.

This won’t just help Handz Studioz, but all websites you visit. If you visit Amazon.com to order something, then Alexa gets a little more data about the number of visits to Amazon.com (which provides a more accurate rank). If you visit Weather.com, then Alexa gets a little more data about the number of visits to Weather.com; it progresses from there. So, here’s a chance to help Handz Studioz, and at the same time, help all sites on the internet!

If you enjoyed this post or found it interesting, please like and follow! Please share it with others in your community, whether physical, or online. Be sure to install the Alexa toolbar; doing so will help the whole internet with more accurate data. Plus, as you visit Handz Studioz, we get a better ranking as the traffic monitoring becomes more accurate!

-The Editor