This simple method for connecting your excel spreadsheet to a google spreadsheet really works. I made a calendar in a Google spreadsheet and connected it to an Excel spreadsheet. Now I have the bennefits of both worlds. Google Docs for Teamwork and Excel for convenience and power.
Using the method described below, I imported the data to a new page. Then used paste link to connect the data to my spreadsheet. It isn't perfect since I must press Data / refresh all to update the data in Excel.
Thank you Mikltk
PUBLISH YOUR SPREADSHEET ONLINE AND "RIP" IT TO EXCEL.
Step 1: In your Google Docs spreadsheet, click file, then Publish to the Web.
Step 2: Open Excel 2010 (I cannot promise that this works in earlier versions) (v 2007 is ok, Steve)
Step 3: Click the "DATA" Tab on the top
Step 4: There is a "Get External Data" section, click "from web"
Step 5: Return to your spreadsheet in Google Docs, in the Publish to the Web box, start publishing, then look lower in the box, get a website link to your spreadsheet, copy it.
Step 6: Return to Excel and paste the website into the address bar of the dialog box that opened when you clicked get data from the web
Step 7: Click the check box that appears in the upper left of your website (in the Excel Dialog Box)
Step 8: Import and Enjoy!!
Sincerely,
Mikltk
