I’m trying to make a database that will hold items in my game, but I want to use a excel and make a .CSV file to import the items to save time.
but everytime I try I get an error. here at the screenshot of the CSV file and then error
Can someone tell me what I do wrong here?
Here’s a quick tut:
Data in the file:
Struct for the DT:
Drag and drop csv into content browser, choose the struct:
Data in the DT:
Do you know way I get this error?
CSV stands for Comma Separated Values. Where are your commas? The file format might be CSV but you do need the commas. Create the files in a spreadsheet (google sheets work very well here) and then save it as CSV.
A csv opened in a notepad would look like this:
Don’t add spaces, if you add spaces, you’ll end with incorrect data.
I copy and paste the the text from Excel to a notepad, here is an image from Excel:
I copy and paste the the text from
Excel to a notepad
Why? When you paste something from Excel to a notepad, you lose all formatting. Definitely do not do that.
Save the file as CSV and import that. Ensure the file is closed when you import.
I belive it is a bug in Excel, here is waht the csv fiels shows in Notepad:
304991-
][1]
Why not just do this? Why do you need notepad in the first place?
I did that, it gives me the same error so I belive it is a bug in Excel.
Here is how the files shows in notpad:
;X1;X2;X3
Item;5;8;2
Potion;3;5;7
Player;3;6;9
I was able to get it to work with LiberOffice.
but thank you for the help.
Super weird to see semicolons there. Glad to hear you got it to work!
