I tried several things, but none worked. Today, importing a CSV file with such column names is impossible.
Not ideal, but would something like this work for you?
- Download the CSV file
- Upload the CSV file to Google Sheets
- Rename the columns
- Download the CSV file from Google Sheets
- Import the CSV file into a table