Mac Numbers CSV coma exportation

Question

Created Dec ’18

Replies 1

Boosts 0

Participants 2

Hi,

I build a PWA where the user can upload his contact liste through a SVG file, the importation work well with all the CSVs who was made in Google Sheet, in Excel, etc.. but that don't work with Numbers!

All the source created the column separation by “ , “ like in this exemple : Mr.,Doe,jon,jond@hihih.com,00335555555,

But when i exported my CSV from Numbers i got this : Mr.;Doe;jon;jond@hihih.com;00335555555;

And this issue don't import the contact list, so we lose all the person, company who will export they're CSV from Numbers!

The oldest post i found about this issue on the web was created before 2008!?! more then a decade with this issue!

I found couple solutions on the web where the person give some great hacks, but nothing relevant for the people who want quickly importe they're contact list from Numbers!

My mom will never find out how to do this!

I contact Apple for that ( Case Number: 20000030854045 ) and all the phone numbers who they give me to speak with Apple developers team im arrive where nobody answers from weeks!

The more funny in this is that i spoke with a person from the Apple Call Center who didn't know about Numbers! 😉

Do someone have a solution?

Boost

Answer 1

Claude31 OP

Dec ’18

That's not really a question for these forums.

Effectively more for Apple support.

But, you should remeber that CSV is not fully specified ; separator may be comma, but may be semi colon (as numbers).

Can read these articles:

https://stackoverflow.com/questions/10140999/csv-with-comma-or-semicolon

h ttps://en.wikipedia.org/wiki/Comma-separated_values

That's the problem when a format is loosely defined, there may be interpretaions, leading to compatibility issues.

EDITED : RFC 4180 tries to define a standard for CSV,

h ttps://www.ietf.org/rfc/rfc4180.txt

but it notes that the RFC only documents the most commonly used format :

While there are various specifications and implementations for the

CSV format (for ex. [4], [5], [6] and [7]), there is no formal

specification in existence, which allows for a wide variety of

interpretations of CSV files. This section documents the format that

seems to be followed by most implementations:

PS: what is PWA ?

I found a list of 50 meanings for this acronym, not clear which one you speak about.

h ttps://acronyms.thefreedictionary.com/PWA

0