Skip to content

Your First Workbook

A workbook holds your MikroSheets data. It can contain multiple sheets, and each sheet can be a freeform grid or a structured table.

Open MikroSheets and begin typing in the grid, or use the new-workbook button to create another workbook in the local library. Rename the active workbook in the top bar. The label beside the formula bar shows the selected cell, and the formula bar shows that cell’s raw value.

Good first steps:

  • Type labels in the first row or first column.
  • Add numbers, dates, or text values into nearby cells.
  • Paste tabular data copied from Numbers, Excel, or another spreadsheet tool.
  • Use the plus button in the sheet tabs to add a new grid or table.
  • Rename a sheet by double-clicking its tab or using the sheet tab menu.
  • Use the library button to switch, rename, duplicate, or delete local workbooks.

Select a cell and type directly, or use the formula bar for longer values. Enter formulas by starting with =, such as =SUM(B1:B4).

The toolbar includes undo, redo, rows, columns, sorting, display formats, text style, fill color, alignment, frozen rows or columns, comments, revisions, print, and import/export.

MikroSheets autosaves to browser storage. Use JSON export when you want a portable workbook backup.

CSV is useful for the current sheet. JSON is the safer backup format because it preserves workbook structure, sheets, formatting, comments, revisions, and structured-table settings.

The app includes example workbooks you can import with the JSON import button:

  • 01-quarterly-finance-planner.json for a formula-heavy finance grid.
  • 02-launch-tracker.json for a structured launch tracker.
  • 03-projects-and-tasks.json for related project and task tables.