Matrix Games Forums

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..."

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.

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

@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.

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

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.

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.

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