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
-
Open Site Explorer - Link Export Not Showing Same Number of Links
Noob question. I'm using Open Site Explorer to hunt down some external links for a website. In the attached image (post-pressing the filter button), it says I have 889 external links, but after I've downloaded the CSV, I only get 695 links. Why the difference in number? And if I'm doing something wrong, how do I make sure I'm getting the full amount of external links to my client's website? Thanks! GG6wURf.jpg
Moz Pro | | EEE31 -
CSV file messed up
I cannot convert my exported CSV file to a proper excel sheet. The data is mixed, so converting doesn't work. Some rows have all data in the first cell (column), some rows have data in first AND second cell.. Anyone a solution? yaIKsZz
Moz Pro | | nans2 -
Can you export a keyword rankings report with the keywords listed in order of ranking ?
My keyword ranking report shows the results all jumbled. I can put them in order when viewing the report online, but when I export it , the results go back to all jumbled rankings.
Moz Pro | | jlane90 -
How can i export a historical ranking report which contains keywords with special characters.
How can i export a historical ranking report which contains keywords with special characters? Previously it only turned the keywords into jumbled format (forgot the tech term) in excel i.e. онлайн чат which are in this case russian characters. The way i got around this was to import it into google docs but that also is now converting it into this format. Due to this i 1 do not know what the keywords are and 2 all my formulas do not work.
Moz Pro | | ColumK0 -
What software can I use on my Mac to open and read a SEOMoz CSV exported file?
I do not want to buy XL or Pages just to read the CSV from SEOMoz. So I bought an app on the AppStore... and this app is unable to read the CSV from SEOMoz. Since I already wasted $2, Id rather avoid to waste more (and avoid that to others too!). What software is recomanded to open these CSV files? Also, I tried Google Docs, but I bumped in their 400K cells limit 😞
Moz Pro | | jgenesto0 -
How long does opensiteexplorer take to generate exportable reports
I tried exporting a few reports out of opensiteexplorer. They have been pending for more than 36 hours. Progress bar appears to be stuck. Is this normal? How long does it take to get the reports generated?
Moz Pro | | ibwork0 -
OSE Update: No direct .csv Export
Playing around w/ OSE post update. Love that there are social signals. Having issues with exporting to .csv via email. What's the reasoning behind this change? Anyone have any solutions for circumventing (i.e. downloading data directly to excel via API)?
Moz Pro | | Gyi1 -
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