Project Name | Stars | Downloads | Repos Using This | Packages Using This | Most Recent Commit | Total Releases | Latest Release | Open Issues | License | Language |
---|---|---|---|---|---|---|---|---|---|---|
Visidata | 6,610 | 5 | 5 | 11 hours ago | 48 | December 16, 2021 | 86 | gpl-3.0 | Python | |
A terminal spreadsheet multitool for discovering and arranging data | ||||||||||
Sc Im | 3,709 | 7 days ago | 1 | February 27, 2018 | 59 | other | C | |||
sc-im - Spreadsheet Calculator Improvised -- An ncurses spreadsheet program for terminal | ||||||||||
Dataproofer | 681 | 6 months ago | 17 | May 26, 2021 | 58 | gpl-3.0 | JavaScript | |||
A proofreader for your data | ||||||||||
Tosheets | 525 | 3 years ago | 9 | September 13, 2019 | 1 | mit | Python | |||
Send your stdin to google sheets | ||||||||||
J | 341 | 100 | 23 | 6 years ago | 49 | December 05, 2017 | other | JavaScript | ||
:x: Multi-format spreadsheet CLI (now merged in http://github.com/sheetjs/js-xlsx ) | ||||||||||
Xtoolset | 149 | 1 | 2 months ago | 20 | November 11, 2021 | 24 | mit | TypeScript | ||
Typed import, and export XLSX spreadsheet to JS / TS. Template-based create, render, and export data into excel files. | ||||||||||
Google Spreadsheet To Json | 121 | 57 | 6 | 5 years ago | 10 | May 06, 2017 | 11 | unlicense | JavaScript | |
Simple tool to export Google Spreadsheets to JSON files, though Node API or CLI | ||||||||||
Google Spreadsheet Cli | 52 | 18 days ago | 8 | April 27, 2017 | 1 | JavaScript | ||||
📊 CLI for reading and writing data into Google Spreadsheet | ||||||||||
Xlsx2csv.rs | 37 | a year ago | 10 | April 06, 2022 | 1 | other | Rust | |||
Excel (eg. .xlsx/.xls) to CSV/TSV Format Converter in Rust | ||||||||||
Terminal_recipes | 24 | 7 years ago | 1 | |||||||
NICAR class to introduce reporters to the power of the terminal. Nothing fancy, just the fundamentals. Contributions welcome! Share your knowledge |
A curses interface for exploring and arranging tabular data
Usable via any remote shell which has Python3 installed.
F1
for command help sheeto
pen .csv, .tsv, .json, .hdf5, .xlsxCtrl-S
ave .csv, .tsvhjkl
cursor movement, t
op/m
iddle/b
ottom scroll to position screen cursor[
/]
sort asc/desc by one columne
dit cell contentsF
requency table for current column with histogramCtrl-O
to eval an expression and browse the result as a python object:
split column (on any sheet)+
join selected columns on Columns sheetS
heets metasheet to manage/navigate multiple sheetsC
olumns metasheetO
ptions sheet to change the style or behavior^E
rror metasheet^T
hreads metasheetOn the C
olumns sheet, these commands apply to rows (the columns of the source sheet), instead of the columns on the Columns sheet
-
hides column (sets width to 0)_
maximizes column width to fit longest value!
marks column as a key column (pins to the left and matches on sheet joins)#
sets column type to int$
sets column type to str%
sets column type to float@
sets column type to date~
autodetects column type~
on the display $ pip3 install visidata
Remember to install the Python3 versions of these modules with e.g. pip3
$ vd [-r/--readonly] [<input> ...]
Inputs may be paths or URLs. If no inputs are given, starts exploring the current directory. Unknown filetypes are by default viewed with a text browser.
Definitions of terms used in the help and documentation:
'go': move cursor
'move': change layout of visible data
'show': put on status line
'scroll': change set of visible rows
'push': move a sheet to the top of the sheets list (thus making it immediately visible)
'open': create a new sheet from a file or url
'load': reload an existing sheet from in-memory contents
'jump': change to existing sheet
'drop': drop top (current) sheet
'this': current [row/column/cell] ('current' is also used)
'abort': exit program immediately
F1
opens the Help Sheet, which shows the available commands along with a brief description.
This sheet can be searched, sorted, and filtered just like any other sheet.
Here are slightly better descriptions of some non-obvious commands:
the "g
lobal prefix": always applies to the next command only, but could mean "apply to all columns" (as with the regex search commands) or "apply to selected rows" (as with d
elete) or "apply to all sheets" (as with q
).
The global_action column on the Help Sheet shows the specific way the global prefix changes each command.
=
"add column expression" takes a Python expression as input and appends a new column, which evaluates the
expression over the row.
Ctrl-S
ave sheet: the output type is determined by the file extension (currently .tsv and .csv)
R
sets the source type of the current sheet. The current sheet remains until a reload (Ctrl-R
).
When sheets are joined, the rows are matched by the display values in the key columns. Different numbers of key columns cannot match (no partial keys and rollup yet). The join types are:
&
: Join all selected sheets, keeping only rows which match keys on all sheets (inner join)+
: Join all selected sheets, keeping all rows from first sheet (outer join, with the first selected sheet being the "left")*
: Join all selected sheets, keeping all rows from all sheets (full join)~
: Join all selected sheets, keeping only rows NOT in all sheets (diff join)Edits made to a joined sheet are by design automatically reflected back to the source sheets.
VisiData was created by Saul Pwanson <[email protected]>
.
VisiData is currently under active development (as of January 2017).
VisiData needs lots of usage and testing to help it become useful and dependable. If you are actively using VisiData, please let me know! Maybe there is an easy way to improve the tool for both of us.
Also please create a GitHub issue if anything doesn't appear to be working right.
If you get an unexpected error (on the status line), please include the full stack trace that you get with ^E
.
Please contact me at the email address above if you would like to contribute in some other way.
VisiData is licensed under GPLv3.