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
-
Is it possible to create "hidden" backlinks?
Don't miss interpret this... I DON'T mean hidden backlinks that you would stick on a page using html/css. What I am trying to figure out is if it's possible to create backlinks from sites that aren't visible by crawlers or SEO tools like Moz?... Does that make sense? Another words, let's say I place a visible/genuine/follow backlink to any external website from my blog. Is there a way to keep crawlers like Moz or other SEO tools from "seeing it"?
Competitive Research | | co.mc0 -
Why has my authority article gone from P1 to below the top 50? Along with the rest of my site...
My site has run into some serious and unexplained SEO issues over the last 6 months, i.e: I wrote the content at http://www.flatroofs.co.uk/flat-roof-insulation/ about 3-4 years ago, and ever since it's competed for position with the huge PLC websites and hovered around the top 3 spots in google.co.uk. However, since May this year things have declined rapidly and now isn't even in the top 50 for [flat roof insulation]! Why?? I am aware that this content has been pretty heavily plagiarised since day 1, with some other sites making the effort the 'rehash' my wording and others just blatantly copying. At the same time it's also been relatively well linked to (for a very boring subject) since day 1. Over the same period (since May) the site has suffered a huge decline in traffic and rankings, as can be seen here http://www.flatroofs.co.uk/wp-content/uploads/2013/11/Capture.png, but I find the huge drop harder to justify for a relevant article than for the homepage/site in general. What strikes me about the above is the two step changes in traffic volume; one in early June and the other in late October. I am vaguely aware of the penguin update etc, but it seems to me like I've been manually banished somehow? Thanks in advance for any advice!
Competitive Research | | Biota0 -
Feed sites replacing my pages in SERP
I have a problem! Sites like:
Competitive Research | | pycckuu
http://lynk.ly/
http://www.yousaytoo.com/
http://www.stumbleupon.com/
http://friendfeed.com/ Are replacing my posts even if i am searching for an exact title of the post. For example this search query:
Christmas Party Style Sets With Black Cocktail Dresses Original post here:
http://richclubgirl.com/christmas-party/christmas-party-style-sets-with-black-cocktail-dresses/ How do i fight this issue? I want to stay on these sites somehow! Thanks in advance!0 -
Open Site Explorer Date of Links obtained
Hi is there anyway to compare a competitors profile over two time periods ie, 6 months ago, then today for example. I have the sites within a current campaign, i would like for example to find a competitors back-links they have obtained in the last 6 months. As some of my competitors have 1000s of links to its difficult to see what they have been upto thanks
Competitive Research | | Will_Craig1 -
Open Site Explorer is not showing dmT. Where do I go to get this metric.
Just trying to understand the video I watched on Link Building w/ Open Site Explorer. I'm not seeing the dmT metric in the live version. Has it been replaced by something else. Or is there someplace else I need to look for it?
Competitive Research | | AhmadS0 -
How a site only with Frame can be at #1 google in a competitive keyword?
Guys, I need help. I have a company in Brasil and due to lack of budget, I'm doing the SEO for my self. And for two years Im reading everything that I can to do my best in my website. I worked very hard, but the #1 in the most important keyword for my company is a very bad website only with frames. What they are doing? Could anyone give help? Keyword: "acampamento"
Competitive Research | | Naghirniac
Google Brazil (www.google.com.br)
#1 website: www.acampar.net My website: www.acampamentoaguiasdaserra.com.br Thank you in advance Miguel0 -
How many Page Rank 8 sites are there?
Anyone have any estimate of how many Page Rank 8 sites are out there? Best, Steve
Competitive Research | | Aggie0