Design News

Google Sheets to Excel: The way to Transfer Again & Forth Between Spreadsheets

Google Sheets
How to Use IFTTT With Google Sheets
Andrew Childress

In short: Sheets started as a web app, and it’s clear that the focus here is to make it the leading choice for web-connected spreadsheets.

Reason 2. It’s Easy to Try

Part of measuring ease-of-use is also looking at the “switching cost” for changing spreadsheet apps. How much work and cost would it take to leave Sheets behind and switch back to another app?

As you’ll see in this tutorial, Sheets makes it easy to switch from Google Sheets to Excel (and back). You can upload spreadsheets from other formats like CSV or Excel, and just as easily export Google spreadsheet to Excel in friendly formats.

Reason 3. It’s Got Auto Backup

The best feature for Google Sheets is one you never have to think about! Because Sheets is so closely tied in with Google drive, your documents are going to stay synced and saved while you’re working in them. You don’t have to even press Save to commit your changes to Google Drive.

Version History Menu
You can roll back to an earlier version of a file in Google Sheets by accessing the File > Version History > See Version History menu.

How many times have you lost your progress thanks to a bug, error, or mistake? Thanks to Sheets, you can even roll back to an earlier version as you can see above. Just go to File > Version History > See Version History and choose an earlier saved state to jump back.

Move Back & Forth Between Spreadsheets (Watch & Learn)

At this point, let’s switch gears and dive into some hands-on examples for using Sheets as a part of a spreadsheet workflow. You’ll learn how to import spreadsheets from other apps, make edits in Google Sheets, and export a finished Excel file.

Below, I’ll keep covering more details of how you can mix Sheets in with other spreadsheet apps and use those apps in tandem. Keep reading to find out more.

2. Migrate a Spreadsheet From Excel

While you can create spreadsheets right inside of Google Sheets, you can also upload and convert your Excel spreadsheets.

To do that, simply navigate over to your Google Drive and drag and drop a spreadsheet onto the Google Drive window.

Create a New Document

If you’d like to keep following this tutorial but don’t have an Excel spreadsheet file to work with, no problem. Simply create a new spreadsheet by clicking New > Google Sheet from the Drive home page. Use this blank slate with some of the features I’ll show in the rest of this tutorial.

3. Use Key Google Sheets Features

Now that you’ve imported some of your spreadsheets, let’s talk about features that will help make Sheets a mainstay in your workflow, no matter what you’re using it for.

Feature 1. Easy Formula Writing

Spreadsheet rookies sometimes need a bit of extra help when it comes to writing more complex formulas. Many formulas need multiple options to let the app know exactly how to use the formula.

This is where Google Sheets really shines. Start off by writing a formula with an equals sign. As you start to type the formula, you’ll see an integrated guide to using the formula, right inside of Sheets.

The VLOOKUP function is a great example of this. It’s a tricky formula to use, but the advantage of Sheets is that the instructions and tips live right inside the app as you can see below.

VLOOKUP Example in Google Sheets
As you start to type a formula like VLOOKUP, you’ll see a guide on how to use the syntax in the pop-up window as you can see here.

For a complete and comprehensive list of Sheets functions, check out

Get started with Google’s web-based spreadsheet tool, Google Sheets, with no fear of being locked into the Google ecosystem in this tutorial.

Google Sheets has quickly gained a foothold as a lightweight and easy-to-use spreadsheet app that lives right inside of your web browser.

If you aren’t already using spreadsheets, you might have misconceptions about how you might use them. It’s true that spreadsheets are much-loved by professionals, but I truly believe that they can find a place in creative professional’s pocket.

Think spreadsheets are just for accountants? Guess again! I use a spreadsheet to plan all of my content I contribute for Envato Tuts+.

Sheets can be the perfect tool to see the magic of spreadsheets, especially because it’s so easy to get started with. This tutorial will help you get started with Sheets and move from Google Sheets to Excel (and back).

This tutorial is going to focus on four key ideas:

  1. Why Use Google Sheets? What might lure you away from a more mature spreadsheet app like Excel? Let’s talk about why Sheets is useful to anyone, no matter which spreadsheet app you prefer.
  2. Migrate from Excel. Microsoft’s spreadsheet app might be the most popular spreadsheet format, but it’s far from the only choice. We’ll learn to migrate those Excel spreadsheets over to Google Sheets and keep using them.
  3. Using Key Sheets Features. Tools can’t be the tail that wags the dog. What are the key features that make Sheets worth trying, even for a seasoned spreadsheet user?
  4. Convert Google Sheet to Excel. Don’t get locked into one ecosystem. I’ll show you how to take the spreadsheets you create and modify in Sheets and export it for use back to Microsoft Excel.
