Useful Excel Data Collection Tip

By Manoj Jasra - Mon, 09/18/2006 - 8:53am.

If you're in the Web Analytics/SEO industry you will often find yourself trying to copy data into excel from other sources (Keywords, Search Engine Stats, etc...). An article posted at Text Link Brokers makes importing data into excel VERY simple.

By navigating to the following option in excel:

DATA > IMPORT EXTERNAL DATA > NEW WEB QUERY

Then selecting the desired data, a person can import any part of given webpage quickly to excel.

Go ahead and try if for your self!

Here's the link again: http://www.textlinkbrokers.com/blog/weblog/P400/

Tag:

Bookmark WebProNews:

Manoj has been working in the search engine marketing industry since 2002. He started out as a software developer but now provides in-depth web site analysis using web analytics.

http://www.enquiro.com
Manoj is also the author of Web Analytics World. Web Analytics is an essential component in developing a successful
online campaign. Help convert visitors into customers by understanding
them.

News Tags: analytics, Excel, Text, Link, HTTP, blog, Data, Web, Weblog

About the author:
Manoj Jasra is a well respected search marketing veteran having been in the industry since 2002. Manoj currently serves as a Sr. Analyst on the web solutions team at Shaw Communications Inc. Manoj's role primarily consists of providing SEO/PPC and Web Analytics strategies in addition to business insight on Shaw's web properties. Previously, Manoj held the role of Director of Technology at Enquiro Search Solutions where he oversaw Enquiro's product development for search marketing solutions and acted as the lead on both SEO Training and Enquiro's Web Analytics approach.

Check out Manoj's well read blog, Web Analytics World, which focuses on his insight in Search Marketing, Mobile, Technology and of course, Web Analytics. You can contact Manoj at manoj.jasra@gmail.com

WebProNews

Useful Excel Data Collection Tip

Comments

Post new comment