jfor.org

Document

What is a .frm file?

A .frm file is a MySQL Table Definition Format. This is a document format, so it holds text and layout meant to be read. Confusingly, this extension has been used by 4 different formats over the years — they're all listed below.

This extension has been used by more than one format

4 different formats have claimed .frm over the years, so two files with the same extension aren't necessarily the same kind of thing.

How to open a .frm file

  • Try LibreOffice (free, Windows/Mac/Linux) — it opens an enormous range of current and historic document formats.
  • Microsoft Word and Google Docs handle most mainstream document types.
  • If nothing opens it, open it in a text editor: many older document formats have readable text inside.

The registry records this extension against MySQL Table Definition Format, Visual Basic Form File, Visual Basic Form File and others, so software from that family is the most likely match.

How to convert a .frm file

  • Once it opens in LibreOffice or Word, Save As .docx or .pdf to get it into a format you can use anywhere.

The technical record

For archivists, developers and the merely curious: these are the PRONOM registry entries for .frm.

Format nameVersionMIME typePUID
MySQL Table Definition Formatfmt/868
Visual Basic Form File4 onwardsfmt/1541
Visual Basic Form File3 or earlierfmt/1542
dBASE Report Form Definition FileIVfmt/1860

Got another one?