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 [email protected]? 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
-
Unsolved Updating labels via CSV upload
Hi, I'd like to update all my keyword labels in one go and I thought it would be easier to do this via a csv upload) however, when I try to upload the keyword file with all my existing keywords and the labels, it says I can't due to me reaching my keyword limit.
Moz Pro | | Rich-H
Am I trying to upload the labels with the wrong tool, or is there another way around this, please?0 -
Universal results not in pdf or csv reports
Right now, the universal results show up when I look at tankings on the site, but do not show up at all in the weekly pdf reports. They also did not appear in the full rankings history .csv report. They only appear in the weekly csv report, and then, the information is not as detailed as it is on the website (it only shows whether a universal exists, but doesn't indicate at what position it shows up). This limits the usefulness of these reports to my customers. I need to be able to show them rankings histories, including universal results, in their monthly or weekly reports. Including the charts would be nice as well. Since I can individually download the .pdfs for these for each keywords, why can't we just include it in the monthly reports. Also, would like to be able to view rankings history for all three search engines at once for a keyword, or multiple keywords to reduce the number of pages in a report. Can you add this feature?
Moz Pro | | HMS0 -
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 -
Greater Number of Linking Domains in Anchor Text Excel Export?
I exported the anchor text for a domain from Opensite Explorer and when I sum the "Number of Linking Root Domains Containing Anchor Text" it is higher than the total amount of linking root domains for the site. Is this because some domains use multiple anchor text links, so it is counted more than once in the exported spreadsheet?
Moz Pro | | ProjectLabs0 -
Can export be sped up?
Good tool guys. Basically, when I used to work at a software development company, we used to have a huge hosted app that had to import/export 10's of 1,000's of records, and at batch of 10,000 could be done in a few seconds. When exporting from OSE, it can take several minutes. Thanks and keep up the good work. Look forward to when your database can catch up to Yahoo's old SiteExplorer (yes, I know they were a full on search engine 🙂 but your one of the only decent alternatives, so guessing you're getting quite popular now 🙂
Moz Pro | | onlinefun0 -
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 -
Does OSE Anchor Text Distribution CSV include internal links or external only?
Quite often when I'm using OSE and perform a CSV export, it looks like the total inbound link count and many phrases come from internal links for the domain in question. I haven't had the time to try and figure this out and don't know exactly how to go about figuring it out. So the initial question is does OSE's anchor text distribution CSV include internal links or are they external only? And alternately, how do I test for this? I deal with sites that have tens or hundreds of thousands of pages and hundreds of thousands or millions of links...
Moz Pro | | AlanBleiweiss0