Ask Your Question
1

how do I open csv files in libre Office 6.0 in windows 10

asked 2018-06-17 21:35:00 +0200

PeterMR gravatar image

updated 2018-06-17 21:38:45 +0200

I download my bank details as csv files. LO opens an import screen showing the file as separated by tabs plus commas. All commas except the first two are ignored so what I get is colA date, ColB ref, colC all other data in one block. All this is on line 1. Help please! Peter R

edit retag flag offensive close merge delete

Comments

Have you tried the way gabix commented? Open with...

Xoristzatziki gravatar imageXoristzatziki ( 2018-06-20 07:16:59 +0200 )edit

1 Answer

Sort by » oldest newest most voted
2

answered 2018-06-17 22:39:10 +0200

David gravatar image

When you "open" your CSV file in LibreOffice, you should get a dialog that looks something like this:

import-csv

You should be shown, in the table immediately below those options, a preview of how your data will be manages in the worksheet.

Which of those Separator Options you choose depends on the characteristics of the CSV file you're importing.

Do you know if the larger "fields" use the " for a string delimiter? It sounds as if the data in your CSV is not corresponding to the choices made for these options. Of course, without a sample input CSV (which for obvious reasons you probably prefer not to share -- unless you can concoct one for us with dummy values?), it will be very difficult to know for certain what is going wrong in your case.

(And it could be that all of this is already known to you!) HTH, all the same.

edit flag offensive delete link more

Comments

2

Good answer. One more detail: to get that dialog window for sure l, you have to manually select the respective file type in the file type field. The problem, as I understand, emerges because the file type is not selected, and the file opens in Writer as a plaintext file.

gabix gravatar imagegabix ( 2018-06-17 22:47:24 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-06-17 21:35:00 +0200

Seen: 507 times

Last updated: Jun 17 '18