The spreadsheet,
at home in Ruby.

Open a CSV, work with live formulas, and turn your data into a chart or summary. Use the desktop editor, an interactive terminal, or the same workbook from Ruby.

Start with a sheet

gem install rukbat
rukbat sales.csv

Ruby 3.2 or newer. CSV and TSV input.

Rukbat showing quarterly sales, calculated yearly totals, formatting controls, and a bar chart.
The real Rukbat editor, rendered with example sales data.
Desktop and terminal
One editor, selected for your environment
Live formulas
Cell, range, and multi-sheet references
CSV / TSV / PDF
Tabular files and searchable documents
Ruby API
Workbooks without opening a window

From a file to a working sheet.

Keep your inputs, calculations, and summaries together while you work.

Edit a real grid
Navigate sparse million-row sheets, edit in place, fill formulas, and undo or redo changes. Only visible cells are rendered.
See formulas resolve
Calculate across cells, named ranges, and sheets. Complete function names and inspect a selected range's sum and average.
Organize the data
Sort, filter, remove duplicates, and find or replace text. Insert, hide, or freeze rows and columns as you work.
Make values readable
Apply number formats, font styles, colors, and borders. Highlight positive values or set whole-number input rules.
Build a summary
Create a static Sum or Count pivot, or display line, bar, pie, donut, scatter, area, and stacked charts.
Choose your output
Save the active sheet as UTF-8 CSV or TSV, or export formatted cells to a searchable PDF with an embedded font.

Calculate your first total.

Put 12 in A1, 30 in A2, and =SUM(A1:A2) in B1. Change an input and the result updates.

Save writes the active sheet's calculated values. CSV/TSV does not retain other sheets or formatting, and Rukbat does not read XLSX or ODS.

Read about files and limits

Open a CSV or TSV

rukbat sales.csv
rukbat data.tsv

Use the workbook from Ruby

require "rukbat"

book = Rukbat::Workbook.new
book.set(1, 1, 12)
book.set(2, 1, 30)
book.set(1, 2, "=SUM(A1:A2)")
book[1, 2] # => 42
Explore the workbook API

Keep exploring.