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
-
Michel,
Thanks for reaching out, can you show me instances of this issue that would indicate what you are looking at? I am starting a ticket so I could communicate better with you. You should be getting a notice soon
I will do my best to help you!
Peter
SEOmoz Help Team.
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
-
Is the MOZ Community Ranking broken?
I have been busy and away from MOZ for a while, but over the years I have been an active member of the community. I have over 2000 Moz points and usually if you haven't been on in the specified time period you become unranked, however this usually updates in 24 hours of logging back in. I have been active again since Sunday and I am still unranked yet I have gained several more points answering a couple of questions. My question is - have I missed something and the system has changed (not according to the top users table) or is the system broken?
Moz Pro | | Matt-Williamson0 -
Opensiteexlorer - Download CSV show different links
Making backlink report, got results -> Download csv Open downloaded csv in excel, it is different links set inside - copied some urls from the web interface and could not find them in excel using Ctrl+F... wtf?
Moz Pro | | Liston810 -
Setting to import into gDocs an Opensitexplorer CSV report.
That's pretty much it. Been trying to import an inbound links report generated with OpenSiteExplorer with no avail. All I get is a messy spreadsheet. Does any of you happen to know the right settings for a nifty import? Thanks a lot 🙂
Moz Pro | | Ersatz0 -
The CSV export seems to have some linebreaks in it sometimes (e.g. in title column). That breaks excel import... any tips?
Example: http://www.unav.es/alumni/actividades/enlaces.html,"Alumni | Agrupaciones territoriales | Club de montaña Alumni | Universidad de Navarra.",Kompass,39,81,2,10356,Yes,No,External,http://www.kompass.de/http://wikipedia.msn.de/wiki/Kompass_Karten, MSN Wikipedia - Kompass Karten,www.kompass.at,26,78,1,15883,No,No,External,http://www.kompass.de/
Moz Pro | | mindshape0 -
Can I export reports as CSV when signed up for pro trial account?
I've signed up for a trial pro account, yet when i try and export a report as a CSV i'm unable. Is this feature disabled for trial accounts? Many thanks, C
Moz Pro | | councilflat0 -
Why has my OSE csv report been finalizing for 3 days?
Hi guys, My CSV report has been finalizing for 3 days. Is that right? I read some posts from last year when there was a backlog Is that happening again. Can someone have a look at that please? Many thanks.
Moz Pro | | Rosewood0 -
CSV export of Open Site Explorer is incomplete.
I exported my back links report from the Open Site Explorer toolbar as a CSV but the file it showed was only about 400 urls. The tool bar is listing over 1,200 links, so at first I thought maybe it was only exporting one link for each unique domain, but it only lists 200 or so unique domains linking to my site. I know it will only export 10,000 urls, but obviously I'm significantly below this level. Here is a link to a competitors site which is having the same issue.
Moz Pro | | bbelgard
http://www.opensiteexplorer.org/links?site=www.zoobooks.comListing about 900 links and only generating about 500 in the CSV report. Any help would be much appreciated.0 -
How do I get the Page Authority of individual URLs in my exported (CSV) crawl reports?
I need to prioritize fixes somehow. It seems the best way to do this would be to filter my exported crawl report by the Page Authority of each URL with an error/issue. However, Page Authority doesn't seem to be included in the crawl report's CSV file. Am I missing something?
Moz Pro | | Twilio0