Data from Open Site Explorer to Excel
-
Hello,
Im having a problem with the data I pull off from Open Site Explorer. Everytime I download a report in CSV, when I open it in Excel 2007, all the information is like this:
What can I do to extract the information exactly as it appears in the Open Site Explorer with all the fields in the right place?
Tks guys,
Regards,
Pedro Pereira
[](<a href=)" target="_blank">a> rwMxO.png
-
Thanks Phil, it solved my problem.
I change the regional setting and boom, problem solved!
Cheers!
-
Open site Explorer export directed as a graph data in CSV Format.Each and every connections linking as root domain of the link.Excel to access the link of the URL Metrics APIs so the most perhaps style approach selecting scope and filters for OSE for Excel sorts.
-
My hunch is that your your version of Excel has a semicolon set as the "list separator" rather than the comma. With that being the case, when you try to open the file, Excel doesn't quite know where to separate things.
To help out, I found this great guide for you that provides a few different ways for you to solve your issue.
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
-
Unsolved How Does MOZ Pro Help An E-Commerce Site Gain Rankings?
Added Maximum keywords on Moz Pro - Updated our SERP and optimized metas for all our products on Bookscardsnbikes. We are sorting out bad backlinks - and have google ads + and boosting our seo. And yet - no traffic or customers [minimal] Have been a business for one year. In short: can you take a look at our moz [Site Audit] and explain what we're missing to get our company off of the ground. We are more than okay with criticism - it helps us grow. Our layout and site design is completely fine and what we want. But we think its just a matter of being a new site that we aren't getting the amount of business we COULD have. Is the 200$ a month worth it? What is moz doing to help us grow? Best. Bookscardsnbikes
Moz Pro | | bookscards15520 -
Moz Spam Analysis vs. GWMT Links to Your Site
Hi Moz Community, I have been conducting some link auditing and started comparing the Moz Spam Analysis tool with the links provided in Google WMT. It appears that the Moz Spam Analysis tools shows an aggregate of links that Moz may or may not consider spam, however when you download and look at Google's "Links to Your Site" list it provides every link iteration known to man that's pointing to the target website - without providing any hints as to whether or not a link may be considered spam by Google. The biggest concern I have here is that Google is picking up a lot of links, which I consider spam, that do not appear in the Moz Spam Analysis results. I guess the question(s) I have are: Does it make sense to compare these two data sets? Has anyone else tried this comparison and how did you use the information to make positive changes? Any recommendations when it comes to determining if an external link is spam/hurting/helping a website? Thank you!
Moz Pro | | GoogleDowner0 -
Third crawl of my sites back to 250 pages
Hi all, I've been waiting some days for the third crawl of my sites, but SEOMOZ only crawled 277 pages. The next phrase appeared on my crawl report: Pages Crawled: 277 | Limit: 250 My last 2 crawls were of about 10K limit. Any idea? Kind regards, Simon.
Moz Pro | | Aureka0 -
Links not appearing on Open Site Explorer
My site gained several new inbound links during December and only two of them are not all showing up on the latest Linkscape update. It seems to be the links that were created at the end of the month which are showing up, whereas a handful at the beginning of the month are nowhere to be seen. All the linking pages have been indexed by Google the links are do-follow, and one of the sites in particular is not obsure and has a DA in the 90's. I appreciate the Linkscape doesn't index everything, but I would have thought that more tof the results of my efforts would have shown up in OSE. I'd be really grateful if anyone could explain this to me please. Thanks Ben
Moz Pro | | atticus70 -
Traffic Data Lag
Today is 8/29/11. Why does my traffic data still show data from 8/8/11? It says last data update 8/15/11 but there is no 8/15 data showing. I should be able to view 8/22 by now. This is way behind. I'm a newbie so hook me up. What am I missing? It was updating every Monday but not anymore.
Moz Pro | | ranger001 -
Open Site Explorer missing links
Hi, When the update of Open Site Explorer was released I noticed that the new version was missing a huge amount of links that the old version previously found. This still seems to be the case and it's pretty frustrating as we use the tool for our clients. Is this something that everybody is seeing and if so SEOMoz when do you think you'll have a solution? Many thanks
Moz Pro | | JonathanSmith0 -
Why does open site explorer show me Chinese characters?
Hi there, When using open site explorer to check the anchor text for www.bookvictoriafalls.com I see Chinese characters as anchor text. However, when I do the same for www.bookvictoriafalls.com/ I see normal English anchor text. Coincidentally this domain has dropped from first page rankings to outside the top 50. Is this a spam issue? Open-Site-Explorer.png
Moz Pro | | Robbern0 -
Domain Authority: Sites with lower numbers get higher ranking.
We had a question about your online tools for http://pro.seomoz.org/campaigns/30642 The Domain Authority for http://pucherinsurance.com/ is 67: Higher than most of our competitors such as <cite><cite>bluecross.ca which has a rank of 54. </cite> </cite> We show up lower in the actual search results. An example phrase would be Visitors to Canada health Insurance. We get an A grade for onsite reports and we are working on the duplicate content and titles. We appear to be doing everything right but still rank lower than expected. Any thoughts?
Moz Pro | | northerncs0