Open ODB files in your browser
The database file of LibreOffice Base and OpenOffice Base. Look through its tables right here, without LibreOffice, and save them as Excel, CSV or SQLite. Nothing leaves your device.
Or drop it anywhere on this page
What you'll see
Your database opens as a folder in the file list, its tables and views with their rows counted, and each table you pick opens in the grid.
- Every table and view in a folder • Rows counted
- Keys lead to the rows they point at
- Search • Every table at once
- Export • Save a table or the whole database
About ODB
Base is the database of LibreOffice and Apache OpenOffice, their answer to Microsoft Access, and it saves everything in one .odb: an OpenDocument ZIP of its tables, the queries, forms and reports built on them, and the settings that say where its data lives.
Most .odb files keep their data inside, in HSQLDB 1.8, the Java database Base has carried since OpenOffice 2: a script of the tables’ columns and keys and the rows of small tables, and a file of the bigger ones’ rows. Some keep it in Firebird, which newer LibreOffice offers too, and others only connect to a server such as MySQL or PostgreSQL, or to a spreadsheet.
Filepeek reads the HSQLDB data itself: each table in the file list, its rows in the grid with its keys leading to the rows they point at, and its queries, views, forms and reports named in its details. Export saves a table, or the whole database as Excel, CSV, SQLite or a SQL dump. A Base file whose tables are in Firebird or on a server says so, and nothing in it runs.
LibreOffice Base database
.odb
Format
- MIME type
- application/vnd.oasis.opendocument.base
- Made by
- LibreOffice and Apache OpenOffice
- Released
- 2005
Inside the file
- Holds
- Tables, queries, forms and reports
- Data
- HSQLDB 1.8, inside the file
- Format
- OpenDocument ZIP
- Made by
- LibreOffice and OpenOffice Base
Opens in every browser
Filepeek opens ODB files in Chrome, Edge, Firefox and Safari. On their own, browsers only download them.
- YouChromeOpens through Filepeek
- YouEdgeOpens through Filepeek
- YouFirefoxOpens through Filepeek
- YouSafariOpens through Filepeek
Apps that open ODB
- WindowsLibreOffice and Apache OpenOffice, free
- MacLibreOffice and Apache OpenOffice, free
- iPhone and iPadNo app opens it
- AndroidNo app opens it
Questions
How do I open an ODB file without LibreOffice?
Drop it on this page. Its tables open as a folder in the file list, each in the grid with its rows, on Windows, a Mac, an iPhone or Android.
Can Microsoft Access open an ODB?
Not as it is. Save it here as an Excel workbook or a CSV of each table, and Access imports those.
Why does my ODB say its tables are kept by Firebird?
LibreOffice can keep a database’s tables in Firebird instead of HSQLDB, and Filepeek reads only HSQLDB’s. LibreOffice opens it as it is.
Why does my ODB say its tables are in another database?
Base can also be a front end to MySQL, PostgreSQL, a spreadsheet or an address book, and then the .odb holds only how to reach them. Only LibreOffice, on a computer that reaches them, shows those tables.
Do the forms and reports open?
Their names show under the database’s details, but their layout is Base’s own and isn’t drawn. The data they show is in the tables, which open here.