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
-
Competitive Link Comparison vs. Open Site Explorer
I get different external followed links showing in the Competitive Link Comparison vs. Open Site Explorer. The total number of links is different as well. I thought this was the same info - just one tracks ongoing and one is just a "one-off" tool. Is this not the case? Do the count links differently? Thanks! Kevin
Moz Pro | | yandl0 -
Problem with seoMoz keyword tool and rank tracking?
hi all, so i get another problem with rank tracking. We’re unable to retrieve your ranking. and keyword difficulty tool The Keyword Difficulty tool is currently unresponsive due to difficulties with real-time rankings retrievals. We apologize for the inconvenience and are working to fix it. i seem to keep getting this error messages these past 2 days and this is affecting the numbers on my campaign (history n analysis) can someone tell me what's wrong? thanks,
Moz Pro | | BSutandio0 -
How often does Open Site Explorer Update?
How often does Open Site Explorer Update? Just trying to get a rough idea. Great tool btw.
Moz Pro | | seo3210 -
Wordpress tag problem
Hei, Just start using seomoz pro and it's freaking awesome:) I have one question about Crawl Diagnostics and hope you guys can help me out. I just launch my website and i get two errors what greep me out a bit. I don't know how to handle them correctly. I have two duplicate content errors what are caused by Wordpress tag's. If i make more blog posts then i get even more duplicate content issues. how should i handle this "tag" situation? Respectfully, TauriU
Moz Pro | | TauriU0 -
No Local Directory links in Open Site Explorer?
Hi there, I just signed up for seomoz pro today and have been playing around in OSE looking at a number of local business websites that I manage SEO for. For all of them, I have put an endless amount of effort ensuring they have good quality, accurate business listings in all the local directories like yelp, yellowpages, hotfrog, tripadvisor, etc. For most of them, I did this months or even up to a year ago. However, I don't see a single link reported in OSE that is a result of my efforts here. Does OSE not report links from local business directories, or should I be concerned that I'm somehow not optimizing properly, or are these types of links of such little value that they don't get picked up, something else? Thanks for the help!
Moz Pro | | rianDS1 -
Link Diagnosis and Open Site Explorer
I work at a web design firm that's starting to offer SEO to its clients. They want to keep costs down until the SEO side becomes more established, so I've been using mostly free tools to do the SEO. I've been using a website called LinkDiagnosis.com to check backlinks for clients. It says the data is provided by SEOmoz, so I thought it must be pretty reliable. However, I just signed up for the PRO trial to test out all of SEOmoz's tools (& hopefully convince my company to sign us up), and I find that the link information between the 2 tools can be vastly different! Sometimes the number of unique linking domains is very close, but other times it can be off by hundreds, even thousands, with Open Site Explorer typically providing the higher numbers. Is the Link Diagnosis tool really powered with data from SEOmoz, or does it just receive a portion of the data, since it's a free tool? I'm just trying to figure out what will be the most reliable solution for me to keep using, and the discrepancies between the two tools has caused me to question the reliability of both. Thanks, Hector
Moz Pro | | hmunoz0 -
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 -
CSV sheets on new OSE not received by email
Is there still a problem with the new OSE anyone ? I am not receiving the csv reports I am ordering via OSE.
Moz Pro | | blocker04080