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
-
Rankings Report - figures clarifiction
I've noticed a possible discrepancy with my data and the figures in the Ranking Report >> Rankings which leads to this question: In top 3 : 10 On first page: 19 Is this meant to mean 10 of the 19 are in the top 3, or after the 10 top 3 there are 19 more keywords on first page?
Moz Pro | | MickEdwards0 -
Getting my top keywords separated out in SEOmoz reports
I am using the standard functionality to produce weekly Moz reports. There does not seem to be a setting to show rankings of my most important keywords. It would be nice to have those high-level keywords on the first page. For example, I have 200 keywords in an account. I want the report to show on a page my 10 most important keywords. Is there a way to set up a Label to my keywords in order to product a report page just for those keywords?
Moz Pro | | clicktoshop0 -
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 -
Where can I upload my logo for custom reports?
Hi, I've read the custom reports FAQ and it said I can upload my logo for white labeling under campaign settings. I navigated to campaign settings but haven't found the place to upload my logo. Could you please help? Barnabas
Moz Pro | | Barna0 -
SEOMoz Private Message Settings
Hi all, Is there a way to be notified (to my personal email address) when I get sent a private message? Thanks,
Moz Pro | | Unity
Davinia0 -
Setting to import into gDocs an Opensitexplorer CSV report.
That's pretty much it. Been trying to import an inbound links report generated with OpenSiteExplorer with no avail. All I get is a messy spreadsheet. Does any of you happen to know the right settings for a nifty import? Thanks a lot 🙂
Moz Pro | | Ersatz0 -
How long does the seomoz crawl take?
It's been doing it's thing for over 48 hours now and Ive got less than 350 pages... is this norma? It's NOT the first crawl.
Moz Pro | | borderbound0 -
What's Your SEOmoz Favorite?
Obviously, SEOmoz is full of awesomeness. But I'm curious as to what sections, tools, etc. of SEOmoz are the users' favorites? For me, it's a close race between the blog, Linkscape/Open Site Explorer, and the search overlay tool on the Mozbar. What are your favorites?
Moz Pro | | Gyi0