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
-
Removing Domains From Disavow File
We may have accidentally included the wrong domains in our Disavow file and have since removed most domains leaving the only very highly rated spammy links (using moz's new spam score)in the file. How long can it take for to google to recognise this change?ThanksMike
Moz Pro | | mlb70 -
Should I block .ashx files from being indexed ?
I got a crawl issue that 82% of site pages have missing title tags
Moz Pro | | thlonius
All this pages are ashx files (4400 pages).
Should I better removed all this files from google ?0 -
Is there a way to export to csv the report of keyword difficulty tool?
I'm using it to create reportes on multiple keywords and I don't see an export/download button.I see that when one keyword only is searched for, you can export the serp results. I am asking about searching multiple keywords and then exporting them all with their scores.
Moz Pro | | davhad0 -
Csv download from open site explorer
After I run a report in Open Site explorer and download the csv, the bar says it processing # of 10,000 links, when the report is done and i open it there are only 450 links
Moz Pro | | thesea0 -
Why does the CSV report on OSE limit the number of links I can download to less than it should?
I run an inbound link report for the domain www.acornstairlifts.co.uk on OpenSiteExplorer.org using the following filters: Show: All Links from: only external Pages to: pages on this root domain Show links: ungrouped It says that there are around 30,678 links for that query. I then go to the advanced tab, and run a report using the same filters, but when I click download report I only get 2874. I've run this for the past 2 days and I get the same. Why?
Moz Pro | | Brett-Harland0 -
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 -
Exporting .csv
I love all the data Roger gives me if I ask him politely. It's awesome to turn that data into a nice looking Excel file for analysis. There is however one situation that gets me into trouble. When I export CSV, open it in Excel and convert text to columns (seperated by comma) and e.g. a Page Title contains a comma (which often happens); my file seperation is messed up. Anyone got some tips to handle that? Thanks in advance mozzers
Moz Pro | | Partouter0 -
Why is Roger crawling pages that are disallowed in my robots.txt file?
I have specified the following in my robots.txt file: Disallow: /catalog/product_compare/ Yet Roger is crawling these pages = 1,357 errors. Is this a bug or am I missing something in my robots.txt file? Here's one of the URLs that Roger pulled: <colgroup><col width="312"></colgroup>
Moz Pro | | MeltButterySpread
| example.com/catalog/product_compare/add/product/19241/uenc/aHR0cDovL2ZyZXNocHJvZHVjZWNsb3RoZXMuY29tL3RvcHMvYWxsLXRvcHM_cD02/ Please let me know if my problem is in robots.txt or if Roger spaced this one. Thanks! |0