Google sheets losing data when converting to html
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.