Why Is My CSV Showing Numbers as Text in Excel?
When you export a report to CSV and open it in Microsoft Excel, you may notice that some numeric values are formatted as text. This happens because Excel sometimes auto-detects the data type incorrectly when importing CSV files, especially for values that have leading zeros or are very long numbers.
How to Fix It
- Select the column with the incorrectly formatted numbers.
- Go to Data in the Excel menu bar.
- Click Text to Columns.
- In the wizard, choose Delimited and click Next.
- Uncheck all delimiters and click Next.
- Select General as the column data format and click Finish.
Excel will re-interpret the values and format them as numbers. You can also try opening the CSV by using Excel's Import feature (Data > From Text/CSV) instead of double-clicking the file, which gives you more control over how each column is interpreted.
Related
- How to Export and Print Reports — Full guide to exporting, printing, and saving reports