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 -
Problem with On-page
I have an issue. I have added 5 keywords but when i go to the "on page" tab. They are not there... So i press on "Add keyword" and it takes me to another page where i can see all my keywords. So i go back to the "on page" and no keyword shows up. I wanna have a summary of the weekly crawl for the on page of these keywords and it's not showing up 😞 Anybody knows why?
Moz Pro | | theseolab0 -
Why Doesn't Open Site Explorer show Domain Links from Twitter, WordPress or Feedburner?
I commented on a few blog posts and wanted to see the domain authority of those sites. When I look at our domain links, I notice the links are not there from the blogs (which I now know I have to give it time to show up). But I also noticed that domains with links to our website (regularly) were not showing up either. i .e Twitter, WordPress and Feedburner. I know we have links in these locations, especially Twitter. Why would these domains not show up? Much thanks!
Moz Pro | | SydisNey0 -
The CSV export seems to have some linebreaks in it sometimes (e.g. in title column). That breaks excel import... any tips?
Example: http://www.unav.es/alumni/actividades/enlaces.html,"Alumni | Agrupaciones territoriales | Club de montaña Alumni | Universidad de Navarra.",Kompass,39,81,2,10356,Yes,No,External,http://www.kompass.de/http://wikipedia.msn.de/wiki/Kompass_Karten, MSN Wikipedia - Kompass Karten,www.kompass.at,26,78,1,15883,No,No,External,http://www.kompass.de/
Moz Pro | | mindshape0 -
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 -
Why is open site explorer not showing the top links that if found previously.
In previous months ago open site explorer listed many other sites linking to mine. I have checked those sites and they are still linking to my site. Why doesn't open site explorer list them?
Moz Pro | | call4help0 -
When to stop link building because page authority is low - open site explorer
Hi, I'm link building with Open Site Explorer. I'm really picky in get links from only high quality sites. When do you stop going down the list of possible backlink providers because the page authority is too low. I usually stop at 40, but what do you do, why, and what does it depend on?
Moz Pro | | BobGW0 -
Open Site Explorer CSV reports
Hello, Small question about the Open Site Explorer. on August 24th I've been trying to create several CSV reports which I knew would take a few days. But now, almost a week later when I check Open Site Explorer > Recent CVS reports it tells me it's still saving data. It's been saving data for 4 days now. Am I missing something, is this a bug, do I have to do something or should I wait a little longer? Thanks in advance, Dennis Tappij Gielen Retail&Clicks JFwMt.jpg
Moz Pro | | RetailClicks0