7 ms·
> 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 `<>` in
by Ygg2 1y 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.
- rickdeckard 1y agoyeah, 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.