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
-
Our crawler was not able to access the robots.txt file on your site.
Good morning, Yesterday, Moz gave me an error that is wasn't able to find our robots.txt file. However, this is a new occurrence, we've used Moz and its crawling ability many times prior; not sure why the error is happening now. I validated that the redirects and our robots page are operational and nothing is disallowing Roger in our robots.txt. Any advice or guidance would be much appreciated. https://www.agrisupply.com/robots.txt Thank you for your time. -Danny
Moz Pro | | Danny_Gallagher0 -
How does OSE select top 10,000 links
Quick question about OSE, if you are extracting with excel all inbound links from a big site like IMDB.com, OSE only exports 10,000. However IMDB has alot more links then that. I was wondering what criteria does OSE use to select those 10,000 links from the 100,000+ which IMDB has. Is it a random selection of those 10,000 links or does it select those 10,000 links based on metrics like DA or PA? For the settings i have selected: followed + 301s, only external, pages on this root domain, group by domain. Cheers, Chris
Moz Pro | | MBASydney0 -
OSE Backlink results - reported link not actually there?
Not a complaint, but a question to understand how the research tool operates: When I run backlink checks on websites, often the reported link is not only not on the page, but it's not found anywhere on the site. I use several tools to search for the link url as well as for the keyword. Why does the tool report a link is there, but I cannot find the links in some cases? Is there a lag in the information the tool is using, making it not quite up to date, or is it something else? Thanks much!
Moz Pro | | AdamThompson0 -
Problem with our connection to your Google Analytics
It is the second time in less then a month when i get that error message. The first time I just removed the connection and re-added it. Is there any other way to fix it? is it the problem on my end or is it on SEOMOZ side?
Moz Pro | | SirMax0 -
OSE lists dead links
Going over the link profile of a competitor who gets 5x the traffic we do.... of course frustrated that the majority of their links are spam blogs (full of words but don't communicate anything) and forum profiles. Thanks Google for telling me what not to do, then rewarding my competitor for doing it shamelessly. Question regarding sites listed by Open Site Explorer as linking to said competitor, but that don't even load when I visit their url. Some go to a godaddy parked page, like the domain name expired long ago. Is this simply a limitation of OSE, and can I assume Google has indexed differently and therefore awarding no link juice from these urls?
Moz Pro | | jotham20 -
OSE Link Report Question.
Hi, when i export a link report as a csv file via the export tool on OSE, there is a column in the exported table called "Numder of Link". Please explain me, what does this column says exactly. Its located between "Domain Authorithy" and "Number of Domains Linking to Domain". Thanx, Seb.
Moz Pro | | TheHecksler0 -
OSE shows 118 FB shares but we show more, whats wrong here?
I ran www.lauriloewenberg.com/ in OSE and it shows 118 Facebook shares while we see more than that. Maybe we are doing something wrong or a setting isn't correct, I'm not sure. The site was created in WordPress. Here are 3 posts that add up to 224 shares: Post 1 114 shares Post 2 64 shares Post 3 46 shares I'm sure there are some people that are sharing multiple posts, Will that make a difference? Even if that was true the number still seems very low. Thanks 🙂
Moz Pro | | Mike-Dream0 -
OSE Advanced Reports best practices
I'm curious how people use the OpenSiteExplorer Advanced Reports tab. It seems very powerful. What do you use it for? In particular, I see that it has choices for 'same C block' and 'different C block'. Those seem useful to find C blocks that my competitors have links from that I do not, but I'm not totally clear on how to construct the query. Any help or best practices would be appreciated. Thanks!
Moz Pro | | scanlin0