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
-
Unsolved How Does MOZ Pro Help An E-Commerce Site Gain Rankings?
Added Maximum keywords on Moz Pro - Updated our SERP and optimized metas for all our products on Bookscardsnbikes. We are sorting out bad backlinks - and have google ads + and boosting our seo. And yet - no traffic or customers [minimal] Have been a business for one year. In short: can you take a look at our moz [Site Audit] and explain what we're missing to get our company off of the ground. We are more than okay with criticism - it helps us grow. Our layout and site design is completely fine and what we want. But we think its just a matter of being a new site that we aren't getting the amount of business we COULD have. Is the 200$ a month worth it? What is moz doing to help us grow? Best. Bookscardsnbikes
Moz Pro | | bookscards15520 -
How do YOU use site explorer?
I normally use open site explorer to identify links that competitors of my clients have and sometimes this gives me what I call 'some low hanging fruit' to go after. (and of course links that are more challenging to get) I don't know why this didn't occur to me sooner. If my client is a chiropractor why not look at the links for 50 or 100 of the top rankings chiropractic sites all over the US? This would HAVE to uncover a wealth of blogs to comment on that have good authority, great industry associations, publications, forums - a whole wealth of items. It made me wonder how many people use site explorer like I have been (top 3-4 competitors that your client has) or identifying links pointing to LOTS of competitors? How do you use it? Couldn't you almost base an entire link building campaign using OSE? Why would this be a bad idea if not? Just some random thoughts. THE WEEKEND IS ALMOST HERE - Have a great day everybody! 🙂
Moz Pro | | Mrupp441 -
Why isn't there any link analysis data in my pro dashboard?
Hi! I've had a pro account for almost a month now and there still isn't any data for my site in the competitive domain analysis section of the pro dashboard. Am I doing something wrong? Bvxj4.png
Moz Pro | | rhmio0 -
I can't find any inbound links that I know I have on open site, ahref or majestic. Does anyone know why?
Since the linkscape update before Christmas I have built a couple of links to fairly high quality sites. I can't find them on open site though or the other tools I mentioned. I'm a bit concerned there is an issue with my site. Does anyone have any idea why? I'm stumped. My site: www.emporiumofmanliness.co.uk
Moz Pro | | EmpofMan0 -
What do you use for site audit
What tools do you use for conducting a site audit? I need to do an audit on a site and the seomoz web crawler and on page optimization will takes days if not a full week to return any results. In past Ive used other tools that I could run on the fly and they would return broken links, missing htags, keyword density, server information and more. Curious as to what you all use and what you may recommend to use in conjunction with the moz tools.
Moz Pro | | anthonytjm0 -
Open Site Explorer Backlink Numbers Wrong?
So, I have a new site that we are currently building links for, lots of hard work. Anyway, I was a bit shocked when I viewed my site through Open Site Explorer and found only 4 backlinks!!!!! Alexa.com, Majestic, and Google Webmaster Tools don't show the exact same numbers, but their figures are all MUCH higher, 4 to 566 for example. What gives Site is www.powerequipmentplus.com for those who want to look themselves. Thanks for your time and concern.
Moz Pro | | DRPower0 -
Looking to Hire an SEO Expert for Travel Site
Hello Everyone, I hope this is OK to post here. I run a travel website and we operate tours abroad. We are slowly expanding after nearly 10 years in the field. I started the company from scratch and currently do my own website design and SEO work. However, over the last couple of years I've lost the SEO connection due to being so darn busy. I started account here with SEO Moz in order to get the ball rolling again. We continually rank high for keywords, publish superb content by great writers, and overall are doing fine. I would just like to ensure this keeps happening and that we have an expert on board to help us in sustainable organic SEO practices. What I'd like to do is hire an SEO expert to help with our site. It might be part time (10 or so hours per week, perhaps?) Anyhow, I would like if this person used SeoMoz and really had their fingers on the pulse of the SEO world. I want all white-hat SEO, help with page optimization, internal link structure, and help getting quality external links. I know that over optimization is something that is now on the forefront of SEO work, so of course keeping this in mind helps. I would like to be kept up to date (perhaps weekly overviews of data and how we are doing) and am willing to make changes as quickly as needed on the site. I would like to see how we rank with competitors and what we need to do to stay on top - for the long term (no short sighted decisions). I want to learn as we progress, not because I want to do the SEO work myself, I just enjoy knowing what is going on. I will not micromanage. I am too busy for that : ) I am not sure what amount SEO experts are paid, but I have a slightly flexible budget. I really want someone will communicate when needed and is thorough in their responses. Attention to detail is a must. I would prefer an SEO expert located in the US but who also knows how to access / think about markets abroad (Canada/UK/Australia). I suppose we can discuss pay once I have a shortlisted group. I am looking to hire and work with someone starting pretty much immediately (even in May). For starters, I suppose our budget might be $500 to $1500 per month. For the first month or so, we might offer payment on a stipend basis just so we can ensure whoever is hired is the perfect fit. It would be great if this person had worked on travel sites before or has at least traveled abroad a few times. But, no worries either way. Thanks so much! Thomas at [email protected]
Moz Pro | | journeybeyondtravel0 -
Does it really take 3-7 days to crawl a site?
This is what you say on your website: Please note: depending on the size and speed of your site, it may take between 3 and 7 days to complete your crawl. Are you guys kidding? This is unacceptable for almost all of my deadlines, and I suspect 99% of the SEO world... you can fly to the moon faster.
Moz Pro | | rldonnell0