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
-
Finding new links to site
Is there a way to find sites that linked to my site during a certain time period? Say in the past 2 weeks or from March 1-March 15th ?
Competitive Research | | priceseo0 -
Why would a site with virtually no external links and low authority rank very high?
Hey there: I'm not sure anyone's going to be game to answer this but... I have designed, done on-page optimization for and done ongoing content marketing and linkbuilding for a local fitness site. The site is about nine months old and I am attempting to achieve rank for the keyword "personal trainers in philadelphia." We've made progress; having taken a new site from +100 to 19 in about four or five months worth of content creation and linkbuilding on a very modest budget. I'm not complaining. What has me confused though is that there are one or two sites that are ranking very high for this keyword string with considerably shoddier metrics than our site and I'm wondering how a stock WP theme site with very few inbound links can rank top five for a reasonably competitive keyword? Our site is http://vtrainersinc.com. The site I've noticed that ranks top five and seems to have an inferior SEOMoz profile is bodycrafters.net. Anybody got any ideas as to why these things seem to occur? I have this feeling this site has stumbled upon a magic SEO elixir which I'd like to get my hands on!
Competitive Research | | splatdude0 -
Can I write guest blogs on competitor's blogs?
I have been doing some guest blogging and its hard to find guest blogs opportunities. I have found some but they are direct competitors. Is it safe to write guest post? by the way the are not local competitors. Any suggestion please. thanks
Competitive Research | | conversiontactics0 -
Why does my site get sandboxed but this one doesn't?
I'm currently working on an entire website redesign and restructuring. My current website is extremely spammy. I really worked on it before I knew much about SEO. Now that I have a better foundation I have been remaking my site to get rid of duplicate content and to have a much better UX. With this said, I still depend on the current site to bring in my income while I'm working on getting my new site up. Google seems to constantly kick me out for about a month at a time and then let me back in. The few other times I thought it was because the new site I have been working on is on a different domain and was exactly the same for a while (I don't want google to find this new domain it's just for testing purposes). So I removed the new domain from google and in a couple weeks my main site was back in. Problem is yesterday google hit me again. I'm out of google for all my search terms. Before I was ranking on the first page for just about every "keyword + city" phrase I was trying to rank for. I can find plenty of reasons why google would give me problems with my current site. For example I have TONS of duplicate pages with just the keyword/city changed. Pretty spammy. I did buy about 5 links a year ago or so but they are pretty nothing sites. My question is if google's going to ban me why don't they just do it? They keep taking me out and putting me back in. No messages in webmaster tools. My domain is below: http://yourmusiclessons.com Also when I just started out I got the idea of "keyword + city" from a competitor that ranks for EVERYTHING which is also found below: http://www.musikalessons.com All of the links I bought were the same links the above site bought. I tried buying a link from classical.net which has a high page rank and links to musikalessons.com on each page of their site. As soon as google found the links, I was kicked out. I had them remove it. My question is musika has basically the same "spammyness" as me just on a much larger scale and yet they never seem to be kicked out of google and still rank high. I've thought about reporting musika, but I'm afraid Google will ban me as well because my site is just as bad. Again I'm working all day on fixing my site and doing a 180, it's just taking a long time and I can't launch quite yet. I live off the income from my current site though, so it's very disheartening when this happens. Any ideas would be greatly appreciated!
Competitive Research | | BrianJenkins0 -
Free SEO tools appearing in SERPS for a site
Hi there, I've just taken over a site and it doesn't have a huge amount of shelfspace on the SERPs for it's brand name. Looking at the results that are there are a lot of free SEO tools that are coming up. They haven't had an SEO before so it's not coming from their side. There's such a lot of them I was wondering if anyone had come across this before - is it simply a competitor looking at the seo, could it be one of the seo analytics packages using free sites or is there anything else to be aware of. I can start knocking the sites down the SERPs but just wondering if anyone has a good solution for this. thanks Shiv
Competitive Research | | Shivvyt0 -
Site in top 3 with a 1-day old domain and no backlinks
Hi everyone, I'm trying to understand some searchresults, when searching in the netherlands for 'online casino':
Competitive Research | | iwebdevnl
http://www.google.nl/search?sourceid=chrome&ie=UTF-8&q=online+casino&pws=0 You'll see as position 3 result this website: http://bit.ly/qhRsUT, it's obviously that this site is there because of blackhat. But how did it come there such high for a keyword with high competition? I don't see anything wrong in the website? It's not like Google did something wrong, because it happened already a few times for this keyword with different domains from that owner. Regards, Yannick0 -
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 -
IP Address Of Site
Hi there, really new to seo and loving being able to research everything on seo moz. I have a question about the ip address of my site: I use a company that sells templated real estate websites (I'm a realtor) and I'm noticing all of their websites show as having the same ip address. There are probably 100's of sites on their server targeting the same keywords as I am, would this affect my ranking at all? I'm just considering switching to a Wordpress site with a unique IP address, so I'm curious to find out how the seomoz members would answer this question. Cheers, Adrian
Competitive Research | | adrianaldous0