3

I'm looking for a software (not an online tool) that can transpose large CSV files. I found this answer, but the proposed tool can't handle my file. I also heard about EmEditor, which can handle large files and has CSV capabilities, but at least I couldn't find the "Transpose" feature.

My OS is Windows, but I'm happy with any GUI or command line tool that does the task.

Improve this question
1
  • Because your file is small enough, Excel works. But I'm curious which "proposed tool" you are talking about which can't handle your file. The one answer to the linked question mentions pyspread, and it easily handles many, many, many more columns than what you have.
    – John Y
    Commented Jun 8, 2018 at 18:09

1 Answer 1

Reset to default
2

Microsoft Excel will do this for you. It has a special paste option called 'Transpose':

enter image description here

It supports up to 16,384 columns so this should work for your CSV file; just copy the content and Paste Transpose it in another workbook or sheet.

It's an online solution, but Google Sheets has the same option, and I expect other spreadsheet tools do too:

enter image description here

Improve this answer
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.