Incorrect number of rows in import screen and Excel rows

I divide the file into 6 parts, using WP All import to upload each file to see each preview of number row (WP Ultimate CSV Importer doesn’t have the preview of row number before processing), Now I can narrow down the issue, I can see which part show incorrect row numbers.

Then I try to remove each column one by one, except the ID and the title columns, and upload to see the preview of row number, now I found that only one column has the issue. This column is a custom field that contains url (ex:https://www.sites.com/). Without this column, all the row shows up correctly. But for this column, I check and see that all the row is added correctly Why?

I try importing 2,539 rows that’s counted on Excel, it shows 2,538 on the screen process and after the import ends, there’re 2,537 posts in total, 2 rows are missing.

I import the CSV and check the rows of this column one by one. I’ve found that there’s this symbol “\” at the end of some url, this causes the issue. The next row of this row disappears but the data goes to this row of this column, mixed together, that’s why the row is missing. I remove “\” from the rows and import again, now work fine. I then import the rest.

By the way, There’s no preview mode before processing. I have to use WP All Import to check this. And somehow the row number displays in the processing screen is not correct, but the preview mode of WP All Import However, when imported, it shows the number of post correctly.