Question

3

CSV tools for terminal?

rated 0 times [ 3] [ 0] / answers: 1 / hits: 1470 / 2 Years ago, sun, october 2, 2022, 2:46:49

I'm using Ubuntu 18.04 and above, both desktop and server, and looking for terminal tools to query / write to large CSV file efficiently, and also easy to interact (few simple commands or commands that resemble SQL query language).

What would you recommend?

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

poefor

Add To Favorites

Follow

Total Points: 379

Total Questions: 95

Total Answers: 115

Location: Serbia

Member since Tue, Jul 26, 2022

2 Years ago

poefor questions

1 Check memory usage of process which exits immediately

Wed, May 25, 22, 04:28, 2 Years ago

1 How do I diagnose my issue, when I'm not sure if it is a hardware or software issue?

Sat, Oct 16, 21, 15:13, 3 Years ago

1 Ubuntu 21.10 - Thunderbird 91.x.x drops (movemail) mbox support!

Sun, Jun 5, 22, 22:15, 2 Years ago

1 How to install latest version of python 3.9.5 on Ubuntu 20.04?

Thu, Nov 11, 21, 15:29, 3 Years ago

1 Not having write access for my FTP User for my Wordpress / nginx / ubuntu with SSH

Fri, Sep 2, 22, 14:39, 2 Years ago

View All

answered 2 Years ago panshow · Accepted Answer

There a lot of great tools:

awk

miller https://miller.readthedocs.io/en/latest/

xsv https://github.com/BurntSushi/xsv

csvtk https://bioinf.shenwei.me/csvtk/

VisiData https://www.visidata.org/