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
-
Moz can't see my link from an external site
Hi, I'm hoping someone can shed some light on this. I've had a followed link created from http://www.dubaisharks.com/ pointing to my website - http://www.yallarugby.com but in the reports it doesn't show that there is a link coming fro this website. The link has been active for a few months now, but still no record of it. Any ideas?
Moz Pro | | SeoSheikh0 -
How do you search for mentions of your brand without searching within your own site
We have a social network site and we monitor mentions. However, when we search we are finding content from our site being included. How do i filter the content to exclude my site.
Moz Pro | | seoworx1230 -
Open Site Explorer and Escaped Fragments
Does OSE have the ability to crawl AJAX pages utilizing Google's escaped fragment directive? I ask because I'm seeing all our AJAX built pages returning HTTP status codes of 404 when I run OSE reports. See for yourself
Moz Pro | | RyanOD0 -
How to push negative product review sites down.
Hi Guys, One of my respected clients have some issues with negative product review sites coming up when they search their brand name on google. So for an exmaple, when I search for Company Name on google, the 3rd and 4th results are angry customer reviews. This is harming my clients brand so bad. My questions are, 1. What should I do to push these results down. I am happy to do pretty much ANYTHING to push these sites down. 2. I'm also thinking of doing a blog for this client for SEO purposes and wondering the pros and cons of having the blog as a subdomain vs subfolder. Which will help me to again, push the negative site links down. Thanks
Moz Pro | | Uds0 -
Tool bar - Analyse page - Link data
Hi all, Need a little help to understand this link information, if you go to our toolbar it show 1.6 million links on 224 root domains. when you analyse the page using the Tool bar. the link data show the page as having over 3000 internal links but when you go page attributes it shows a more complementary 92 page links we have a menu to all our pages and I am wondering if this is being registered in its entirety
Moz Pro | | LocksOnline0 -
Our recently searched Open Site backlink reports are identical to last months across multiple clients. Why is this happening?
When processing the backlink data of our clients for this month (searches done on 28th December), we're finding that the information gathered from Open Site explorer is identical to the data that was found on searches done at the end of November. It appears to have happened for the reports we use for every single client so it must be more than a coincidence. From our perspective, it's almost as if no data has been tracked since the last time we gathered backlink reports. Could you help us get to the bottom of this?
Moz Pro | | queryclick0 -
GWT data v SEO Moz data
I'm sure there's a simple explanation but I can't find it - Looking through the GWT avg position data v SEOMoz ranking data and Market Samurai data there is a large discrepancy. For one term that we hold #1, and have held for a month or two GWTis showing that the avg position is 180 (and down 30). Any reason you know of why the GWT avg position data would be so out of whack with our SERP's and other data? Thanks.
Moz Pro | | MrPaulB0 -
Open Site Explorer vs. Linkscape... without mozRank passed how do you measure link value?
Hi all, Since Linkscape was retired we've been struggling without the mozRank passed data for our competitor research. However, I've read that it wasn't a particularly reliable metric to go on so my question is: what makes a link more valuable, in your opinion? I'm trying to work out the relation between Page Authority / Domain Authority / Number of Links etc., ideally to come up with some form of ranking system where we can say: Overall link value = ( (A x Page Authority) x (B x Domain Authority) x (C x Number of Links) ) / Number of Linking Domains or something like that. Is this a good way to go about it? What do you guys look at when using the OSE data? Thanks in advance for your help!
Moz Pro | | OmarKattan0