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
-
Moz Crawl Report more urls?
Hi. I have used Moz Crawl Test and get my 3,000 urls crawled no issue. However, my site has more than that, is it possible to crawl the entire website? Alot of the crawl urls in the Moz test are search string urls and filters so Ive probably wasted about 2,500 urls on filter urls. Any advise or alternative software that wont cost a fortune?
Moz Pro | | YNWA
Thanks0 -
Raven Reporting Alternative
Does anyone know of a tool that has similar capacity to Raven's Reports? I'm doing some white labeling of reports for another Agency that is used to sending their clients a monthly Raven report that is basicly pulling out all the Google Analytic Data of top referrers, keywords, landing pages ect and putting them into a nice format. I've used the Moz reporting and at times just combined it with a pdf of the actual GA equivalent. That's always seemed a bit clunky but I don't want to have to take on a Raven subscription just for that. Anyone have any good alternatives or know if when the new dashboard launches if it will also up its game when it comes to the generated reports?
Moz Pro | | BCutrer0 -
Not provided Data in SEOMoz reports
Hi How do SeoMoz reports deal with 'not provided' data I see my total visits from organic search for a month are same as total of both my branded and non branded keyword traffic combined yet GA is reporting 157 visits from non provided data so is SEOMoz being very clever and finding a way to decipher this not provided data and allocate it accordingly in the reports ? Or if not what ? Many Thanks Dan
Moz Pro | | Dan-Lawrence0 -
Order of urls in SEOMoz crawl report
Is there any rhyme or reason to the order of urls in the SEOMoz crawl report, or are the urls just listed in random order?
Moz Pro | | LynnMarie0 -
Using the On-Page optimization Report Card
I am curious if there is a way to get the on page optimization report card to not show a grade of "F" for a page that I'm not targeting a particular keyword for? For example my home page has a lot of grade "F's" for keywords that are targeted on different pages.
Moz Pro | | kadesmith0 -
Conflict in reported link data
I have a competitor in a campaign - the campaign report shows 181 linked domains BUT - the site explorer report shows only 15 linked domains. Which is correct? And if the site explorer is correct - how do we fix the campaign report? [URL]]([URL=http://imgur.com/m9xFv][IMG]http://i.imgur.com/m9xFv.jpg[/IMG][/URL]) m9xFv open-site-explorer open-site-explorer competitive-domain-analysis-humphreys-assoc.com-seomoz-pro
Moz Pro | | robertdonnell0 -
Will Social be Incorporated into the New Reports Interface
Just wondering if there are plans to integrate the social media reporting section with the new "Reports" section. Having a social section in the new Reports interface that could show weekly/monthly/yearly Facebook and Twitter interactions would be awesome to have all in one PDF report with the rest of the reporting options.
Moz Pro | | noBulMedia0 -
How do I get the Page Authority of individual URLs in my exported (CSV) crawl reports?
I need to prioritize fixes somehow. It seems the best way to do this would be to filter my exported crawl report by the Page Authority of each URL with an error/issue. However, Page Authority doesn't seem to be included in the crawl report's CSV file. Am I missing something?
Moz Pro | | Twilio0