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 -
SEOMoz API not working for Scrapebox
I want to import SEOMoz data to list of URLs I have using scrapbox. I added in my credentials according to the API but am getting error 401 as the status of all my links. Any idea why and what I should be doing?
Moz Pro | | theLotter0 -
What is the best ranking checker solution for 100's of sites
Hello, We used IBP for over 2 years and it worked great. We were able to schedule every clients site to auto run and email our clients. Now IBP is terrible due to Google's new updates. We are looking for something cost effective since we have 100's of websites we check on a weekly basis. We are either looking for a great software that uses proxies to check, or a service that offers unlimited sites and is cheap per month. We have searched for many, however there are so many that we aren't sure what is good and what isn't. We tried Jonathan Ledgers new one and it's not good, we looked into Web CEO and it's per amount of websites which is expensive. We tried cute rank tracker which is free and added proxies and it doesn't work, it lags out and doesn't even track ranks properly. It wouldn't hurt if it had a built in report analysis of the website as well. So whats a good one?
Moz Pro | | MarketingOfAmerica0 -
Joined SEOMOZ but non changed.
hi. i am new SEOMoz and i joined pro monthly and create 2 campagnes but there are every thing shows me 0 and i guess nothing changed with before.. please see this.. | | StickerApt |
Moz Pro | | bratt
| Domain Authority | 1 |
| Domain MozRank | 0.00 |
| Domain MozTrust | 0.00 |
| External Followed Links | 0 |
| Total External Links | 0 |
| Total Links | 0 |
| Followed Linking Root Domains | 0 |
| Total Linking Root Domains | 0 |
| Linking C-Blocks | 0 |
| Followed Links
vs
NoFollowed Links****Followed Linking Root Domains
vs
NoFollowed Linking Root Domains | | ubdomain Metrics | canadastickerking | stickeryou | stickybusiness |
| 4.31 | Transparent 5.26 | 4.56 |
| 3.78 | Transparent 5.43 | 4.87 |
| 71 | Transparent 38,649 | 631 |
| 73 | Transparent 38,814 | 1,265 |
| 3,805 | Transparent 235,124 | 26,337 |
| 7 | Transparent 243 | 115 |
| 7 | Transparent 286 | 161 |
| | | | | | StickerApt |
| Subdomain MozRank | 0.00 |
| Subdomain MozTrust | 0.00 |
| External Followed Links | 0 |
| Total External Links | 0 |
| Total Links | 0 |
| Followed Linking Root Domains | 0 |
| Total Linking Root Domains | 0 |
| Followed Links
vs
NoFollowed Links****Followed Linking Root Domains
vs
NoFollowed Linking Root Domains | "No followed (0%)"
"No nofollowed (0%)" | Total Branded Keywords Manage brand rules Non-branded Keywords Week ending: 9/9 Change 9/16 9/9 Change 9/16 9/9 Change 9/16 --- --- --- --- --- --- --- --- --- --- Organic Search Visits 45 -18% 37 7 -14% 6 38 -18% 31 URLs Receiving Entrances Via Search 8 25% 10 4 -50% 2 4 100% 8 | Non-Paid Keywords Sending Search Visits | 20 | -10% | 18 | 6 | -33% | 4 | 14 | 0% | 14 | can any one help me what should i do with SEOMoz? all the keyword i set up tells me not in top 50 ranking.. i set up 12keyword for start.. and aslo i there is craw erros on my site but it can not be fixed because the page that getting erros are automatic quote pages and made php. and it should be duplicate pages it share with other pages, hard to explain.. but you will see what i am talking about it has duplicate title and content.. it should be like that.. http://www.stickerapt.com/quote.php i can not change duplicate erros is it gonna effect page rank? please help..ㅡㅡ0 -
You've recently updated your brand rules. We're fetching your new data, and we should have it ready for you within the hour.
Why do i always see this message when entering a certain campaign? "You've recently updated your brand rules. We're fetching your new data, and we should have it ready for you within the hour." I didnt change a thing since i started this campaign two-three weeks ago ...
Moz Pro | | alsvik0 -
Seomoz on-page analysis, how strict to be
Hello, In a competitive niche, how important is it to be strict with the seomoz on-page analysis? If it gives a page/keyword an A, am I good to go? Or do I need to be more strict in that. We've had some competition move above us and we want to make sure we're on-site optimized well. site: nlpca(dot)com Thanks.
Moz Pro | | BobGW0 -
What's the best research tool for measuring blogger outreach success?
I'm looking for the best MOZ Pro research tool to track the success of our fledgling blogger outreach/link building efforts. Should we use Open Site Explorer's "Full List of Link Metrics", or is there something better or more granular for counting and analyzing inbound blog links? Thanks!
Moz Pro | | MJOshea0 -
When using Wordpress, why does it show up so many meta data errors on here and on google webmaster? A list of do's would be good?
Using wordpress is a good CMS, yet there sre so many meta data errors occuring, is there a list of what to look out for and good practices when using wordpress?
Moz Pro | | CosmikCarrot0