I had to change my bank account number because I was phished. Now the bank is only allowing me access 7 years of data in statement form. I copied the data I need to LibreOffice. I used tabs to line up the data created.How do I convert to LibreCalc file?
If your statement is in a format like this:
Date Out In Balance
14/3/1999 23.00 47.00
19/4/1999 12.50 59.50
(A single tab between each value, and the two “data” lines each have a “blank” value), then you can use one of these two approaches:
1. COPY - PASTE
-
CTRL-A
to select all the information in your document; - in your new spreadsheet,
right-click
in A1 (Or whatever cell you want!), - choose
Paste Special > Unformatted Text
- in the “Text Import” pop-up, make sure you have
[✓] Tab
selected for the “Separated by” value. You should be able to confirm the expected result in that window, too; - assuming that looks good, click
OK
.
The result is something like this:
You will then need to format the cells for currency, etc., but the data “transfer” will be done.
2. CONVERT TO CSV
With that same original document, you can do a global search/replace to produce CSV format for opening in Calc:
-
CTRL-H
(or whatever on your system) to open the Find & Replace dialog. - ensure that
[✓] Regular Expressions
is checked in the “Other Options” panel (can be toggled open). - in the Find: field, put in
\t
- in the Replace: field put
,
- click
Replace All
.
Use Save As… to save the file in Text (.txt) format, then change the resulting file so the name is “my-file.csv”. Open this in Calc, and it will be displayed in the spreadsheet.
Again, you will then need to format the cells for currency, etc., but the data “transfer” will be done.