|Posted: 2015-02-03 13:16|
I would like to know what it's the best way to import an excel spreadsheet by mac.
In particular, what it is the best csv (csv comma separeted values or Windows comma separated or MS DOS comma separated)?
I used the excel format provided by you in the help/importing pages and then tried to import the file once with csv comma separated, once with windows comma separated and once with MS DOS comma separated, and they are not working.
The result is that I imported the file, but all the columns are in one row and the system cannot understand the values.
Look forward to hearing for some help.
|Posted: Tue, 17.03.2015 - 10:07|
At Stage 1 of the import, ensure you select the CSV File Format as Mac, this will change the Character Sert to UTF-8 Unicode which should enable you to import you data successfully.