Posts tagged as:

excel

OutWit Hub

by BillySeptember 30, 2009 Media

OutWit Hub is my new favourite extension for Firefox. It let’s you easily extract data from any HTML web page and export to Excel.
The interface is very intuitive and works like a browser. The Guess and List functions are accurate and usually extract infomation as expected. Guess and List are suitable for most data extraction [...]

Tagged as: excel, outwit hub, scrapers

0 comments Read the full article →

Prepare AdWords campaigns in Excel for upload into AdWords Editor

by JCDecember 16, 2008 Online Marketing

One of the most common tasks when working with Google AdWords PPC is preparing campaigns in Excel ready to be loaded into Google’s AdWords Editor.
We think the following process is the quickest and most effective method for producing these lists in Excel. A lot of the speed comes from learning the keyboard shortcuts for various [...]

Tagged as: adwords, excel, ppc

7 comments Read the full article →

How to expand keywords in Excel

by JCOctober 26, 2008 Online Marketing

If you’re dealing with keywords, then Excel is your friend. Excel makes managing large lists of data very easy and it has a number of features that work especially well with keywords.
Here is a simple recipe to combine a few simple keywords together to create a list of long-tail terms.
Ingredients
Core terms

apples
oranges
bananas

Geographic terms

new york
los angeles
boston
philadelphia

Recipe
In Excel, [...]

Tagged as: excel, keywords

1 comment Read the full article →

Importing CSVs into Bento

by JCOctober 13, 2008 Settings

When importing CSV files into Bento it’s important that the date is exactly the right format, so if Bento has a date like 30/09/2008 then the CSV dates must be in exactly the same format.
In Excel, you can format the cells to be a custom date type by typing dd/mm/yyyy in the cell format dialog [...]

Tagged as: bento, excel

0 comments Read the full article →