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 -
Difference between Open site Explorer's Root Domain and Basic SERP Report's Linking Root Domain?
Why show different Linking Root Domain open site explorer and SERP of any websites? Open Site explorer show different linking root domain and Basic SERP Report show different linking root domain of any website url, who is the correct and why it is show different linking root domain?
Moz Pro | | surabhi60 -
I need an interlinking report for my site, is there a report in Moz or another application that tell me how all of my pages are linked to other pages on my site?
I am in the process of doing a redesign for one of my sites. I need an interlinking report for my site. Is there a report in Moz or another application that tell me how all of my pages are linked to other pages on my site?
Moz Pro | | seoflorida0 -
Open Site Explorer Says I have 1,627 inbound links, but only downloads 275\. Am I missing something?
Is there a feature i'm missing out on here? I want to download the complete link profile, but I only see 275 of 1,627 links when I export to CSV. Any guidance would be appreciated!
Moz Pro | | lipoweb0 -
Usable to set up campaign because site cannot be
I don't understand this message. i never had problems with other sites and now I get problems with this message when trying to set a campaign twice for 2 different sites. I received the same message twice. What do I do? Help! We have detected that the root domain xxxxxxxxxxxxxxxxxxxx does not respond to web requests. Using this domain, we will be unable to crawl your site or present accurate SERP information. Thanks.
Moz Pro | | mcuneo0 -
Bulk OSE Open Site Explorer Tool?
I am trying to do some spring cleaning for a client and hoping to prune any unnecessary domains. Is there a tool that will check, in bulk, these domains through Open Site Explorer? I've looked through all the different Excel spread sheet apps and google doc apps but they are incredibly buggy if they work at all since SEOmoz changed their data limits. Maybe a new tool has been updated in the last few months that I am not aware of. Thanks!
Moz Pro | | kerplow0 -
OPen Site Explorer listing criteria?
Checking link data for a potential client who has given me access to their websmaster tools account, I've noticed that Google list over 150,000 "Links to Your Site" but yet OSE only reports a tiny fraction of this number.
Moz Pro | | G-DC
I have manually verified that there are in fact direct links from the sites that are listed in Webmaster Tools but not in OSE. Does OSE discard some links? Is there a reporting lag? Does anyone know why there would be such a large discrepancy?0 -
Only 2 internal links in OpenSite Explorer?
In Open Site Explorer´s tab Full list of Metrics I get for the Page Specific Metrics only 2 Internal Followd Links for one of my websites domain URL. I have checked this metric for other websites and I get some surprising results. Most of the websites get an amount which seems logical take the size of the site into account. But there are a couple of sites more for which I get very low results like only 1 or 2 Internal Followed Links! This is strange because the sites do have at least more than a 100 internal pages which are all linking back to the domain and are indexed in Google. I have checked if there is something strange with the robots.txt or htaccess but I havent found anything. So I wonder if this a failure in Open Site Explorer or can there be any other explanation? Anybody with similar experience? aNp83
Moz Pro | | ceesie0