Opensite Explorer CSV Problems

[atticus7]

I'm getting a few formatting errors in the CSVs I export from Opensite Explorer, after I've opened them in Excel. Specifically, in an Inbound Links export, there are several merged fields creating new rows. This seems to be caused by line returns in the Title column. At the moment I'm sorting these all out by hand, but it's a bit of a chore when there are lots of records. However it has to be done, because you can't sort of filter properly otherwise.

Has anyone else had similar problems. If so. I'd really appreciate any tips to a) stop it happening, of b) speed up / automate the process of cleaning up the CSVs.

Many thanks

Ben

[cfguti]

Hi Ben,

I have the same problem, I think it can be the commas, but the way I choose to solve it is open it in numbers with a macbook pro...

If somebody know how to solve these problems, please respond to this post!

[KeriMorgret]

This sounds like something that the help desk should know about so they can fix it on their end. Could you please each send them an email at help@seomoz.org with the details and maybe a sample CSV?

Thanks so much, and sorry for the troubles.

[atticus7]

Thanks Keri,

I think this might be user error!

The problem only seems to occur if I import the CSV into an exisiting Excel spreadsheet. If I directly open the same CSV in Excel then it formats as expected.

So my mistake it seems. Sorry for wasting anyone's time!

Ben