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
-
Stupid question: why SEOMOz has become MOZ?
According to their On-Page Report Card the URL should include the main keyword i.e. SEO in their case, so why do they get an F grade If I check their main page www.moz.com for the keyword SEO? Thanks for your comments!
Moz Pro | | mcany0 -
Local search results reporting
Is there a way I can report on local search results for our keywords by city?
Moz Pro | | RPM5
For example could I specify Phoenix or Chicago and then see how we rank as if we did the search in that city?0 -
I want to create a report of only de duplicate content pages as a csv file so i can create a script to canonicalize them.
I want to create a report of only de duplicate content pages as a csv file so i can create a script to canonicalize them. So i get something like: http://example.com/page1, http://example.com/page2, http://example.com/page3, http://example.com/page4, Because I now have to open each in "Issue: Duplicate Page Content", and this takes a lot of time. The same for duplicate page title.
Moz Pro | | nvs.nim0 -
SEOmoz tool Issue?
Hi Mozzers, I am doing a web maintenance task for a client and it's been weeks that Moz is detecting 49 duplicate pages ( contact page). I thought resolving the issue when creating the xml sitemap and excluding those duplicates. The moz tool would still detect them, so I went in making a search with some of these duplicate to check if they were indexed but non of them were indexed. So my question is has anyone recently experienced similar issues? Is the moz tool not 100% accurate? Thanks for sharing your thoughts and answers
Moz Pro | | Ideas-Money-Art0 -
Seomoz bar: No Follow and Robots.txt
Should the Mozbar pickup 'nofollow" links that are handled in robots.txt ? the robots.tx blocks categories, but is still show as a followed (green) link when using the mozbar. Thanks! Holly ETA: I'm assuming that- disallow: myblog.com/category/ - is comparable to the nofollow tag on catagory?
Moz Pro | | squareplug0 -
Crawl Diagnostics Report
I'm a bit concerned about the results I'm getting from the Crawl Diagnostics Report. I've updated the site with canonical urls to remove duplicate content and when I check the site - it all displays the right values, but the report, which has just finished crawling is still showing a lot of pages as duplicate content. Simple example: http://www.domain.com http://www.domain.com/ Both of them are in the duplicate content section although both have canonical url set as: Does each crawl check the entire site from the beginning or just the pages it didn't have a chance to crawl the last time? This is just one of 333 duplicate content pages, which have canonical url pointing to the right page. Can someone please explain?
Moz Pro | | coremediadesign0 -
Is the SEOMoz Rank Tracker still accurate?
I monitor several keywords on several domains and i have found that rank tracker gives me one result yet when searching via Google myself (on different machines) i get a different result. I've tried several devices on different networks so there is no chance that Google is remembering my searches as such and i ensure that i am always signed out of my account. All devices provide the same results yet Rank Tracker provides a completely different result. It's as though Rank Tracker is a day ahead or something. Can anyone shed any light for me please?
Moz Pro | | MarkHincks0 -
Why is the Rankings Report of SeoMoz always show inaccurate results?
I have been using SEOmoz PRO tool from last two months but I am not happy with the SEOmoz PRO Ranking Report.The results are very inaccurate and I am not able to understand why there is such a difference in the ranking results when SEOmoz tracks and when I track?Please reply at the earliest. Regards, Prashakth Kamath
Moz Pro | | 1prashakth0