Making a List of All Posts in a Blogger (i.e., Google Blogspot) Blog

I had a Blogspot blog containing hundreds of posts.  I wanted to add an Archives page that would give me a dynamically generated (i.e., automatically updated) list of posts within that blog.  Unfortunately, Blogspot did not seem to offer anything like the simple archives shortcode available to WordPress bloggers.  Even after some extensive searching, I was unable to find a simple way that actually worked in my case.  A question about this generated no immediate responses.  (Later, it did produce a response, but one that seemed complex at my ability level.)  Instead, while I was screwing around, I managed to wipe out my template, only to discover that it was apparently no longer available for reconstruction.  Fortunately, I had a backup.

At some point, I more or less gave up in disgust.  Then I realized that there might be another way.  Two other ways, actually.  One would be to use my XML backup of the blog to try to create a new copy of it on WordPress, where I could use the archives shortcode.  But that is not the path I chose.  It probably would have been OK if I did delete the Blogger account, except that deleting it would have meant losing whatever links or word-of-mouth advertising I was getting.  Not that it mattered financially; I just liked to see that people were finding my work useful.

I had stopped adding new material to that Blogger post two years earlier, anticipating that Google might eventually drop the ball in the blog hosting area, as it had done in other areas.  Lately, the news seemed to be saying that that time was approaching — that Google was cutting back on numerous projects.  I hoped that at least the blog would remain in place for a while longer.  As long as I didn’t try to change anything, perhaps I wouldn’t need support or features from it.

I wondered, in other words, whether I could make do with a static, manually generated list of posts in the blog.  Granted, a completely manual list of more than 500 posts could take a while to create.  But when I say “manual,” I mean something that would not be automatically generated or updated.  I don’t mean necessarily typing it all out by hand.

So here is the approach I took.  I went into Blogger’s list of my posts.  For the blog in question, within that list, I chose Posts > All.  This gave me a list of posts.  I was able to set that page to display 100 posts at a time.  I highlighted the information related to the individual posts (i.e., not the webpage header or other extraneous material).  I copied and pasted that material (Ctrl-C, Ctrl-V) to a Microsoft Word 2010 file.  I added the next 100 posts, and so forth, until I had copied that material for them all.

I made a copy of the Word document.  I also printed a copy to PDF, to preserve its information about the numbers of page views per post, just in case I was ever curious about that.  Then I deleted unnecessary columns.  This left me with just the column containing the title and tags for each post and the date when it was posted.  To separate out the title and tags in more readable form, I pasted the contents of the Word doc into a blank WordPress blog post in Visual view, switched to viewing it in HTML, copied that HTML code into a Notepad .txt file, and opened that text file in Excel, manually removing all of its guesses as to where data columns might break.  I inserted an Index number column to remember the original order of rows, re-sorted to isolate and eliminate large numbers of unimportant HTML codes, did search-and-replace operations to the same end, and used various Excel functions to produce the desired HTML.  Finally, I posted it into a blank Archives page in Blogger.  The resulting page gave me the desired list.

This entry was posted in Uncategorized and tagged , , , , , , , , , . Bookmark the permalink.

2 Responses to Making a List of All Posts in a Blogger (i.e., Google Blogspot) Blog

  1. karen says:

    WOW…is all I have to say! Looks like Google would have a function for this instead of your tedious method. I was trying to avoid numerous actions like that. But congrats on finding a workaround for blogger!

  2. Gigi says:

    Hello Ray, I was glad to read your post – I’ve had so much trouble over the past several years getting a widget for a list of posts that works consistently beyond about 50 or so posts.

    When the 3rd party widget I’d been using for the past year inexplicably broke recently, I was faced with the same sort of problem that you had. I returned to the blogger widgets today to see if there was anything there that worked, and indeed there is (at least it’s working for my blog). It’s called Recent Posts, and it auto-updates and is listing all the posts in my 50+ post list. I do not know if it will work for your > 100+ posts though.

    I do know it works better than the old version of Recent Posts which I’d tried out a couple of years ago (& didn’t work for my 50+ list of posts). So, the new version of Recent Posts is something you may want to look into in case it works out for you. I wouldn’t delete the MS-Word-based list you’re currently using on your blogger blog though, just in case the new Recent Posts doesn’t work out for your large blog.

    Thanks again for blogging about the post list problem! I definitely feel less alone knowing that someone else has been facing the same sort of problem that I have! So much info is out there for other platforms, but there is comparatively little for Blogger, so, thank you Ray for your work.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s