Opening and Saving GS‑Base Databases (Saved as *.xls Workbooks)

1. Saving a Workbook in *.xlsx / *.xls / *.xml Format

Use File → Save As and choose Excel (*.xlsx, *.xml) from the File of type list.

Note (1):

As of version 20.0, table references defined inside worksheets are not yet supported. Formulas such as:

=Meals[[#This Row],[Budget]] - Meals[[#This Row],[Actual]]

are loaded and saved with their values, but they are not recalculated.

Note (2):

Although old *.xls files are still supported, if they contain formulas, GS-Calc loads and saves only formula values.

1.1 Save Options (Save Excel XLSX File Dialog)

Excel split options

2. Opening a GS-Calc File Saved in *.xlsx / *.xls Format

Use File → Open and choose Excel (*.xlsx, *.xls) from the File of type list.

Excel merge options

3. Related Topics

GS-Calc *.gsc and ODF *.ods files
Excel (*.xlsx, *.xml) files
PDF files
Text files (*.csv, *.txt, *.tab ...)
Text *.zip archives
GS-Base (*.gsb) files
dBase/Clipper/FoxPro files
SQLite (*.db) files
MySQL (*.sql) files