# CSV Import Adds "Row Name" as Default Column

**URL:** <https://forums.unrealengine.com/t/csv-import-adds-row-name-as-default-column/484216>\
**Category:** Feedback & Requests\
**Tags:** csv, Structure, data-table, unreal-engine, documentation, import, question\
**Created:** [June 1, 2021, 2:12am UTC](https://forums.unrealengine.com/t/csv-import-adds-row-name-as-default-column/484216 "2021-06-01T02:12:03Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Doctor\_Kannon](https://d1ap1mz92jnks1.cloudfront.net/user_avatar/forums.unrealengine.com/doctor_kannon/32/1130101_2.png) [@Doctor\_Kannon](https://forums.unrealengine.com/u/Doctor_Kannon)\
**Post date:** [June 1, 2021, 2:12am UTC](https://forums.unrealengine.com/t/csv-import-adds-row-name-as-default-column/484216/1 "2021-06-01T02:12:03Z")

</div>

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:

1. Create a spreadsheet with the desired data. In this case, LibreOffice 7.0 was used.
2. Export spreadsheet to .CSV file format.
3. Create a Structure in UE4 with fields/types matching those of the spreadsheet.
4. Import (drag or button) spreadsheet to UE4 directory.
5. 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.

* * *

 ![340352-spreadsheed-before-csvsave.png](https://d3kjluh73b9h9o.cloudfront.net/original/4X/c/a/c/cac292d529955f806d81f02f5d012ed6209341ef.png)

 ![340353-structureformat.png](https://d3kjluh73b9h9o.cloudfront.net/original/4X/4/5/1/45153b3a414397125386712a0064c494c86fa280.png)

![340354-datatableoptions.png](https://d3kjluh73b9h9o.cloudfront.net/original/4X/b/0/e/b0e741b3ac09e79f606e3fa9178d90adba147676.png)

![340355-importerror.png](https://d3kjluh73b9h9o.cloudfront.net/original/4X/6/6/3/663f1b1e829e87b420a15eaa6aa4ae11f0a8344e.png)

 ![340356-datatablewrong.png](https://d3kjluh73b9h9o.cloudfront.net/original/4X/6/c/4/6c4c26291cbda5c09a78709fe60c822e49510115.png)

---

<div class="post-metadata">

**Author:** ![Doctor\_Kannon](https://d1ap1mz92jnks1.cloudfront.net/user_avatar/forums.unrealengine.com/doctor_kannon/32/1130101_2.png) [@Doctor\_Kannon](https://forums.unrealengine.com/u/Doctor_Kannon)\
**Post date:** [June 1, 2021, 2:29am UTC](https://forums.unrealengine.com/t/csv-import-adds-row-name-as-default-column/484216/2 "2021-06-01T02:29:37Z")

</div>

Adding images from Workaround:

 ![340360-csvblankcolumn.png](https://d3kjluh73b9h9o.cloudfront.net/original/4X/7/3/0/7301818e8a5ce2f959dbfc05b4ecc2d9f15801a3.png)

 ![340371-datatableredundantcolumns.png](https://d3kjluh73b9h9o.cloudfront.net/original/4X/d/1/f/d1f7af1a351e2d770513bbd7789d512c77fe1394.png)

---

<div class="post-metadata">

**Author:** ![Gacriva](https://d3kjluh73b9h9o.cloudfront.net/original/4X/2/8/5/28502927f1d97ba1051b3b47ccfe17233bf41ef0.png) [@Gacriva](https://forums.unrealengine.com/u/Gacriva)\
**Post date:** [August 25, 2022, 6:55pm UTC](https://forums.unrealengine.com/t/csv-import-adds-row-name-as-default-column/484216/3 "2022-08-25T18:55:36Z")

</div>

I also want to know the answer to this

---

<div class="post-metadata">

**Author:** ![BIGTIMEMASTER](https://d1ap1mz92jnks1.cloudfront.net/user_avatar/forums.unrealengine.com/bigtimemaster/32/710746_2.png) [@BIGTIMEMASTER](https://forums.unrealengine.com/u/BIGTIMEMASTER)\
**Post date:** [August 25, 2022, 7:47pm UTC](https://forums.unrealengine.com/t/csv-import-adds-row-name-as-default-column/484216/4 "2022-08-25T19:47:41Z")

</div>

order of operations is causing the problem here.

Unreal requires the column “row name”. This column is how rows are looked up.

Easiest way to work is like this:

- create your struct
- create data table from struct
- export data table as csv
- import csv to your spreadsheet editor program
- export when ready
- reimport to unreal

if you need a display name, it’s probably better to not use the RowName, but make a separate column.

---

<div class="post-metadata">

**Author:** ![Doctor\_Kannon](https://d1ap1mz92jnks1.cloudfront.net/user_avatar/forums.unrealengine.com/doctor_kannon/32/1130101_2.png) [@Doctor\_Kannon](https://forums.unrealengine.com/u/Doctor_Kannon)\
**Post date:** [September 4, 2022, 5:41am UTC](https://forums.unrealengine.com/t/csv-import-adds-row-name-as-default-column/484216/5 "2022-09-04T05:41:20Z")

</div>

Thank you for the reply. When I have some time, I will check to confirm this answer, both in 4 and 5.

---

<div class="post-metadata">

**Author:** ![BartekMerope](https://d3kjluh73b9h9o.cloudfront.net/original/4X/2/8/5/28502927f1d97ba1051b3b47ccfe17233bf41ef0.png) [@BartekMerope](https://forums.unrealengine.com/u/BartekMerope)\
**Post date:** [May 6, 2023, 3:17pm UTC](https://forums.unrealengine.com/t/csv-import-adds-row-name-as-default-column/484216/6 "2023-05-06T15:17:10Z")

</div>

I had the same issue so i edited my spreadsheet to look like this.  
I still get Row Name column but the data is presented correctly.

 ![Zrzut ekranu 2023-05-06 152739](https://d3kjluh73b9h9o.cloudfront.net/original/4X/e/5/c/e5c74fe25739a900058b49ce1c9bf996d036fab3.png)  
Edit: Im using UE5.1 but the issue seems to be the same.
