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
-
Does anyone have an SEO strategic plan template for a beginning SEOmoz'r?
I'm fairly new to the SEO world and am going to be creating an SEO strategic plan for my boss (with his help). I was wondering if anyone had any recommendations on a template to use, outline to follow, must have's/don't need, etc. Anything you're willing to share would be greatly appreciated!
Moz Pro | | kyle21ct0 -
Google Webmaster Tools and Open Site explorer's links not matching up
My question is why do my GWT's links not match up to the ones on Open Site Explorer. I watched John Mueller's video, and he said that they had problems with the link counts recently. After checking my links today, I can see that the problem is fixed, but my link count differs from Open Site Explorer. On Web Master Tools I have 307 links, but on Open Site Explore I have 42. Has anyone dealt with this problem? thanks. Peter
Moz Pro | | PeterRota0 -
Learn SEOmoz API (and more)?
I'm sorry for this very basic question. The reason why I'm asking is that I wan't to start to use SEOmoz API (and later on Majestic SEO etc.) I have search on the web about API in general, SEOmoz specifically, in Q&A and asked around but:
Moz Pro | | OscarSE
I really can't get my head around what "set of skills" I need to know to be able use the SEOmoz API? And other APIs for that reason. Do I need a programming skills, or just knowledge how each specific API works(+ common sense)? Or both? I'm sorry if this is off topic but the main reason why I'm asking is that I wan't to start to use the SEOmoz API. If you could provide a link or two about where I can start to learn about how this works, I would really appreciate that!0 -
Does SEOmoz give a way to know what link on what page produces the 404 errors that SEOmoz is telling me I have??
SEOmoz gives me a report of 404 errors on my site. Do they give a way to know from what link on what page produces the error?
Moz Pro | | MeridianGroup0 -
Yo-Yo-ing rankings - what's going on?
I'm getting a little fed up and exasperated - if I'm honest! Our seoMoz rankings are yo-yoing on a weekly basis - extremely. One week we're in the top 3, the next week, we're not in the top 50. The week after that, we're back in the top 3. Then we're outside the top 50 again. I understand rankings go up and down sometimes - but this is every week, without fail. Not only that, but I also check my rankings with cuteRank and Firefox's Rank Checker and while those rankings are consistent with each other - seoMoz's rankings are always different and the only ones that Yoyo. Further, it's not just our rankings that Yoyo - it's those of our competitors too. They follow the same pattern except that when we go up, they go down, and vice versa, I'm just a little lost and unsure what to do, and I can't believe really that this is a true reflection of what is happening to us on Google every week. I know rankings change but surely Google aren't throwing us around like this? It is making doing any SEO on the site impossible because I never know where I stand. Any ideas or help would be wonderful. Thanks.
Moz Pro | | JetBookMike0 -
How to tell where a competitor's Facebook Shares are coming from?
Is there a way to tell where a competitor's facebook shares and likes are coming from? How to also tell what ads they have running in Facebook and their spend? I am looking at OSE's data and its telling me a competitor has 8.5K Facebook shares and 1K facebook likes. I go to their facebook page and it has about 25 likes. This site should not have anywhere close to the facebook shares/likes its receiving so wondering where they are getting their boosted traffic from.
Moz Pro | | rjb6270 -
Opensite Explorer CSV Problems
I'm getting a few formatting errors in the CSVs I export from Opensite Explorer, after I've opened them in Excel. Specifically, in an Inbound Links export, there are several merged fields creating new rows. This seems to be caused by line returns in the Title column. At the moment I'm sorting these all out by hand, but it's a bit of a chore when there are lots of records. However it has to be done, because you can't sort of filter properly otherwise. Has anyone else had similar problems. If so. I'd really appreciate any tips to a) stop it happening, of b) speed up / automate the process of cleaning up the CSVs. Many thanks Ben
Moz Pro | | atticus70 -
Best Tool to Build List of Competitor's Top Keywords?
What is the best (hopefully seomoz) tool to create a list of the keywords bringing the most traffic into a competitor's website? Goal is to build a list of keywords that bring the competitor the most traffic, stack ranked by volume of traffic coming into the competitor.
Moz Pro | | sftravel1