Excel - creating csv file

Question

I want to enter the data manually in a excel file and generate the below CSV File format. Problem is I entered the data in 11 rows(Excel). First row has 10 columns. Second row has 15 columns. Last row has 4 columns. Some columns can have empty data also. When i save the file as csv file first line and last line has 15 columns. How can i generated the csv file. what i need to do to include the empty columns in the csv file

H,TEST_w99999999999_f101203001,03/12/2010,02:45:28,MIS,MISC,MIS,NEW,, D,,0027940622,,,MISC,030100059566901-000000452312108,MIS,03/12/2010,,,1,57.25,, D,,0027940622,,,MISC,030100059566901-000000452312109,MIS,03/12/2010,,,1,56.00,, D,,2000003318,,,MISC,030200059566901-000000452308586,MIS,03/12/2010,,,1,0.92,, D,,2000004473,,,MISC,030300059566901-000000452176305,MIS,03/12/2010,,,1,-0.45,, D,,2000004439,,,MISC,030300059566901-000000452243016,MIS,03/12/2010,,,1,-38.28,, D,,2000003460,,,MISC,030300059566901-000000452251974,MIS,03/12/2010,,,1,-267.77,, D,,2000006846,,,MISC,030300059566901-000000452300634,MIS,03/12/2010,,,1,-0.05,, D,,2000006846,,,MISC,030300059566901-000000452300636,MIS,03/12/2010,,,1,0.05,, D,,2000004059,,,MISC,030300059576013-000000452317628,MIS,03/12/2010,,,1,272.50,, T,TEST_w99999999999_f101203001,9,80.17

can anyonepls respond to my query

Arav
– Arav

2010-12-30 04:50:07 +00:00
Commented Dec 30, 2010 at 4:50 — Arav
– Arav, Commented Dec 30, 2010 at 4:50

CaBieberach · Accepted Answer · 2010-12-29 11:02:36Z

1

   Sub SaveAsCSV()
      ActiveWorkbook.SaveAs Filename:= _
          "C:\NewCsvDile.csv", FileFormat:=xlCSV, _
           CreateBackup:=False
   End Sub

answered Dec 29, 2010 at 11:02

CaBieberach

1,7682 gold badges17 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Arav Over a year ago

Header and tail records have different number of columns. How can i resolve it.

CaBieberach Over a year ago

Just save it as a "CSV (comma delimited) (*.csv)." type. You'll only have as many columns per row as you have data. Empty cells between columns will also be respected. Can you post a screenshot of the excel file you are filling?

Arav Over a year ago

Thanks a lot for the info. I am not sure how i can paste screen scot here. Only text box is available.

CaBieberach Over a year ago

Nice to hear it helped. To insert pictures in a post, use the 6th icon from the left. The one that looks like a polaroid picture.

Collectives™ on Stack Overflow

Excel - creating csv file

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related