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 detects links from a site that redirects to it? How is this possible?
I was checking external links to a site: scte-brasilien.de/ and was wondering why there are so many links pointing from another domain (reisen-nach-brasilien.com/) although it redirects to scte-brasilien.de/? So when checking the redirecting domain OSE knows its redirecting... The URL you've entered redirects to another URL. We're showing results for scte-brasilien.de/ since it is likely to have more accurate link metrics. See data forreisen-nach-brasilien.com/ instead? How is this possible? best regards
Moz Pro | | inlinear
Holger0 -
How do i fix the problem of having 2 url's splitting my rankings?
please excuse my noobness. i have a nice site, www.soundsenglish.com which I built from scratch and learned by doing. It has lots of nice content and it does ok, my rankings are woeful mostly cos of all the mistakes i made building it...i'll fix that stuff. This stuff i don't know about. from my adsense i get 2 listings www.soundsenglish.com and soundsenglish.com wierdly the second one gets consistently higher paying ads although most of the visitors come through the first but they are both the same landing page same content -as far as i can tell. when i try to find rankings, use the seo tools etc i get diferent scores, so whatever it is, it is splitting the sites - can't be a good thing. i have no idea why this happens and i have some inkling that maybe i need something to do with cannonical redirects or maybe a 301 redirect. both of which i have little idea how to do. If that isn't enough naive blundering about for you, i have a little more... it occurs to me that this prpoblem is probably happening with every page on my site, i.e. the 'juice ' is not getting credited onto that one page. this surely means cannonical redirects but even afterreading up on them idon't quite get it. or rather ido but idon;t get how to apply it to my context.
Moz Pro | | soundsenglish0 -
Adding Disavowed Domains to Open Site Explorer?
Hi, Is there a way to add to the OSE a list of disavowed domains? Also, how often is it refreshed?
Moz Pro | | BeytzNet
I know that the GWMT shows us links on sites that are down for months now. Thanks0 -
Problem in doing seo for a German medical website?
Hi We have been doing seo for http://www.internetapotheke-holland.com/ since last 4 month including onpage and offpage process like link building etc. but not getting a proper output keywords are as follow: xenical holland rezeptfrei xenical Xenical Ohne Rezept Xenical Bestellen Xenical Kaufen Rezeptfrei bestellen Rezeptfrei kaufen Tramadol TropfenRezeptfrei Please could you add some more cool tips so that we can help our client. Thanks & Regards
Moz Pro | | expertvillagemedia0 -
Is anyone having problems with rank tracker
Hi for some reason i am finding semoz site very slow and when i have tried to use rank tracker it is not working. is anyone else finding this
Moz Pro | | ClaireH-1848860 -
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: http://i.imgur.com/rwMxO.png 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 [
Moz Pro | | PedroM
](<a href=)" target="_blank">a> rwMxO.png
0 -
Open Site Explorer: Facebook Likes Accuracy
I show in open site explorer that I have 8 Facebook likes for my domain but I actually have 1500+ Facebook likes. Am I missing something?
Moz Pro | | fibers1 -
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