Ask Your Question
0

How do I open downloaded bank csv files

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

PeterMR gravatar image

updated 2018-04-07 22:56:00 +0200

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 close merge delete

Comments

Hello,

I have not seen any problems opening .csv files thru the import dialog on LO versions thru 6.0.2.1 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
0

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

PeterMR gravatar image

Thanks.

I hope the attached explains what I am getting.

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

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

Peter

edit flag offensive delete link more

Comments

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
0

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 98 times

Last updated: Apr 10 '18