Well, yes, but adding data into a spreadsheet by hand shouldn’t be dismissed entirely. Wait, aren’t we supposed to be looking at ways to import live data into a spreadsheet automatically? In this post we look at four different ways to get almost any data into a spreadsheet. But what you probably don’t know is that with some simple techniques and plugins, any humble spreadsheet can be transformed into an incredibly powerful, automated, data-gathering machine that can save you or your team hours of manual input.
If you’re reading this you probably know spreadsheets are a useful way to aggregate, tidy and analyse data. Importing live data into a Google Sheet or Excel spreadsheet might seem like a daunting task, but it’s easier than you think…