How to Quickly Convert Google Sheets to Excel Spreadsheets

1. Why Use Google Sheets?

There’s no shortage of choices for spreadsheet apps, so why does

Continue Reading

20 Free Fonts With Particular Characters (02/2018 Version)

I don’t think anyone would say that there were too few fonts on the web. The opposite is the case; they are a dime a dozen. The problem is that most of them don’t support special characters for various languages. All of the following fonts do just that.

Adam.CG Pro by Shrenik Ganatra

Adam.CG Pro is a sans serif font from the digital quill of the Indian designer Shrenik Ganatra. Since it only provides capital letters, it is not a good choice for paragraphs, but rather for headlines.

License: free to use for personal purposes, a paid commercial license is available
Download: Adam.CG Pro

AXIS Typeface by Jean Wojciechowski

Axis Typeface supports the special characters of several different languages. Just like Adam.CG Pro, the font only provides uppercase letters and is sans-serif as well.

License: no license declared
Download: AXIS Typeface

Mosk Typeface by Iulian Maftei

Mosk is a member of the sans serif family as well and only had lower case letters at first. These were edited to create capital letters. Now, it’s a very consistent, modern, and elegant font.

License: No license declared, but the font is labeled as free
Download: Mosk Typeface

Butler by Fabian De Smet

If you do want a font with serifs, you should take a look at Butler. There are 14 different versions of it, including seven stencil versions. Butler comes with 334 characters in total. The included variety of different glyphs allow for unique typographies.

License: free to use for both personal, and commercial projects, such as commissions
Download: Butler

Jaapokki by Mikko Nuuttila

Jaapokki by Mikko Nuuttila from Finland is one of the unique fonts of this small compilation. Aside from the pretty, but rather conventional version, Jaapokki also provides the two alternatives

Continue Reading

The Prime Running a blog Platforms of the Yr

Deciding to start a blog, whether it be for personal or professional use, is a great idea. With the rise in internet activity, especially on mobile devices, it makes…

The post The Top Blogging Platforms of the Year appeared first on Onextrapixel.

Continue Reading

Completely happy Lunar New Yr! Wag howdy to the Yr of the Canine

Today marks Lunar New Year. Across the world, people are celebrating the end of the year of the Rooster and the start of the Year of the Dog.

Whether you’re enjoying tteokguk with family or handing out red envelopes for good luck, there are many ways to celebrate the holiday. According to Google Trends, Malaysia, Thailand and Vietnam are among the countries searching the most for “red envelopes.” Meanwhile, top searched foods are nian gao, dumplings, pineapple tart, rice cake and peanut cookies.

Since we’re dog people here at Google, we sniffed out a few non-traditional ways to celebrate. Howl you be spending the Lunar New Year?

Try your paw at drawing

In the last year, people have drawn more than 3 million doodles of dogs in Quick, Draw!—a fun game that uses neural networks to try to recognize your drawings. In honor of Lunar New Year, our team snuck in a special version of Quick, Draw! with-related items. Put your doodling skills to the test.

Quick Draw Dog

If you’re more of a data breed, you can check out the pawsome dog doodles from around the world in a special Lunar New Year version of Facets Dive, a tool that visualizes large sets of data (in this case ruff-ly 140,000 dogs that people have drawn in Quick, Draw!).

The dogs of Street View

Lunar Year of the Dog means dogs are everywhere–including on Google Street View! We’ve had a lot of fun finding furry friends all around, from this one strolling through New York’s Central Park to thisDog Face on Google hanging out in a small alley in San Sebastian, to our friend here enjoying the Coastal Walk in Sydney. Scroll through our favorites below, or find dogs on Street View in your

Continue Reading

Google proclaims intent to accumulate Xively

Today, Google has announced that it has entered into an agreement to acquireXively, a division of LogMeIn, Inc.

By 2020, it’s estimated that about 20 billion connected things will come online, and analytics and data storage in the cloud are now the cornerstone of any successful IoT solution. This acquisition, subject to closing conditions, will complement Google Cloud’s effort to provide a fully managed IoT service that easily and securely connects, manages, and ingests data from globally dispersed devices. With the addition of Xively’s robust, enterprise-ready IoT platform, we can accelerate our customers’ timeline from IoT vision to product, as they look to build their connected business.

Through this acquisition,Cloud IoT Core will gain deep IoT technology and engineering expertise, including Xively’s advanced device management, messaging, and dashboard capabilities. Our customers will benefit from Xively’s extensive feature set and flexible device management platform, paired with the security and scale of Google Cloud. With Google Cloud’s deep leadership in data analytics and machine learning, our customers will also be uniquely positioned to build turnkey IoT solutions and focus on business value creation.

We look forward to sharing more details after close—stay tuned!

Continue Reading