Forum Discussion
hennan730
Aug 06, 2024Copper Contributor
Every other row is blank when downloading .csv files
When viewing .csv files with Notepad, everything looks great. However, when I open these files, every other row is blank including the header row. Is the problem on my end with various format selec...
HansVogelaar
Aug 06, 2024MVP
The problem must be at the source where the file is created, so it would be best if they can correct it.
Otherwise: after opening the csv file in Excel. select the entire range and sort it on an appropriate column. The blank lines will be sorted at the bottom. Then save as an Excel workbook.