> Excel can't even open CSV files properly. You need to run the import wizard. O... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		Ygg2 19 days ago \| parent \| context \| favorite \| on: GitHub is no longer independent at Microsoft after... > Excel can't even open CSV files properly. You need to run the import wizard. Ofc you do. In practice, a CSV file can decide to use `\|` for comma, and `<>` instead of quotes.

rickdeckard 19 days ago [–]

yeah, what Excel does is, it assumes the comma and separator of your regional settings and doesn't care if it fails or not.

> In practice, a CSV file can decide to use `|` for comma, and `<>` instead of quotes.

Ofc it is. Now try to edit that CSV with Excel and save it again in that format.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact