Skip to content
Vault Studio Pro
Menu

Sheets

Open and edit .xlsx spreadsheets privately in your browser

Vault Studio Pro Sheets opens .xlsx, .xls, .csv and .tsv files, recalculates formulas as you type and saves .xlsx or .csv, all inside your browser. Your numbers are never uploaded.

Open SheetsHow the privacy works

What the spreadsheet editor does

Sheets is a spreadsheet for budgets, invoices, trackers and small data sets. It opens workbooks created in Microsoft Excel, Google Sheets, Numbers or LibreOffice, keeps your formulas and cell positions, and saves a standard .xlsx file with every tab. It runs in the page itself, so a salary sheet or a client list stays on your computer.

How to edit a spreadsheet

  1. Open the app and choose Sheets, or drop an .xlsx, .xls, .csv or .tsv file onto the window.
  2. Click a cell to type. Start with = for a formula, for example =SUM(B2:B20).
  3. Save as .xlsx to keep formulas and formatting, or as .csv for plain values.

Formulas

The formula engine has more than 70 functions and recalculates in dependency order. It supports references to other tabs (Sheet2!A1:A3), whole columns (A:C), and it flags circular references instead of freezing. The functions cover:

  • Totals and statistics: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, COUNTBLANK, PRODUCT, MEDIAN.
  • Conditional: SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS.
  • Logic: IF, IFS, IFERROR, IFNA, AND, OR, NOT, CHOOSE.
  • Lookup: VLOOKUP, HLOOKUP, INDEX, MATCH.
  • Maths: ROUND, ROUNDUP, ROUNDDOWN, INT, ABS, SQRT, POWER, MOD, CEILING, FLOOR, LOG and more.
  • Text: CONCAT, TEXTJOIN, LEFT, RIGHT, MID, LEN, TRIM, UPPER, LOWER, SUBSTITUTE, FIND, SEARCH, VALUE.
  • Dates: TODAY, NOW, DATE, YEAR, MONTH, DAY, WEEKDAY, DAYS. Finance: PMT.
  • SPARKLINE, which draws a small chart inside a cell.

Formulas are evaluated by our own parser, not by running code from the file. A crafted spreadsheet can't run scripts when you open it.

Analysis and formatting tools

  • Bar, line and pie charts.
  • Pivot tables that summarise with sum, count, average, minimum or maximum.
  • Conditional formatting: greater or less than, between, equal to, text contains, duplicates, colour scales and data bars.
  • Data validation (list, number, date), goal seek and named ranges.
  • Sort, filter drop-downs, remove duplicates, split a column by a delimiter, and a fill handle.
  • Frozen header row and first column, multiple tabs, and currency, accounting, percent and other number formats.

Limits worth knowing

  • Sheets does not support every Excel function. A function it doesn't know shows #NAME?. That includes XLOOKUP, FILTER, UNIQUE, SUMPRODUCT and other dynamic-array functions, and most statistical and financial functions beyond those listed above.
  • Macros (VBA) are not run or kept.
  • Charts you create are shown in the app. Don't expect them to appear as native charts inside the saved .xlsx.
  • CSV export saves values only and escapes cells that look like formulas, so the file is safe to open elsewhere.
  • It is designed for everyday workbooks, not for data sets with hundreds of thousands of rows.

Moving data between tools

Tables found in a PDF can be sent straight to Sheets from the PDF editor. Anything that looks like a formula in that table is kept as text, so a PDF can't plant a live formula in your workbook. You can also encrypt a finished workbook into a password-protected .vault file with the File Safe before you email or store it.

Common questions

Can I edit a Google Sheets or Numbers file?

Yes, once it is a file on your computer. In Google Sheets use File, Download, Microsoft Excel (.xlsx). In Numbers use File, Export To, Excel. Then open the downloaded file in Sheets. When you are done, save an .xlsx and import it back if you need to.

Will the people I send it to see my formulas?

Yes. The saved .xlsx keeps both the formulas and their last calculated results, so it opens with the same numbers in other spreadsheet programs. Export a .csv instead if you only want to share values.