Opensite Explorer CSV Problems
-
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
-
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
-
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.
-
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!
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
-
Fresh Web Explorer explorer doesnt seem to work properly
How do I get Fresh Web Explorer explorer to work properly. The feedback I’m getting shows that my brand, Health 2000 had over 4000 mentions on Monday the 13th of January. However when I check out the links that supposedly mention our brand, they bring up general terms related to Health and make no reference to our brand. How can I refine this?
Moz Pro | | Hardley1110 -
Escape commas in OSE csv export
Hi When I import an OSE Site Crawl .csv to Excel, the lines get messed up. This is due to commas within the crawled site: For instance, when there is a comma in the Meta Description field, it gets separated into two fields. Is there any way to escape this so that only the correct fields get separated? Thanks!
Moz Pro | | zeepartner1 -
In Open Site Explorer is it possible to use wildcards?
If I have a section on my website called lists with articles in there can I use wildcards in Open Site Explorer to find how many backlinks all articles in that section have - and ideally which pages are most linked to? Something like www.example.com/lists/* to give number of backlinks to all articles in that website section and which are the most highly linked to. Would be a great feature to have! Cheers Siimon
Moz Pro | | SimonCh0 -
Broken CSV files?
Hi, I have been downloading fiels from seoMOZ for quite a while and I keep getting broken CSV files. ON my Mac, I wrote a script that cleaned them out but I cannot (don't know how) do this on the Windows side. The problem is that some of the record lines get broken up mainly in the "Anchor Text" field (maybe the anchor text in question contained a return). This of course messes up my file when I open it in Excel. Is there a way get/open these files without having them messed up like this? P..S. I am also seeing problem with text encoding, I would like to see the anchor text that is being diaplayed on the referring site rather than its HTML/Unicode/UTF-8 code value. TIA, Michel
Moz Pro | | analysestc0 -
Open Site explorer
I checked some of the results with OSE that ranked top on Goolge SERPS that have high Domain Authority,Page Authority 1 and content on the website's particular page is thin. How come they rank high when PA is very low?
Moz Pro | | Frost0 -
Anyone seeing ose csv exports hanging?
None of my reports are completing - even if left to run overnight - anyone else seeing this? There was mention of this in http://www.seomoz.org/q/problems-with-ose-downloads but I get the sense from that thread that the problem was solved back in August.
Moz Pro | | JaspalX1 -
OPen Site Explorer listing criteria?
Checking link data for a potential client who has given me access to their websmaster tools account, I've noticed that Google list over 150,000 "Links to Your Site" but yet OSE only reports a tiny fraction of this number.
Moz Pro | | G-DC
I have manually verified that there are in fact direct links from the sites that are listed in Webmaster Tools but not in OSE. Does OSE discard some links? Is there a reporting lag? Does anyone know why there would be such a large discrepancy?0 -
Opensite explorer issues still there
Hi I asked a question a few weeks ago regarding the linkings being shown in opensite explorer showing crazy stuff like psds and odd file formats as being the source of the links. I was told it was being repaired , the results were almost useless and I stopped using , I have just logged back in to check again and see even more random odd results with sites that would have no reason to link to us. Is this tool ever going to be repaired ? Is there a ETA for the fix ? How come you are launching new tools when the existing ones dont work ? Kind Regards
Moz Pro | | jbloggs0