Geek asks and answers

Excel exports hundreds of blank columns to CSV export

Before starting, I use Excel for Mac 2011. I have a problem with a specific Excel spreadsheet. When I export any active sheet to CSV (CSV format), it exports ~ 200 empty columns along with 7 or 8 filled columns. I had a similar problem in the past, and I found a site that says that the way to fix this is to find all the empty characters and replace them with a space. This worked in the past and all empty columns were no longer exported. This is not like this particular book.

Does anyone know how to solve this? Is there a specific macro that I can use to get rid of these empty columns or maybe Apple Script? Any help would be greatly appreciated.

+3
source share
1 answer

I remember this problem with old Excel, even on Windows.

The problem is that Excel considers these columns to be part of a workbook. I'm sure there is a way to choose exactly what you need and tell Excel about the boundaries, but I don’t remember.

If you go into page mode, you will see what Excel considers your data. I think you can fix it here.

A simple solution is to select the column to the right of your data, expand the selection to the right, and delete the columns.

+5
source

More articles:


All Articles