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
-
Open Site Explorer: Facebook Shares, Likes, etc.
I don't fully understand what this means in the report for our site: http://screencast.com/t/aG5jbkYWLA here is our site: www.discountqueens.com & we have thousands of fans & facebook likes and all the time on all our posts. For example yesterday we had 73 likes on this post alone: http://www.discountqueens.com/amazon-ultimate-shrinky-dinks-jewelry-designer-1495/ So here's my questions: Is there an error in the reporting? Are we using a social sharing method that isn't giving us valid credit for these links? What should I consider doing differently & why isn't our likes, shares, tweets & Google+ being calculated into our score?
Moz Pro | | seointern0 -
I have a client with a bit over 100 inbound links but Open Site Explorer shows total links on Subdomain as over 66,000, how can this be?
I have a client www.woodard247.com that shows only a bit over 100 inbound links. using the Open Site Explorer, they are a well trafficed local site and are not doing any grey hat or black hat techniques. However the rankings for their main keywords have suffered recently and we cannot identify any duplicate content or keyword stuffing issues. We have never purchased links or used link building software. Now for the main question: When we run Open Site Explorer it shows only a bit over 100 inbound links on the page and the domain, but the subdomain shows over 66,000 total links! How can this be possible? Could this be a problem? How can I find out what these links are since Open Site Explorer and Seo Spyglass both show only a hundred or so?
Moz Pro | | tjkirgin0 -
Rank Tracker is anyone else having problems with it
Hi, i have been trying to check some ranks with my site www.in2town.co.uk but for some reason over the past couple of days the rank tracker has not been working. I thought it could be a fult with my computer but i have tried a few computers and i am still getting the same responce. Can anyone let me know if they are experiencing any problems
Moz Pro | | ClaireH-1848860 -
How do I get the Page Authority of individual URLs in my exported (CSV) crawl reports?
I need to prioritize fixes somehow. It seems the best way to do this would be to filter my exported crawl report by the Page Authority of each URL with an error/issue. However, Page Authority doesn't seem to be included in the crawl report's CSV file. Am I missing something?
Moz Pro | | Twilio0 -
Site explore reporting error over week
unable to dispaly anchor text error Doh! Roger is still working out the kinks with the new index and is having issues untangling anchor text data. We're currently showing anchor text data from the previous index, but we will update as soon as we can.
Moz Pro | | 1step2heaven120 -
Only 2 internal links in OpenSite Explorer?
In Open Site Explorer´s tab Full list of Metrics I get for the Page Specific Metrics only 2 Internal Followd Links for one of my websites domain URL. I have checked this metric for other websites and I get some surprising results. Most of the websites get an amount which seems logical take the size of the site into account. But there are a couple of sites more for which I get very low results like only 1 or 2 Internal Followed Links! This is strange because the sites do have at least more than a 100 internal pages which are all linking back to the domain and are indexed in Google. I have checked if there is something strange with the robots.txt or htaccess but I havent found anything. So I wonder if this a failure in Open Site Explorer or can there be any other explanation? Anybody with similar experience? aNp83
Moz Pro | | ceesie0 -
Potential site architecture problem.
We are experiencing a problem in which category pages do not appear to be passing Page Authority to subcategory pages. See the example below: Home page has PA of 47 http://www.minespress.com/ The next level category page down has a PA of 34 http://www.minespress.com/category/apparel The next sub category down has PA of 1, and shows no links at all in spite of the fact that we got to it from a category link http://www.minespress.com/category/golf-shirts The page in question is crawlable, is indexed and has nothing that we can see that would be prevent it from showing Page Authority and a link profile using your tools. Do we have a site architecture problem?
Moz Pro | | smines0 -
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