Geek Answers Handbook

Opening csv files in MicroSoft Excel on Mac

I am having problems opening csv files correctly in MicroSoft Excel for Mac 2011, version 14.1.0. Files will open, but the dialog box for setting the delimeter in the form of a comma will not be displayed, and thus, all columns will be joined by commas. Is there a way to make Excel recognize a comma? Thanks!

+8
excel csv macos
source share
3 answers

The trick is that you need to create a new book and then import the CSV file (i.e. via the file / import). In the CSV import dialog box, you can select items such as delimiter, encoding, etc .; while you don’t have the option to set the delimiter character, etc. if you just open the existing CSV file directly.

This is also discussed here: https://apple.stackexchange.com/questions/23220/how-to-open-csv-file-with-microsoft-excel

+10
source share

One way is to insert sep = yourdelimiter at the beginning of the file.

If you create csv in PHP: fwrite ($ fileHandle, 'sep = yourdelimiter '. "\ R \ n");

Otherwise, you can open your csv with a text editor and add sep = yourdelimiter to the top of the file.

+8
source share

Migrate iPad / iSpreadsheet document to Mac OS 7 Excel doc

  • Email the iSpreadsheet to yourself as a CSV file.

  • Open the CSV file in Numbers

  • Email the doc number to yourself as a .xlsx file.

  • Open the attached .xlsx file in Excel on Mac OS 7.

0
source share

More articles:


All Articles