Export LibreOffice to LibreCalc?

[justjo]

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?

[dajare]

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.