heimdal
New member
- Joined
- Apr 29, 2020
- Messages
- 4
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2013
I am trying to export a spreadsheet that has 11 columns and 26000 rows, in to a CSV. This is for the purposes of loading it in to a database. The resulting CSV appears to have added empty cells for all columns, even those are empty and beyond the range of my data. This results in 17 rows of ,,,, between each row of data. This is causing problems with the load into my database, that only has 11 columns. I have tried all versions of CSV, without success. Any suggestions would be appreciated, as redoing 26000 rows is no small task. I am using Excel365 and it is essentially useless in the way I am using it.