CSV file in Excel is not rendering correctly

Question

This is the content of the excel file:

"Windows Excel","AndroMoney","20140227"
"Id","Valuta","Importo","Categoria","Sottocategoria","Data","Spese(Trasferimento Out)","Entrate(Trasferimento In)","Note","Periodicita'","Progetto","Pagatore/Beneficiario","uid"
"19","EUR","-1079.63","SYSTEM","INIT_AMOUNT","10100101","","Bank","","","","","116EUR-1079.63_26_102"
"20","EUR","-2662.9","SYSTEM","INIT_AMOUNT","10100101","","Credit Card","","","","","117EUR-2662.9_26_102"
"960","EUR","0","SYSTEM","INIT_AMOUNT","10100101","","Bank austria","","","","","265C6BD548CE41FEA0250BF4E19C392F"
"1","EUR","8","Food","Breakfast","20130326","Cash","","","","","","1EUR8_1_1"

And here is how Excel shows its content:

enter image description here

In another post they say it's due to the usage of the , instead of ;

Is it possible to solve the problem without changing Operating System settings?

Raystafarian · Accepted Answer · 2014-02-27 17:20:27Z

2

You can select column A and go to Data - Text to Columns. Then use delimited and define , as the delimiter. This will delimit the data and show it correctly.

If you're asking how to make it delimit based on the comma when you open it, I didn't read the question that way. But instead of double-clicking the file to open, go to the Data tab and Get External Data from it, defining the delimiter.

answered Feb 27, 2014 at 17:20

Raystafarian

3,0622 gold badges32 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

esdebon · Accepted Answer · 2014-02-27 16:02:05Z

1

I use a trick.

Change the extencion from CSV to TXT, the open the file with excel, define , as the delimitator character

answered Feb 27, 2014 at 16:02

esdebon

2,7815 gold badges27 silver badges34 bronze badges

Comments

Mateusz M. · Accepted Answer · 2014-02-27 16:04:45Z

0

In Excel 2010 and newer csv files are read correctly. In older versions you need to specify a separator during import in text import wizard.

answered Feb 27, 2014 at 16:04

Mateusz M.

4127 silver badges18 bronze badges

1 Comment

Revious Over a year ago

mmm.. But the software I'm using is Excel 2010.. and seem not to work

Collectives™ on Stack Overflow

CSV file in Excel is not rendering correctly

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related