Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an XSLX file where some rows have multiple lines, for example:


When I'm trying to export (using menu "Save As") this file as CSV or Excel workbook (1997-2003), Excel substitutes multi-line cell's value with a lot of hash symbols


Are there any ways to export these file to CSV file without skipping such cells?

I see hashes in Excel (because it doesn't fit the cell) and in any text editor used to open the CSV file after exporting XSLX as CSV.

share|improve this question
I've add a couple of details in my question. I see hashes in Excel (xlsx) and in any text editor (csv). Hashes in Excel is not a problem definitely. – ravnur Feb 1 '12 at 10:27

Problem is solved.

I added "`" at the beginning of each cell using VB. After that I change cell format from "text" to "number". After these manipulations file was correctly saved to csv format.

share|improve this answer

Are you sure it's not just because the cells are too small for the contents? For example, if I put 121221312121121221 into an Excel cell, then make the cell smaller, at a certain point all the numbers in the cells turn into ####.

It's probably because CSV files don't hold any type of table width data. If you open the CSV in Notepad, your data will probably be there.

Have you tried dragging the cells of the CSV file bigger? This should make the data appear. If this is the problem, it is only a temporary measure though, as CSVs don't save cell width data.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .