calibre Formats Column Not Showing: How to Display EPUB, MOBI, AZW3, and More

If the calibre formats column is not showing, the most likely explanation is simple: calibre stores format information for every book, but it does not necessarily display that information as a standard column in the main book list. You may need to create a custom or virtual column that reads calibre’s built-in Formats field. If a column already exists but appears blank or inaccurate, the cause is more likely to be an empty book record, duplicate records, a hidden column, the wrong library or virtual library, or a file that was never attached to the selected record.

This guide focuses specifically on formats stored inside the calibre library, such as EPUB, MOBI, AZW3, PDF, and DOCX. Device formats, files visible in Finder or File Explorer, and formats offered by a retailer are separate issues. Start with the small test below, then stop as soon as calibre correctly shows the formats attached to each book.

1. Confirm the Symptom With a Small Safe Test

Before changing preferences, determine whether calibre knows that the selected book has any stored formats. This separates a display problem from a library-content problem.

1.1 Inspect the Available Formats in Edit Metadata

1. Select one book that you know should have an EPUB, MOBI, AZW3, or another e-book file.
2. Click Edit metadata, or press E.
3. Find the Available formats section in the individual metadata editor.
4. Note every format listed there, then close the dialog without making unnecessary changes.

A single calibre book record can contain several formats. For example, the same record may contain EPUB, AZW3, and PDF. These are not three separate books. They are three files associated with one title and author record.

Success looks like this: the Available formats area lists the file types you expected. If it does, the files are stored correctly and your problem is limited to how the main book list displays them. Continue to Section 2.

If the Available formats area is empty, the column is not the underlying problem. The selected entry is an empty record or its files are attached to another record. Continue to Section 3.

1.2 Check the Book Details Panel

Select the same book and look at the Book details panel, normally displayed beside or below the book list depending on your layout. If it is hidden, use the Layout control near the lower-right area of the main window to show Book details.

The panel can display links for the formats attached to the current record. Its contents can also be customized under Preferences > Interface > Look & feel > Book details. If formats appear here but no Formats column exists in the main list, calibre is reading the library correctly. You only need to add or reveal a book-list column.

Stop changing settings if Available formats and Book details both show the expected files. Device detection, conversion settings, email accounts, the Content server, and the e-book viewer cannot repair a missing book-list column.

2. Add or Restore the Formats Column

calibre has built-in format information, but displaying that information in the book list is commonly handled through a custom column. The safest option is calibre’s Formats quick-create choice, where available.

2.1 Create a Formats Column With the Quick-Create Option

1. Open Preferences.
2. Go to Interface > Add your own columns. Depending on the interface layout, the wording may appear simply as Add your own columns.
3. Click the button for adding a custom column.
4. Use the Formats quick-create option if it is offered.
5. Give the column a clear heading such as Formats.
6. Accept the changes and restart calibre if prompted.

The generated column is a composite or virtual column. It displays information derived from calibre’s library database rather than storing a second, manually maintained list. You should not type EPUB or MOBI into each row yourself.

Success looks like this: the main book list gains a Formats heading, and records with stored files display values such as EPUB, MOBI, AZW3, or PDF. Records containing several files should show several format names.

2.2 Build the Column Manually With the Formats Template

If the quick-create option is unavailable or you are checking an existing custom column, create a column whose type is Column built from other columns. Use this template:

{formats}

The template asks calibre for the formats attached to each book record. Choose a simple heading such as Formats and a unique lookup name. calibre normally adds the required custom-column prefix to its lookup name.

Do not create an ordinary free-text column for this purpose. A text column will not update automatically after conversion, format removal, or the addition of another file. A composite column based on {formats} should reflect the current library state.

2.3 Reveal a Hidden or Narrow Column

If you already created the column, inspect the header row carefully. The column may have been moved to the far right, reduced to a very small width, or hidden through the column-header menu.

• Scroll horizontally across the book list.
• Right-click a column heading and look for the Formats column in the visibility choices.
• Enable it if it is unchecked.
• Drag its header to a convenient position.
• Widen it so multiple format names are visible.

A narrow column can make values look missing when they are merely clipped. Once the expected values are readable, stop. Changing conversion or metadata-download settings will not improve a working formats column.

3. Fix Blank, Missing, or Incorrect Format Values

If the column exists but a particular row is blank or wrong, return to Edit metadata > Available formats. That section is the direct check of what calibre associates with the selected record.

3.1 Attach an Existing File to the Correct Book Record

If you have the e-book file on your computer but the selected record has no available formats, add the file to that existing record instead of importing it as another book.

You can use one of these methods:

• Drag the file onto the selected book’s Book details panel.
• Right-click Add books and choose the command for adding files to selected book records.
• Open Edit metadata and use its format-adding control.

Be certain that the intended record is selected before adding the file. calibre copies imported books into its managed library, so the original source file can remain elsewhere.

