Forum Discussion

selleX's avatar
selleX
Copper Contributor
Jan 16, 2019

Excel Conversion to CSV

Hi, 

 

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.

excel
Excel Online

2 Replies

  • johndre's avatar
    johndre
    Copper Contributor
    Feb 26, 2019
    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
  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Jan 16, 2019
    Hi

    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?

Resources