0
votes
2answers
42 views

Excel - take two csv files and map them

I have two csv files. 1 has a list of emails, another has a longer list of emails with first names, last names, address, etc. What I am looking to do is take both of these files and map the emails ...
1
vote
2answers
87 views

Shortcut to convert multiple lines to comma seperated values in Sublime

I am using sublime 3 in Mac OS. I want to convert 1 2 3 to 1,2,3 using keyboard shortcuts. or any plugin which can convert vice versa with keyboard shortcut. I don't want to press 10 keys to make ...
1
vote
1answer
53 views

batch converting from XLS to windows CSV on a mac

I'm using OS X and have lots of these XLS files that I need to format as a batch operation. I need them in "Windows CSV" format, but I can only seem to get them batch converted to Mac CSV... I am ...
0
votes
1answer
125 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
347 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
6k 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
201 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 ...