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
-
Static Html Pages V/s Wordpress - For open content pages?
Hi there. I am worried a bit about static html pages or wordpress as an instance to write down open page content for our website. We are a product based website - primarily Saas based product. But with time we have seen that if we write more content people will be able to find us better,. Earlier our blog resided on blog.example.com now we are moving it to example.com/blog/ Issues - I really want to know that I need to generate lots of fresh content so I am using wordpress as the blog medium and content generation medium too. Basically the wordpress instance will be a content generated pages. I can also have static html page based content but then our content writers will always have to take the help of develoeprs to publish it to our sites. Whats the best way to go about this keeping SEO really crucial in mind? Thanks for your time and help!
Competitive Research | | shanky10 -
Blogging just to manipulate rankings?
Hi, I have been playing with Open Site Explorer for a while and have been trying to figure out how some of our competitors could rank with "not so great" articles. I don't want to sound harsh here but some of the articles outranking us are nothing but 6 images + 200-225 words from a press release and a Video. How exactly does Google justify this by ranking them higher than a 1500 word unique article that has been written in no less than 7 days? According to OpenSite Explorer, about the two pages compared, the difference is the number of LINKS. The sad part is, without 1 exception, all their links are coming from blog pages like *.wordpress.com *.typepad.com etc. I would have been just FINE if their links were NATURAL. You may ask me why I assume those blogs are created by them. Because every single post on those blogs are pointing to their domain... I don't think a normal blogger would keep pointing to the same domain. So what are we supposed to do here? Wait 3 months so people discover our articles and natural links will come? (It happens sometimes but then it may not...) Do what they do? Sorry about the ranting but I have one question if you don't want to read the rant. Is blogging to build links, considered black hat or not?
Competitive Research | | Gamer070 -
Manta inbound link in OSE - competitor site yes, my site no, why?
Our site has had a link back to our site from Manta for a long time, but it's not appearing in our OSE results. One of our competitors similarly has an inbound link from Manta and that link DOES appear in their OSE results. I'm not certain whether that matters for us. Does it? But in any event, why would the one link appear but not the other? Thanks! Tim
Competitive Research | | tcolling0 -
Good tools to compare site speed on different sites?
Google tells me that my site is slower than 81% of the internet.Now this is a very large news website, so I would like to compare this against other very large news websites. Are there any tools that will be able to tell me the speed of a list of websites? I am looking for something a little more detailed than 'this site loaded in 1 second'. Also, do any of you fellow SEOs know of any good tools to analyse what is causing your site to slow down? Kind regards
Competitive Research | | MirandaP0 -
How can my site not ranked on easy keyword while it currently ranked 1 on difficult keyword??
The site in question is http://ikt.co.id The site is perfectly optimized (or even over optimized) for keyword "Bikin Website Murah" (in Indonesia it means "develop an affordable website") currently if you search on both google.co.id AND google.com, it ranked on #10 (on google.co.id) and it ranked on #7 (on google.com), and both term only return 1.3 million results I have A LOT OF pages that started with 'bikin website' , or 'website murah' ... there are a lot of them, and i have had a lot of backlinks on those pages too (have been manually building a lot of links, starting from creating a tutorial article and blog submission and many other way) .. the site has been perfectly optimized for that keyword For example we have http://ikt.co.id/blog-category/bikin-website-murah-promo-terbaru.html (for newest promotion) http://ikt.co.id/blog/bikin-website-seo-murah-discount-40-sampai-31-juli-2011.html (for discount 40% promo that lasted untill 31 juli 2011) AND YET, if you search on google.co.id for keyword "2000 likes facebook" , our lone page that i created when our facebook likes reached that amount, RANKED #1!! , and please let me tell you this term return 400 million results++ (on google.com this keyword ranked #19, on 500 million results++). And let me tell you it take that SINGLE page (which has absolutely 0 backlinks) 2 days to ranked #1 .... and her brother if you searched "1000 likes facebook" also show similar result (though not better then the sister) How ?!? and Why ?!? , i dont understand this at all.... my domain does not contain any keyword, they uses the same engine and yet that lone pages which have absolutely no backlink ranked so well on a very competitive keyword, while my Target Keyword ranked poorly.... And what is even more bizzare? "Bikin website murah" might not rank good, but "bikin website" ranked better x_x ... arghh i dont get it... why my site ranked poorly on easy keywords and ranked high on difficult keywords :(( .... Why I am not smiling because those easy keyword is actually my primary keywords 😞
Competitive Research | | IKT0 -
Creating Sub Pages To Target Specific Keywords
Hi Guys, Hope you can answer this question. Our website is currently on the first page in position 6 for a competitive keyword, domain is 11years old and currently has a PR of 4. At the moment there are 4 competitors above us one of which as two listings, they have managed to do this by creating a page dedicated to the keyword. E.g www.ourdomain.co.uk/key-word.html. Do you think we would achieve a good ranking if we built the same page but with fresh content and links pointing to that page? Cheers.
Competitive Research | | ScottBaxterWW0 -
Why there is no tool that check the page content ?
When using the SEO tool: http://www.seomoz.org/keyword-difficulty/google.com We can see the top 10 competition on a lot of parameters but i think you are missing the research on PAGE TEXT CONTENT. What do you say ?
Competitive Research | | idoravivo0 -
How does a site get to no 3 in Google with no KW in their links?!!
Hello everyone, my first post - ahhh I'm investigating a niche and there is a site that should have no right being there in my view. It's no. 3 Google UK for 'company formation' with a small site with 65 weak links from only 7 domains and hosted in the US. But more importantly, the Open Site Explorer says there is not 1 link with that term in its anchor text. This I find crazy and makes me suspicious. But before I go back to my client saying "oh they must be black hat" I would like your expert views. I'm not sure whether to tut or congratulate them and for the first time I'm not sure what reasons to give for their amazing performance! What's your views?
Competitive Research | | GOYMedia480