Sometimes when you save a worksheet as a CSV file it will leave many empty rows of commas after your excel data. You can get rid of these rows by randomly deleting rows after your data. Or using this easier trick.

Instead of randomly deleting rows, you can find out exactly how far down Excel thinks the data is on your worksheet, and delete accordingly. To do this:

1. On the main menu click Edit
2. Click Goto
3. Click the Special Button
4. Click “Last Cell” and hit OK.

Delete rows untill this Goto function goes to the last row of your data.