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?
-
OpenOffice did the trick.. Excel also did ask me what to use (comma), but it just did gave me the right results.
Thanks!!
-
Hi Nancy,
It looks like you're opening a comma-separated CSV with a different delimiter. My first suggestion is to see if there's a way to open the file with a comma delimiter. The delimiter is the character that tells the CSV to start a new cell or row.
If you can't find one, I'd recommend downloading OpenOffice (it's free and legit, run by Apache) and opening the file in it. The great thing about OpenOffice is that, unlike Excel, it asks what delimiter you want for your data. Choosing a comma should do the trick, and you should see the data line up correctly in the preview pane.
We have this issue in reverse - we provide CSVs that are semi-colon separated by default. Our European customers open them easily. Our American customers need this work-around.
Good luck!
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
-
Issues with Moz producing 404 Errors from sitemap.xml files recently.
My last campaign crawl produced over 4k 404 errors resulting from Moz not being able to read some of the URLs in our sitemap.xml file. This is the first time we've seen this error and we've been running campaigns for almost 2 months now -- no changes were made to the sitemap.xml file. The file isn't UTF-8 encoded, but rather Content-Type:text/xml; charset=iso-8859-1 (which is what Moveable Type uses). Just wondering if anyone has had a similar issue?
Moz Pro | | BriceSMG0 -
Is there a way to export to csv the report of keyword difficulty tool?
I'm using it to create reportes on multiple keywords and I don't see an export/download button.I see that when one keyword only is searched for, you can export the serp results. I am asking about searching multiple keywords and then exporting them all with their scores.
Moz Pro | | davhad0 -
Csv download from open site explorer
After I run a report in Open Site explorer and download the csv, the bar says it processing # of 10,000 links, when the report is done and i open it there are only 450 links
Moz Pro | | thesea0 -
Setting to import into gDocs an Opensitexplorer CSV report.
That's pretty much it. Been trying to import an inbound links report generated with OpenSiteExplorer with no avail. All I get is a messy spreadsheet. Does any of you happen to know the right settings for a nifty import? Thanks a lot 🙂
Moz Pro | | Ersatz0 -
Rankings csv export doesn't show local rank
Is there a way to enable this in the settings somewhere? or is this simply not an available feature yet? Would be really great if there was an extra column in the report that shows local rank, as 93 of our top 100 keywords we track are all blended search results and a lot of the time this shows really inaccurate results because of this.
Moz Pro | | adriandg0 -
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 -
Ability to have .csv files automatically emailed on a weekly basis (after rankings are updated)?
Hi I am not sure if this is the proper place to post this. I was wondering if there are any plans to add automated emails to SEOMOZ Pro. Each week I find myself logging into SEOMOZ Pro to pull csv files across several profiles (I use PRO Elite), does SEOMOZ have any plans to add this functionality sometime in the future? All I need is an email to be sent to a specific email address after the ranking report has been updated. SEOMOZ staff - Great job on the tool, definitely the best ranking tool I have ever used. Thanks, Chris Phillips
Moz Pro | | 21stSEO0 -
SEOMoz's Crawl Diagnostics showing an error where the Title is missing on our Sitemap.xml file?
Hi Everyone, I'm working on our website Sky Candle and I've been running it as a campaign in SEOmoz. I've corrected a few errors we had with the site previously, but today it's recrawled and found a new error which is a missing Title tag on the sitemap.xml file. Is this a little glitch in the SEOmoz system? Or do I need to add a page title and meta description to my XML file. http://www.skycandle.co.uk/sitemap.xml Any help would be greatly appreciated. I didn't think I'd need to add this. Kind Regards Lewis
Moz Pro | | LewisSellers0