Ask Your Question
0

I am trying to open an Excel CSV spreadsheet but all columns are merged into one?

asked 2018-06-20 18:48:30 +0200

OldFatDog gravatar image

A client sends to me Excel CSV spreadsheet. When I open them in LibreOffice all of the columns are merged into one rendering the spreadsheet useles. What am I doing wrong?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2018-06-20 19:56:40 +0200

m.a.riosv gravatar image

Opening the file don't you see the Text import dialog?, set up the right field separator, usually comma ',' or semicolon ';'.

https://help.libreoffice.org/Common/T...

edit flag offensive delete link more
0

answered 2018-06-20 20:07:21 +0200

OldFatDog gravatar image

BINGO! Thanks!!

edit flag offensive delete link more

Comments

Please use the comments to the answer. And if the answer solves your question please tick the ✔.

m.a.riosv gravatar imagem.a.riosv ( 2018-06-20 22:21:40 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-06-20 18:48:30 +0200

Seen: 33 times

Last updated: Jun 20 '18