CODEWITHSUNDEEP
excelcsv
Nagendra Pratap Singh
Nagendra Pratap Singh

Reputation: 163

How to merge two cells in CSV file

How to merge two cell in CSV file like as Excel?

I want to merge two cell in CSV file file as:

Header         Id        Name                       mobileNo
Sub-Header     id   first Name last Name     countryCode  MobNumber

Upvotes: 13

Views: 20732

Answers (2)

gangadhar mudda
gangadhar mudda

Reputation: 7

You can just keep on adding comma's after a text in one cell to merge it with other cells. It did work for me at least.

Upvotes: -1

Surya Tej
Surya Tej

Reputation: 1382

This is not possible

  • A comma-separated values (CSV) file stores tabular data (numbers and text) in plain text.
  • It is just data, with no attached formatting or knowledge of how the cells should be merged when the data is imported.

You could use a script maybe like python to merge them, refer this link https://dzone.com/articles/merging-cells

Upvotes: 13

Related Questions