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
-
Crawl tests stuck in queue
I have tried to run a number of crawl tests recently for our client's sites outside the US and they have been stuck in the queue for over a week. 3 of them completed, but then 5 are stuck. Anyone experience this? I haven't seen anything about crawl tests having issues right now.
Moz Bar | | rmcgrath810 -
Site crawl only shows homepage
Hi everyone, A client of us has a quite new website with a lot of URLs. (Google Search Console indicates around 5300.) However, when I execute a site crawl with screaming frog, or a crawl test in MOZ, it only shows me one URL, the homepage. Does somebody have an idea why the other pages of the website are not showing up? Thanks,
Moz Bar | | WeAreDigital_BE
Jens0 -
Duplicate page found with MOZ crawl test?
When I crawl my website www.radiantguard.com, the crawl test comes back with what appears to be a duplicate of my home page: http://www.radiantguard.com and http://www.radiantguard.com/ Does the crawler indeed see two different pages and therefore, are my search engine rankings potentially affected, AND is this because of how my rel canonical is set up?
Moz Bar | | rhondafranklin0 -
Cannot Crawl ... 612 : Page banned by error response for robots.txt.
I tried to crawl www.cartronix.com and I get this error: 612 : Page banned by error response for robots.txt. I have a robots.txt file and it does not appear to be blocking anything www.cartronix.com/robots.txt Also, Search Console is showing "allowed" in the robots.txt test... I've crawled many of our other sites that are similarly set up without issue. What could the problem be?
Moz Bar | | 1sixty80 -
I got a 404 in the Crawl Test Tool Report
I, yesterday i ran an crawl on http://www.everlastinggarden.nl and i get an 404. Does anybody know why this happens? <colgroup><col width="1535"></colgroup>
Moz Bar | | IMforYou
| # ---------------------------------------- |
| Crawl Test Tool Report | Moz,http://pro.seomoz.org/tools/crawl-test |
| www.everlastinggarden.nl |
| Report created: 15 Jul 18:34 |
| # ---------------------------------------- |
| URL,Time Crawled,Title Tag,Meta Description,HTTP Status Code,Referrer,Link Count,Content-Type Header,4XX (Client Error),5XX (Server Error),Title Missing or Empty,Duplicate Page Content,URLs with Duplicate Page Content (up to 5),Duplicate Page Title,URLs with Duplicate Title Tags (up to 5),Long URL,Overly-Dynamic URL,301 (Permanent Redirect),302 (Temporary Redirect),301/302 Target,Meta Refresh,Meta Refresh Target,Title Element Too Short,Title Element Too Long,Too Many On-Page Links,Missing Meta Description Tag,Search Engine blocked by robots.txt,Meta-robots Nofollow,Blocked by X-robots,X-Robots-Tag Header,Blocked by meta-robots,Meta Robots Tag,Rel Canonical,Rel-Canonical Target,Blocking All User Agents,Blocking Google,Blocking Yahoo,Blocking Bing,Internal Links,Linking Root Domains,External Links,Page Authority |
| http://www.everlastinggarden.nl,2014,404 : Received 404 (Not Found) error response for page.,Error attempting to request page | Best regards, Jos0 -
Moz Crawl Test: Referrer is sitemap.gz?
Hi,
Moz Bar | | Titan552
I'm looking at a crawl test report, and I'm seeing that most of the pages have the sitemamp.gz file listed as the referrer. As I recall in my other reports the referrer is usually the root domain - unless of course there's a redirect. Does having sitemap.gz as the referrer indicate a problem? If so, what problem does it indicate? Thanks!0 -
Mozbar - SERP Control Panel - Export to CSV - Update
Hi I asked a question on 22nd Sep about Mozbar: "I have been exporting SERP results using the Mozbar, but I don't get PA and DA data even though this is shown in the SERP overlay. The data is shown in excel as being 'undefined'. Anyone else having this problem?" I was told that this was a known issue and a fix would be available within 2 weeks. Is there any update on when this update is likely? Thanks again for your assistance. Neil
Moz Bar | | mccormackmorrison0 -
What happened to moz Crawl Test? Is it moved in the redesign?
Love the new design of moz.com! And the mentions tool is terrific. However, I use the Crawl test a ton and cannot find where to access it now.
Moz Bar | | jessential0
