4 ms·

What do you recommend for viewing and editing such files?

• ac29 3y ago
  Visidata works with arbitrary separators. I just tried with a CSV separated with ␟ (ASCII unit separator) and it worked just fine.
  • lolive 3y ago
    Excel too?
    • leonim 3y ago
      lolive, VisiData has some Excel support. However, don't expect VisiData to be a full blown editor for Excel files. It can provide a view of the data in an Excel spreadsheet.
      • dotancohen 3y ago
        I think GP means to ask if Excel can read files with ASCII 29,30,31 separators.
    • smitty1e 3y ago
      If you have a python installation available, openpyxl[1] is great both for converting to .csv and for packaging .csv outputs as .xlsx (which is really zipped .xml, anyway). [1] https://openpyxl.readthedocs.io/en/stable/index.html https://openpyxl.readthedocs.io/en/stable/index.html