Fractal Softworks Forum

Please login or register.

Login with username, password and session length
Advanced search  

News:

Starsector 0.97a is out! (02/02/24); New blog post: Simulator Enhancements (03/13/24)

Author Topic: CSV files  (Read 2960 times)

Xeryn

  • Ensign
  • *
  • Posts: 5
    • View Profile
CSV files
« on: November 09, 2018, 12:04:02 AM »

Hello, do you guys have any recommendations for a good spreadsheet-type CSV editor? I used to have some kind of excel program on my old computer that worked phenomenally and since I just barely set up this computer, I don't really have anything like that installed. If possible I'd like to save time in looking for a good, reliable one. Free, or at least cheap, if possible. Any recommendations are appreciated.
Logged

Tartiflette

  • Admiral
  • *****
  • Posts: 3529
  • MagicLab discord: https://discord.gg/EVQZaD3naU
    • View Profile
Re: CSV files
« Reply #1 on: November 09, 2018, 03:19:29 AM »

Ron's Editor
Open Office with proper separator settings
Google sheets
Notepad++
Logged
 

Blaine

  • Lieutenant
  • **
  • Posts: 72
    • View Profile
Re: CSV files
« Reply #2 on: November 09, 2018, 03:40:58 AM »

Is there anything Notepad++ can't do?

Don't answer that. I prefer to live with my delusions.
Logged

Embercloud

  • Commander
  • ***
  • Posts: 120
    • View Profile
Re: CSV files
« Reply #3 on: November 09, 2018, 05:37:06 AM »

I use notepad++

It’s pretty good
Logged

AxleMC131

  • Admiral
  • *****
  • Posts: 1722
  • Amateur World-Builder
    • View Profile
Re: CSV files
« Reply #4 on: November 09, 2018, 10:45:24 AM »

I use LibreOffice. Nice one because it's cross-platform, and free.  :D

Don't use Notepad guys, ++ or otherwise. It works, but you will make your CSV-editing a living nightmare. Treat it like a spreadsheet and open it in a spreadsheet editor accordingly.
Logged

Nick XR

  • Admiral
  • *****
  • Posts: 712
    • View Profile
Re: CSV files
« Reply #5 on: November 09, 2018, 11:23:08 AM »

Not much to add other than what ever editor you use, ensure it's giving you a "raw" view of the data and not an interpreted view.  For example Excel will reformat dates and other columns without telling you, then persist those changes on save (same thing with some kinds of numbers or quotes). 

Xeryn

  • Ensign
  • *
  • Posts: 5
    • View Profile
Re: CSV files
« Reply #6 on: November 10, 2018, 02:29:03 AM »

Thanks for all of the recommendations guys, I appreciate it. I was using wordpad at first and I've had to close it without saving the changes quite a few times at this point. My friend was telling me about notepad++ so I'll probably give that one a go first.
Logged

vagrant

  • Ensign
  • *
  • Posts: 29
    • View Profile
Re: CSV files
« Reply #7 on: November 16, 2018, 05:21:06 PM »

google drive is my go-to for this!
Logged