How can I make a link that downloads a Google Sheet in Excel format?


If you want to create a link which enables you to download a Google Sheet as an Excel file you have at least two options. The options below are valid for a sheet within the nhl.nl domain. In order for this to work you have to publish your Google Sheet first using "File, Publish to the Web" within your Google Sheet in a browser. You can decide which parts you want to publish.

 

1) Option 1

https://docs.google.com/a/nhl.nl/spreadsheet/pub?key=0BtnMxE5EWx8vdENtUjJZZkMxYzZUZ1dSMk5kSG9ZNkE&single=true&gid=0&output=xls

2) Option 2 does the same:

https://docs.google.com/spreadsheets/d/0BtnMxE5EWx8vdENtUjJZZkMxYzZUZ1dSMk5kSG9ZNkE/pub?pref=2&single=true&gid=0&output=xls

 

The key 'gid' stands for an identifier selecting a certain sheet/tab within your Google Sheet. You can find this number in the address bar of your browser when the tab/sheet is selected. In the options above the used key is a random one

Labels: Excel, Google, Sheet
Laatst bijgewerkt:
2016-02-16 11:52
Auteur:
Harry van der Pol
Revisie:
1.3
Gemiddelde beoordeling:0 (0 Stemmen)

U kunt commentaar op deze vraag geven

Chuck Norris has counted to infinity. Twice.