Convert Excel Spreadsheet to Google Sheets
                     log 
C/ onvert xcel to 
Google
heet: tep--
eptemteer p28,  2G022 uide
6 min read
With over 1 illion end uer, preadheet remain the mot popular unie 
application in the orld. A of 2022, the majorit of preadheet uer till leverage 
Microo 몭  xcel. ut Google heet,  enhancing preadheet collaoration, 
i   increaingl tealing market hare from xcel.
Neverthele, xcel remain dominant in man ector, particularl in legac  
indutrie. A a reult, even team that ork excluivel in Google heet end  
up encountering xcel preadheet.
ut that doen’t mean thee team have to ork out of xcel. Google heet 
can eali
convert xcel 몭 le into Google preadheet. Thi allo them to remain in the
preadheet platform the prefer.
Here’ a tep  tep guide on the et a to convert xcel 몭 le to Google
preadheet.
xcel to Google heet: upported 
File  Tpe
ince 2007, xcel’ default 몭 le format ha een the .xlx 몭 le. efore that, the 
defautl 몭 le format a .xl. Google heet can convert oth .xl and .xlx 몭 le into 
Googel
preadheet.
Quick refreher: a .xl 몭 le tore preadheet data in a ingle inar 몭 le. ut a .xlx 
몭 le i aed on the Open XML format, and tore data a eparate 몭 le and folder  
in a compreed ZIP package.
Google heet can alo convert other preadheet 몭 le created  xcel. Thee 
niculde:
.xlm
.cv
.xlt
.od
.tv
.ta
Ho to Convert xcel File to Google
heet
Google heet o 몭 er everal imple, uilti n a to convert xcel 몭 le to Google
heet. You can upload xcel preadheet to Google Drive, add ne heet ith  
xcel data, automate the converion proce, and more.
Here’ a complete alkthrough on ho to treamline the proce of converting xce l 
몭 le into Google preadheet.
Convert xcel File from Google Drive
You can upload an xcel 몭 le directl to Google Drive, and then convert it into a 
Google
preadheet in a fe tep.
Firt, navigate to our Google Drive homepage. Click Ne  > File Upload.
Then elect the xcel 몭 le that ou ant to upload from our 
device.
Pre Open, and the xcel 몭 le ill upload to Google 
Drive.
Click on the 몭 le to open it in Google 
heet.
Thi ill allo ou to edit the .xlx 몭 le uing the Google heet interface. Hoever,  
if
ou ant to convert the .xlx 몭 le into a Google preadheet, ou mut explicitl  eva
 the 몭 le a uch.
To do thi, click File  > ave a Google heet.
Over 50K pro uilding report ue Coe 몭 cient to 
automate
uine tem data into their Google heet
Learn More
"What an amazing app! Coe 몭 cient make integrating ome of the mo t
 complex etm unelieval imple! et up our integration in 
e l  than a minute."
Yonatan chvimer
And, voila — the xcel 몭 le i  converted into a Google 
preadheet.
Automaticall Convert xcel File into Google preadheet
With the right etting, ou can kip thi lat tep altogether, oou don’t have to  
manuall ave the xcel 몭 le a a Google preadheet. You can actuall 
automatical  convert an upload to Google Drive into Google Doc (in thi cae, 
Google heet).
Here’ ho. Click on the Gear ha 몭  on the Google Drive homepage. Then click
etting.
In the etting menu, navigate to General  > Convert upload and check the ox. 
Thi
ill automaticall convert all of our uploaded 몭 le to Google Doc editor format.
From no on, hen ou upload xcel 몭 le, the ill automaticall convert into 
Googel
preadheet a oon a ou open them.
Convert xcel File From 
Google
You can alo convert xcel 몭 le dirpecrtlea fdrom Ghoeogelet heet. Thi allo ou 
 to
upplement our Google preadheet data ith data from xcel.
Here’ ho to do it. Open a Google preadheet and click File  > Import.
Chooe the xcel 몭 le ou ant to import. You can pick 몭 le ou’ve alread 
uploaded  to Google Drive, or ou can upload a ne 몭 le.
Let’ upload a ne 몭 le. Click on the Upload ta and elect an xcel 몭 le from 
o ur device.
Once the xcel 몭 le i uploaded, ou can chooe ho to import the preadheet ungi 
 the dropd on ox.
