Comment by Ygg2
1 day ago
> 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.
1 day ago
> 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.
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.