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
-
Yeah, good idea Keri. Wanted to challenge mozzers first but will move on to SEOmoz help.
-
Could you email help@seomoz.org? They might have an answer for you, since nobody has chimed in here. And if they don't have an answer, they can add it to the queue of suggestions for future improvements.
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
-
Poor quality PDF exports from analytics.moz.com
The new reports look great http://analytics.moz.com/dashboard/overview/ But when I export to PDF, the text is low quality and images are low quality. Not as good as the old report. In fact, the PDF is such low quality we are not providing them to our customers. We're using the old reports. ETA for HQ PDF Export please?
Moz Pro | | OPUS-Cambodia0 -
Mozbar SERP Control Panel Help: Export Results Option Not Available
Hi everyone. For some strange reason, the "Export" option is no longer appearing in my SERP Control panel when trying to export results from the SERP Overlay. It worked fine before SEOMoz changed over to Moz, but now the option is no longer available. Is there something I can do to restore this feature?
Moz Pro | | bashseo2 -
Is there a way to export keywords from SEOMOZ?
Hi, is there a way to export keywords of a campaign in SEOMOZ? The other way around to import including labels? Best
Moz Pro | | ValerieSchmidt0 -
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 -
Export & Email Keyword Report for Selected Tags
Is there a way to get a keyword ranking summary report emailed to me for specific tags?
Moz Pro | | CPollock0 -
Exporting Reports to Excel
Hello, I'm having trouble exporting reports to excel, when I open it, all the accented characters apeears wrong, is there anything I can do?
Moz Pro | | marimonteiro0 -
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 -
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