CSV reports in SEOmoz
-
Hello,
I would like to export the reports from SEOmoz to an Excel sheet. However when I downoad the report and open it, all the information is random and is hard to work on it. Since Im not an excel expert, I have to ask if there is an Excel sheet ready to receive the SEOmoz reports.
Tks for the help,
Regards,
PP
-
Hi Pedro,
Were you able to get things working if you manually instructed Excel to use a comma as a delimiter?
-
The file from SEOmoz appears like the image I attached in here.
Any ideia how to fix this?
Tks!
-
I'm not sure what problem you're having exactly as Excel is usually compatible with CSV files and I've had no problem with downloaded reports from SEOmoz.
It sounds like you may be having an issue with the delimiter but I can't say for sure without seeing exactly what you're talking about. You can find a guide about how to import a delimited file in Excel here:
http://www.ehow.com/how_4449036_import-delimited-file-excel.html
Hope that helps.
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
-
Analytics reporting
I am new to the world of SEO and Google Analytics specifically. I want to find a way to easily see top pages, search terms, and traffic. In Moz I thought I could see this by using "traffic from search", but I only see one page that is ghost spam nothing related to any of my pages. I made sure the right account is connected and it is. Any suggestions on how to get this data easily?
Moz Pro | | CRMI0 -
SEOmoz Not Picking Up Links
I'm finding that SEOmoz often doesn't pick up on many of the links my client's websites are attaining. The links do appear in search engine and often have a high domain authority (often PR links, which I why I follow up to see if they've been picked up). I do tend to see many of the links appear in webmaster tools, so it's a little frustrating that they don't appear, even after months of pages being live. Thoughts?
Moz Pro | | SebastianDyer0 -
On page report card - small niggle
I've been carefully making page corrections and trying to get each age in line with SEOMoz recommendations. However, under the section marked Optional (and I realise I could just ignore it!) it tells me to "Avoid Using Meta Keywords Tag". However, none of the pages have any meta keywords in. They have a meta description, but no keywords. I have also removed any global keywords. Is the software wrong, or are there some more hidden somewhere.... website page is http://www.forktruckexpress.com/Hire/rossendale-forklift-hire.html Thanks in advance
Moz Pro | | Gordon_Hall0 -
How do I disallow a subdirectory in my reports?
My seomoz reports include thousands of pages from a "localmarket" subdirectory licensed to an ad packager that I am soon turning off. How do I remove this subdirectory from seomoz reports now?
Moz Pro | | mulligan0 -
Why does Crawl Diagnostics report this as duplicate content?
Hi guys, we've been addressing a duplicate content problem on our site over the past few weeks. Lately, we've implemented rel canonical tags in various parts of our ecommerce store, over time, and observing the effects by both tracking changes in SEOMoz and Websmater tools. Although our duplicate content errors are definitely decreasing, I can't help but wonder why some URLs are still being flagged with duplicate content by our SEOmoz crawler. Here's an example, taken directly from our Crawl Diagnostics Report: URL with 4 Duplicate Content errors:
Moz Pro | | yacpro13
/safety-lights.html Duplicate content URLs:
/safety-lights.html ?cat=78&price=-100
/safety-lights.html?cat=78&dir=desc&order=position /safety-lights.html?cat=78 /safety-lights.html?manufacturer=514 What I don't understand, is all of the URLS with URL parameters have a rel canonical tag pointing to the 'real' URL
/safety-lights.html So why is SEOMoz crawler still flagging this as duplicate content?0 -
Seomoz Customer Service does anyone feel let down
I would like to know if anyone else feels let down by seomoz and their customer service. I will give you a couple of examples why i feel let down. I contacted customer services over an issue a couple of weeks a go and never got an answer from them, and the second issue is the private question that you can ask. I asked many days ago and it was an important question and it has still not been answered. I am just wondering what we are paying for by using this site and if other customers of this service feel let down like me.
Moz Pro | | ClaireH-1848860 -
Anyone having problems with the SEOmoz KWD Tool??
Just a quicky: Tried to run keyword difficulty tool reports last couple of days but keep getting error messages regardless of how many words/phrases I request. Is this a general outage or just me? Cheers
Moz Pro | | lovealbatross
James0 -
SEOmoz metrics vs Panda Algorithm
Hey SEOmoz guys, My question is simple. Have you re-test your metrics (DA, PA, mR etc) correlation with SERPs in google panda update? are they still valid in determining authority, trust and popularity in panda update? are they still usefull? Thanks! Yudhis
Moz Pro | | yudz0