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
-
Greater Number of Linking Domains in Anchor Text Excel Export?
I exported the anchor text for a domain from Opensite Explorer and when I sum the "Number of Linking Root Domains Containing Anchor Text" it is higher than the total amount of linking root domains for the site. Is this because some domains use multiple anchor text links, so it is counted more than once in the exported spreadsheet?
Moz Pro | | ProjectLabs0 -
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 -
Open Site Explorer: Facebook Likes Accuracy
I show in open site explorer that I have 8 Facebook likes for my domain but I actually have 1500+ Facebook likes. Am I missing something?
Moz Pro | | fibers1 -
How often does seo moz update its link data?
I have lots of recently gained good links that don't show in seo moz, how long does it take for moz trust, moz rank and PR to update?
Moz Pro | | myloseo0 -
Open Site explorer (last 1-3 updates) shows new and wierd results
Hi Moz'ers! I have a questions for you guys. Can you explain why the website "Netspiren" has a lower "domain Authority" than "Duft og Natur"? See screenshot. I know it's a tough question without a detailed analysis, but looking at OSE's data, does the mozrank,moztrust, C-block don't reflect the power of the Domain Authority. What's you take? BTW: "Netspiren" has always had more and better links, and also had a higher Domain Authority. Something about the Domain Authority changed since the past 1-3 OXE updates. Looking forward for your take on this! Have a good weekend! mnRPI.png
Moz Pro | | FrederikTrovatten220 -
Why is there such a difference between Open Site Explorer and Domain Analysis?
When I look at my links in the Competitive Domain Analysis and I see I have 113,018 Ext followed links but Open Site Explorer shows 3,148. Why is there such a difference? In addition, is there a way to view the External Followed links? I want to see where these 113,018 links are coming from. Thanks, Josh
Moz Pro | | kdieruf0 -
[No Data] Open Site Explorer Top Pages WordPress fix?
Some of my Open Site Explorer Top Pages http://www.opensiteexplorer.org/drho.ro/a!toppages have [No Data]. How do I fix this? I use WordPress and these are .pdf files I uploaded to my server and 301 redirects I created using the Pretty Link Pro plugin
Moz Pro | | drhoro0 -
Historical Linkscape/OSE data available?
Hey Mozzerati, I'm curious if there's a way to expose and analyze historical data from each previous Linkscape/OpenSiteExplorer (OSE) update. Essentially, I'm looking for something similar to MajesticSEO's Backlink History tool that can show you both daily links over a short time as well as cumulative links over a long period. I think the utility of such a tool is to see which competitors have gained many links over a short period, signalling that they're engaging in some form of link-building/-buying/-baiting activity. Is there any way to yield this data (other than to record it manually after each Linkscape/OSE update) from SEOmoz PRO tools?
Moz Pro | | jcolman0