CSV import to UE4 is adding a “Row Name” title to the first column.
Without a blank column, UE4 does not recognize the first column and adds a ‘Row Name’ column header. The next column has the name of the original first column, but the data is left blank.
Steps to Reproduce:
- Create a spreadsheet with the desired data. In this case, LibreOffice 7.0 was used.
- Export spreadsheet to .CSV file format.
- Create a Structure in UE4 with fields/types matching those of the spreadsheet.
- Import (drag or button) spreadsheet to UE4 directory.
- Click through dialog popups. Select newly created Structure. No checkboxes selected.
Expected Result:
The CSV imports to a properly formatted Data Table.
Actual Result:
The first column (string name) is not recognized. UE4 adds a “Row Name” header and places the first column’s data in that column (with whitespace characters removed). The data under the actual first column name is blank.
Attempted Workaround:
Add a new first column to the spreadsheet. Insert sequential numbers into these fields. Leave the column name blank. Save as CSV, Import to UE4.
Attempted Workaround Result:
The CSV imports without error. The originally untitled column appears with the “Row Name” title.
This behavior does not match the UE4 documentation (from 4.9). The user should have the option to include a numbered column or not. As the rows are numbered by the editor, this results in a redundant numbering scheme.