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.
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
-
Unsolved Updating labels via CSV upload
Hi, I'd like to update all my keyword labels in one go and I thought it would be easier to do this via a csv upload) however, when I try to upload the keyword file with all my existing keywords and the labels, it says I can't due to me reaching my keyword limit.
Moz Pro | | Rich-H
Am I trying to upload the labels with the wrong tool, or is there another way around this, please?0 -
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 -
Issues with Moz producing 404 Errors from sitemap.xml files recently.
My last campaign crawl produced over 4k 404 errors resulting from Moz not being able to read some of the URLs in our sitemap.xml file. This is the first time we've seen this error and we've been running campaigns for almost 2 months now -- no changes were made to the sitemap.xml file. The file isn't UTF-8 encoded, but rather Content-Type:text/xml; charset=iso-8859-1 (which is what Moveable Type uses). Just wondering if anyone has had a similar issue?
Moz Pro | | BriceSMG0 -
Does Rogerbot respect the robots.txt file for wildcards?
Hi All, Our robots.txt file has wildcards in it, which Googlebot recognizes. Can anyone tell me whether or not Rogerbot recognizes wildcards in the robots.txt file? We've done a Rogerbot site crawl since updating the robots.txt file and the pages that are set to disallow using the wildcards are still showing. BTW, Googlebot is not crawling these pages according to Webmaster Tools. Thanks in advance, Robert
Moz Pro | | AC_Pro0 -
Did the SERP Overlay CSV export disappear?
I'm using Google Chrome with SERP Overlay and it use to say Export to CSV... now it says Get Keyword Difficulty Report. Was this purposely removed? This is one feature that I really liked (SEOQuake does this)... basically where I can export the search results with relevant metrics.
Moz Pro | | WrightIMC0 -
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
Moz Pro | | atticus70 -
Ability to have .csv files automatically emailed on a weekly basis (after rankings are updated)?
Hi I am not sure if this is the proper place to post this. I was wondering if there are any plans to add automated emails to SEOMOZ Pro. Each week I find myself logging into SEOMOZ Pro to pull csv files across several profiles (I use PRO Elite), does SEOMOZ have any plans to add this functionality sometime in the future? All I need is an email to be sent to a specific email address after the ranking report has been updated. SEOMOZ staff - Great job on the tool, definitely the best ranking tool I have ever used. Thanks, Chris Phillips
Moz Pro | | 21stSEO0 -
Meta description tag in rss xml file?
The SEOmoz crawl diagnostic tool is complaining that I'm missing a meta description tag from a file that is an RSS xml file. In my <channel>section I do have a <description>tag. Is this a bug in the SEOmoz tool or do I need to add another tag to satisify the warning?</description></channel>
Moz Pro | | scanlin0