How to save Excel file as CSV, without losing long text?

How to save Excel file as CSV, without losing long text?

I have an Excel file I want to save as a CSV. Some of the cells has a lot of data in it, and so Excel shows it as
##############

And the sort. But of course, the data is actually there.
But when I save it as a CSV, it actually overwrites the data in those cells with those #######
And thus I lose data. How can I fix this, so it doesn't overwrite data with ######?
Double-clicking the cell length to widen it does not work, as the cell is so large even Excel doesn't expand it long enough. Expanding the rows and/or columns did not help either, still showing up as ###### because there's not enough room to display it on the screen/cell.

Solutions/Answers:

Answer 1:

The issue may be that you have a Text format applied to the offending cells. In an Excel cell with Text format, there is a limit of 1,024 characters. For example, the two cells below contain the same text, but A1 is formatted as General and B1 is formatted as Text. When saved as CSV, B1 is saved as pound signs.

enter image description here

Try removing the text format if it is not absolutely necessary to presenting the data properly, and then saving as a CSV. That should do the trick.

If you have long data that needs the Text format to keep Excel from changing your data (e.g. a long sequence of numbers with leading zeroes), you can enter an apostrophe before the text in the formula bar and then convert the cell format to General.

Related:  Stop Excel chart from changing series formatting

Answer 2:

Maybe not the best solution, but use Ctrl+A to select all columns, double click a column separator to make it expand to the size to fit the cell contents, then save the csv, and ctrl+z to undo the column expansion?

Answer 3:

Maybe try expanding the width of the column containing the data, to eliminate the ###### before saving as a CSV.

Our Awesome Tools

References