Saturday, 16 March 2019

Unit Converter

Microsoft Excel has a CONVERT function that will convert a number from one measurement unit to another measurement unit.
Formula: =CONVERT(number, from unit, to unit)
Example: =CONVERT(1.5, "ozm", "g")
This is a powerful function as it contains a comprehensive list of measurement units and full range of metric prefixes from yocto (x10-24) to yotta (x1024). In between these Yocto and Yotta are prefixes like Kilo (x103), Mega(x106), Giga(x109), Mili (x10-3), Micro (x10-6), etc. just to name a few of the famous one. Among the measurement units, one may scratch his head to find out the codes for Angstrom or light year in the =CONVERT() formula to calculate distance.

As you can see, finding a specific unit code and metric prefix code for the CONVERT formula is not straight forward for most users. This Unit Converter, an Excel Add-In, makes the unit conversion and insertion of =CONVERT formula extremely easy.

WORDzco Unit Converter

WORDzco Unit Converter converts number values in all selected cells from a measurement unit to another unit. You can choose the converted output as EITHER number OR in CONVERT formula, i.e. =CONVERT(2.6,"mi","m"). It is fast and is easy to use and it runs on your own desktop. Watch this:

Convert Square Feet to Square Meter 

Full list of metric prefixes from the ultimate big Yotta, Zetta, Exa, etc. to Tera, Giga, Mega, Kilo to mili, micro, nano, right down to ultimate small atto, zepto, yocto.


You may download and try the free complimentary version here, OR WATCH DEMO of the complete functionality of the Unit Converter.

Saturday, 10 November 2018

Keywords Editor - Updates

Two updates of WORDz.co Keywords Editor

1. Analysis of the theme of a keywords list

You can know the frequency of word or words in a keywords list. Just select a column of keywords and press "Themes" button in the "Compile Keywords" functions group.

Simple report on frequency of word/ words of a keyword list


2. Change the "Destination URL" to "Final URL"

URL is one of the fields of the output table to be uploaded to Adwords Editor. We changed the header "Destination URL" to "Final URL".

Below shows how to Copy and Paste the output table to Adwords Editor.

Copy and Paste output table in Excel to Adwords Editor.

Monday, 29 October 2018

Group a Column of Keywords by Common Theme (Word or Words)

How to segregate and group a list of keywords by common theme? Without using any tool, the process is slow, tedious and exhausting.

Keywords Editor has a function, i.e. "By Words" (i.e. Compile Keywords by Words), that can segregate and group the list of keywords quickly based on common word/words contained in the keywords.

The two demos below show how the keyword tool works. Try it, you can download a free copy here.

1. The demo below shows how to group keywords that contained "sneaker" and "sport shoes" to one column and keywords that contained "glove" and "gloves" to another column.

Group and segregate keywords by common word/ words into columns


2. The demo below shows how to group keywords that contained "sneaker" and "sport shoes" into one table that can be uploaded to your campaign through Copy and Paste to Adwords Editor's "Making Multiple Changes" function.

Group and segregate keywords by common word/ words into table. Copy & paste the table to Adwords Editor.


You can download a free trial copy of WORDz.co Keywords Editor here.

Monday, 4 May 2015

Wordz Expand (Keywords Ideas from Search Results)

You can get more keywords ideas from the keywords suggested by search engines at the bottom of the search results page based on your original search term. You can extract these keywords quickly into your Excel worksheet. You don't even need to copy and paste from the search results page and to the worksheet.





You can download this free Excel Add-In tool here.
keyword grouping tool download
Free Download


Note: For a comprehensive Excel Add-In to manage and manipulate keywords in bulk, check out our Keywords Editor, a "Swiss Army Knife" tool for keywords.

Note 2: Search engines may change the layout of search results page from time to time, therefore this tool will need constant update. Visit this page frequently to get the most updated version.

Sunday, 26 April 2015

Wordz Trim is a simple tool to remove all spaces from text except for single spaces between words. You select the cells that contain the text and click to remove the extra spaces.

Instead of writing formula in the cells like this, i.e. =TRIM(+A1), =TRIM(+A2), =TRIM(+A3), etc., you simply
  1. select the cells that contain the text and
  2. click to remove the extra spaces




You can download this free Excel's add-in tool here.
keyword grouping tool download
Free Download


Note: For more features to manage and manipulate keywords in bulk, check out our Keywords Editor, a "Swiss Knife" tool for keywords.


Saturday, 13 December 2014

New Google Adwords Editor 11

Google just released its latest version of Adwords Editor. It looks promising in simplifying and quickening the process of campaign building. These are 4 things that I truly like
  1. its interface
  2. the way it structured multiple users and further access to multiple accounts
  3. the way it structured the access to campaigns, groups, keywords and ads
  4. it is fast on my Windows 8 PC






Comments from the industry experts are generally positive. Here are the comments from a few of the experts:
  1. Larry Kim on the New Google Adwords Editor 11
  2. Ginny Marvin on the New Google Adwords Editor 11
  3. From the horse mouth, Google Adwords's blog on the new Adwords Editor 11
  4. Check the discussion on Adwords Editor in Google Adwords Community


There are small unfavorable changes made, for instance Keyword Grouper function in Adwords Editor 10.6 and earlier was removed.

Tuesday, 28 October 2014

Keyword Grouping: Wordz Group 1.01

We released an updated version of our keywords grouping tool, Wordz Group.

It is an Excel add-in. It splits your long list of keywords into smaller groups based on your criteria of word or words.



Step-by-Step


  • Select your list of keywords on the worksheet
  • Enter word or words (separated by comma ( , ) and/ or ampersand ( & )) as criteria to extract keywords from the list
  • In one click, it will extract all the keywords that contain the word or words you indicated and place them in another column
  • It will also automatically delete the extracted keywords from the original list


We distribute this little powerful Excel add-in tool for free. You can download it here.


Other free or free for evaluation resources: