We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

How do I open downloaded bank csv files [closed]

asked 2018-04-07 22:49:07 +0200

PeterMR gravatar image

updated 2020-08-12 17:05:04 +0200

Alex Kemp gravatar image

I download bank csv files for my account. If I ask to have these opened in Excel they open straight away. If I ask to have these opened in Libre Office Calc I get a file import screen which I cannot make open the file. How do I get around this, please? Sorry - forgot to say I am using Windows 10. Peter

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-12 17:05:25.793869



I have not seen any problems opening .csv files thru the import dialog on LO versions thru on Linux Mint. Why do you state it won't open? Have you set the proper delimiter (Separator)? Character set (what bank did)? Text option? What happened when you selected OK button?

Ratslinger gravatar imageRatslinger ( 2018-04-07 23:05:28 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-04-10 16:42:20 +0200

PeterMR gravatar image


I hope the attached explains what I am getting.

I am running Libre Office (c64) Build: 92a7159f7e4af62137622921e809f8546db437e5

I hope this helps. C:\fakepath\Libre Office Calc Note.doc


edit flag offensive delete link more


Please don't "Answer" with what is actually a clarification/amendment to the question. You should edit the question and put that sort of things there. Answers answer the original questions.

And better provide a sample CSV and screenshots, and put the textual description right here, so that one doesn't have to open a file to just see... explanation text perfectly suitable in the question body itself.

Mike Kaganski gravatar imageMike Kaganski ( 2018-04-10 16:59:41 +0200 )edit

answered 2018-04-08 01:41:57 +0200

PaulaO gravatar image

When that window comes up, make sure "comma" is checked under the "Separator Options". You can leave the others in the same location checked.

When you check it, the sample screen below should display it correctly.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-04-07 22:49:07 +0200

Seen: 175 times

Last updated: Apr 10 '18