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
-
Thanks Keri,
I think this might be user error!
The problem only seems to occur if I import the CSV into an exisiting Excel spreadsheet. If I directly open the same CSV in Excel then it formats as expected.
So my mistake it seems. Sorry for wasting anyone's time!
Ben
-
This sounds like something that the help desk should know about so they can fix it on their end. Could you please each send them an email at help@seomoz.org with the details and maybe a sample CSV?
Thanks so much, and sorry for the troubles.
-
Hi Ben,
I have the same problem, I think it can be the commas, but the way I choose to solve it is open it in numbers with a macbook pro...
If somebody know how to solve these problems, please respond to this post!
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
-
Opensiteexlorer - Download CSV show different links
Making backlink report, got results -> Download csv Open downloaded csv in excel, it is different links set inside - copied some urls from the web interface and could not find them in excel using Ctrl+F... wtf?
Moz Pro | | Liston810 -
Open Site Explorer and Escaped Fragments
Does OSE have the ability to crawl AJAX pages utilizing Google's escaped fragment directive? I ask because I'm seeing all our AJAX built pages returning HTTP status codes of 404 when I run OSE reports. See for yourself
Moz Pro | | RyanOD0 -
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 -
I'm seeing duplicate links listed in open site explorer. Can anyone explain why this might be happening?
For each link listed in Open Site Explorer, I am seeing two identical entries. You can see why this might be a problem for both workflow and data accuracy. Any ideas why this might be happening? Is there a setting or filter that I'm missing?
Moz Pro | | StephenEggett0 -
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 -
Open Site Explorer Question- Link Value?
One of my backlinks is from a site that has a page authority of 74. However, the domain is a domain I purchased and 302'd to my current main domain. What I'm wondering (without getting into why a 301 is better than a 302) is this: does OSE have any tool that shows if there is actually value in a link? My assumption is that despite this domain having a PA of 74, the 302 is not passing over any value. To be clear, I understand that a 302 doesn't pass over any SEO value, but my question is whether or not OSE shows the value of a link? Thanks!
Moz Pro | | RodrigoStockebrand0 -
Missing back links in Open Site Explorer?
I'm looking at the Open Site Explorer for my site, and it shows 9 links to my site, all from 2 domains (showing all links from all pages and for both www and not www version of my domain name). But I know for sure that there are other sites linking to my site. Are they not there because they are not important or because the links have not been crawled yet?
Moz Pro | | jsoldi0
