Generally speaking, the data format in the Excel file to be imported should be text format. If it is forced to be in text format, the date of birth, home address or ID card may be garbled. At this point, you can use the following general methods to set all text format data at once:

1. Right-click the desktop to create a new text document (. Txt document), and paste all the data in Excel into this text document.

2. Click the right mouse button on the desktop to create a new Excel file (. Xls file), open a new Excel file, press Ctrl and A on the keyboard at the same time, select all files, set the cell format with the right mouse button, select the text item under classification, and confirm. At this time, you must press Ctrl and A on the keyboard at the same time to select all, and then set the cell format with the right mouse button.

3. Paste all data into the newly created text document (. Txt document) into this newly created Excel file and save it. (You can use Ctrl and A to select all, and then right-click to copy).

4. Import the new Excel file into the national comprehensive declaration system for students' physical health standards.