▲ | Ygg2 5 days 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 5 days ago | parent [-] | |
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. |