DBeaver failed to import excel data

Since we Can't parse numeric value [NULL] using formatter, Just remove the NULL
, use Notepad++, replace all NULL values with null, and import.

Columns imported into the database in excel, columns that cannot be converted to numbers, rows that are ignored. It is recommended to confirm the data format and column selection Settings in excel.

According to your error message: Can't parse numeric value [] using formatter, analyze the following possible causes of the problem: This error is usually caused by the data format of some cells in Excel that is incompatible with the database. The following are some possible solutions:
1. Check the format of Excel cells: Before importing data, ensure that the format of data in Excel is compatible with the requirements of the database. For example, if the fields in the database are integers, the data in Excel needs to be in integer format. Check that the data contains non-numeric characters, such as commas and Spaces, and also clean up accordingly.
2. Modify the import Settings: When importing data, you can modify the DBeaver import Settings to fit the Excel data format. Select "Advanced settings" in the import wizard, then change Settings like "Number format" and "Decimal separator", Save Excel data as a CSV file: If you cannot solve the problem of data format compatibility, save Excel data as a CSV file and import the CSV file using DBeaver. When saving CSV files, you can select appropriate delimiters and data format options to ensure database compatibility.
4. Check the database table structure: Before importing data, ensure that the database table structure is compatible with the format of the imported data. If the database table structure is incompatible with the format of the imported data, modify the database table structure or adjust the format of the imported data.

If the above methods still do not solve the problem, check the specific cell or row mentioned in the error message for a possible error. If you need further help, provide more specific information, such as versions of DBeaver and Excel, import Settings, and so on.

The description should be a data type conversion error. An error was reported when the data was converted to a number type.
can be prompted to cancel batch inserts, thus skipping the wrong single row of data

According to the error message, you Can see that can't parse numeric value [] using formatter, cannot parse the value that is not numeric. You can go to excel to check whether there is abnormal data or empty data row