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
-
Site visitors dropped off- have tried everything
Hello Moz team....I love the tools but I'm more of a content created for my web site than a developer. So I am super stuck with a major money losing problem. My traffic has nearly gone to zero and I have good content, regular content, no duplicate content, and so on. Can someone help.... Today I disavowed thousands of bad inbound links found in a Moz report Since January I have been fixing pages with missing meta data found in the crawl report In December 2018 I switched over to HTTPS I have no clueeeeeee
Moz Pro | | MattBanes0 -
Why my site so poorly ranks on Google
Hi 🙂 I hope you can help me for my site http://www.majordroid.com/ I really do not understand why my site so poorly ranks on Google. What can I do about that? Are there any errors or something? What can be done about that? Also when I go to the Moz Tools - Open Site Explorer to check how many backlinks I have... It says: 12 Total Links but according to the Google Webmaster tools I have in total 334 links and 138 links to the homepage. see attachment Why Open Site Explorer does not see all the links to my site, which is a possible reason? And last question, what I need to do to remove pages from Google search like this: <cite class="_Rm">/page/2</cite>. <cite class="_Rm">/page/3 and so on...</cite> Thank you 🙂 aK0x345.jpg
Moz Pro | | ivek19870 -
How to make Seo Tools Site serves ?
hello i want to add seo tools at my site for users i want my visitors able to use pagerank checker , link tracker , backlinks checker , etc - and keyword tools , domain tools , Analytics and Reporting. something like http://smallseotools.com/ what scripts i need ? can i do this all with wordpress ? Thanks 🙂
Moz Pro | | Wagdys0 -
SEOMoz SERP Overlay Vs. Opensite Explorer
This may be a simple answer, but when I search for a term and see a website on the SERP, the SEOMoz tool bar shows link data beneath the link. For this site in particular, it shows 300+ links for the root domain and for the page, it shows 8 links. When I put that website in opensite explorer, it shows the same data for the "Page" stats (8 links from 3 root domains), but nowhere can I find where the 315 links from 4 domains comes from. So my questions is why do those links show in the SERP overlay, but not in OSE? il5y9.png
Moz Pro | | GetFoundFirst0 -
How to Use Open Site Explorer
I've used Open Site Explorer here at SEOmoz for the first time and I'm confused by the results. I'm wondering how dated the results are? And, what are they based on? For example, I'm certain my facebook shares and like are higher...same with the twitter links. It seems kind of old?! One of my competitors who gets about 2x more traffic than me DOES have great backlinks. I know that. BUT, it's odd that her facebook and twitter results are what they are compared to mine - they're WAY higher in site explorer AND her links seem on par with her facebook page whereas mine don't. Whereas mine seem WAy Way lower than what they are in reality. She barely tweets and facebooks any more. Maybe once per month. She started out gangbusters, but doesn't do it much any more. That's kinda why I'm wondering if it's based on older stuff and not updated often? Anyone know?
Moz Pro | | annasus0 -
Links from External Sites not Showing on OpenSite or Google Webmaster Tools
Hi, I asked this in another post, but didn't get a solid answer. For several websites I manage, I have access to their Google Webmaster Tools. When I put the site through there, or the link:// or SEOMoz's OpenSite link reporter, I get not even a fraction of the links that I know are pointing to the websites in question. Some of these links are from home pages or side columns, and some are from articles keep within a website, like at Inc.com. I wondered if the links in question were not themselves being indexed, but if I do a very specific search, I can pull them up in the search results. Is it just common knowledge that these link tools are not accurate? And to assume that somehow, search engines really do see all of the inbound links, even if our reporting tools don't. Thanks in advance!
Moz Pro | | lilactree0 -
Domain and Submain : which choice ? (open explorer tool)
Hi, 1/ Please could you tell me why Moztrust and Mozrank give not similar figures for subdomain and root domain ? 2/ Which is the best way for Google webmaster tool for configuring : Sub or Root domain ? 3/ Finally, regarding anchor text, Sub or root domain ? Tks for links or knowledge base about it....
Moz Pro | | mozllo2 -
How Do You Leverage Linkscape Data to Overcome Your Competitors?
Hi everyone...I used Q&A a long time ago when my company had a paid subsription but I haven't used it in a while, so I'm excited! And since the Q&A is apparently addressed to the Moz community, I figured I would embrace it and ask all of the Mozzers out there: How do YOU use Linkscape to reverse engineneer a competitor's website? I understand how to use Linkscape. What I'm looking for is specific filtering or "out of the box" uses of Linkscape to truly understand how a website has obtained it's ranking in the search results. In particular, I'm really curious about how everyone (including those who truly know how Linkscape works, i..e the minds behind it) make sense of the "DJ Passed" #'s or "most important links" criteria. I realize Linkscape is wonderful, but what I've found is that often times the links that "pass the most juice" or the links that are the "most important" AREN'T actually the most important links on a site. For example, I often find that the links that have the highest "DJ Passed" are directories. I could be wrong, but my guess would be that directories actually pass very little link juice. If directories gave as much link juice as the linkscape metrics indicate, then they are by far the best linking source, which I think we all know isn't the case in most instances. To be clear...My intention is not to "debunk" the value of Linkscape...On the contrary, I think it's a wonderful tool and I want to understand it's nuances so I can identify "false positives", use it to get a true picture of a website, and get any tips/tricks from those who've successuly used it to overcome there competitors. Thanks ahead of time!
Moz Pro | | LuminConsutling1