• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Saving excel file with blank column as CSV

B

budimu

New Member
Hey Guys,


I have a big issue, i have an excel file where column A & Column B are blank, but i do have data in columns C,D,E,... i have noticed that when i save my excel file into a CSV file, the blank columns are removed from my new CSV file, and column C & D are now the new columns A & B. Does it make sense?


I need to have those 2 blank columns and then the other columns, what can i do to preserve them?


thank you so much!!!
 
Budimu


That's unfortunately how Excel exports CSV Files


If you leave a space character or another non-printable character in a single cell in Column A, Excel will export it as you wish with:

,,3,4,5

,,3,4,5

etc
 
hey budimu


i made one excel file in which column A and B are blank and only column C have data now i save the file as CSV(macintosh) format then there were all the column as before in excel... i mean its perfect converted i had no problem.
 
You must log in or register to reply here.
Back
Top