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
-
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 -
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 -
Csv download from open site explorer
After I run a report in Open Site explorer and download the csv, the bar says it processing # of 10,000 links, when the report is done and i open it there are only 450 links
Moz Pro | | thesea0 -
Firefox Export to pdf Bug?
UPDATED: Okay, it works in Chrome, but not Firefox 13.0.1. In Chrome, a new page is loaded with the .pdf, but in Firefox the page is requested, i can see the keyword and the URL being passed to SEOmoz, but there doesn't seem to be any response and the page is neither reloaded or redirected. Nothing happens. I'm happy to use Chrome, but is this a bug for Firefox 13? Does anyone else experience the same lack of result in Firefox? Thank you, Michael I run an Onpage Analysis Report, and click the "Export to PDF" button. The page shows as connecting, but then when it stops, I'm still on the same page and cannot find the pdf in my inbox or in my downloads file. Where do I go to retrieve the pdf once it's generated? Thank you! Michael
Moz Pro | | XLAB0 -
Open site Explorer CSV output mixed up
If I download a CSV output of the external links and the characteristics of them, the output is mixed up. When I put the data in Columns, some columns are disordered. Do more people experience these problems? Is there some preference I have to adapt? Thanks! SFCTf
Moz Pro | | MartijnHoving820 -
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 -
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 -
Mozbar export of serp overlay as csv not opening on Mac OS w/FF.
Its works on my (virtual) Window based machine in FF. And when I open that same file on my Mac OS, it works! However, when downloading the overlay data to csv on my Mac OS in FF, i get a super long file name & then the file won't open? Shows -5000 error? Both in Excel and Open Office. Any ideas? Both new version of Excel & Mozbar.
Moz Pro | | josey1