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.
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
-
How to find the authorities site to link from
Hi It seems getting quality authority backlinks is the main priority to success in your SEO which is also most difficult task as well . How do you find these authority sites that allows you to backlink from them? is there any tools to find good quality sites for backlinks? Thanks
Moz Pro | | Matt-kind0 -
Crawl Diagnostics : Problem of display in Excell.
Hi Mozers, I've just finished watching the Crawl Diagnostics Webinar and when I try to export one of my campaign into the CSV format, I've a display problem into Microsoft Excell. Every headtitles are into the "A" column so, I can't do anything with that : I can't organize the data,... It's totally unreadable. What can I do? Thank you for yours answers. Jonathan
Moz Pro | | JonathanLeplang0 -
Inbound Link Discrepancy: Campaign vs Open Site Explorer
Hello, I am getting starkly different inbound link amounts from Open Site Explorer and my Campaigns tab. Domain 1
Moz Pro | | truckguy77
Campaigns: Total links = 10,895,942 Open Site Explorer - Links = 224,000 Domain 2
Campaigns: Total links = 25,670,287
Open Site Explorer - Links = 157,000 Why would these be so different? For reference, the "Historical Domain Analysis" shows these sites getting exponentially more links starting in February. This is of concern to me. I didn't do anything different in February to get so many more links (especially not in the millions). If anything, I am hoping the "Campaigns" section is simply wrong about this.0 -
Using the 'Organic Traffic Data ' feature.
I don't have access to the clients Google Analytics Password. Can you set it up without being redirected to Google webmasters? Is there a way to insert a simple code into the website and then have SEOmoz double check the code? Thanks so much
Moz Pro | | Robin_Jennings0 -
Open Site Explorer Data
Good afternoon SEOmoz, I first want to congratulate with you for the amazing new look and new features of Open Site Explorer, it's an amazing and valuable tool that I use every day and that has helped me build tons of links for my clients. I have been keeping track of the OPE data on a monthly base and I just noticed something strange. In May 2011, OSE was showing that my client's website had 12,624 links, in July 2011 the website had 14,157 links and today I just ran a new report that showed just 6,401 links. I don't want to believe that in 2 months we lost half of the links, so I was wondering if you guys can give me more insights about this data.
Moz Pro | | Aviatech
Did SEOMoz change the way they measure the number of links? Or is this just a bug or issue they are having with the new version of OSE? Thanks!0 -
Keyword Data from Previous Months
Is it possible to view keyword statistics from previous months. I'm interested in analyzing the trend of particular keywords from the beginning of this year up until the present.
Moz Pro | | DigitalHills0 -
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 -
Bing ranking my non-www version of my site.
My site is ranking #1 on Bing for the non-www version of my homepage, but this is not showing in my ranking stats, since the site is setup in SEOMOZ as www version. Do I have to create a whole new campaign for the non-www version or is there a way to pickup these rankings?
Moz Pro | | pdlcom0