How Do You Create an excel spreadsheet of all blog post content on a site?
-
Is there a quick and easy way to create an excel spreadsheet with a list of all blog content and it's SEO factors i.e. URL, title, description, etc.? I know I could use screaming from to get the entire site but is there a way to just get the content on the blog?
-
You can export your database to an excel spreadsheet, then you can retrieve the url based on your ids in database.
After you have your list of urls you can both do a crwal using screamingfrog or xenu and join the two lists with a vlookup or you can simply retrieve your title and meta description using seotools extension for excel from nielsbosma.se
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
What tool can I use to find the top traffic-driving keyword for a batch of pages from multiple sites?
I thought I might be able to use Ahref's Batch Analysis for this, but that just gives stats on backlinks. I have a several lists of thousands of pages scraped for particular sets of keywords, but what I need is some way to automate fetching the biggest keyword that each page ranks for - biggest being the keyword that is estimated to drive the most organic traffic. Is there a tool out there that does something like this?
Competitive Research | | helenlorettahasan0 -
What a Brand should do first for Their Blog Keyword Research or Topic Research?
Hello Moz Community, Need your help guys. What a Brand should do first for their Blog? Keyword Research or Topic Research? Like for the Brand Product page/ eCom Pages, it's quite easy > 1. Buy "Product" Online
Competitive Research | | Max_
2. Buy "Product" "Geo."
3. Product Reviews [for Guest Posting or Reviews]
4. Best "Product" Online and so But, for the blog, it's tough for searching out the keywords that will work if the SEO team or the keyword research team is not aware or don't have the detailed knowledge about the niche they are working on. Please verify: Is it a correct method that an editor should provide a "topic" to the SEO team to find relevant keywords by using a Keyword Research tool that there are enough searches for it which can provide benefits to the blog via the search engine.0 -
Why does this site atlantapestcontrol.com rank so high?
I have been doing competitive research on the keyword phrase "atlanta pest control" this website atlantapestcontrol.com is #1. Why? The number 2 website makes some sense for its rank, but this one does not.
Competitive Research | | SammyL300660 -
Is there a SEO Moz Competitor Analasys tool that will show me how many Vistors their site receives?
I'm trying to find out how much traffic a competitor gets. Is there an SEOmoz tool for this?
Competitive Research | | starkSEO0 -
Analyzing Back Links - Says site A has back link to Site B but when I look at site B I can't find any back link to Site A. Why?
I am new to SEO Moz - It looks like incredible technology. I was playing around with different websites to see where they had back linked to see how it works. Looked at a site called racingsecretsexposed [dot] come and it said that it had dozens of links to www.ndesignstudio.com such as: ndesign-studio.com/blog/best-wordpress-sites?replytocom=893 with link anchor text "laying horses" but when I do a search for the company name, or the anchor text "laying horses", or the owner of the company's name on ndesignstudio.com - nothing appears. Why not? Isn't the back link anchored by the text laying horses, which should link back to the racing secrets website? Thanks
Competitive Research | | NewtoSEO900 -
Why do you think this site can't reach a better ranking?
Hello, My name is Pablo Lagos. We have a hosting company in Chile since 2006. All the time we have been ranked in the first page for the keyword "hosting" in google.cl. Some years ago, we used to be on the first 3 results. Since the last year our site went down to 7 and higher places no matter we do. When I run the link analysis, we have the highest punctuation in all items. I would really appreciate your comments. The site is in spanish: www.ilihost.cl Thanks.
Competitive Research | | pabloandres0 -
Sites With Duplicate Content Ranking Way Higher
The site I am writing about is easendtorontohomes.com I don't get it. I see that some of my competitors have more inbound links and have been around longer. Their SEOmoz trust etc is also higher. But I don't get how many could possibly be ranking higher since they're sites are all template based site via Web Tech Design and the content is duplicated from one to the other. The other weird thing is that they do everything wrong - they stuff their keywords tag, some of them use the same keywords/meta data on every single page, some of them don't even have meta tags, some of them don't even have a blog with ANY original content. Apart from listings EastEndTorontoHomes.com has TONS of original, well-researched, and keyword rich content. I just don't get it. Is it possible that google has some sort of relationship with that company? Or am I totally missing something? Some of these sites include: tinasmith.ca, mikeclarke.com, teamkassen.com
Competitive Research | | annasus0 -
How due I take the advanced report that i have exported as a excel file and recreate your online color coded version with the data.
In the keyword difficulty screen how do I recreate your beutiful color coded spreadsheet in the exported excel file based on the advanced reports.
Competitive Research | | bmcfarlane0