• Dave Foord
  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,641 other followers

  • Dave Foords Twitter

    • RT @greenfieldscc: after one loan player for our twos tomorrow @landrcl can anyone help? 5 days ago
    • Looking out the window and reminding my self that we are 3 days away from the ‘middle of summer’ 1 week ago
    • On my way to London, to look at potential of Moodle being used by a client to create a mobile friendly gamified sport development activity. 2 months ago
    • Heading up North, where I will be spending at least a week working on a huge Moodle migration project with a client. 3 months ago
    • RT @CharnwoodPE: 🏃🏻‍♂️🏃🏻‍♀️ - The 3 Charnwood medalist’s from the @dretsport Cross Country Cup! Harry Foord 1st 🥇, Colin Foord 2nd 🥈, and E… 3 months ago
  • Advertisements

Automatically pull an entire sheet of data between google spreadsheets

Edit (22/6/2017) – please note that since writing this post, the company importsheet.com has been renamed as sheetgo.com

In November 2011, I wrote a blog post titled ‘How to automatically pull data between different Google Spreadsheets‘ – which was based on a feature called ‘ImportRange’. Although nearly 5 years old, this particular blog post is one of my most frequented and certainly the most commented on post that I have ever written.

I have recently been introduced to a new add on feature called ‘Import Sheet’ – which can be found at https://importsheet.com/ – and this does exactly what it says on the tin. It allows you to easily import (or export) a sheet from one file to another. So for example, I use google sheets to log the work that I do for each of my clients, with each client having a separate workbook (this means that I can share that workbook with them, without them seeing other contracts that I work on). I can then have a master dashboard, which imports copies of these sheets into a single location, and using simple functions such as the = function, I can then pull key data out of each of the sheets into my dashboard. Using Importsheet rather than the ImportRange feature is much easier, quicker and less likely to have problems.

The add on is a commercial tool, that does have a pricing plan, however the free version does what most people will want. Obviously I have no idea how the pricing plan may change in the future – they may choose to get rid, or reduce the functionality of the free version, so I wouldn’t suggest that people invest lots of time creating high stakes activity with this add on (unless they are prepared to pay in the future) – but certainly for the moment, this looks rather neat.

Advertisements