CSV export drops $ signs and all formatting, by design

Dollar signs and formatting disappeared when I saved Excel to CSV

Your prices had dollar signs and bold formatting in Excel, and the CSV has plain numbers with none of it. That's expected — CSV has no concept of cell formatting at all. Here's exactly what gets kept and what doesn't

convert-excel-to-csv · xlsx-for-ai

Formatting and value are two different things — CSV only keeps one

Every cell in Excel has an underlying value and, separately, a set of formatting instructions for how to display it — the number format, the font, the fill color, the borders. Those formatting instructions live in the workbook's styles, not in the cell's value. CSV has no equivalent structure at all; it is nothing more than rows of plain text separated by commas, so when Excel writes a CSV it can only export the raw value, never the styling layered on top of it.

What survives the export and what doesn't

Raw numbers survive, dates survive as whatever text or serial representation the export chose, and literal text strings survive exactly as typed. What doesn't survive: currency symbols and thousands separators that came from a number format rather than being typed directly, bold, italics, colors and borders, conditional formatting rules, and the visual effect of merged cells, which collapses down to just the top-left cell's value.

If you need the formatted look, don't rely on the CSV for it

Systems that consume CSV files, like Shopify, Mailchimp, or a database import, almost always want the plain number rather than a formatted string anyway, so the right move is usually to reapply formatting on the receiving end, not to try to preserve it in the CSV. If a destination genuinely requires the literal dollar sign as part of the value, you'd need to generate that as text intentionally before export — understanding that it will then be text, not a number, for whatever reads it next as well.

More Convert your Excel file to CSV — free. guides

← All Convert your Excel file to CSV — free. guides