Skip to main content

Featured Post

Changing Digit Grouping (Comma Style) in MS Excel - Million to Lakh

Well this is a very common problem for our sub-continent i.e. Bangladesh, India, Pakistan, Nepal, Maldives, Sri Lanka. Cause our digit grouping system doesn't match with the international system. To be more specific - they use million, billion etc. But we use - lakh (also lac), crore etc. 
Users of the mentioned regions often face problem with the comma separator position in MS Excel. Cause the default system is international. It doesn't suit our digit grouping system. 
International System - Separates every three digits 1,000.0010,000.00100,000.001,000,000.001,000,000,000.00
Subcontinental System - Separates every two digits after the 1st three digits
1,000.0010,000.00 1,00,000.001,00,00,000.001,00,00,00,000.00 
If you're familiar with the Indian Subcontinent system and if you're bound to use this system then it will be a big trouble if you don't know the solution. Well nothing to worry about as you are going through this article. Cause from the very next moment you'…

AdSense Friendly Custom Robots.txt for Blogger

Custom Robots.txt for Blogger

Bloggers who have SEO Knowledge, should know about robots.txt and its use. But it is quite unfamiliar to the new bloggers. But some of them might be interested in Blogger's search preferences and they must ask about what is Custom robots.txt? Well this is not so easy to explain. To the new bloggers, the explanation might be confusing. In order to explain the term robots.txt, I've to tell about search bots or search crawlers. But I will try to explain the term clearly. 

Suppose, you've opened a blog in blogger. continuously you're publishing new posts. If everything is okay, your post will appear in Google Search within few hours. If your post is matched with someone's search topic, your site will appear in the search results. How it's possible? 

Blogger's Default robots.txt:

Search engines scan your site for new posts continuously. This is known as crawling. Search bots crawl your site regularly and index your posts in their directory. By default, blogger comes with a robots.txt for your site that helps search engines crawl your site.

But as we know, the default or general settings never guarantee the accurate result. So we need to customize the settings as our requirement. Same rule is applicable for blogger's robots.txt.

Custom Robots.txt for Blogger Blog:

Today you will learn how to customize the robots.txt of blogger. There is a rumor that the default robots.txt can't index the old posts properly. If you have a proper custom robots.txt, your posts will be indexed properly. In my last post, I discussed about creating XML sitemap for blogger blog. There I gave example of XML sitemap. You can use that sitemap as your custom robots.txt content.

Custom Robots.txt Settings for Blogger

Look at the above image. This is how you can customize your robots.txt element. Or use the instruction below:

Sign in to Blogger Dashboard > Settings > Search Preferences > Crawler and Indexing > Custom robots.txt > Enable? > Yes > Now add the code below > Save Changes.

# Blogger Sitemap generated on 2013.11.06
User-agent: *
Disallow: /search
Allow: /

Here you just need to change the site URL. Replace the word munnamark with yours. And for sure, this will help search engines for better crawling of your site.

AdSense Friendly Custom Robots.txt for Blogger:

This custom robots.txt might be less useful for AdSense enabled blog. If you use this type of custom robots.txt in your blog, AdSense will not be able to show relevant ads on your site. Consequently your ads impression you will affected seriously. And ultimately, your revenue will fall.

But a little change in that could save you all the day. If your site is AdSense enabled, then use the following code:

User-agent: Mediapartners-Google
# Blogger Sitemap generated on 2013.11.04
User-agent: *
Disallow: /search
Allow: /
Sitemap: http://

Look, only the blue part has been added with the previous code. If you're working with AdSense then consider using this code as your robots.txt element. Actually the blue part is used by Google AdSense only. 

If you use this code (User-agent: Mediapartners-Google Disallow:), AdSense will be able to crawl your posts properly. Then it will show relevant ads on your site. And the other part of the code will be used by the search engines for indexing your contents. 

