Fix phone numbers converted to scientific notation
Excel saves a phone column as a number and shows 9.05332E+11, so the wizard counts those rows invalid. Format that column as Text, then upload again.
The wizard raises a warning the moment it reads phone values in scientific notation. Those rows land in the invalid counter and never reach the list. In an Excel file the panel restores the full number when the file still stores it; if the digits were lost when the file was saved, the row stays invalid. For CSV it does not, because the digits were gone when the file was saved. The repair belongs in the source file.
Before you start
- The Listeler tab enabled on your account
- An .xlsx or .xls copy of the source file
- Phone numbers of 8 to 15 digits, country code included
Step by step
These screens sit inside the Intent AI section. Sign in, open Intent AI; the menu names below are in that section's left menu.
Upload your file to the wizard
Press Veri İçe Aktar on the Listeler tab in Veri Yönetimi.
Read the warning on the summary step
Note the warning box and the figure in the invalid counter.
Set the phone column to Text in the source file
Open the file in Excel and change that column to Text format.
Retype the numbers in full
Changing the format alone will not bring back digits Excel has dropped.
Confirm the invalid count falls
Upload the corrected file; the warning on the summary step goes away and the invalid count falls.
Result checkIf it did not work
Check these
- A CSV upload gets no repair, because the digits were lost when the file was saved. Converting that CSV to .xlsx does not bring them back; those rows are still counted invalid. Upload the original .xlsx the CSV was saved from, export the numbers again from the system they came from, or retype them in full into a column set to Text.
- To see sample invalid numbers, press the "CSV indir" link once the import finishes. The gecersiz-numaralar.csv file lists at most 20 sample numbers.
- The file is not a full list of broken rows: it leaves out anything past 20 and blank phone cells, and carries no row numbers. Check the phone column in the source file to see every one.
- If the warning returns on the new file, the column is still a number. Retype into an empty column already set to Text.
Does this step look different in your panel?
We can review the screen and exact error text together.
This guide was checked against the product UI and code inventory on 4 October 2026.
