Problems with csv file from OSE
-
Hello Support,
I have problems with the formatting of csv files from OSE in Excel. I got lines that only contain -- and these lines break up the data. It is possible to correct this manually but a bit annoying if you have 1500+ links generated in the file. I work a lot with csv files from other tools and programs and those give me no problems.
Can you help me out please?
Greetings Rob
-
Hello and thanks for reaching out to us! If the fix listed below by Bas_Linders does not work, please email this report with the description of your issue to help@moz.com. We would love to find the cause of your CSV issues. Sorry for the inconveniences that you are experiencing.
-
Hey Rob,
Your issue probably has to do with the localization of your operating system. You'll want to change the country / language settings of your OS version to English / US. You can then download and open the file and the information will be displayed in their respective columns correctly. Save + exit, switch back your country / language settings to their original state and you can then normally open and read the file.
Hope this helps
-
Never really happened to me in the past... I believe you should try contacting help@semoz.org for further assistance!
Hope this helps!
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
-
OSE not displaying data
Is anyone else having a problem with OSE not displaying any data except for domain and page authority?
Moz Pro | | SamCUK0 -
Crawl Diagnostics Summary Problem
We added our website a Robots.txt file and there are pages blocked by robots.txt. Crawl Diagnostics Summary page shows there is no page blocked by Robots.txt. Why?
Moz Pro | | iskq0 -
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 -
What's Happened To OSE's External Links For My Site?
Hi, I'm just taking my first steps with Open Site Explorer. I've hit a problem that I'd be really grateful for some help with. I'm running a website (that I didn't create) and want to get a clear picture of the inbound links. When I enter the URL into the OSE search bar, there are no external domains listed under the 'Inbound Links' and 'Linking Domains' tabs. Only internal site links are registered. Setting the filters, "only external" + "pages on this root domain", under the Inbound Links tab, does bring up a list of external sites. But I haven't had to enter filters just to see a list of inbound links with any other sites. Also, the breakdown under the Linking Domains tab remains the same - only links within my site are shown. Does this ring a bell? Any ideas what I might be doing wrong, or what might be wrong with my site to cause this problem? Cheers for helping, Josh
Moz Pro | | JoshAustin460 -
Is anybody else having problems with Open Site Explorer downloads
I've been trying to get a CSV for linking domains for two days now and still have nothing. It got to the "Finalizing" status within a few hours and stayed that way for about 24 hours, and now it's back to the beginning of a "pending" status.
Moz Pro | | BlastAM0 -
SEOmoz Crawl CSV in Excel: already split by semicolon. Is this Excel's fault or SEOmoz's?
If for example a page title contains a ë the .csv created by the SEOmoz Crawl Test is already split into columns on that point, even though I haven't used Excel's text to columns yet. When I try to do the latter, Excel warns me that I'm overwriting non-empty cells, which of course is something I would rather not do since that would make me lose valuable data. My question is: is this something caused by opening the .csv in Excel, or earlier in the process when this .csv is created?
Moz Pro | | DeptAgency2 -
Meta description tag in rss xml file?
The SEOmoz crawl diagnostic tool is complaining that I'm missing a meta description tag from a file that is an RSS xml file. In my <channel>section I do have a <description>tag. Is this a bug in the SEOmoz tool or do I need to add another tag to satisify the warning?</description></channel>
Moz Pro | | scanlin0 -
Does OSE Anchor Text Distribution CSV include internal links or external only?
Quite often when I'm using OSE and perform a CSV export, it looks like the total inbound link count and many phrases come from internal links for the domain in question. I haven't had the time to try and figure this out and don't know exactly how to go about figuring it out. So the initial question is does OSE's anchor text distribution CSV include internal links or are they external only? And alternately, how do I test for this? I deal with sites that have tens or hundreds of thousands of pages and hundreds of thousands or millions of links...
Moz Pro | | AlanBleiweiss0