Microsoft Excel has a max number of columns of 16,384
Open/Libre Office Calc has max number of columns of 1,024
A summery of the limits for several speadsheet softwares can be found here
I have 500KB CSV files. Currently my files have 1,200 columns (so work in Excel but not Calc). Soon I'll be working with bigger files that will have 96,000 columns (So will work in neither).
Transposing my CSV is surprisingly hard to do. Neither Excel, nor Calc support a "Open and Transpose" option. (I.e. open the file, converting columns to rows). That would be a decent workaround solution.
- Must be able to open CSV files
- Must support (directly or indirectly) opening files with >96,000 columns
- Must have plotting features
- Could be Windows or Linux
- Ideally would be free, but that is not a requirement
My current best plan is to use Python Pandas, or Matlab to do my plotting. Which works for me -- it is what I would have done anyway, but it does not always work for my collaborators.