CSV not properly shown
-
When i download a csv i get just one colum with every information in it...
which makes it unreadable.. any suggestions for this unlogical problem?
-
I am still struggling with this. I am using Numbers on my Mac, and I have tried to change the file extension to txt, but I'm still seeing everything in one column.
-
sorry donford I'm mac user but I've notice on other computer with MS system and and brand new ms office that when opens csv it exchanges e.g. 459/2011 (agreement no/year) to date. Nobody could supply me a solution for this issue, so I added a space before the number and now I read it as text
MS in his save the world mission sometimes add features that are not really helpful
-
Is it possible to just use Excel's data tab "Text To Columns" and split the data on commas or whatever the delimiter is?
I haven't had this issue before but that may help with the CSV if you use Excel.
-
I got the same problem couple a weeks ago and I change a file extension to txt and next open in spreadsheet and I've got a good structure.
maybe it will help you
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
-
How to Check 301 Done Properly on Homepage
Hi All, I posted previously about this, and had some good advice (thanks!)... but not quite sure my problem has been fixed. About a month ago we changed our hosting over, and our dev didn't coordinate to have both versions of our homepage redirected to the same URL. Our crawl showed up with every single page as duplicate content, and our organic traffic has since dropped by over 60%. They have told me that it is fixed as of last Monday, and a redundant error that was appearing in my Google Analytics now says that it has been fixed, but Moz crawled my site 2 days ago and still says everything is duplicate content, and my organic traffic is stressing me out! Any advice on how I can check this is done for myself, rather than trusting these guys haven't messed it up any further? Or is it possible the Moz crawl is a bit slower? Thanks in advance.
Moz Pro | | b4cab0 -
Used a free WP theme and now Webmaster Tools has shown hundreds of broken links
Hello everyone, We've recently launched two new music instrument listing websites. One in the US http://www.yourinstrument.com One in AU http://www.yourinstrument.com.au While we're waiting for our custom, branded WP to be built, I went and put up one of the free themes with closely matching colors. Clearly, this was a mistake because now my WMT account has spit out around 200 'not found' errors and my Moz account is calling them around 282 'dupe page titles' and 'content'??? 1. Aren't WP outbound links supposed to be 'nofollow' ? / Why is my theme creating strange links? 2. Can I clean all these up with assigning rel=canonical to the original blog post? Do I need to wait for the new theme to be installed and then 301 the random URLs found by Moz and WMT ? weird link examples: http://imgur.com/Cm6pO5H Please help 😕
Moz Pro | | Beetlebum0 -
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 -
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 -
Google analytics account not shown
At the point where I'm asked to connect my Google Analytics account, it only shows three of my accounts, and not the one I'm trying to connect.
Moz Pro | | skittish430 -
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 -
What software can I use on my Mac to open and read a SEOMoz CSV exported file?
I do not want to buy XL or Pages just to read the CSV from SEOMoz. So I bought an app on the AppStore... and this app is unable to read the CSV from SEOMoz. Since I already wasted $2, Id rather avoid to waste more (and avoid that to others too!). What software is recomanded to open these CSV files? Also, I tried Google Docs, but I bumped in their 400K cells limit 😞
Moz Pro | | jgenesto0 -
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