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
-
Site Crawl Error
In moz crawling error this message is appears: MOST COMMON ISSUES 1Search Engine Blocked by robots.txt Error Code 612: Error response for robots.txt i asked help staff but they crawled again and nothing changed. there's only robots.XML (not TXT) in root of my webpage it contains: User-agent: *
Moz Pro | | nopsts
Allow: /
Allow: /sitemap.htm anyone please help me? thank you0 -
Why is OSE showing no data for this URL?
Hi all, Does anyone have any ideas as to why OSE might not have any data for this URL: http://www.ccisolutions.com/StoreFront/product/shure-slx24-sm58-wireless-microphone-system-j3 It is not a new page at all. It's been on the site for years. Is OSE being quirky? Or is there an underlying problem with this page? Thanks in advance for any light you can shed on this, Dana
Moz Pro | | danatanseo0 -
Can you explain social indicators in Open Site Explorer
My Google +'s for my domain were 403 last month and 35 this month.... Based on this I'm assuming OSE's numbers are not cumulative. Are they based on the previous month or a different time period? Any explanations would be helpful. Thanks!
Moz Pro | | theLotter0 -
Open Site Explorer, Which is the right link number?
Hi SEOMozers, I am trying to check a record of links to one of the websites I help look after. One problem with the site is the home page automatically redirects to /home which seems to make OSE give some weird results. I can give out the domain if need be but I would rather not if I can help it 😉 To sum up what's happening when you put the domain into OSE with the /home then I get the social figures but the link number is right out saying the site has 200 links. Typing in the domain without the /home brings up no social figures and 15k links which looks more correct. Also OSE has the notification about the redirect and if I'd like to go to the /home version. The weird thing is however is if I change the filter to 'Pages on this root domain' which should show all links pointing to the website, the figures don't change...? Has anyone experienced this? Any solutions? Or is it a known bug? Cheers for any help in advance!
Moz Pro | | thisisOllie0 -
How do you solve this issue? Pages coming up as [No Title] in Open Site Explorer
I see this when researching top pages. I know for a fact that the pages have title tags that appear to be fine on google and our site, so I'm not sure what the [No Titlle] means or why it's appearing in Open Site Explorer. Thanks!
Moz Pro | | JasonBilog0 -
Sometimes we could not download all the data of inbound links from all linking domains
Sometimes we could not download all the data of inbound links from all linking domains. (Around tithe.) Don't you have any idea?
Moz Pro | | crossfinity0 -
Old Incoming Links Redirected to new pages are not Being Factored on the Open Site Explorer
Hi, My website has been online since 1994. We have old links pointing to pages that no longer exist so what we have done is to create redirects to the specific page where the content is being displayed now. However, when we use the Open Site Explorer, the linking root domains do not show those sites that contain old links pointing to our domain. One good example of this one is: dmoz.org. Am I improperly handling the redirects? Or, what do I have to do so that old links that are being redirected to the new pages where the information is are accounted when calculating domain authority and trust? Thanks, Alex
Moz Pro | | costarica.com0 -
No data showing in SiteExplorer
For this site: www.cooperator.biz/ I see no backlinks in SEO Moz Open SiteExplorer but Majestic SEO is showing 13 unique domains linking to it. I regularly encounter zero data for sites that I know have backlinks, why is this? If it's a problem with crawling them, why would I continue to use SEO Moz when other SEO services are showing me links? Kind regards, Rich
Moz Pro | | Boogaloodoood0