Instant Blog Post Index in a Google Sheets Spreadsheet

Did you ever wish you could easily have a list of blog post titles with links in a spreadsheet so you could easily see them all in one place, or maybe add some data related to each? What data, you ask? Maybe promotion text for tweets or counts of promotion posts, or just tracking categories or other data that might help you manage your content…

I have… So I did ;)

I created a quick spreadsheet that make it easy using Google Sheets and the simple function that imports the blog RSS feed with one simple formula.

The spreadsheet - which you can see here and get your own copy (use the File / Make a Copy menu) …

… has a simple formula that you don’t even have to change yourself - you can just enter the new blog RSS feed URL on the sheet and the formula will use that!

The IMPORTFEED() function does have a limit of grabbing just 250 posts - but it’s still pretty powerful! Some feeds it seems actually limit to 100 posts - but you can experiment to see how it goes.

I tried it with one of my favorite blogs - JMoney’s BudgetsAreSexy.com blog - which gives you a quick way to check out the titles of all his recent posts - and even a quick way to link to all those posts!