.CSV files

[lunca]

How to properly open, edit and save .csv file? Always when I did it I can no longer import it back. I got message: "error open..."

[lunca]

Please help me. I want to change something via Excell (export/import .csv file) but when I save as .csv something goes wrong. What is the right procedure to export .csv file to Excell and import back to the game?
Thank you.

[Denniss]

once opened in Excel the files are protected from access. you need to close the file in excel first

[lunca]

@Denniss
I tried all the ways, but it does not work. When I try to import, the game closes and I'm back on the desktop.

This is original .csv file after export. If this fail import right back without save_as in Excell, then the import is successful.


This is .csv file after save_as in Excell. A completely different form from original .csv file.

[Denniss]

you need to import it as comma-separated csv file, upon saving it should retain this separation.

[lunca]

ORIGINAL: Denniss

you need to import it as comma-separated csv file, upon saving it should retain this separation.

I'm doing exactly that but after save_as, file is different form than the original (see above). How to convert it save_as file back to the form the original had? Has anyone worked with export/import .csv file?

p.s.
Please try to export file to Excell and save it there, then try to import back to the game and tell me if it works.

[RedLancer]

I use CSV all the time. Just save the file that you have opened as a CSV as a CSV then close. Normally I don't change the save name as that means you'll have to change the name when you import it back in.

[lunca]

I found a solution !!!
When I make save as a comma-separated csv in Excel, I get a file with ";" instead ",". I do not know why, but this was the reason that import file did not work.

The solution is:
I opened the existing file as Text document and replaced all ";" with ",". I can now import file back in the game without problem