• X

    How To Export Google Sites To Blogger?

    By in Blogspot

    Bluehost hosting

    Google sites is a web page creation tool provided by Google. It has very limited features, including storage capacity of 100 Mb only (Google Apps users can increase it upto 10 GB). One can use only a fixed set of HTML codes and even custom CSS cannot be made use of in the templates.

    As it has very less options, it is suitable to newbies who would like to dive straight into blogging rather than having to worry about the technicalities involved in other blogging platform or CMS. However, once you make a site on Google sites, it is very difficult to move it to another platform, mainly because, it does not provide the ability to export your articles. There is the possiblity to export articles as XHTML files by using the Google Sites Liberation Tool, but again, XHTML is not a format supported by Blogger or WordPress for importing purposes.

    So what can we do to transfer articles on Google Sites to Blogger? After quite a bit of brain-storming, I came up with a solution : Feeds. Google sites does generate feed, but how can we import those feeds to our blogger blog? The easiest way is to use the secret email address provided by Blogger. Here I’m sharing step by step tutorial, which any one follow to migrate their Google sites to BlogSpot platform.

    Configure Blogger platform:

    Posting using email on blogger How To Export Google Sites To Blogger?

    Go to your blogger dashboard. Navigate to Settings > Mobile and Email.

    On “Posting using email”, enter some texts after the “.”, select “Save emails as draft post” and click on Save settings.

    Whenever an email is sent to this particular email address, it will get saved as a draft on your blogger dashboard.

    Google Sites Feed URL

    A default Google Sites URL looks like this : http://www.sites.google.com/site/example

    The feed URL for that site can be accessed by going to : https://sites.google.com/feeds/content/site/example/

    Configure RSS2Email

    There are lots of realtime RSS to Email web-services available, but most of them are not suitable for our purpose because either they include an ad at the end of the email or they just don’t accept blogger.com emails at all (due to spam, off course).

    So instead, we are going to use a free, open-source tool called RSS2Email. It is available for users of both Windows and Unix OS.

    First of all, download Python 2.X and install it on your computer. Now, download RSS2Email and extract its contents to a folder.

    This tool will use our own email account in order to send RSS feeds to our secret email address. I’m going to use Outlook.com email account for the purpose, but you can use any one you like, just google for the SMTP settings of your preferred mail service provider.

    SMTP Settings How To Export Google Sites To Blogger?

    Open up the config.py.example file with a text editor (eg. Notepad). Put the following information on the respective fields :
    SMTP_SERVER = “smtp.live.com:587″
    AUTHREQUIRED = 1
    SMTP_USER = ‘[email protected]’  (Do not use an alias here.)
    SMTP_PASS = ‘email-password’

    Save the file and rename it as config.py.

    If you are on Windows 7, python scripts cannot be executed directly without making some changes to the system’s PATH variable. So, here’s what you need to do (only if you are on Win 7):

    • Right click on Computer and go to Properties.
    • Select Advanced system Settings.
    • Select Environment Variables under Advanced tab.
    • Now under System variables, select Path and click on Edit.
    • Paste the following texts in the Variable value field (at the start of the field). Do not delete the texts that are already there.

    C:\Python27;C:\Python27\Lib\site-packages\;C:\Python27\Scripts\;

    Change Path Variable on Windows 7 How To Export Google Sites To Blogger?

    • Click on OK.

    Execute the script

    Open up command prompt and navigate to the folder where you had extracted the contents of RSS2Email. Enter the following commands on command prompt :

    r2e.bat new [email protected]
    r2e.bat add Google-sites-feed-url.com

    Unix users will need to run “r2e” instead of “r2e.bat”. You can add multiple Google sites feed URLs by repeating the second command.

    Now, to send all the articles to blogger, enter “r2e.bat run“.

    Executing RSS2Email1 How To Export Google Sites To Blogger?

    There is a limit on how many articles you can send to Blogger in a day, so if you have lots of articles, you can setup Windows Task Scheduler to run “r2e.bat” every once in a while. That’s it. All of your Google Sites posts should be imported and saved as drafts. You might need to go through every article and edit the alignments, HTMLs. Or, you can just make changes on the config.py file to exclude HTML, CSS Styling etc.

    If you stuck at any step, feel free to ask me via comments. If you find this article informative, do consider sharing it on Google plus and Twitter.

    This is a guest post by Subigya Nepal, who blogs at TheLacunaBlog. You can also join ShoutMeLoud AdSense revenue sharing program by participating here.

    Subscribe to Download WordPress Guide Worth $99

    Discover more awesome articles

    Article by

    Subigya has written 1 articles.

    If you like This post, you can follow ShoutMeLoud on Twitter. Subscribe to Blogging tips via RSS or EMAIL to receive instant updates.

    { 6 comments… read them below or add one }

    Robin

    was searching for this one to recommend it to my friend. :) thank you and the steps are clean and detailed to complete the export.

    cheers.

    Robin.

    Reply

    Ayush Jain

    Good tutorial Subigya, you made it really easy to Export Google Sites To Blogger. Hope it do work for me soon . THanks for sharing !!

    Reply

    Lakhyajyoti

    Thanks for sharing the step by step tutorial to transfer a Google sites to blogger. Surely your tutorial will help many people like me.

    Reply

    Steven

    Hello Subigya Nepal

    I should say thanks to you for the great information. I’m searching for this information from the last 1 week i didn’t get the information this much clear in any blog or in any posts…

    Reply

    Aqib Shahzad

    Thanks for sharing the step by step tutorial to transfer a Google sites to blogger.

    Reply

    Gajender

    Could you please make a video on that.
    I’m searching this one from a log time. Because Google Sites does not allow me to edit in the html and my adsense account is not approved. And that’s why I’n not able to show ads on my Google Site.
    I have searched a lot in Google Help but there is nothing and a lot of people seaching for this.
    So could you please make a video on this ……
    Pleaseeeeeeeeeeeeeee
    Thanks in advance

    Reply

    Leave a Comment

    Previous post:

    Next post:

    `