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
-
Spammy inbound links: Don't Fix It If It's Not Broken?
Hi Moz community, Our website is nearing the end of a big redesign to be mobile-responsive. We decided to delay any major changes to text content so that if we do suffer a rankings drop upon launch, we'll have some ability to isolate the cause. In the meantime I'm analyzing our current SEO strengths and weaknesses. There is a huge discrepancy between our rankings and our inbound link profile. Specifically, we do great on most of our targeted keywords and in fact had a decent surge in recent months. But Link Profiler turned up hundreds of pages of inbound links from spammy domains, many of which don't even display a webpage when I click there. (shown in uploaded image) "Don't fix it if it's not broken" is conflicting with my natural repulsion to these sorts of referrals. Assuming we don't suffer a rankings drop from the redesign, how much of a priority should this be? There are too many and most are too spammy to contact the webmasters, so we'll need to do it through a Disavow. I couldn't even open the one at the top of the list because our business web proxy identified it as adult content. It seems like a common conception is that if Google hasn't penalized us for it yet, they will eventually. Are we talking about the algorithm just stumbling upon these links and hurting us or would this be something we would find in Manual Actions? (or both?) How long after the launch should we wait before attacking these bad links? Is there a certain spam score that you'd say is a threshold for "Yes, definitely get rid of it"? And when we do, should we Disavow domains one domain at a time to monitor any potential drops or all at once? (this seems kind of obvious but if the spam score and domain authority alone is enough of a signal that it won't hurt us, we'd rather get it done asap) How important is this compared to creating fresh new content on all the product pages? Each one will have new images as well as product reviews, but the product descriptions will be the same ones we've had up for years. I have new content written but it's delayed pending any fallout from the redesign. Thanks for any help with this! d1SB2JP.jpg
Moz Pro | | jcorbo0 -
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 -
How can I submit my sitemap file to SEOmoz? (I mean the same file I send to google and bing, not the sitemap page)
I'm new to SEOmoz. As far as I understand, SEOmoz goes out to my site and crawls it to find all the pages. Is there anyway I can submit my sitemap page to SEOmoz just like I submit it to Google or Bing? Thanks for your help! Fernando
Moz Pro | | fsantospt0 -
Group by Domain sorting is broken.
When sorting links with "Group by Domain" it only works for the 1st page. Pages 2 - X do not group the results. Am I doing something wrong? Can we simply set it to "view all" to avoid paging?
Moz Pro | | DanielElmore0 -
CSV sheets on new OSE not received by email
Is there still a problem with the new OSE anyone ? I am not receiving the csv reports I am ordering via OSE.
Moz Pro | | blocker04080 -
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