Use File → Open and choose one of the following formats from the File of type list:

• dBase III
• dBase IV
• FoxPro 2.x
• Clipper

Then specify additional xBase file options:

Encoding

Specifies the text encoding for the xBase file: ANSI 8‑bit or ISO/OEM.

xBase records marked as “deleted” are displayed in red. To clear the “deleted” flag in the saved file, remove the red font color from the corresponding worksheet row.

To automatically resize columns when opening xBase files, enable:

Settings → Options → General → Auto‑fit column widths in imported files

(See Settings)

Use File → Save and choose one of the following formats from the File of type list:

• dBase III
• dBase IV
• FoxPro 2.x
• Clipper

Then specify additional xBase file options:

Encoding

Specifies the text encoding for the xBase file: ANSI 8‑bit or ISO/OEM.

To mark records as “deleted” in the saved file, format the corresponding worksheet rows using a red font.

Note: After saving a document in a different format, you may need to use File → Reload to refresh the view.