Google Drive 2014; Import an Excel spreadsheet

I wrote about this in 2013.  Since then, Google Drive has changed its look, and possibly also adjusted how it works.  It’s still better to get your data into a Google Spreadsheet than to upload an Excel file.  The reason is that only computers and devices that have Excel installed can work with an Excel file.  But any computer or device with a browser can work with a Google spreadsheet.

We’ll start with an existing Excel spreadsheet that we’ve saved as a file; we won’t be using Excel during this process.

Send your web browser to Google’s My Drive.  In the left sidebar, click New.  A floating menu appears.  Click Google Sheets.

70 new sheet A new, empty Google spreadsheet appears.  In the spreadsheet’s menu (not the browser), click the File menu and select Import.

75 importThe Import File page appears.  There are several ways to get a file to import.  Check Upload in the top menu.

80 uploadThe Import File page appears.  Open your computer’s file manager in another window.  (OSX; Finder.  Windows; WinExplorer.)  Navigate to the file, click and hold it, and drag it into the browser’s “Import File” window.

85 dragThere are several possible destinations for the file you’re importing.  I chose “Replace spreadsheet” because I had already opened an empty spreadsheet.  Click Import.

90 replaceFor me, the resulting spreadsheet held the Excel data but was still named “Untitled Spreadsheet.”  I changed its title.  Later I noticed that I had two copies of the spreadsheet in Google; the one I uploaded early in this process (bad) and the one I created, replaced data in and renamed (good).  The problem with the bad one is that, if I open it, I see a screenprint-like image of a spreadsheet, not a grid-and-text image that I can change.  That’s an Excel spreadsheet, and Google can’t work with that kind of file.

95 duplicate

Advertisements

3 thoughts on “Google Drive 2014; Import an Excel spreadsheet

  1. Vicki

    Awesome – thanks heaps this helped my to no end. Knew there had to be an easy way to get there! Worked perfect.

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s