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
-
Is it possible to block Moz from crawling sites?
Hi, is it possible to stop Moz from crawling a site at the server level? Not that I am looking to do this or anything, but here's why I'm asking. I have been crawling a site that is managed (currently by 2 parties), and I noticed that this week pages crawled went from 80 (last week) to 1 page!! I know, what? See my image attached... and the issues all went to zero "0"....! So is it possible that someone can't prevent Moz from crawling the site at the server level? I checked the robots.txt file on the site, but nothing there. I'm curious. dYNUwjd.jpg
Moz Pro | | co.mc0 -
Quarterly Reports Show Odd Data
I've pulled a quarterly report for a client, and it's showing very odd numbers. I'm monitoring 58 keywords - and the current keyword ranking report from last week says that there are 21 keywords in the top 3 and 33 on the first page. But the quarterly report says that there are 50 in the top 3 and 70 on the first page??? What's up with this?
Moz Pro | | Bigheadigital0 -
Does SEOmoz work for fully secure sites (https)?
We have created a large file sending service (https://digitalpigeon.com) and for obvious reasons we have secured the entire site (we used to have a trial file send form on the homepage so it made sense to secure everything with 301 redirects from http to https) Because we, somewhat naively, started out with a memorable name and domain - Digital Pigeon - where all of our competitors just keyword stuffed their domains we don't really rank for any useful keywords yet. For me, building domain authority via links is more important right now that any on page SEO that is going to be trumped by google's infatuation with domain keywords anyway. Here's the problem though, it seems SEOmoz and even Google Webmaster Tools and Bing Webmaster Tools all fail to take into account inbound links for both http and https for any reports or analysis! I'm wondering if utilising SEOmoz PRO for keeping tabs on our MozRank is pointless if it's not accounting for all inbound links
Moz Pro | | DigitalPigeon0 -
Which of these is the best guest blogging site
Which of these is best: http://www.guestblogit.com/http://www.bloggerlinkup.com/ http://www.Myblogguest.comhttps://www.helpareporter.com/ I like the look of MyBlogguest.com so far. We are wanting to guest write articles to be published on quality sites in exchange for one or two links back (link building) Also, how do you choose what article topics to write. So far my strategy is to look at the industry's biggest sites and to use the "Top Pages" tab in OSE to look for hot topics. Thanks!
Moz Pro | | BobGW0 -
Link from Dr. Oz web site not being seen, what are we doing wrong?
Newbie so this may be SEO 101... Quick back story: My wife Lauri is a Dream Expert who has been on over 5,000 radio shows, TV shows like Good Morning America, the Today show, the View, in major magazines and newspapers, the list goes on and on, I'm not bragging actually the opposite. Lauri barely exists online and to top it off we don't seem to be getting any "link juice" from some big sites that have linked to us. Here is just one example of many: Our site: theDreamZone.com Here is a page on Dr Oz site that links to us, anchor text at top right "Click here": When you use On site Explorer this link isn't there, what are we doing wrong? Our plan is to build a new site (LauriTheDreamExpert.com) and get these links and many others pointing to us correctly so she can get the exposure she's earned. Lauri was also on the Dr Oz TV show : Watch it if you like. Thanks for any wisdom, Mike
Moz Pro | | Mike-Dream0 -
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 -
Canonical issue in open site explorer
When I look at my back links in OSE, I see two landing pages on my site that are really the same page. www.mysite.com/ and www.mysite.com/(affiliate code here) These show different inbound link characteristics and page authority. The page in question has a rel=canonical tag. Am I doing something wrong?
Moz Pro | | EugeneF0 -
Open Site Explorer CSV reports
Hello, Small question about the Open Site Explorer. on August 24th I've been trying to create several CSV reports which I knew would take a few days. But now, almost a week later when I check Open Site Explorer > Recent CVS reports it tells me it's still saving data. It's been saving data for 4 days now. Am I missing something, is this a bug, do I have to do something or should I wait a little longer? Thanks in advance, Dennis Tappij Gielen Retail&Clicks JFwMt.jpg
Moz Pro | | RetailClicks0