Importing Excel with multiple headers into a database

This article will explain how to import this kind of complex multi-level header Excel table into the database like this: Determine the data area Start importing Open the DiLu Converter, select the file, select the label of the column to be imported, fill in: C:O, fill in 3-5 for the row number of the header, fill in 4 for the number of rows to be imported, and click Start View the results Continue to optimize Here, the number of rows to be imported is set to 4, which is suitable for the situation where the number of data rows is determined. If the number of data rows is uncertain, but the last row of note data needs to be excluded, the number of skipped end rows can be set to 1. If you also want to remove the blank rows in the last second row, you can also set the Delete Blank Rows option in the Data Cleaning Options interface.

May 5, 2025 - 02:42

Importing Excel with multiple headers into a database

This article will explain how to import this kind of complex multi-level header Excel table into the database like this:

Determine the data area

Start importing

Open the DiLu Converter, select the file, select the label of the column to be imported, fill in: C:O, fill in 3-5 for the row number of the header, fill in 4 for the number of rows to be imported, and click Start

View the results

Continue to optimize
Here, the number of rows to be imported is set to 4, which is suitable for the situation where the number of data rows is determined. If the number of data rows is uncertain, but the last row of note data needs to be excluded, the number of skipped end rows can be set to 1. If you also want to remove the blank rows in the last second row, you can also set the Delete Blank Rows option in the Data Cleaning Options interface.