MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Saving as CSV

Posted by Andy D. on December 15, 2000 1:11 PM

I have some spreadsheets that I have to save into CSV format for importing into another program. What I do is hightlight all of the data and make a print area (ie. A1 to Q41) and there are no empty rows or columns. I then do "save as" and pick *.csv and when I open the file in a text editor (edit.exe), there are 2 rows of extra commas at the bottom. Is this a know problem or is there any way to prevent this from happening?

Posted by Anna Daly on December 18, 2000 4:35 AM

I have noticed that this happens when saving spreadsheets as csv files. However I have also noticed that if you save the same csv file again (under the same name) the extra commas are removed and the csv file size actually gets smaller. I don't understand why!

Posted by thomas venn on December 20, 2000 2:39 PM

I can't seem to replicate your problem. My guess is that your 2 extra rows are not empty, meaning that you had data in there, then deleted it. You might want to try highlighting your data area, copy and paste it to a new sheet.