Integer / Number fields are getting converted to String when exported

English Forum Issue Report
1

Describe the bug

When exporting data from a table that contains Integer or Number fields, those fields are being converted to String values in the exported file (e.g., CSV or Excel).
This causes issues when the exported data is re-imported or used for calculations in external tools, as numeric fields are no longer recognized as numbers.

Environment

  • NocoBase version: 1.8.22
  • Database type and version: PostgreSQL 16
  • OS: Linux
  • Deployment Methods: Docker
  • Docker image version: 28.3.3
  • NodeJS version: v18.19.1

How To Reproduce

  1. Create a table with at least one Integer field and one Number field.
  2. Add a few rows of data.
  3. Go to the table block.
  4. Export the data (CSV/Excel).
  5. Open the exported file — notice that the Integer and Number values are converted to String.

Expected behavior

The exported data should preserve the original data types.

  • Integer and Number fields should remain numeric in the export file, not converted to text or strings.

Screenshots

Not available

Logs

No error messages appear in the server logs during the export process.

2

Hi FamTrack,

This issue is caused by Excel itself. When opening exported files, Excel may interpret some numeric values as text depending on formatting, quotes, or regional settings. The export from NocoBase preserves the original data, but Excel’s automatic type detection can convert numbers to strings.