Here’ a ummar of each option:
Create ne preadheet – Convert the xcel preadheet into a ne Google
preadheet
Inert ne heet() – Inert the xcel preadheet a a eparate heet in the curent  
Google preadheet
Replace preadheet – ntirel replace the current preadheet ith the xcel
preadheet
Let’ pick Inert ne heet(). Chooe Import Theme to preerve the theme of the
xcel preadheet. No click Import data.
The xcel data i automaticall placed on a eparate heet ithin the 
current
preadheet.
Convert Google heet to xcel
Google heet alo make it ver eato convert Google preadheet to xcel  몭
el .
impl click File  > Donload  > Microo 몭  xcel (.xlx).
Thi ill donload the current Google preadheet a an xcel 몭 le. You can alo  
donload the preadheet in 몭 le format that are compatile ith xcel, uch a  
c.v and .tv.
xcel to Google heet: What are 
the  Limitation?
In mot cae, converting an xcel 몭 le to Google heet i  eamle. The platform  
are relativel interoperale for mot ue cae, and Google heet make  importing 
xcel 몭 le traightforard.
Hoever, in certain cenario, converting an xcel 몭 le to Google heet i not diea,l 
optimal or feaile. Here are ome limitation to atch out for:
preadheet ize – Google heet jut recentl increaed the maximum numer  
of cell per preadheet to 10 million, till ell elo the illion of cell xcel
preadheet can handle. Hence, ou cannot upload xcel 몭 le ith more than 
 10 million cell into Google heet.
VA – Google heet cannot ue Viual aic for Application (VA). VA 
macro  ni
xcel on’t ork in Google preadheet. heet ue Google App cript 
(GA) for
cripting.
Link to orkook – If our xcel 몭 le ha link to other orkook, Google heet  
ill not e ale to retrieve or edit them. heet can onl acce the xcel 몭 le  
ou’ve uploaded.
Advanced data modeling – Google heet cannot implement ome of the advanced 
 data modeling capailitie of xcel, including Poer Quer and Poer Pivot.
No let’ look at the revere — converting Google preadheet into xcel 몭 le. In  
hit  cae, ou’re not jut loing the collaoration of Google heet. xcel alo doe  
not
upport everal function in Google heet, including:
ARRAYFORMU
LA  CONCAT  
CONTINU  
COUNTUNIQU  
DIVID
Q 
FILT
R
GOOGLFINA
NC GT
GT 
IMPORTDAT
A 
IMPORTF
D 
IMPORTHTM
L 
IMPORTRAN
G 
IMPORTXML 
JOIN
QURY
ORT
PARKLIN
PLIT 
TCOo_Tnvert xcel to Google heet: Work 
XT
UfrNoARmY_PRC
NT UNIQU
UPLU
If ou convert a 
Google 
preadheet to 
.xlx, and it 
contain one of 
thee function,
ou’ll likel 
have to rerite 
the formula in 
xcel to avoid 
reakage.
the preadheet Platform You 
GoogleP rheetf emarke it imple to convert xcel 몭 le into Google preadheet. On  
hte 몭 ip ide, heet alo allo ou to eail donload Google preadheet a  
xcel 몭 le.
Although incompatiilit eteen xcel and heet i poile, mot uer ill not 
run into di 몭 cultie during the converion proce. Thi 몭 exiilit allo ou to  
ork in the preadheet platform ou prefer.
And ith Coe 몭 cient, ou can lend realt ime data from our unie etm thi
xcel 몭 le, CV, and and other ource in Google heet. Tr Coe몭c ient for 
free  on to treamline data anali in Google heet.
Wait, there' more!
Connect an tem to Google heet in jut 
econd.
Get tarted Free
50,000+ uer on  
Google 
Marketplace
Truted  thouand 
of companie
©2022 Coe 몭
Integration  cient
alefo
rce Hu
pot
Google 
Analtic  Looker
Taleau
More 
Integration  
Product
Overvie
 Pricin
g
Data ecurit  
Cutomer torie
olv 
Je
it 
Cat
or 
Ao
ut
Compan
 Car
eer
log
Privac 
Polic  Term