FormulaCraft

INFO

INFO returns a text string describing a specified aspect of the current spreadsheet environment, using keywords such as "version" (application version), "osversion" (operating system), "recalc" (calculation mode), "numfile" (number of open worksheets), or "directory" (current file path). It is useful for embedding environment details in audit logs or documentation sheets.

Excel
=INFO("version")
Google Sheets
=INFO("version")

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1Type a supported info_type keyword in quotes as the sole argument (e.g., "version", "osversion", "recalc").
  2. 2The function returns a text string describing that aspect of the environment; results vary by platform.
  3. 3Use "directory" to get the current file's folder path, or "numfile" to count open worksheets.

Need a version for your data?

Try: “Display the current Excel version number in a cell for documentation purposes

Related

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: