IMPORTED CSV DATA SHOW MORE ROWS IN ACTUAL CSV FILE

Hi everyone, 

Hope you can help me  cope with below issue

I am trying to use CSV file import action

Below is my CSV file : there's only one row of data

kvngo94_0-1649639680816.png

Below is what's imported in my data base : there are 3 rows, 1 with expected data, 2 other rows ?!

Could someone help me explain this situation ? thank you 

kvngo94_1-1649639735247.png

 

I think the problem might be here : I don't want to make a new template by creating a new CSV file, so I use export CSV file and exported 3 rows, then I delete these data except headers to make a CSV template. If it's correct, please kindly educate me how to  solve this ! Thanks all

 

 

 

Solved Solved
0 6 601
1 ACCEPTED SOLUTION

Google Spreadsheet's CSV export ignores all blank rows.

Excel apparently does not.

So you just have to establish how you create your CSV files correctly and stick to it. That is part of your testing after all.😁

View solution in original post

6 REPLIES 6
Top Labels in this Space