Success looks like this: the new format appears immediately in Available formats and Book details. The Formats custom column should also update. If all three locations agree, no conversion or database repair is needed.

3.2 Understand Multiple Formats Under One Record

Each normal book row represents a metadata record, not necessarily one physical file. If you convert an EPUB to AZW3, calibre usually stores the output beside the EPUB under the same record. The Formats column should then report both formats.

Conversion does not create a valid output merely because a format name was selected. Check the Jobs area after conversion. If the job failed, no usable output format may have been added. Open the job details to read the error before attempting another conversion.

Do not create an empty file just to make a format name appear. A placeholder may cause the column to report that format even though the record does not contain a readable e-book.

3.3 Merge Duplicate Records Instead of Deleting Useful Files

A common source of confusing values is having one row for the EPUB and another row for the MOBI or AZW3 version of the same title. Each row then reports only its own attached format.

To consolidate them:

1. Confirm that the records genuinely represent the same book and edition.
2. Select the duplicate records.
3. Use the Merge book records command available from the Edit metadata actions or context menu.
4. Choose the merge behavior carefully, preserving the formats and preferred metadata.
5. Inspect Available formats on the surviving record.

Merge first, verify second, and remove redundant records only after confirming that the surviving record contains every required file. Simply deleting a duplicate row can permanently remove the only copy of a format stored in that record.

Success looks like this: one row remains for the title, and its Formats value includes all retained formats.

3.4 Do Not Confuse Downloaded Metadata With Stored Formats

Metadata downloading can update fields such as title, author, identifiers, tags, comments, or covers. It does not download every retail format of the book and does not prove that an EPUB, MOBI, or AZW3 file is stored in your calibre library.

Likewise, a cover and complete description can exist on an empty book record. Use Available formats, not metadata completeness, to determine whether the record contains an e-book file.

4. Search and Filter the Library by Format

Searching is a quick way to test calibre’s database independently of your custom column. Enter format searches in the main search bar.

• format:epub finds records containing EPUB.
• format:mobi finds records containing MOBI.
• format:azw3 finds records containing AZW3.
• formats:true finds records that have one or more book files.
• formats:false finds empty records with no book files.

If format:epub finds a record but its custom Formats cell is blank, review the custom column template and visibility settings. If the search does not find the record and Available formats is also empty, the EPUB is not attached to that record.

4.1 Check Virtual Libraries and Active Filters

A Virtual library limits which records are displayed. It does not normally remove formats from the underlying books, but it can make you inspect the wrong subset or assume that a duplicate record has disappeared.

Return temporarily to the full library, clear the search bar, and select the title again. Also confirm the current library name. Users with several calibre libraries sometimes create a Formats column in one library while viewing a similarly named book in another.

Success looks like this: the full library shows the expected record, its Available formats agree with search results, and the custom column displays the same formats.

5. Rule Out Plugins, Devices, the Server, and Operating System Problems

Most cases of the calibre formats column not showing are interface or record-organization issues. The following components matter only in specific circumstances.

5.1 Plugins and Interface Customization

A plugin or saved interface layout can alter menus, columns, or displayed views. If the built-in {formats} custom column remains blank even though Available formats lists files, temporarily disable recently installed interface or metadata-related plugins and restart calibre.

Do not uninstall every plugin at once. Test one recent change at a time so you can identify the cause. If disabling a plugin makes the column work, stop and review that plugin’s settings or compatibility before re-enabling it.

5.2 Device Views Are Not the Library View

When a reader is connected, calibre can display books located on the device. That view is not the same as the main calibre library. A device may contain only the format that was sent to it, even when the library record contains EPUB, AZW3, and PDF.

Switch back to the library view before evaluating the Formats column. USB mode and device detection matter when calibre cannot see or send to a reader, but they do not control the formats stored in the library database.

5.3 Content Server and Browser Displays

The calibre Content server presents library information through a web interface. Its layout is not a copy of the desktop book-list columns. A custom column visible in the desktop application may appear differently, be omitted from a particular browser view, or require separate Content server display configuration.

First verify the data in the desktop application. If Available formats and the desktop Formats column are correct, your library is healthy. Treat a server-only display issue as a separate interface problem rather than rebuilding the library.

5.4 Viewer and Editor Behavior

The e-book viewer opens a selected format for reading, while the editor works with supported editable formats. Neither tool is the authoritative list of every file stored under a book record. A book opening successfully in the viewer proves that at least one readable file was available, but it does not prove that every expected format is attached.

Always return to Edit metadata or Book details when checking stored formats.

5.5 Permissions, Antivirus, and Cloud-Synced Libraries

Operating system permissions become relevant when calibre cannot add, remove, convert, or update files. Warning signs include failed conversion jobs, access-denied messages, formats that disappear after restarting, or library maintenance reports showing missing files.

