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:
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?
Do you know way I get this error?
I copy and paste the the text from Excel to a notepad, here is an image from Excel:
I belive it is a bug in Excel, here is waht the csv fiels shows in Notepad:
304991-
][1]
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
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
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.
Why not just do this? Why do you need notepad in the first place?
Super weird to see semicolons there. Glad to hear you got it to work!
I was able to get it to work with LiberOffice.
but thank you for the help.