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
-
Why are my month old links not showing in WMT or OSE?
Hey Everyone! I've been working hard on boosting my ranking after launching my new site 2 months ago. I realize that this process normally takes some time however I've come across a questions that I'm not sure I know that answer to... I had some really solid back links added about a month ago but nothing is showing up yet in WMT on them. When I run an OSE I don't see any links there (not even under newly discovered). Can someone please help with some insight on why they might now be showing. Is it just a time thing or should I be doing something different?Any insight will be very helpful. Thanks
Moz Pro | | MDesigns0 -
Does SEOMOZ planing to restructure OSE metrics?
As you know SEO slowly turning into SEM and some metrics and numbers from Open Site Explorer are no so relevant any more. As a customer of SEOMOZ product i am warning if you guys are planning to add more value and ranking metrics according to the new ranking metrics and factors to your tools?
Moz Pro | | JasonOliveira0 -
CSV file messed up
I cannot convert my exported CSV file to a proper excel sheet. The data is mixed, so converting doesn't work. Some rows have all data in the first cell (column), some rows have data in first AND second cell.. Anyone a solution? yaIKsZz
Moz Pro | | nans2 -
Are the CSV downloads malformatted, when a comma appears in a URL?
Howdy folks, we've been a PRO member for about 24 hours now and I have to say we're loving it! One problem I am having with however is a CSV exported from our crawl diagnostics summary that I've downloaded. The CSV contains all the data fine, however I am having problems with it when a URL contains a comma. I am making a little tool to work with the CSVs we download and I can't parse it properly because there sometimes URLs contain commas and aren't quoted the same as other fields, such as meta_description_tag, are. Is there something simple I'm missing or is it something that can be fixed? Looking forward to learn more about the various tools. Thanks for the help.
Moz Pro | | Safelincs0 -
So many problems with my site.
Hi all.I was shocked when when i run a campaign and the warnings and recommendations about my site are so many.I know nothing about web design and the person who design it is asking me what are these problems and where did i get all these? any solution this are the problems 1.5XX (Server Error)
Moz Pro | | jubba
2.Duplicate Page Content(875)
3.Duplicate Page Title(875)
4.Overly-Dynamic URL(1048)
5.Too Many On-Page Links(60) and this is just a few of the problems.0 -
CSV export of Open Site Explorer is incomplete.
I exported my back links report from the Open Site Explorer toolbar as a CSV but the file it showed was only about 400 urls. The tool bar is listing over 1,200 links, so at first I thought maybe it was only exporting one link for each unique domain, but it only lists 200 or so unique domains linking to my site. I know it will only export 10,000 urls, but obviously I'm significantly below this level. Here is a link to a competitors site which is having the same issue.
Moz Pro | | bbelgard
http://www.opensiteexplorer.org/links?site=www.zoobooks.comListing about 900 links and only generating about 500 in the CSV report. Any help would be much appreciated.0 -
I'm not getting the csv emailed in OSE? Anyone else?
The new version of the tool does not allow me to download the data via csv immediately. It says it will email in 5-10 minutes and never comes? Anyone else having this problem? Cheers
Moz Pro | | josey0 -
SEOMoz's Crawl Diagnostics showing an error where the Title is missing on our Sitemap.xml file?
Hi Everyone, I'm working on our website Sky Candle and I've been running it as a campaign in SEOmoz. I've corrected a few errors we had with the site previously, but today it's recrawled and found a new error which is a missing Title tag on the sitemap.xml file. Is this a little glitch in the SEOmoz system? Or do I need to add a page title and meta description to my XML file. http://www.skycandle.co.uk/sitemap.xml Any help would be greatly appreciated. I didn't think I'd need to add this. Kind Regards Lewis
Moz Pro | | LewisSellers0