fbpx
Search
Close this search box.

Now Edit Google Spreadsheets using MS Excel

Share

Facebook
Twitter
LinkedIn

Do you like the cool features of Google docs spreadsheets but too comfortable with MS Excel’s UI? Well, the supercool OffiSync add-in is for you. It is developed for Oudi Antebi an former marketing manager at Microsoft.

How OffiSync Google Docs add-in for MS Office works?

Once you finish the installation of the addin you will see a new ribbon in the corresponding applications (word, excel and powerpoint)

OffiSync Toolbar for Excel (Microsoft Office Add-ins)

When you want to open a google doc, just hit the open button, select the document you want to open and bingo, it is available for editing right inside excel.

OffiSync - MS Excel Addin for editing Google Docs - Screenshot

You can even try options like collaboration, sharing from excel.

The limitations of OffiSync:

Google has some very cool functions like GoogleFinance(), ImportHtml(), ImportXml() etc. using which you can build a stock portfolio tracker, Webpage monitors, RSS to Excel converter. But these functions don’t seem to work properly when you open the document in Excel using OffiSync.

Also, when you have the addin installed, Excel takes more time to open as it needs to connect to google everytime you run office.

What do you think about the OffiSync add-in ?

[Hat tip: Digital Inspiration]

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.
5/5

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

letter grades from test scores in Excel

How to convert test scores to letter grades in Excel?

We can use Excel’s LOOKUP function to quickly convert exam or test scores to letter grades like A+ or F. In this article, let me explain the process and necessary formulas. I will also share a technique to calculate letter grades from test scores using percentiles.

8 Responses to “Now Edit Google Spreadsheets using MS Excel”

  1. noone says:

    What about all functions/formulas only available in excel? What happens if you use them in a Google spreadsheet?

  2. Saqib Ali says:

    I successfully installed Offisync couple of days ago after few attempts. The problem was with downloads on amazon, and not related to Offisync.

    After the install, the Offisync Ribbon appeared on my Office 2007. Upon entering my Google credentials, I was able to access all the docs and spreadsheets stored in Google Docs. Very very cool.

    Couple of minor things I noticed:
    1) You can't add "everyone" as collaborator from within Offisync. You have to enter email addresses of each collaborator, one-by-one, which could be painstakingly slow. But seems like this is limitation is due to Google API. See: http://twitter.com/OffiSync/status/1855024033

    2) After the install my "Recent Documents" list from Word and Excel was MIA. This could be a one off thingy. Did anyone else experience this?

    Note: I love MS Office Live [1] because of its seamless integration with Office 2007 Suite. Now Offisync provides same integration with Google Docs. A dream come true.

    1. http://workspace.office.live.com

  3. Chandoo says:

    @Noone... obviously they fail to work on gdocs. I think this add in is one step towards being able to use gdocs on office and still be able to collaborate with others using gdocs alone.

    @Saqib: thanks for sharing your review. I havent tried the office live features yet. May be I should do it sometime...

  4. Saqib Ali says:

    @Chandoo -

    Both Google Apps and Office Live Workspace provide a very capable collaboration platform. Sometimes I find myself struggling to decide to which platform to use for my classwork.

    Office Live Workspace, as expected, provides seamless integration with Microsoft Office, which is critical if you are working with lots of documents and spreadsheets. But with release of Offisync, a 3rd party plugin for MS Office, the same level of seamless integration with MS Office is now available for Google Docs users.

    MS needs to learn about collaborative editing from Google, and Google needs to learn about building user-friendly interfaces and seamless integration with desktop apps from MS

  5. Matt Smedley says:

    Hi Chandoo,
    I just came across this. I've been using Google Cloud Connect add in for MSOffice. It syncs to Google Docs, but not quite as nicely as this. Great find!

  6. Fatiha says:

    I have been trying to fit a regression line in my data using Google spreadsheets, managed to come up with the chart, but some how have failed to insert the regression equation and being able to solve for the coefficients.

    In Excel we have the option of "Add Trendline". Does any body know how it can be done? Will be glad if you helped.

  7. Mazzel says:

    It's no longer available.

Leave a Reply