Ran into a CSV issue to Xlsb help

[zone709]

Hi i download bank statements in CSV form. I forgot to covert the sheets to Xlsb. What i did was copy the data from the csv inside sheet and paste it to a new workbook Xlsb.
The end of the day i realized the file was so big like 126,000 KB. I have multiple books like this. Is there an easy way i can open these sheets up. Highlight the data and change the text so when i save it the file will be smaller? I dont want to open new books and copy the data and pastespecial it then save it?

 

[Skyybot]

What do you want to change the text to? Arial, New Times Roman, Calibri? I don't think that changing the font is going to make your file smaller.

 

[zone709]

What do you want to change the text to? Arial, New Times Roman, Calibri? I don't think that changing the font is going to make your file smaller.

Hi i was thinking can i highlight the text and use text columns somehow to covert the data so the file isn't so big anymore. The sheets i made that i copy and paste it to are 126,000 KB which this should really be like 34KB for the book. Need to do something to downsize the excel books. Can i?

 

[Skyybot]

I don't know. I'd have to see the source data and a definition of what the expected result would be to be able to answer that question.

 

[zone709]

Hi The only thing i did is just copied from a CSV workbook and pasted it into a new book XLSB. Then saved it. By doing this it made the file big. I usually covert the CSV file to XLSB before i so anything. I forgot this time. Instead of me doing this over. I am trying to make the workbook size smaller. Its save as a XLSB. I am thinking the paste data from the CSV file made the XLSB large. This file is usually 30KB but its 126,000 KB

 

[Skyybot]

I'd start with selecting all of the Cells and Clearing Formats. Whittle it down little by little. Or, another thing to try would be opening the original CSV, and then click Save As (to XLSB), and click on the current XLSB file (click yes to Overwrite).

 

[zone709]

I'd start with selecting all of the Cells and Clearing Formats. Whittle it down little by little. Or, another thing to try would be opening the original CSV, and then click Save As (to XLSB), and click on the current XLSB file (click yes to Overwrite).

Ok i will try both later and let yiu know thank you.