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
-
Can check my site
can you please tell me what should I do with this site I trying a lot to solve its issues. the link is here https://alazharquranteaching.com/
Moz Pro | | saharali150 -
Difference between Open site Explorer's Root Domain and Basic SERP Report's Linking Root Domain?
Why show different Linking Root Domain open site explorer and SERP of any websites? Open Site explorer show different linking root domain and Basic SERP Report show different linking root domain of any website url, who is the correct and why it is show different linking root domain?
Moz Pro | | surabhi60 -
Cleaning Up Bad 301 External Links From Old Site
A relatively new site I'm working on has been hit really hard by Panda, due to over optimization of 301 external links which include exact keyword phrases, from an old site. Prior to the Panda update, all of these 301 redirects worked like a charm, but now all of these 301's from the old url are killing the new site, because all the hyper-text links include exact keyword matches. A couple weeks ago, I took the old site completely down, and removed the htaccess file, removing the 301's and in effect breaking all of these bad links. Consequently, if one were to type this old url, you'd be directed to the domain registrar, and not redirected to the new site. My hope is to eliminate most of the bad links, that are mostly on spammy sites, that aren't worth linking to. My thought is these links would eventually disappear from G. My concern is that this might not work, because G won't re-index these links, because once they're indexed by G, they'll be there forever. My fear is causing me to conclude I should hedge my bets, and just disavow these sites using the disavow tool in WMT. IMO, the disavow tool is an action of last resort, because I don't want to call attention to myself, since this site doesn't have a manual penalty inflected on it. Any opinions or advise would be greatly appreciated.
Moz Pro | | alrockn0 -
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 -
My domain authority is 1, and I am not seeing any links to my site.
I know that there are links to my site, but nothing shows up. My website is www.mullinsgeoffrey.com. I have tried with and without the www. I am using wordpress for this site, but competitors are as well, and there authority seems fine. is there a hidden setting somewhere that is screwing things up?
Moz Pro | | mullinsgeoffrey0 -
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 -
Is the Open Site Explorer Tool working right now?
Is the Open Site Explorer Tool working right now? I keep getting directed to a sign-up page.
Moz Pro | | LarryEngel0 -
Open site explorer - Analysing competitors links
When using open site explorer to analyse my competitors links, when going through them, I would click them to have a look at them. Almost all of the ones I clicked on something started to download on my computer and would be a blank page or the tab would disappear when the download begun. What is this? Why have they done this? Is this bad practice? Thanks
Moz Pro | | CompleteOffice0