Stay with Marks PC Solution to get more interesting IT topics!


  1. Rahaman sir I am Bis followers of your blog. Sir I am suffering from 55 Duplicate meta description problem in my blog Sir I am using free downloaded template in my blog. Sir if you have any effective solution please help me. Sir my humble request please help me.

    1. :)
      I will never visit your site if you don't change your template - I promise. Cause I use only 1 GB monthly pack.

    2. sir i have change my blog template, please now tell me how to fix duplicate meta description.

    3. Actually you didn't get me. You were supposed to make your site faster. Use a simple template. Or simply use one of the default blogger templates.

      By the way - where do you get that you have duplicate meta? Have you changed your template manually? Maybe your current template has some problems. Use simple blogger template.

      Forget about styles, social gadgets. Visitors hate these. People hardly like or plus one your site. So remove them if possible. Speed is necessary.

    4. Sir now I am using Simple Template of blogger. I get duplicate meta description in webmaster tool.

  2. thank you very helpful information from me to increase adsense earnings on this blog. belajarkreatif [dot] net

  3. I've used your given code in my blog but what about the :generated on 2013.11.04?? in code.Is it important to edit the date?

    1. Maybe not. But you can use recent date if you wish.
      You can use 2014.01.06 . . .

  4. For Anurag My answer is Jani means Lovable as we Speak in India

    My question about Custom Robots arise when I was using Blogspot domain I was Getting around 30000 daily views and I moved to so now my traffic was good for some days but a sudden fall took place and it got reduced to 5000 daily. So any Solution you may be having

    1. and also how to use Custom Robot I mean changing the sitemap date will work or not. a

    2. Just replace the URL in sitemap. Maybe date is not much inportant. But you can use the current date.

      And to reduce the fall in pageviews, you have to add the new domain in Google Webmaster. And only then you can change your address. I mean .blogspot to .com.

    3. It is already added automatically. You are using the same that you mentioned here..?? then I am applying them.
      Can I get your template.. I know its simlpe template from blogger but as you said before being simple is good so I want this. Rate mine template my site -

    4. :)
      You know this is simple template. But why do you want this one? I've manually edited it. And everywhere you will get my site's link. You have to change them again.

      Better you can choose the simple template (your site is too heavy). Then I can help you to customize it. Even I've tips to customize the simple template as you want. You can chat me: munnamark at Google Talk or Gmail.

  5. This comment has been removed by a blog administrator.

    1. How old your site is? It may take some times to be indexed in Google. And I've checked your site. There is no content.

      Try to write something. Trying to index in the search engines without writing is not a good idea at all !!!

  6. JazakAllah Brother...
    you are doing eternal blessed work..... just about learning..... very useful.... and I also get some out of above..... Stay Blessed!

  7. Hello sir, can you please tell me how can i get my blog posts in google search some of my stuffs are unique some are indexed by google and some are not my blog link is

    1. Keep Writing. Some words are highly competitive. In those keywords your site will perform poor in search resutls.

      But as soon as you rank higher, your posts will start appearing in Goolge.

  8. Asalam alaekum,

    i got 86euro since 5month ago and everything stopped after then, i hardly see 2cent per day now.
    i serious need help! my blog is
    let me highlight my problem more, so that You could help to the last.
    1st : i need to know how get the Right Keyword to that blog.
    2nd : i need to change it to
    3rd : i need to know how to get Pure traffic to my blog.

    Abdul Akeem

    1. Contact me via Google Talk.


Post a Comment

Popular Posts

GTA San Andreas Cheat Code (PDF)

After Vice City, San Andreas is the most popular game released by Grand Theft Auto (GTA). Usually GTA releases role playing game. San Andreas is such a game where you can act like a person. You can do everything. You have to take part in missions and complete them. 
To make your missions easier, there are lots of cheat codes. If you can properly apply these codes, the tough parts of the game will be easier. Cheat codes are somewhat like keyboard shortcuts of computer programs. 

I've shared 63 cheat codes below. There were more cheat codes in my collection, but I've omitted the less important cheats. Effects or result of the cheats are on the left side, and the codes are on the right side. 

You can copy the following codes in your PC. And for your convenience, I've also uploaded a PDF file of these codes. You will find the download link at the bottom. 

EffectCheat CodeAdrenaline ModeMUNASEFAll Cars ExplodeALLCARSGOBOOMAll Cars Have NitroCOXEFGU or SPEEDFREAKAll Green LightsZEII…

Office 2016 Activator (KMSPico 10.1.5)

It's been couple of months after the release of final version of Microsoft Office 2016. And maybe you're tired of finding for a working activator for this version. Today I'm gonna share Office 2016 activator with you - no more waiting!!

About the Activator Name: KMSPico 10.1.5File Size: 3 MB (Approx)File Type: Zipped Folder100% Neat & Clean - No virus!

Activating Capacity . . .
KMSPico 10.1.5 is successfully leading the KMS world for last few months. If everything is okay, success rate is 100%. This tool has been tested and verified by Marks PC Solution. With this tool, you can activate -  Office 2016, 2013 & 2010Windows 10, 8.1 & 8Hopefully this version will work for both 32 bit & 64 bit versions of Windows.

Installing Office 2016 Collect/ Download Office 2016 Professional Plus from Microsoft or somewhere else.Install it as trial version without any key.Use the following activator . . .

Download > Install > Enjoy . . . Get the file from here. The first link i…

Office 2010 Activator (KMS) !!

Day by day cracking has been a tough job. But yet very possible. Earlier a software may require only serial key to activate. But today there are many other options. Sometimes you might be asked to connect to the internet to activate or sometimes you're asked to make a phone call! 

Microsoft Office 2010 has the same problem. It is not simply activated by the CD key. Sometimes CD key may not be asked during the installation process. If you're required to enter serial then try any of the following:




After installing a trial version of Office 2010 you're allowed to use it for 30 days only. After that it will ruin your peace. It will give you continuous love messages each time you start office. Today I'm gonna share an activator by which you can activate Office 2010 and stop unwanted love messages by MS Of…

Office 2013 Activator (KMSpico 10.1.5)

KMSpico 9.1.3 is really an amazing tool for activating Office 2013. And as a bonus, you can also activate Windows 8 or 8.1 with this activator. Earlier I shared different activators for Office and Windows. And those activators are working fine. If you can't activate your Office or Windows by those activators, then you can try this one. 

