Handling Column Names when Creating New Tables

For TAB and shape formats, column names come from the file. For GeoJSON files, the property names become the column headings. For CSV and Excel files, the first row of the data must contain column names.

The following limitations apply to column names:

  1. No column header can be empty or null
  2. No column header can contain numeric values
  3. No column header can have a duplicate name
  4. No column header can contain special character other than Hash (#), Tilde (~), and Underscore (_). Unsupported characters are . - / \ space & : * ? < > | " ' ! + @ % $ ^ () + = { } [] ; , `