Windows 10, Excel 2016 Google Timeline download fail

[aduguid]

trafficstars

Set xmlHttp= New MSXML2.XMLHTTP60 ' works on Windows 7, Excel 2016
'Set xmlHttp= CreateObject("Microsoft.XMLHTTP") ' works on Windows 7, Excel 2016
'Set xmlHttp= CreateObject("MSXML2.XMLHTTP")
'Set xmlHttp= CreateObject("MSXML2.XMLHTTP.6.0")
'Set xmlHttp= CreateObject("MSXML2.serverXMLHTTP")

[aduguid]

Do research for possible answer, if not resolved then create a question on stack overflow.

[actionjakson]

Hi Anthony

1. I by accidentally deleted my google maps timeline history. Before the timeline was deleted from Google I downloaded it as a JSON file from google. Is there a way I can import this file back into the google timeline?

2. I would like to out the google timeline info into an excel spreadsheet so I can figure out the hours I was somewhere much like this app does

https://chrome.google.com/webstore/detail/mileage-timeline-spreadsh/kgmdpfoaldphfmbpnlpkelfbbegnaifc?authuser=0

. But since I may not have the timeline anymore is it possible to do form the JSON file?

How much would the above cost if you can provide the services?

Thank you mark

On Wed, Mar 20, 2019 at 8:39 PM Anthony [email protected] wrote:

From the spreadsheet or from Google?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/Excel-projects/Excel-Timesheet/issues/2#issuecomment-475079967, or mute the thread https://github.com/notifications/unsubscribe-auth/AufnOwuWkjVWFFuU-vgmfseQf8ryk7HTks5vYtTegaJpZM4WYv2F .

--

Thank you, Mark

[aduguid]

At this time, Google does not have a feature to allow importing into your timeline. However, I may be able to generate the same type of Excel table for your JSON file. I'll download mine and give it a try. https://support.google.com/maps/answer/6258979?vid=0-2167895081-1476304453401&co=GENIE.Platform%3DAndroid&oco=1

[aduguid]

I found another project I can base this off of. https://github.com/omegastripes/VBA-JSON-parser