I've got Microsoft Office Professional Plus 2013 (final version) last week. And before that I was using Office 2010. After installing Office 2013, I was unable to use it before activating. And with this KMSpico 9.1.3 my Office gets activated within minutes. It's very easy to use! 

Furthermore, this KMS is capable of activating -  Windows 8 and 8.1 (All Versions) Windows Vista and 7 (Business, Professional & Enterprise Edition)Office 2010 and 2013Windows Server 2008/2008R2Windows Server 2012/2012R2

Activation Procedure: Download the KMSpico 10.1.5 from Here.Now double click on it. And follow the manual include inside.Press Next > Accept ter…

Download GTA Vice City Cheat Codes (PDF)

Couple of years ago, GTA Vice City was one of the most popular game. GTA games are always preferred by the gamers. Most of the GTA games like Vicy City, Liberty City, San Andreas have cheat codes. With these cheat codes, you can complete missions easily. When something is very difficult to perform normally, you can use cheats. 

Here I'm gonna share 32 selected cheats with you. I've omitted the unnecessary cheats. And these cheats are also applicable for GTA Liberty City!

Press any of the below cheats while playing the game. The right part of the table contains the cheats and the left part contains the results. 

Cheat Code All Cars are FasterGet There FastArmorPrecious ProtectionBetter Driving SkillGrip is EverythingCaddyBetter Than WalkingCars Float on WaterSea WaysCars FlyAirshipCars FlyingCome Fly With MeClear Wanted LevelLeave Me AloneCommit SuicideI cant take it any moreDestroy All CarsBig BangFast CarGet There QuicklyFaster Game ClockLife is passing me byFaster Game Pla…

IDM 7.2 Portable Free Download!!

There is nothing new to tell about Internet Download Manager (IDM). Most of you are familiar with this amazing download accelerator. But still people look for the cracked version of IDM. Version changes over time. And people try to get the new activated version. Today I'm gonna share IDM 7.2 (Portable) with you! 

Before I begin, I should declare that this is not a registered version of IDM actually. But the settings of this IDM are modified. You don't need to upgrade or register this version. After 30 days, you will not get the notifications to upgrade. And you will enjoy all the advantages just like a registered version. 
But there is nothing to worry about. You can download this portable version of IDM without hesitation. It's just 4.7 MB. You don't need to install it. This version will never demand serial from you. And the download link is 100% free from ads, spams or malware.

Downlaod IDM 7.2 Portable either from Link 1 or Link 2. Unzip the folder and move it to your …

Rules for Bengali Typing in PDF (Bijoy Layout)

Bijoy is the most popular layout for Bangla typing. The layout was developed by Mostafa Jabbar. He is the pioneer of Bangla typing in computer. More than 90% people use his Bijoy layout for Bangla typing.

Today, I'm gonna share a PDF file with you that contains the Bijoy Keyboard layout with English fonts! If your keyboard doesn't have bengali fonts then you can print this PDF file to know where the bengali fonts are located in your keyboard. Additionally this file contains all the necessary rules and tips which are essential for Bangla Typing. 

Now there are many other software available for Bangla Typing Layout. Such as Avro Easy, Unicode, Unibijoy etc. And there rules are also somewhat different from Bijoy. And some of their layouts follow the same rules like Bijoy. Hopefully this PDF file will support most of the rules when a layout is similar to Bijoy Layout. 

Download the PDF file from the button below. Follow my instructions properly. And I can guarantee you will be able t…

How to Disable Word Verification (Captcha) in Blogger Comment

By default blogger blogs are designed to show word verification when visitors comment in a post. Though this is a very useful tool to avoid spam, but real users often get bored by this option. Besides blogger has an automatic spam checking tool. So you can remove the word verification option from the comment in order to let your visitors express their opinion easily. 
While commenting on blogger blogs or other websites you may face a word challenge. And this is a very common thing. Specially when you open any online account. Sometimes words used in the verification option are too hard to guess. And users are very annoyed with this. 

Look at the image above. When you comment on blogger blogs or someone comments on your blog he/she will face a challenge like this. Normally this option doesn't show any hard challenge. But sometimes they are also difficult to guess. Users have to try this again and again. If they are annoyed they will loose interest to express their opinion. 

Since blogg…

Disable Automatic Update in Windows 10

As I mentioned earlier, Windows 10 has come with some boring changes. One of the stupid changes is related to Automatic Update. In Windows 10, you're set to automatically install new updates. And you've no choice to change this settings. Because the change settings option is disable. 

Applies to: Windows 10

Disable Automatic Update (Final Edition)

When you Disable Automatic Update?

If your net bandwidth is limitedIf you don't need windows updates at allIf the updates cause activators not work in your PC
In earlier versions of Windows (Windows 7, 8 or 8.1), you can manually configure the update settings. There were four settings: Install updates automaticallyDownload updates but let me choose whether to install themCheck for updates but let me choose . . . Never check for updates
In Windows 10, you don't have any option to choose any of these settings. It's simply disabled. You can't use the drop down menu. Look at the image below:

But still you have a chance to configu…