Crawl test csv has lost its formatting??
-
All the columns/heading merged into column A.
Anyone else noticed this over the past few days?
-
Great tip! Thanks
-
Thanks a lot. Had the same problem in Win 10
-
Ok worked out a solution for anyone updating to win 10 and having trouble opening csv files.
To change
- Settings - Time & Language
- Additional date, time & regional setting (at the bottom
-change date, time or number formats - Additional settings ... (Button)
Change the List Separator from the semi colon to a comma.(,)
-
Thanks for the extra information!
-
Pasting from sheet to excel works, would appear to be a win 10 change in formatting issue.
Thanks any ways.
-
Hmm..
That does seem to be the potential problem here. It's one we unfortunately won't be able to troubleshoot for a bit though. The PC users at Moz have been told not to upgrade until a vulnerability has been patched so we don't have an environment to test in. I know this isn't the most elegant solution, but I recommend sticking with Sheets for now. I'll be sure to pass this along though so we can get this looked at as soon as we can. Apologies I don't have a better answer for you
Please let us know if there's anything else you need in the interim though.
-
I agree it opens fine with Google sheets, lets see if anyone else has issues with win 10 and excel..
-
Have been using office 2016 excel for the past three years or so with no issues. Only recent change is that I have updated to Win 10 from 8.1
Updated to the latest office still no joy.
This is a major issue for me
-
Hey Eric!
I downloaded and reviewed a couple of crawl test reports in both your and my own accounts using Excel, Numbers and Google Sheets. Everything seemed to work ok for me. What program are you trying to use? Have you run the most recent updates for it?
-
Had a look/download all the past reports. All data has merged into one column??
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
-
Site crawl warning - concatenated urls from Wordpress
I could use some help on how to fix this. I asked at the walkthrough but was told it was a Wordpress issue but so far I can't find anything to point me in the right direction. There are no errors in the files on server side and I have asked my hosting company too. I am hoping someone here may be able to shed some light on it. One of my websites it giving 404 errors on links that are formed as below and there are over 12.7K of them! Example: <mydomainurl>/www.instagram.com/www.instagram.com/<instagram username=""></instagram></mydomainurl> The link that relates to my website is valid and working, but I don't understand the rest. I am totally stumped on how to move forward with this. Any advice, suggestions, tips on how to fix these errors and stop these types of links getting generated. Thanks.
Moz Bar | | emercarr0 -
4 days waiting for a Moz Crawl - How quick are yours?
Hi there Please could anyone say how long they have been waiting for crawl results. I requested a crawl on a 20 page website and I have been waiting 4 days since last weekend. I checked Moz Health and there have been no related issues there: http://health.moz.com/ Your response would be welcome. Thanks
Moz Bar | | SEOguy10 -
Weird 404 in Crawl Diagnostics
I'am getting a lot of 404 errors (196 to be precise ) - but their pattern is weird.
Moz Bar | | oorbo
The page that the crawler is trying to find is (e.g):
http://www.oorbo.com/item/asufa-israeli-design-shop**/www.oorbo.com.
the linking page is** http://www.oorbo.com/item/asufa-israeli-design-shop meaning it adds to the end of the link the root URL - /www.oorbo.com. This happens in all 196 cases - trying to find a page http://www.oorbo.com/some-page/www.oorbo.com from a refferer page http://www.oorbo.com/some-page. Obviously this pages do not exist, and it's getting a 404. I've look into the pages themselves and digged into their code - It doesn't seem that the bad link is any where on the page. Did anyone came across this kind of issue? any one can point me to a solution ?0 -
I'm getting a Crawl error 605 Page Banned by robots.txt, X-Robots-Tag HTTP Header, or Meta Robots Tag
The website is www.bigbluem.com and is a wordpress site. I'm getting the following error: 605 Page Banned by robots.txt, X-Robots-Tag HTTP Header, or Meta Robots Tag But what is weird is the domain it lists below that is http://None/BigBlueM.com Any advice?
Moz Bar | | TumbleweedPDX1 -
I am not able to perform crawl test in moz tools
it is throwing there is some problem in domain when i try testing the crawl test for my domains
Moz Bar | | IBEE-Hosting0 -
Is there a way to get Page Authority values included in the Crawl Diagnostic .csv export?
Would be nice to have these values included so that you can sort by Page Authority. 4uF6efx.png
Moz Bar | | WebReputationBuilders0 -
Historical reporting- PDF is default and I need csv/excel
I am trying to create trend reports for certain keywords that we track in Moz- The problem is that all of the historical data is only available as PDF! Is there a way to get historical reports in csv? Please help! Thanks!
Moz Bar | | SheilaK0 -
Not getting foreign characters in crawl diagnostics .csv
The crawl diagnostics .csv file is showing high-ascii characters instead of the correct language (foreign language website) e.g. Vietnamese, Chinese (both kinds), etc. Is there a way to get this right?
Moz Bar | | trainSEM0