Analytics
1.6K members online now
Understand information in your reports and troubleshoot reporting issues such as self-referrals, (not set) data, and inaccurate information
 
Guide Me
star_border
Reply

Google sheets losing data when converting to html

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello everyone, 

 

I am currently using the google analytics add in in google sheets to retrieve data I am interested in, I then get the output into a html file by changing the url and link this to excel using its data connection from web utility. It pulls in most of the data I need but it seems to ignore some instances of text. Does anyone else use this method to get their GA data into excel and have they found out why this happens? The data IS present in the google sheets report but as soon as I turn it into a html table that is when it is lost. 

Re: Google sheets losing data when converting to html

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭
Hi Michael,

The Google Sheet uses formula's and Formats , once you convert to HTML some formulas will not copy as it is not a different format.