09-02-2024 09:11 PM
11-16-2024 07:39 PM
Your CSV likely contains non-UTF-8 characters or a Byte Order Mark (BOM). To fix:
1) Check the file's actual encoding (e.g., file -I yourfile.csv on Mac).
2) Clean it using a script like this in Python:
import codecs
with codecs.open('input.csv', 'r', 'utf-8-sig') as source_file:
with codecs.open('output.csv', 'w', 'utf-8') as target_file:
target_file.write(source_file.read())
3) Ensure Metabase outputs clean UTF-8 without BOM.
4) Compare the "manual" and "automated" CSV versions for differences.