No shaving off leading zeroes, no assuming I want a formula unless I explicitly prepend the cell with an = (or whatever the syntax is). If I want a string that starts with a hyphen, it’s just a string that starts with a hyphen. If I open a CSV or TSV file and save a copy without doing anything to it, it should be identical to the original down to hashing the same.
But I’d also like the nice auto-filtering capabilities that excel has, where there’s a dropdown on each column for sorting and searching.
Does such a program exist?
AFAIK, when you save to CSV with Excel it doesn’t add anything.
But you won’t have a Table either, as that requires saving to an Excel format.
As for the rest just format your columns as “text” in Excel.
You could create the Table, do your sorting, and still save as CSV - it’ll retain the sort but won’t save the Table settings so you’d have to recreate the Table next time you open it.
Edit: just remembered Excel adds quotes around text - I’ve always just removed them with a text editor like Notepad+ and Find/Replace.