QGIS - Import CSV column names as numbers

Question

I want to import a CSV table (no geometry) to QGIS. The column names which are numbers (e.g. 2004) are not getting imported.

This is my test CSV file:

Name;Eigenschaft;2004;test
derName;1;21;21
sdfsfaf;11;11;15

This is how it looks in QGIS:

The third column is not called 2004 like I want but field_3

How to solve this?

Sometimes it's common to see numbers preceded by an underscore if numbers are required for field names. E.g. _2004. — Joseph, Oct 22 '15 at 11:35

Community · Accepted Answer · 2017-05-23 12:39:40Z

Field names starting with a number are not allowed in SQL and many formats, see

1 Answer 1