Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[speeder]

I noticed that the game has LOTS of CSV files...

And editing them is a nightmare, they have line breaks without special character on it, and also use line breaks to separate rows (I don't even know how Alex coded a CSV reader that understand that).

I noticed that some applications can read the CSV files correctly, some almost correctly, and some get it completely wrong (usually barfing at the line breaks).

But had no such luck with applications that can save them back, excepting applications that don't know what a CSV file is in first place and don't try to format or edit anything except the raw text I changed.

So, what CSV editor you people are using?

[Clockwork Owl]

Standard text editor. Had no luck with Excel since it messed up with my translation mod(broken character, even when I and the program were supposed to use THE SAME LANGUAGE). To you, Excel might be nice.

[Snrasha]

Me, i use note bloc( classic in windows, not use note bloc windows 10, ah ah!)

Also, when i use a ship editor, i do not save CSV, i edit in file. Because with note bloc, hum, destroy my file?
Exemple:
I save with notebloc:

Code

id,variant,fleet pts,quality,hyperdrive,formation,num,role,refit,base value,,,,,,,,,,,,,number

Lt_Exp_wing,Lt_Exp_variant,6,1,,BOX,2,INTERCEPTOR,10,14000,,,,,,,,,,,,,

Lt_Sin_wing,Lt_Sin_variant,6,1,,V,3,ASSAULT,10,10000,,,,,,,,,,,,,

I use notebloc and i save with editor:

Code

id,variant,fleet pts,quality,hyperdrive,formation,num,role,refit,base value,,,,,,,,,,,,,numberLt_Exp_wing,Lt_Exp_variant,6,1,,BOX,2,INTERCEPTOR,10,14000,,,,,,,,,,,,,Lt_Sin_wing,Lt_Sin_variant,6,1,,V,3,ASSAULT,10,10000,,,,,,,,,,,,,

So, yeah, use Excel (warning with "", excel love destroy this).

[Stalker]

I use Excel. I've had no issues with it.

For quick edits/tweaks I use Notepad++

[Rushyo]

I use LibreOffice Calc without issues. It's a little more friendly to non-Windows formatting.

[Serenitis]

Open Office seems to do okay with them.

[edit]
Settings I use with no problems at all:

Spoiler

Opening.


Saving.

[close]

[speeder]

I tried here Open Office and its forks...

All of them break something (I am unsure what, upon opening the file everything looks fine, but when I launch starsector it crashes with an error about json, despite the only thing I did was opening and saving again a CSV without changing anything).

Notepad++ can safely edit CSV though, BUT it don't has columns and fancy features like that

[celestis]

I use a piece of software with a weird name: Ron's csv editor. Surprisingly convenient. It requires registering, but is free. It has all necessary features like column renaming/reordering/etc. A bit tricky at editing long text values, but I rarely do that.

[Clockwork Owl]

Google spreadsheet worked. Man that's a good one.