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
-
Fresh Web Explorer Question
Hi, I have been using the FWE tool currently in the SeoMoz toolbox but can't seem to do something. I want to search for say 'Flower Pots' but only return results with the extension .co.uk. Is this possible using the operators? Thanks
Moz Pro | | Bondara0 -
Site Explorer Results - Linking Domains Tab
I have a competitor who has the following Linking Root Domains numbers on the Linking Domains tab and was wondering if some one could explain what the numbers mean? opera.com - 205,515
Moz Pro | | bridgeway04-34677
dmoz.org - 97,752 prweb.com - 198,092 quantcast.com - 115,748 tinyurl.com - 443,540 jquery.com - 57,886 URL: http://www.opensiteexplorer.org/domains?site=www.verypdf.com%2F Thanks, Brad0 -
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 -
Finding page authority for a list of sites
I went to Distilled's linklove conference earlier this week. Many of the presenters showed spreadsheets where they had pulled in Page Authority for a long list of sites. What tool can you use to quickly do this? For instance, I want to be able to copy a list of 100 sites into a tool and have it spit out the PA for every site...anybody know how to do this?
Moz Pro | | znotes0 -
A suggestion to help with linkscape crawling and data processing
Since you guys are understandably struggling with crawling and processing the sheer number of URLs and links, I came up with this idea: In a similar way to how SETI@Home (is that still a thing? Google says yes: http://setiathome.ssl.berkeley.edu/) works, could SEOmoz use distributed computing amongst SEO moz users to help with the data processing? Would people be happy to offer up their idle processor time and (optionally) internet connections to get more accurate, broader data? Are there enough users of the data to make distributed computing worthwhile? Perhaps those who crunched the most data each month could receive moz points or a free month of Pro. I have submitted this as a suggestion here:
Moz Pro | | seanmccauley
http://seomoz.zendesk.com/entries/20458998-crowd-source-linkscape-data-processing-and-crawling-in-a-similar-way-to-seti-home1 -
Opensite Explorer CSV Problems
I'm getting a few formatting errors in the CSVs I export from Opensite Explorer, after I've opened them in Excel. Specifically, in an Inbound Links export, there are several merged fields creating new rows. This seems to be caused by line returns in the Title column. At the moment I'm sorting these all out by hand, but it's a bit of a chore when there are lots of records. However it has to be done, because you can't sort of filter properly otherwise. Has anyone else had similar problems. If so. I'd really appreciate any tips to a) stop it happening, of b) speed up / automate the process of cleaning up the CSVs. Many thanks Ben
Moz Pro | | atticus70 -
Traffic Data Lag
Today is 8/29/11. Why does my traffic data still show data from 8/8/11? It says last data update 8/15/11 but there is no 8/15 data showing. I should be able to view 8/22 by now. This is way behind. I'm a newbie so hook me up. What am I missing? It was updating every Monday but not anymore.
Moz Pro | | ranger001 -
Will Open Site Explorer ever show number of links over time?
OSE is an amazing tool, but do you guys at SEOmoz have any plans to develop it so we can track numbers of links over time. I need to demonstrate to clients how the link building is going, and this would be a great quick report to see how many links you found on a given day, month, year, etc. A bit like magesticSEO backlink history graph, but better 🙂
Moz Pro | | timwills0