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
-
Can I batch export top 5 or 10 SERPS for each keyword in my campaign
I'm a newby. I have about 70 keywords and I want to create a list of all of the websites ranking in the top say 10 positions. This is to create a list of competitors in my client's space. How do I do this? I poked around but can only see single-keyword search capability to get the full serp listing (top 50). thanks.
Moz Pro | | empiricalSEO0 -
How to export keyword list to duplicate for another campaign in Moz?
I've create a couple campaigns (sub-domains) but I want them to largely have the same keywords as my other already create campaigns. How can I bring across these keywords? Export and then import them somehow?
Moz Pro | | BlueLinkERP6 -
Is there any way to export the organic traffic data?
All of the other Moz pages allow us to export for reports...why can I not export the organic traffic data page? I want a one stop shop...I don't want to have to go to Analytics! Don't make me leave the Moz systemmmmm! 🙂
Moz Pro | | Jeannie.0 -
OSE - Group by Domain Export
When exporting inbound link data from OSE, it seems to lose the "group by domain" filter. Is it possible to download the data like that or do I need to filter through all the links myself? Thanks!
Moz Pro | | cccreationsinc0 -
I want to create a report of only de duplicate content pages as a csv file so i can create a script to canonicalize them.
I want to create a report of only de duplicate content pages as a csv file so i can create a script to canonicalize them. So i get something like: http://example.com/page1, http://example.com/page2, http://example.com/page3, http://example.com/page4, Because I now have to open each in "Issue: Duplicate Page Content", and this takes a lot of time. The same for duplicate page title.
Moz Pro | | nvs.nim0 -
The CSV export seems to have some linebreaks in it sometimes (e.g. in title column). That breaks excel import... any tips?
Example: http://www.unav.es/alumni/actividades/enlaces.html,"Alumni | Agrupaciones territoriales | Club de montaña Alumni | Universidad de Navarra.",Kompass,39,81,2,10356,Yes,No,External,http://www.kompass.de/http://wikipedia.msn.de/wiki/Kompass_Karten, MSN Wikipedia - Kompass Karten,www.kompass.at,26,78,1,15883,No,No,External,http://www.kompass.de/
Moz Pro | | mindshape0 -
Anyone seeing ose csv exports hanging?
None of my reports are completing - even if left to run overnight - anyone else seeing this? There was mention of this in http://www.seomoz.org/q/problems-with-ose-downloads but I get the sense from that thread that the problem was solved back in August.
Moz Pro | | JaspalX1 -
OSE Linking Domains CSV Export Blank?
For some client domains, I've tried to do a CSV export from the OSE Linking Domains page, I get a CSV that contains the typical OSE header text, but no output records. Before I click the CSV link I always choose "show domains with links to All pages on the Root Domain". It doesn't happen with every domain I've tried this with, and when I've had the time/patience, some of the time if I try hours later, I get data. The problem though is I rarely have the luxury of running reports a second time during the audit cycle. Has anyone else experienced this? Is it a bug, or just an export fail due to system resources or something?
Moz Pro | | AlanBleiweiss0