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
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
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! Go to 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.😁
User | Count |
---|---|
16 | |
10 | |
8 | |
5 | |
5 |