4 ms·
"you can export the whole sheet and perform your own analysis or just copy the sheet and use Google Spreadsheet to run formulas and/or generate charts/graphs."
by halfaton 11y ago
"you can export the whole sheet and perform your own analysis or just copy the sheet and use Google Spreadsheet to run formulas and/or generate charts/graphs."
I can't see a way to get the data out of there other than saving as a html page, there are no standard google docs controls available. Am I missing something?
- CroCroCro 11y agoIf you have Excel, you can use Data -> Import from Website
- SloopJon 11y agoIf you remove htmlview from the end of the URL, you'll get the regular view with the option to download from the File menu.
- dror 11y agoActually, that wasn't enough for me. I had to open a different sheet, and replace /htmlview?usp=sharing&sle=true with /edit#gid=XXXXXXXXXX (replaces the XXXXXXX with your number)
- akazn 11y agoYou can use google sheets IMPORTRANGE function to make your own copy. For example: =IMPORTRANGE("1a1Df6dg2Pby1UoNlZU2l0FEykKsQKttu7O6q7iQd2bU", "'Salaries'!A:L")