Excel Conversion to CSV

Occasional Visitor



I would like to know if there's any other way we can convert an excel file (.xlsx) to CSV without loosing/adding  any data. Some have the dash (-) character at the beginning of the texts and when the file is being converted to csv, it becomes a formula (a lot of ERROR shows on the columns) .  We already tried modifying the texts by adding quotation marks, it works but it is a hassle since we have multiple files to convert. 


Thank you in advance.

2 Replies

When you say it becomes a formula, are you saying that when you open up the CSV to look at it using Excel then Excel turns it into a formula?

Does the CSV look OK if you open it in NotePad?
I am not sure of a solution within excel but 3rd party utilities can be very helpful in this regards such as Total Excel Converter: https://www.coolutils.com/TotalExcelConverter
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies