Convert Excel To Google Sheets – Here’s How

Thanks for the tips. Now here is the follow up question : links between excel spreadsheet cannot be imported into google sheet. Well we have a problem, then. What is the walk-around to import 7 files that have existing links ? I have seen Zapier could bring part of the solution ?

Hi, the file is in my drive; it is just labeled X (for excel), Not the off-center cross that is on my other google sheets. Please help! I am in a bind!

The trick worked for me really well. Couldn’t have been much easier.

It worked for me in a single go !
I simply uploaded xls file to google sheets as per your instruction and it was done .

Thanks for sharing 🙂
Regards,
Sanjay M

It does’nt work.
Google Sheets (Kalkyl) can’t take the formula i have in Excel.
Does anyone know how it shall be written in Google? Please let me know.
The formula is on Swedish.

=RANG.EKV(AB5;$AB$5:$AB$24;0)+ANTAL.OMF(Villkor;$AB5;$Z$5:$Z$24;”>”&$Z5)

I NEED HELP!
I have an excel document that I made, it uses conditional formatting to color in boxes, it goes from column A to column BP. When I upload it to Google, it cuts my document off at column Z. The conditional formatting works fine in columns A-Z. How do I get the rest to upload correctly??

This is not correct information, only open with Google sheet will not change the format, If you came back after closing the document will be in same format .xlsx.
To change the format you have to click on the file and then click on save as Google sheet so the format will be changed.

This information isn’t entirely correct. Simply opening the excel file as a google sheet will not save the file as a google sheet. If you close the google sheet and return to your google drive folder, it will still appear as an excel file.

To save as a google sheet you need to “open with google sheets” and then once the file is open you need to select “file” then select “save as google sheet”.

I’m trying to convert a .xlsx file to google sheets and get this error: cannot fetch file: 502 Bad Gateway. What is going on?

I tried to convert an excel file to google sheets…all seems to be OK except for one formula – see below:

=LOOKUP(2,1/(E:E””),E:E)

Any thoughts? This is for a checkbook type equation where withdrawels and deposits are giving an update value.

Thanks for all the help so far…

KJ

Oh Fantastic thank you. Finally got it to work after so much trouble. God bless!

Microsoft excel sheets are getting converted to google sheets properly with respect to data. But the images are not getting saved in the Google sheets. What can be a solution for that?
if I try to move one by one image file I am able to, but when I copy-paste all the images I am not able to … As I have 100 images to be pasted is there some better solution???

I have a perfectly working Excel spreadsheet (Excel MAC V15.34). When I upload it to Google sheets all of the cell formula’s work except this one:

=IF($V40,IF($Z4$AA4,IF($Z40,IF(AND($Z4$AA4,$V40),$V4/($AA4+1-$Z4),””),””),$V4),””)

Any ideas?

Big thanks to Brooks Duncan , you’ve save me a lot of time to pin point the solution that I was looking for. Keep up the good work buddy.
God bless you!

There’s a free open source solution for automating copy from excel files (xls and xlsx) to Google Sheets.

Feel free to contribute.

my spreadsheet created with microsoft works has XLR extension now. can not display the XLR file with google sheets.

WARNING FOR Noobs.
Make sure you delete all Excel VBScript/macros from Excel file before you convert that file to Google sheets. The macros remain hidden in Google sheets BUT as soon as anyone downloads Google sheet into local drive and opens it with Excel… well you can expect the worse.

Well, that was a bust. My file uploaded but I can’t view it because it’s too large! Where does it say anything about file size limitations??
My crazy old PC holds the file safely but has decided to have Alzheimer’s so I can’t open it in Excel to reduce the size.
I just got handed a big disappointment.

Hi,

I converted an Excel to Google sheet, but whenever I try to edit it ( even on the copy version), it first freezes and then gives an error. Is there a way to fix that issue? It’s very important to document that I need. I can’t even copy and paste it.

Thanks.

I have a fairly complex workbook with 40 tabs and math and time functions on every sheet with a summary sheet at the end. I have converted this sheet without the time functions and don’t have a problem. Is it possible the workbook has become too complex for google sheets to convert?

on converting excel file to google spreadsheets pivot tables are missing. simply data is displayed in the sheets without any filters. How do I recover my pivot table?

I’m trying to convert an excel document that is uploaded to Drive to Sheets but it tells me the file is too large. It is a simple spreadsheet but it has numerous pages to it with math that adds data from one sheet to the next. Is that type of document doomed? Thanks

Hi guys, I uploaded my excel sheet to google drive, if I preview it, it shows all my graphs correctly, in an excel format, And if I say ” Open With Google Sheet” it converts it, but it doesn’t display the graphs.

Any advise?

