import csv to writer table

Why is this so hard? I have a 2-column CSV with titles in row 1 and I want to import it to a Writer 2-column table of the same length. Best I can do is cell-by-cell copy paste from an xterm. This should be a doddle.

It’s not hard to me. I seem to do it another way. But as you don’t describe what you tried and why it didn’t fit you, I’d rather not tell what I do.

@Mike2: +1

A Writer file is a text document. A CSV file is a spreadsheet or a database file. Thus, I can only second Mike’s comment.

Librebel is half correct. It doesn’t work as he\she described (but yes, it should in ideal world :slight_smile: ) . If works though as follows:

  1. Open a .csv file in Libreoffice Calc
  2. Select all the sheet or the part you need to insert into a Writer table
  3. Press Ctrl+C
  4. Click on the place in the LibreOffice Writer document you want to paste the info into
  5. Press Ctrl+Shift+V to activate the “Paste as…” menu
  6. When the “Paste as…” menu shows up, click on the bottom option “Formatted text(RTF)”.

I did that a lot of times, it worked. Libreoffice (x64) version.

Hello @duncan_roe,

You could try to open the .csv file in Calc, then select all cells and copy-paste the result into Writer.

Looks like nobody understands what the task is.

The task is to transfer calc sheet ( after column hiding,
sorting and filtering ) to the final report in wrter.

Instead of understanding this task and the fact it is next to impossible every adviser
states that this task has no sense.
Paste special as RTF ignores filtering and shows traces of hidden colums.

Looks like nobody has described what the task is (until now) :wink: - and even now, you didn’t follow the site’s rules, and wrote as “Answer”/“Solution” what should have been edited into the question itself…

I understand your sarcasm and admit that I have used the wrong style. However, I have an excuse

  1. I was looking for the way to copy a table from calc to writer, and read plenty of stupid advice.
  2. I have found the solution and can share it with the audience - PASTE AS HTML. This preserves the appearence and data.