0
votes
1answer
120 views

CSV - Microsoft office for mac 2008 doesn't add all the commas?

Let's say I have 5 column headings and I only complete the first 2 values. I then save the file as CSV (Windows). It ends up looking like this: ID,Product,Name,Value,Interest 1,PC Which is no good ...
5
votes
1answer
300 views

ODBC Query cannot be executed because it is too complex?

I have a CSV file which I am using as a database with LibreOffice DB. What I'm doing is explained in detail in this answer. I can do some operations, but when I try to enter the following into the ...
2
votes
2answers
1k views

Change line endings and delimiter format (permanently) when saving to CSV from Excel

I'm using Excel on Mac and it's always painful to have to reopen all exported CSVs in another text editor just to change the line endings from "CR" to "LF" and the delimiter from ";" to "," Is there ...
1
vote
1answer
5k views

How to import (and view correctly) Chinese UTF-8 encoded CSV file with Excel 2011 on Mac OS X

I have a CSV file which I can open and view the column with Chinese letters normally with TextMate. However, when I try to import this file into Excel 2011, the field comes with unreadable fonts. ...
1
vote
1answer
195 views

My computer isn't loading my massive Excel fileā€¦are there any tricks?

I have an 11,000 row Excel file (in Japanese) that I have saved as an xlsx file. I need it to be saved in UTF-8 format, so I went in and tested a few rows in OpenOffice (the reason for this apparent ...