How are table values inserted?
Excel uses saved cell display values, including leading zeros and date formats; formulas are not recalculated. CSV values remain text. Every data row after the chosen header is processed, including blank rows. Empty cells insert empty text.