I have an excel sheet that someone created for me. It has a formula that uses “traffic lights”. I need it to keep track of students who take State’s tests and students who don’t show up and need to make-up. The problem is that I need to share it with the testing committee so that we all have access and edit. For this reason, we use google sheets. When I go to my drive and upload the excel file from my documents, the document gets converted to google sheets but I do not see the traffic light dots (yellow, green, red). I only see the numbers (1, 2,3) for each color code. Can someone please help me? Is there any way to fix this? I know that one is Microsoft and the other one is google, but I need a way to fix this. I don’t know how to create this formula using google sheets. I don’t know how. Someone helped me to create the excel sheet and that person does not know how to use google spreadsheets. Thank you!!!

How can Automatically Convert Excel To Google Sheets When I save my Excel file from my email to google drive without upload !?
I don’t need to download and upload the file again to google drive to be considered as google sheet file.

You all have been so helpful. thanks a million.

When I try to convert, open or upload an excel file to google sheets, the only option I have is open with is Google Oauth 2.0 Playground. I don’t have an option to open with Google Sheets. I don’t know what Oauth 2.0 is or how I got it. When I read up on it, it seems to be a tool used by developers. How do I get rid of it and get plain old Google Sheets back as an option?

I do not want to use google sheets for lot of reasons (macros, passwords, layout, law enforcement files etc). I therefore want people in my organisation to use Microsoft Excel locally on their computers. My problem is that people often goes on making the transformation unknowingly. The do not know what they do, and suddenly we have two files and people start working in different files.
Is there a way to turn off the possibility to make the transformation from Excel into a Google Sheet?

When I convert my excel sheet to google sheets the axis of my chart is incorrect. In excel the vertical axis is 0-100. When I convert it to google sheets it goes from 60-90. I double clicked on the axis to change the range while in google sheets but it does not work – it overlaps numbers.

Is it possible to copy a row from google sheets and paste into an already created excel worksheet and match everything in that worksheet?

I was trying to automate the process of converting the excel to google sheet using python. While doing a search over the internet I did not find a direct way to do it so I manage do to a workaround. My reports were in ssrs so I used SSIS to schedule a download of the report and used Python to convert the downloaded file into google sheet. I hope it may help someone.

https://devzoe.wordpress.com/2017/05/24/export-xls-to-google-sheet-using-ssis-and-python/

Hi,

I created drop down lists in a column for each cell and those selections have rules with the formula =$L2=”Sold” which will colour the row green when I select the Sold option in the drop down list for any cell in column L.

In Google Sheets when I select the Sold option in the drop down list I created to cells in column L, the rule to colour code highlights the row 12 down. So, if I hit sold in L2, L14 will highlight green. This doesn’t happen in the original. Can anyone help???

Cdata Software has developed The Google Sheets Excel Add-In, which is a powerful tool that allows you to connect with live data from Google Spreadsheets, directly from Microsoft Excel. Use Excel to read, write, and update Google Sheets. Perfect for mass imports / exports / updates, data cleansing & de-duplication, Excel based data analysis, and more!
Here are some of my favorite features:

Easy import of data into Excel
Free for non-commercial use
Easy to save changes back*
Ability to filter and sort, not just a raw import
Establishes a live, refreshable connection, not just a static dump
Modify and delete records
Quickly export and backup data
Operate on data with Charts and Pivot Tables
The robust features of the Excel Add-In are easy to use, thanks to out-of-the-box functionality. You can install the Add-In, configure the connection to your data source, and, thanks to the point-and-click interface, immediately begin working with your data.

While the default options allow you to access and manipulate your data without writing any code, the Add-In is supported in macros/VBA functions. This gives you robust, granular control of your data on top of the generic queries possible through the Excel Add-In user interface.

For more information visit: https://www.cdata.com/drivers/gsheets/excel/

I have used the above method however several charts in my spreadsheets are not converting to google sheets and displaying properly. Several pieces of information especially the axis information is not carrying over.

The directions were perfect and easy to follow, once I understood the following:
-knowing which page was the home page for google docs, and
-figuring out what the “open file picker” icon was. To find it, I hovered over various icons and found it in middle right (not top right) of my google docs home page.

Hi,

I’ve been using Google Sheets for quite some time, and always use the 1st method above with no problem. Suddenly it stopped working, and I get the error “Document cannot be converted”. When I go back to old files that were previously converted fine, they cannot be converted anymore either.

When trying the automatic conversion when uploaded, I get an upload failure.

Ever run into this?

Thanks.

There is another way. You don’t necessarily have to convert Excel to Google Sheets. You can also directly import the data from Excel into Google Sheets.

I described the process in this video tutorial: https://www.youtube.com/watch?v=CgAl9gjBlaQ&feature=youtu.be

Hello,

I already have an excel document on google docs but now I don’t need to share it anymore and would like to retrieve it to excel and work it from there.

I cannot find how to do that? Please help.

Best regards,
S. Birgisdottir