How to convert excel to .csv file

1 replies
Basically I am trying to save an excel file into .csv and its loosing its formating when I do save as .cvs

Is there any way or software I can use to convert it without losing some of the formating?
#convert #csv #excel #file
  • Profile picture of the author Nigels
    Unfortunately that's something which is inherent to the purpose of CSV. CSV is intended to able to swap data between applications that know nothing about each other's formatting. So a CSV file will only contain the unformatted data in tabular form, with commas to separate the individual fields (bits of data). Once your excel data is converted to CSV, it's always going to end up looking something a bit like this example from Wikipedia:

    1997,Ford,E350

    If you want to retain formatting, you'll need to save to a different file type. Does the software you want to use the CSV file with support any other formats?
    {{ DiscussionBoard.errors[1796013].message }}

Trending Topics