You can download the excel sheet here:

Free Meta Tag Generator Tool for Excel Version 1.1

Watch this 2 minute video to learn what it does:

In order to use this tool, you need to have macros enabled. Depending on the version of Excel you're using, you may be propted to enable them when opening the workbook.

There's a column for your new meta tags, and one for your old meta tags. You don't need to use the old column, this is just if you want to compare a page's existing meta tags.

The Google Simulation tab shows you what your tags will look like on the google search results page. If you press the search button, a new tab is created that shows you the keyword bolding Google does.

You can only enter ONE word per cell in the search bar, up to six words per search.

The control panel allows you to adjust how many characters before the "..." cutoff on the Google simulation tab. Also, you can turn off the "old" and "new" labels.

Once you're done writing your meta tags, press the Generate HTML button to wrap your tags in HTML code. The results are copied to a new sheet.

This is just the first version of this free tool. Please let me know if there are any features you'd like see or problems you're experiencing.

If you need more help with Local SEO, please get in touch!