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
-
Improving SEO for a Niche Blog - Seeking Advice
I am a college student studying Information Sciences and was "hired" by my uncle over the summer to work and maintain his baseball-related website, which he started in 2016. His posts provide very in-depth information but were created without a focus on SEO. I've noticed that a competing site, which seems to have started as an e-commerce site, is ranking higher than my uncle's site for the query "how much does a baseball weigh." Interestingly, this competing site ranks for keywords like "mass of baseball," even though these exact keywords are not present in the post. Given the recent Google updates and changes in rankings, I'm trying to understand: How can an e-commerce site with seemingly less specific content outrank a detailed blog post?
Competitive Research | | sf9090
What strategies can I employ to improve the ranking of my uncle's site for this specific query?
Are there tools or methods I can use to analyze why the competitor is ranking higher and how to address it?
I recognize I am not well-versed in SEO, so any insights or advice would be greatly appreciated. Thanks!0 -
Why is this site at no.1?
In the last 2 months, a previously unranked/unheard of website jumped straight to no.1 position for a particular keyword when searched from USA and is even ranking over many other big brands or stronger DA/PA sites. I did notice some very strange JavaScript popup links that are heavily keyword linked from the first mention of the keyword on the page content. What are they trying to do here? Otherwise they don't seem to have much PA/DA or seo going on. Why are they doing so well?!
Competitive Research | | emerald0 -
How does this site get a youtube backlink?
http://www.youtube.com/watch?v=dzMdpgJ-7Is is a video with a clickable external link to their website. How do they do this??
Competitive Research | | brianw100 -
Working through the slides on my first seo project, I'm trying to determine the most popular content on competition sites.
From the video, I understand I should be looking for unique opportunities. But is there a baseline for product qualification, ie., a min. PA,LRD, Inbound LInks, social shares, etc. I guess I'm asking what I should be looking for in the data provided on each competing site? What determines THE most popular and unique product?
Competitive Research | | AhmadS0 -
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 -
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 -
Excel Concatenate Function for Google Places?
I'm trying to expedite my research by using the concatenate function. How should the search URL be modified to trigger a google places search as opposed to a normal search. Thanks!
Competitive Research | | BlueFountainMedia0 -
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