Home

Excel Conversion to CSV

%3CLINGO-SUB%20id%3D%22lingo-sub-319886%22%20slang%3D%22en-US%22%3EExcel%20Conversion%20to%20CSV%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-319886%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20know%20if%20there's%20any%20other%20way%20we%20can%20convert%20an%20excel%20file%20(.xlsx)%20to%20CSV%20without%20loosing%2Fadding%26nbsp%3B%20any%20data.%20Some%20have%20the%20dash%20(-)%20character%20at%20the%20beginning%20of%20the%20texts%20and%20when%20the%20file%20is%20being%20converted%20to%20csv%2C%20it%20becomes%20a%20formula%20(a%20lot%20of%20ERROR%20shows%20on%20the%20columns)%20.%26nbsp%3B%20We%20already%20tried%20modifying%20the%20texts%20by%20adding%20quotation%20marks%2C%20it%20works%20but%20it%20is%20a%20hassle%20since%20we%20have%20multiple%20files%20to%20convert.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-319886%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-357365%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Conversion%20to%20CSV%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-357365%22%20slang%3D%22en-US%22%3EI%20am%20not%20sure%20of%20a%20solution%20within%20excel%20but%203rd%20party%20utilities%20can%20be%20very%20helpful%20in%20this%20regards%20such%20as%20Total%20Excel%20Converter%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.coolutils.com%2FTotalExcelConverter%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.coolutils.com%2FTotalExcelConverter%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-319912%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Conversion%20to%20CSV%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-319912%22%20slang%3D%22en-US%22%3EHi%20%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20you%20say%20it%20becomes%20a%20formula%2C%20are%20you%20saying%20that%20when%20you%20open%20up%20the%20CSV%20to%20look%20at%20it%20using%20Excel%20then%20Excel%20turns%20it%20into%20a%20formula%3F%3CBR%20%2F%3E%3CBR%20%2F%3EDoes%20the%20CSV%20look%20OK%20if%20you%20open%20it%20in%20NotePad%3F%3C%2FLINGO-BODY%3E
selleX
Occasional Visitor

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.

2 Replies
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?
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
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies