Groups | Search | Server Info | Login | Register

Groups > comp.apps.spreadsheets > #13

Re: Help needed with exporting data from Google Spreadsheets to Excel via dynamic link

Show all headers | View raw

On Thursday, April 19, 2012 10:59:27 AM UTC-7, Phil wrote:
> Hello Everyone. 
> 
> Here is my scenario. 
> 
> I have a google docs spreadsheet that is changed regularly - every two days or so. I want to automatically export that data into excel - note here, automatically! 
> 
> I want my client to be able to open an Excel file and see updated data from my google spreadsheet. I am able to manually push the data to her via spreadsheets, but I want it to happen automatically. 
> 
> I know that I can export a file (HTML, CSV, EXCEL, TXT) but that is not automatic. 
> 
> I know also, that I can publish to the web, and get a link to the published data. I have made sure to make that public data and everyone can access it. 
> 
> PROBLEM: When I try to open the URL (txt or csv) that Google Spreadsheets gives me in Excel 2011 (File, Open URL) 
> https://docs.google.com/spreadsheet/pub?key=0Aqr4T7rLB9FMdDZ2S1daa3RIeFNMdWVKck9FNWF6YVE&single=true&gid=0&output=csv
> 
> I get the following message: This site cannot be accessed. And Microsoft Excel cannot access the file "Filename"
> Path does not exist
> its being used by another program
> name of the workbook is the same as another already open. 
> 
> This is not the case in any of the examples. 
> 
> Can anyone help with this solution or any other solution that will allow me to automatically update data from google spreadsheets into Excel.

Found the answer - I am using Excel 2011 for Mac - which does not allow you to do this. Crazy pointless laziness from Redmond. 

Back to comp.apps.spreadsheets | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Help needed with exporting data from Google Spreadsheets to Excel via dynamic link Phil <phil@groklabs.com> - 2012-04-19 10:59 -0700
  Re: Help needed with exporting data from Google Spreadsheets to Excel via dynamic link phil@groklabs.com - 2012-04-19 11:41 -0700
    Re: Help needed with exporting data from Google Spreadsheets to Excel via dynamic link Peter Grummett <peter.grummett@regather.net> - 2012-05-27 00:34 -0700

csiph-web