Do the column names need to be in the format of the original sheet?

This section is under revision

No. Actually they shouldn't! Sheetload needs to convert the name of the columns in a format that works with your database and as such you should write the columns in the sheets.yml file as they would end up in Snowflake.