{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 Ridiculous、 的问题《How to export Firebase analytics data》','https://www.manongdao.com/q-220030.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I'm trying to figure out if it's possible to export all the Firebase Analytics data to an excel spreadsheet, similar to how you can do it with Google Analytics. From what I can find the only way to go about doing it is to link with BigQuery then do some SQL statements to build a table and export.
Unfortunately for us this is not going to work (due to client budget and capabilities). Is there any other way to export this data that I'm missing?
You could easily select and copy UI blocks on the Analytics web page in Firebase, and then just paste the copied data into an Excel sheet. You'll see fancy tables.
There is a YouTube video that explains and demonstrates the procedure here:
Copy Your Analytics Data to a Spreadsheet with this One WEIRD Trick! - Firecasts
Update: You can now export the analytics reports as CSV from the Firebase console by clicking the Download CSV option from the ⠇ overflow menu.
In the meantime, you really should give BigQuery another look. The pricing is very reasonable and there is a free query tier of 1 TB/mo.
Steve Ganem
Product Manager, Firebase Analytics