Crawl test csv has lost its formatting??

[Moving-Web-SEO-Auckland]

Had a look/download all the past reports. All data has merged into one column??

[SamWeber]

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?

[Moving-Web-SEO-Auckland]

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

[Moving-Web-SEO-Auckland]

I agree it opens fine with Google sheets, lets see if anyone else has issues with win 10 and excel..

[SamWeber]

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.

[Moving-Web-SEO-Auckland]

Pasting from sheet to excel works, would appear to be a win 10 change in formatting issue.

Thanks any ways.

[SamWeber]

Thanks for the extra information!

[Moving-Web-SEO-Auckland]

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.(,)

[Carlos.Hoempler]

Thanks a lot. Had the same problem in Win 10

[GPFTeam]

Great tip! Thanks