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
-
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 -
Is it possible to see Ranking data for longer than one week at a time?
The weekly ranking data is great for short-term analysis, but it would be great to be able to see ranking data in aggregate across an entire month, or 3-month time span. Being able to track ranking fluctuations over that amount of time makes it easier to spot trends and mark changes to website plans and how they worked over time. It also makes it easier to spot visitor trends based on rankings with Google Analytics numbers for keywords that don't get a lot of traffic on a weekly basis. Anyways, I can't seem to find any way to see ranking numbers over a larger timespan other than exporting each weekly ranking report and doing it manually. Is there a better way that I just haven't seen? Does anyone have a better solution that I'm just too stupid to think of? Any help would be greatly appreciated. Thanks!
Moz Pro | | windwardseo0 -
Site Explorer - No Data Available for this URL
Hi All I have just joined on the trial offer, im not sure if i can afford the monthly payments, but im hoping SEOmoz will show me that i also cannot afford to be without it! In my proses of learning this site and flicking through each section to see what things do. However when i enter my URL into Site Explorer i get the following message "No Data Available for this URL" My site should be crawl-able, so how do i get to see data for my site/s. I wont post my URL here, as the site has a slightly adult theme.
Moz Pro | | jonny512379
If anyone could confirm if i can post "slightly adult" sites. Best Regards
Jon0 -
Looking for Advice on SEO for Minimilistic Site
Hi everyone, I found this site and it looks like a great place for us to start, we have just opened the doors to our new website fenwaymedia thats a dot co dot uk. Now Ihave tried to maintain the most minimilistic design throughout but I believe with this comes certain drawbacks - - - - S E O which is why i am here. My thought were that I would draw my clients from the Web Design, web Marketing & Blog page which I will starting in 3 hours be constantly updating. but Im not sure Im doing the right thing. I am trying to target Edinburgh, Scotland although we would take work from anywhere, if anyone could spare us a moment, I would greatly appreciate any help, tips or comments that might help us attain some visibility. Thanks in advance and thanks for looking. Kind regards, Craig
Moz Pro | | fenwaymedia0 -
Is there a way to pull ALL rankings for a site for a set of keywords?
I'm fairly new to SEOMoz, and am looking for a way to pull all rankings for a site with the keywords I've listed, not just the top ranking. So for instance if my site ranks for the keyword "widget maker in MO" in two spots. The current rank report will only show me the top result. I know I can click on each keyword individually and see a full list of the top 50, but I'm looking for a more automated way of doing this (I'm the only SEO at my agency and time is an issue). I previously used Advanced Web Ranking and the tool would like me pull a CSV of the top 30 sites for each keyword I was tracking and then I could just search for my site and pull those results easier. Anyone know of a shortcut or report I should use? Thanks!
Moz Pro | | OsbornBarr0 -
How do I increase domain authority? Real Estate SIte
I have a site that is just a few months old. How do I get the domain authority up?
Moz Pro | | bronxpad0 -
Why doesn't Open Site Explorer recognize the link from my twitter profile?
When I run a report on my competition I'm seeing their link show up in OSE's report under the "Linking Domains" tab, but when I put my site in there, it doesn't recognize my link from my twitter profile. Any ideas?
Moz Pro | | shawn811 -
How long do old links stay in Open SIte Explorer stats?
Hi, In Open Site Explorer has around 2000 External followed links which would be great if it was true. I think the issue is that before my site wasn't appending slashes to the url so I think it was counting links from http://mydomain/page1 to http://mydomain/page2/ as an external link (could be wrong here). I corrected this a couple of months ago but I still seem to have over 2000 External links. When I look at the linking pages many of them are "sans slash" and have old anchor text in the link. How long does it take of OSE to update these stale links it there any way I can prompt it to take aciton?
Moz Pro | | moesian0