I'm importing xls files and one of them has a column name with a full stop/period in it, which causes an error and the import fails. Whilst I can edit the file and change the column name, I would like my colleagues to be able to upload the file without having to edit it first.
- Has anyone else encountered this and is there a workaround?
- Would it make a difference if the file was xlsx format?
- How do I import xlsx files, what do I need to do?