Ask Your Question
1

export LibreOffice to LibreCalc?

asked 2018-04-26 16:00:59 +0200

justjo gravatar image

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-04-26 17:30:31 +0200

David gravatar image

updated 2018-04-26 17:44:24 +0200

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:

screeshot

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-04-26 16:00:59 +0200

Seen: 39 times

Last updated: Apr 26 '18