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
-
Unsolved Is the Keyword Explorer tool down?
Hi, I was supposed to work with researching keywords today. After researching a few queries in the Keyword Explorer, it stopped retrieving keywords and shows the message, “Getting keyword suggestions failed. Please retry your search or refresh this page”. The issue has persisted for a few hours. Thanks in advance.
Moz Pro | | wp-annalv0 -
How do you solve this issue? Pages coming up as [No Title] in Open Site Explorer
I see this when researching top pages. I know for a fact that the pages have title tags that appear to be fine on google and our site, so I'm not sure what the [No Titlle] means or why it's appearing in Open Site Explorer. Thanks!
Moz Pro | | JasonBilog0 -
Open site Explorer CSV output mixed up
If I download a CSV output of the external links and the characteristics of them, the output is mixed up. When I put the data in Columns, some columns are disordered. Do more people experience these problems? Is there some preference I have to adapt? Thanks! SFCTf
Moz Pro | | MartijnHoving820 -
Problem with our connection to your Google Analytics
It is the second time in less then a month when i get that error message. The first time I just removed the connection and re-added it. Is there any other way to fix it? is it the problem on my end or is it on SEOMOZ side?
Moz Pro | | SirMax0 -
Anyone seeing ose csv exports hanging?
None of my reports are completing - even if left to run overnight - anyone else seeing this? There was mention of this in http://www.seomoz.org/q/problems-with-ose-downloads but I get the sense from that thread that the problem was solved back in August.
Moz Pro | | JaspalX1 -
Why is there such a difference between Open Site Explorer and Domain Analysis?
When I look at my links in the Competitive Domain Analysis and I see I have 113,018 Ext followed links but Open Site Explorer shows 3,148. Why is there such a difference? In addition, is there a way to view the External Followed links? I want to see where these 113,018 links are coming from. Thanks, Josh
Moz Pro | | kdieruf0 -
When does Open Site Explorer automatically follow a redirect?
Does anyone know what determines when Open Site Explorer will ask if you meant to type in the redirected URL or when it will automatically change the URL to the www version. example of a site I get asked the redirect question: http://www.opensiteexplorer.org/comparisons.html?site=checkbook.org Oh Hey! It looks like that URL redirects to www.checkbook.org/. Would you like to see data for <a class="clickable redirects">that URL instead</a>? example of a site that redirects automatically: http://www.opensiteexplorer.org/comparisons.html?site=healthleap.com
Moz Pro | | irvingw1 -
Certain Domains no longer recognised by open site explorer
Afternoon everyone (well, it is for me), We've been tracking the linking root domains to our domain for around 6 months now, alongside tracking these domains we have also been engaging in linking building activities. Our initial activities worked quite well with linking domains rising from around 620 to 720 in 3 months. However, recently we have seen those numbers begin to fall away, in many cases it is because certain domains have stopped linking to us, have become no=follow sites or have been archived. But, in some cases we can see the link is still there, and is being registered by other tools such as yahoo or webmaster tools. My question is really, does anyone have a way of working out why a link, that was in the past being registered by open site explorer, is no longer registering and presumably no longer passing over juice to help with domain authority. What kind of signals should i be looking for to tackle a 'decaying' link? Looking forward to hear your thoughts!
Moz Pro | | NigelJ0