Exporting excel to csv

[xchangx]

I have a table of data I need to export to a comma delimited file, but need to include the header with each value.

for ex; header1 value, header2 value, header3 value.

header1 header2 header3
value value value
value value value
value value value

When you export to csv it puts the header at the top, but doesn't include it with the values.

Any ideas?

Thanks!

 

[nickbits]

that isn't a csv file. you need to write a script or something to do the conversion.

 

[KLin]

Definitely not a csv format. Like nickbits said, you'd have to do a vba macro to write to an output file.

 

[postmortemIA]

CSV is plain text format, there's no formatting on it. Contents are separated by commas and line return designates new row. That's it.

 

[Ken g6]

You can create a new sheet with formulas, like =Sheet1!A$1&" "&Sheet1!A2. Replace "Sheet1" with the proper name, fill that through the rest of the new sheet, and you should be able to save the new sheet as a CSV.

 

[xchangx]

Yeah, I figured I'd have to do it that way, just didn't want to...

🙂

 

[Nothinman]

CSV is plain text format, there's no formatting on it. Contents are separated by commas and line return designates new row. That's it.

At the most basic level sure, but when most people speak about a CSV file they're talking about a file that's laid out like a spreadsheet with each column separated by commas with no labels mixed in with the data.