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?
-
Thanks a lot for this question and answer. I've been cursing for months and months on this issue.
The solution suggested by Barry is TOP! Download Open Office, even if it's just to convert CSV correctly to columns.
-
In hindsight, the solution offered on that page does not do the trick. I guess I will keep using my workaround...
-
Thanks for the quick response. Open Office is something I should have checked first and indeed, opening the .csv in Open Office doesn't cause semicolons to split columns.
A workaround in Excel I've just now tried is making an empty spreadsheet and importing external data from the .csv, which lets me deselect the semicolon as separator.
I've also set the separator to something else in the Windows Language Settings, thanks for that link.
-
Think it's more likely a PC 'fault'.
You probably want to list a comma rather than a semi-colon as a separator - http://office.microsoft.com/en-us/excel-help/import-or-export-text-txt-or-csv-files-HP010099725.aspx#BMchange_the_separator_in_all_.csv_text
If you use open office you can choose what you want to use when you first open each file.
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
-
Now our site is ready what's next
Site is all inxed in google, with analytics and webmaster tool. No error in all our 5000 products pages So where do i start my organic seo? What should I read first? Its an online store for retailler only but we still want people to learn about the product or find a store.
Moz Pro | | koloss
We have made 300 original video on youtube with a full description these video are also associated in our site in each respective product. I know our competitor. So now everything is clean and ready. How do I start seo, we have no external link at all. Wich would be the first best step to do. Regards, Bruce0 -
Track client's facebook page with Social
I use SEOMoz for a client and want to track the client'sprogress on Facebook. But I can not get connected becasuse the facebook page is not my own. How to solve this? Patrick
Moz Pro | | paddydaddy0 -
Still Cant Crawl My Site
I've removed all blocks but two from our htaccess. They are for amazonaws.com to block amazon from crawling us. I did a fetch as google in our WM tools on our robots txt with success. SEOMoz crawler here hit's our site and gets a 403. I've looks in our blocked request logs and amazon is the only one in there. What is going on here?
Moz Pro | | martJ0 -
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 -
Why is my crawl STILL in progress?
I'm a bit new here, but we've had a few crawls done already. They are always finished by Wednesday night. Our website is not large (by any means), but the crawl still says it's in progress now 3 days later. What's the deal here?!?
Moz Pro | | Kibin0 -
How can i get seomoz to crawl a campaign on demand
hi how can i get seomoz to crawl a campaign on demand instead of on a weekly basis? For example i have corrected some error warnings and on page elements and would like it to re crawl the site sooner to see how the corrections have worked? thanks
Moz Pro | | Bristolweb0 -
Your opinion on this opportunity's difficulty?
I'm building a tool for mechanical engineers, and I'm trying to find 10 low-competition keywords to target in my first few content marketing efforts. I've got a lot of maneuvering room, so (with a bit of expert advice) I bet I'll be able to find some low-hanging fruit. Here's what I've found: Most keywords are seem to have about 40% difficulty. What's the highest level of SEOmoz "keyword difficulty" that a new website should reasonably try for? Some ranking high-authority pages are don't appear to be targeted at the term Is it fair to say that I could beat any page with less than a 'C' ranking for on-page optimization? (Assuming I target the term with general best practices)* Thanks! If you're interested, here is my current process: Go on engineering blogs for keywords Use Wordstream's Keyword Suggestion Tool for ideas around it Use Google Keyword Tools for keywords above 50 searches in direct match Use SEOmoz Keyword difficulty report, looking more deeply at keywords under <50% If I can find a top 10 page that's less than 30PA and less than 40DA, or has less than 'C' ranking for on-page optimization, I consider the keyword achievable within 3mo, using general best practices. *Except for YouTube/Wikipedia/etc
Moz Pro | | 49wetnoodles0 -
Seo moz crawl is not updating
When I check our seo campaign I can see that the report was not updated. It still show that the next crawl is Nov 1 but it is already Nov 3.
Moz Pro | | shebinhassan0