• Ensure your user account can read and write the calibre library folder.
• Avoid manually rearranging files inside the managed library directory.
• Check whether antivirus or security software quarantined or locked an e-book file.
• Pause conflicting cloud-sync activity while testing library writes.
• Do not let two computers or two calibre processes modify the same synchronized library simultaneously.

If a format remains visible after restarting calibre and opens normally from Book details, permissions are probably not the cause. Stop changing operating system security settings.

6. Use Logs and Library Checks Only When the Evidence Points There

Logs are useful when adding or converting a file fails. They are unnecessary when the only issue is that you have not created a Formats column.

6.1 Review Conversion Job Details

After a conversion, open the Jobs area and inspect the completed job. A successful conversion should add the output to the same record, after which Available formats and the custom column should include it.

If the job failed, read its details for a specific input-file, permission, plugin, or conversion error. Correct that error rather than repeatedly converting with unrelated options.

6.2 Run a Library Consistency Check

If calibre reports formats that cannot be opened, or files are present in book folders but absent from records, use Library > Library maintenance > Check library. Review the report instead of automatically deleting everything it identifies.

Back up the library before performing repairs. Database restoration is a recovery measure for genuine corruption, not a normal fix for a hidden column. Restoring a database can discard some library-level configuration that is not recoverable from per-book metadata backups.

6.3 Use calibre-debug for Reproducible Application Errors

Advanced logging with calibre-debug can help when the interface throws errors, a plugin breaks column rendering, or the behavior changes between a normal and clean test. It is rarely required for creating a Formats custom column.

If you collect debug output, reproduce only the failing action, such as opening the library or displaying the problematic column. Avoid making unrelated preference changes during the same run.

7. Run a Clean Temporary Test Before Reinstalling

Reinstalling calibre normally does not repair a hidden custom column, duplicate records, or a library stored in the wrong location. A temporary test gives you clearer evidence without risking your main collection.

1. Create a new temporary library from calibre’s library menu.
2. Add one DRM-free test EPUB or another file you are permitted to use.
3. Open Edit metadata and confirm that the format appears under Available formats.
4. Create the Formats custom column using quick-create or the {formats} template.
5. Convert the test file to another supported format if you need to test multiple-format display.
6. Confirm that both formats appear under the same record.

If the temporary library works, the calibre installation is functioning. Return to the original library and check its column definition, active view, duplicate records, permissions, and consistency. If the temporary library also fails, test without recently added plugins and record any exact error messages before considering reinstallation.

Do not delete your main library as a test. Do not manually edit metadata.db, rename managed book folders, or move individual files inside the library directory.

8. Quick Fix Checklist

• Open Edit metadata and inspect Available formats.
• Show the Book details panel and check its format links.
• Create a Formats custom column through Add your own columns.
• Use the composite template {formats} if creating it manually.
• Reveal the column if it is hidden, narrow, or positioned off-screen.
• Add missing files to the existing record rather than creating unnecessary duplicates.
• Merge genuine duplicate records while preserving all useful formats.
• Test searches such as format:epub and formats:false.
• Clear searches and Virtual library filters, then confirm the active library.
• Review Jobs only when conversion failed to create an expected format.
• Run Check library only when files and database records disagree.
• Use a temporary library before reinstalling or attempting database recovery.

9. Frequently Asked Questions

9.1 Does calibre have a built-in Formats field?

Yes. calibre tracks the formats attached to each book record. You can inspect them in Edit metadata and Book details, search them with format queries, and display them in the book list through a custom composite column. The field exists even if no visible Formats column currently appears.

9.2 Why does one book show EPUB, MOBI, and AZW3 in the same cell?

That is expected. calibre allows one book record to contain several file formats. Keeping related formats together avoids duplicate metadata and makes it easier to choose an appropriate file when viewing, converting, saving, or sending the book to a device.

9.3 Why is the Formats cell blank even though I can see the book title?

The row may be an empty book record with metadata but no attached e-book file. Press E and inspect Available formats. If it is empty, attach the correct file to that record or merge it with the duplicate record that contains the file.

9.4 Should I remove duplicate records or merge them?

Merge them when they represent the same book and contain different formats you want to keep. Verify the surviving record’s Available formats before deleting anything. Keep separate records when they are genuinely different editions, translations, or substantially different publications.

9.5 Why did converting an EPUB not add AZW3 to the column?

Check the conversion job details. If conversion succeeded, AZW3 should normally appear under Available formats for the same record. If it did not, confirm that you converted the intended record and read the job log for an error. Do not manually type AZW3 into a free-text column.

9.6 Do I need to change device, email, or Content server settings?

Not for a missing Formats column in the desktop library view. Those settings affect delivery, device transfer, or remote access. First confirm Available formats and create the correct custom column. Change other settings only if the separate feature itself is failing.