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
-
Now our site is ready what's next
Site is all inxed in google, with analytics and webmaster tool. No error in all our 5000 products pages So where do i start my organic seo? What should I read first? Its an online store for retailler only but we still want people to learn about the product or find a store.
Moz Pro | | koloss
We have made 300 original video on youtube with a full description these video are also associated in our site in each respective product. I know our competitor. So now everything is clean and ready. How do I start seo, we have no external link at all. Wich would be the first best step to do. Regards, Bruce0 -
Infographic distribution sites, ideas & tools
What is the best way to get a infographic distributed for pure marketing? Is there a good way to get both digital and news related channels? big-mistake.php
Moz Pro | | jdcline1 -
Moz vs google data conflict?
Hi there, I am doing an SEO site audit for a client(giveaway, and here is the problem: when performing site:domain.com on google --> 13,800 pages were found When I see this number it seems to be a bit too much compare to the links i checked on integrity(link check for broken links) which gave me a result of 1291. I digged in more into the Google results and saw hundreds(maybe thousands) of pages that are blocked by robots.txt. So I am thinking, ok this is it, thousands of pages can't be crawled by the search engines. Here is the big BUT though, then I check at my moz crawl (see attachment) and no pages are blocked by the SEs, and then look at the dups, only 23 recorded?? Is Moz not crawling properly the 13,800 results that google finds or is this some magical phenomenon happening here? I am really confused here that is why I need some help here! Thank you guys! A990Hu4.png k842AOn.png
Moz Pro | | Ideas-Money-Art0 -
Indexed sites
Hello I´m a newbie here on seomoz. My question is just simple but i need to be sure about that:Refering to the report which you can create in the "crawl diagnostic summary". Does the CSV export lists all and ONLY the URLS which are in the google index?If not: does a report is available where all and ONLY the URLS are listed which are in google index?Many thanks! Henrik
Moz Pro | | drgoodcat0 -
Open Site Explorer & SEOMoz Bar for Chrome Showing Different Numbers
When I run a report on OSE checking for linking root domains, the number is always different from the number of root domain links that the SEOMoz bar shows in Chrome. For example on OSE a site shows 88 root domain links, but in the SEOMoz bar, it shows 110 root domain links. I've tested this issue with several sites and there is always a discrepancy in the number of root domain links. Does anyone know which one is actually correct and why this might be happening? Thanks.
Moz Pro | | torontojon0 -
Does SEOmoz work for fully secure sites (https)?
We have created a large file sending service (https://digitalpigeon.com) and for obvious reasons we have secured the entire site (we used to have a trial file send form on the homepage so it made sense to secure everything with 301 redirects from http to https) Because we, somewhat naively, started out with a memorable name and domain - Digital Pigeon - where all of our competitors just keyword stuffed their domains we don't really rank for any useful keywords yet. For me, building domain authority via links is more important right now that any on page SEO that is going to be trumped by google's infatuation with domain keywords anyway. Here's the problem though, it seems SEOmoz and even Google Webmaster Tools and Bing Webmaster Tools all fail to take into account inbound links for both http and https for any reports or analysis! I'm wondering if utilising SEOmoz PRO for keeping tabs on our MozRank is pointless if it's not accounting for all inbound links
Moz Pro | | DigitalPigeon0 -
Excel tips or tricks for duplicate content madness?
Dearest SEO Friends, I'm working on a site that has over 2,400 instances of duplicate content (yikes!). I'm hoping somebody could offer some excel tips or tricks to managing my SEOMoz crawl diagnostics summary data file in a meaningful way, because right now this spreadsheet is not really helpful. Here's a hypothetical situation to describe why: Say we had three columns of duplicate content. The data is displayed thusly: | Column A | Column B | Column C URL A | URL B | URL C | In a perfect world, this is easy to understand. I want URL A to be the canonical. But unfortunately, the way my spreadsheet is populated, this ends up happening: | Column A | Column B | Column C URL A | URL B | URL C URL B | URL A | URL C URL C | URL A | URL B | Essentially all of these URLs would end up being called a canonical, thus rendering the effect of the tag ineffective. On a site with small errors, this has never been a problem, because I can just spot check my steps. But the site I'm working on has thousands of instances, making it really hard to identify or even scale these patterns accurately. This is particularly problematic as some of these URLs are identified as duplicates 50+ times! So my spreadsheet has well over 100K cells!!! Madness!!! Obviously, I can't go through manually. It would take me years to ensure the accuracy, and I'm assuming that's not really a scalable goal. Here's what I would love, but I'm not getting my hopes up. Does anyone know of a formulaic way that Excel could identify row matches and think - "oh! these are all the same rows of data, just mismatched. I'll kill off duplicate rows, so only one truly unique row of data exists for this particular set" ? Or some other work around that could help me with my duplicate content madness? Much appreciated, you Excel Gurus you!
Moz Pro | | FMLLC0 -
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