title: AWS Glue from Excel formatted file
body: <p>I have some files in .csv format that I need to crawl from an S3 bucket using AWS glue and then upload to an Aurora RDS using a Glue Job.</p>
  
  <p>They have been saved by a colleague using Excel, but since Excel does not support UTF-8 encoding they are possibly Win-1252 encoded? At any rate, they are not UTF-8 and not being classified correctly by the AWS Glue crawler. Converting files to xlsx or xls does not improve matters, as Glue does not have a classifier for these either.</p>
  
  <p>Aside from saving into text and manually editing each file, what formats can be saved from Excel that AWS Glue would properly crawl and parse? It seems a strange to have no compatability with such a ubiquitous program, even if it is Excel...</p>