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
-
Unsolved Export to csv does not work
HI friends. For long time I cannot download csv reports for links. I need to export new spam links sort by spam score and compare to existing but export to csv button spins for ever and nothing happens
Moz Pro | | netcomsia0 -
Fresh Web Explorer explorer doesnt seem to work properly
How do I get Fresh Web Explorer explorer to work properly. The feedback I’m getting shows that my brand, Health 2000 had over 4000 mentions on Monday the 13th of January. However when I check out the links that supposedly mention our brand, they bring up general terms related to Health and make no reference to our brand. How can I refine this?
Moz Pro | | Hardley1110 -
Are the CSV downloads malformatted, when a comma appears in a URL?
Howdy folks, we've been a PRO member for about 24 hours now and I have to say we're loving it! One problem I am having with however is a CSV exported from our crawl diagnostics summary that I've downloaded. The CSV contains all the data fine, however I am having problems with it when a URL contains a comma. I am making a little tool to work with the CSVs we download and I can't parse it properly because there sometimes URLs contain commas and aren't quoted the same as other fields, such as meta_description_tag, are. Is there something simple I'm missing or is it something that can be fixed? Looking forward to learn more about the various tools. Thanks for the help.
Moz Pro | | Safelincs0 -
Can't find backlinks shown in report.
I ran an advanced report to show me all the backlinks pointing to a domain. When I go to many of the domains listed, I can't find the link. I've searched the pages by anchor text in the browser and nothing comes up. Anyone know why this would be?
Moz Pro | | PatioLifeStyle0 -
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 -
Open Site Explorer csv report pending since 2 days!
I have tried to download a csv report from Open Site Explorer. But it has been pending since 2 days. Why do these reports take so much time? When can I expect to get this report?
Moz Pro | | ShashiR0 -
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 -
SEOmoz Crawl CSV in Excel: already split by semicolon. Is this Excel's fault or SEOmoz's?
If for example a page title contains a ë the .csv created by the SEOmoz Crawl Test is already split into columns on that point, even though I haven't used Excel's text to columns yet. When I try to do the latter, Excel warns me that I'm overwriting non-empty cells, which of course is something I would rather not do since that would make me lose valuable data. My question is: is this something caused by opening the .csv in Excel, or earlier in the process when this .csv is created?
Moz Pro | | DeptAgency2