Almost March 2022 and this glitch still exists 😕
I work with Excel. After going through all the solutions suggested in this thread, I confirm that using the Google Sheets workaround is the only way that worked for me.
Disappointing as I upgraded my plan to get that bulk .csv upload feature mostly...