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 backlink results different that MajesticSEO... why?
When checking the number of external links linking to a site, Open Site Explorer and MajesticSEO give completely different results. In one case Open Site Explorer is saying the website has: "49 Total Links" and MajesticSEO is saying the website has: "6,143 External Backlinks (in the last 5 years)" and "497 External Backlinks (in the last 90 days)" Does anyone know why this is?
Moz Pro | | conor10050 -
Link from Gizmodo disappeared from Open Site Explorer
Hi, I have been using OSE to check competitor links, DA, PA etc. And recently noticed that an author at Gizmodo was kind enough to link us to a blog post of his. This is great news as Gizmodo has a DA of 94 and a PA of 50 (Which is pretty big compared to our DA of 30 and PA of 42). The link to the post is here: http://gizmodo.com/5956401/everything-you-need-for-the-best-trick+or+treating-house-in-the-neighborhood And the link to our website is: http://www.electromarket.co.uk/lighting-effects/lighting-effects/strobe/ffa0144 It was showing on OSE for the past few days but now it has vanished and it is showing channel5 (TV Channel in the UK) as the highest DA linking to us, which is still pretty good. But I just want to know why the link has stopped displaying on OSE 😞 Any help or insight is appreciated! Tom
Moz Pro | | tomhall900 -
Site Explorer shows links as followable but they have nofollow tags
Hello, I am looking at site explorer and sites linking to my site moneyfact.co.uk. I've got thousands of links showing as 'followable' but when i check them they have rel="nofollow" tags. e.g: http://www.dianomioffers.co.uk/partner/moneyfacts.co.uk/brochures.epl?partner=93&partner_id=93&partner_variant_id=33 Why would they show as followable when the links are nofollowed? Thanks Steve
Moz Pro | | SteveBrumpton0 -
Open Site Explorer & SEOMoz Bar for Chrome Showing Different Numbers
When I run a report on OSE checking for linking root domains, the number is always different from the number of root domain links that the SEOMoz bar shows in Chrome. For example on OSE a site shows 88 root domain links, but in the SEOMoz bar, it shows 110 root domain links. I've tested this issue with several sites and there is always a discrepancy in the number of root domain links. Does anyone know which one is actually correct and why this might be happening? Thanks.
Moz Pro | | torontojon0 -
Open Site Explorer Video Broken?
Hey, I went to watch this Open Site Explorer video, and found that I can't see any video - but I can hear the audio? http://www.seomoz.org/webinars/using-open-site-explorer-to-uncover-new-marketing-opportunities Wondering what's going on. Can anyone help? Thanks a bunch
Moz Pro | | naturalsociety0 -
Why does the CSV report on OSE limit the number of links I can download to less than it should?
I run an inbound link report for the domain www.acornstairlifts.co.uk on OpenSiteExplorer.org using the following filters: Show: All Links from: only external Pages to: pages on this root domain Show links: ungrouped It says that there are around 30,678 links for that query. I then go to the advanced tab, and run a report using the same filters, but when I click download report I only get 2874. I've run this for the past 2 days and I get the same. Why?
Moz Pro | | Brett-Harland0 -
What software can I use on my Mac to open and read a SEOMoz CSV exported file?
I do not want to buy XL or Pages just to read the CSV from SEOMoz. So I bought an app on the AppStore... and this app is unable to read the CSV from SEOMoz. Since I already wasted $2, Id rather avoid to waste more (and avoid that to others too!). What software is recomanded to open these CSV files? Also, I tried Google Docs, but I bumped in their 400K cells limit 😞
Moz Pro | | jgenesto0 -
Open site Explorer Findings??
On OSE, I am comparing two websites(A and B) and one has a page authority higher than the other (35(A) vs 36 (B)), but all the linking metrics are in favor for website A except for the linking C block (A has 11 and B has 12). The website B is ranked in page 1 for couple competitive keywords whereas the website A don't show up in the search at all. Why is that? Does B have better content and is more kw focused?
Moz Pro | | Ideas-Money-Art0