Ask Your Question
0

How can I make a csv file with Writer and import with Calc

asked 2015-09-25 16:09:10 +0200

Luis Pina III gravatar image

updated 2015-09-30 11:44:30 +0200

Alex Kemp gravatar image

LibreOffice 4.4.3.2 Writer & Calc Linux Mint 17.2

I tried saving a csv file with Writer, when saving I wrote the file extention as csv, and it saved as .csv.odt. How do I import into Calc?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2015-09-30 11:55:35 +0200

Alex Kemp gravatar image

Hi Luis Pina III

You cannot import the ODT file into Calc; it needs to be plain-text (though containing comma-separated text, of course).

Importing and Exporting CSV Files (wiki Help)

The key on export is step 4:-

2) Choose (menu)FileSave as
...
4) In the File type box, select Text CSV.

If this helps then please tick the answer (✔)
...and/or show you like it with an uptick ()

edit flag offensive delete link more
0

answered 2015-09-30 13:34:47 +0200

Lupp gravatar image

updated 2015-09-30 22:26:14 +0200

If you need the csv file anyway, do as @Alex Kemp described. If the csv just was thought to be an intermediary helper you may omit it this way:

1) Select the text you want to import into a Calc sheet. (> 'Edit' > 'Select All' e.g.) and copy it. (edited)

2) Go to the appropriate cell of your sheet (or insert a new one) in your Calc document.

3) > 'Edit' > 'Paste Special...' (Ctrl+Shift+V) > ' Unformted text' > 'OK' > Select options > 'OK'

edit flag offensive delete link more

Comments

I think you left out step 1a: Copy.

JKEngineer gravatar imageJKEngineer ( 2015-09-30 22:04:43 +0200 )edit

@JKJEngineer : Thanks! In addition: We can even 'Paste' (without the 'Special...') and keep the formats getting one cell per paragraph. A strange thing I just observed first time (V5.0.2): Th cells filled this way with text in font 'Liberation Serif', paragraph style 'Default' originally don't show any font name. Neither in the toolbar nor in the sidebar nor in the 'Format Cells' dialogue nor in the 'Format Character...' dialogue.

Lupp gravatar imageLupp ( 2015-09-30 22:40:06 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-09-25 16:09:10 +0200

Seen: 763 times

Last updated: Sep 30 '15