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 -
Problems with csv file from OSE
Hello Support, I have problems with the formatting of csv files from OSE in Excel. I got lines that only contain -- and these lines break up the data. It is possible to correct this manually but a bit annoying if you have 1500+ links generated in the file. I work a lot with csv files from other tools and programs and those give me no problems. Can you help me out please? Greetings Rob
Moz Pro | | FindFactory0 -
Open Site Explorer CSV export limit?
Hi! Something has been puzzling me. I've filter down a few things within open site explorer to produce some links of interest to me - around 500 records are showing When I try to export it via CSV however, only 25 links appear? Anyone know why and how I can get the rest?? David
Moz Pro | | rejigdigital0 -
Open site Explorer CSV output mixed up
If I download a CSV output of the external links and the characteristics of them, the output is mixed up. When I put the data in Columns, some columns are disordered. Do more people experience these problems? Is there some preference I have to adapt? Thanks! SFCTf
Moz Pro | | MartijnHoving820 -
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 -
Open Site Explorer csv report pending since 2 days!
I have tried to download a csv report from Open Site Explorer. But it has been pending since 2 days. Why do these reports take so much time? When can I expect to get this report?
Moz Pro | | ShashiR0 -
Why does the crawl report say I should have meta description and title tags in my xml files?
Just had my first crawl report today which has been very useful in finding missing and duplicated title tags and meta descriptions but it has flagged up the fact that my xml files are missing these. Surely non HTML documents shouldn't have them (or need them) so why are they showing up in the report?
Moz Pro | | PandyLegend0 -
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?
Moz Pro | | DeptAgency2