How to Import Files to OpenOffice Calc

You can type data in any application manually, but this takes some time and is usually rather boring. If data is available in any digital form, it is always quicker to import it.
by Updated March 4, 2013

OpenOffice Calc lets users import data from various other systems. It is able to open up files of many other applications and convert them.

A. You can check what types of files OpenOffice Calc is able to convert in the File > Open menu.

  1. Go to the File menu

  2. Select Open and click the “files of type” dropdown menu. By scrolling down, you will see the file formats OpenOffice Calc is compatible with.

  3. If the file format is compatible with OpenOffice Calc, you can open it by double-clicking on the file.

B. If the file format is not compatible with OpenOffice Calc, you can try to export the data to a delimited text file (CSV file) in the source application. Delimited text files can be imported into Calc.

How to import text files into Calc?

  1. Go to the File menu

  2. Select Open and when the dialog comes up, choose the file to load. Double-click on the name of the CSV file that contains the data to be imported. The text import screen will appear. Here you can control how the data will be mapped to cells in Calc.

  3. Check what delimiters separate data fields in the CSV file. These are characters like comma or tab surrounded by either single or double quotes.

  4. Check the appropriate boxes of the Separator options. The text will split across the columns, you will see the result in the datagrid at the bottom of the screen.

  5. You can change a column's data type by clicking on the column, and then selecting the required Column type in the pull-down menu. E.g. if a column contains dates, select the column type accordingly.

  6. If you want to exclude a column of the CSV file from the import process, select the column type Hide. That column will not be imported at all.

  7. If the result in the datagrid looks fine, click the OK button. The import is ready.

  8. Should all the text appear in one column, check Separator options. As you change them, you will see the text distributed across the columns differently.

C. Option: You can use the Insert > Sheet from file menu to import the CSV file as a new sheet within a workbook. The data of the CSV file will be entered into a new sheet.

  1. Go to the Insert menu

  2. Select Sheet from file and when the dialog comes up, choose the file to import. Click Insert.

  3. Check the appropriate boxes of the Separator options as discussed before. When it is done, click OK.

  4. Indicate if you want to insert the new sheet before or after an existing worksheet, and click OK.




anonymous by MikeeR on 4/1/2013
I hit Files>Open and I cannot see "files of type"
I cannot create "files of type"

spreadsheeting is tedious and maybe
why internet marketers
never elave their fay jobs
anonymous by Roger on 4/2/2013
In some versions, the “files of type” words may not be displayed in the “Open” box, but the file type list should be always there. It is below the file names, and the first option displayed is “All files”.
anonymous by Hugh on 12/15/2014

I have a simple task - I get calc spreadsheets every week, and I want to merge them into one master that accumulates the weekly sheets. I don't want to import the new sheets, I want the data. It seems easier to import text than it is merge spreadsheet files.

anonymous by Werner on 12/1/2018

But, I DON'T want a new sheet! Instead read just the data from .csv into an EXISTING (preformatted) sheet.

anonymous by michael on 3/25/2019

like other 'freebie' 'applications',. calc is written by a huge childish committee of unskilled 'workers' who cannot get jobs at REAL companies. This is an example of calc's preposterous uncapable abilities to deal with real world data - which is NEVER 'entered by the keyboard', contrary to the absurd statements in libreoffice / open office 'help' files. What utter nonsense. OF COURSE it does not work - who would expect it to work? Excel, on the other hand, WORKS and WORKS WELL.
No contest, and the reason is simple: Socialism TAKES, Capitalism CREATES.
End of discussion.

Add your comment

by Anonymous - Already have an account? Login now!
Your Name:  

Enter the text you see in the image below
What do you see?
Can't read the image? View a new one.
Your comment will appear after being approved.

Related Posts

What is Impress? Impress is a presentation software that is delivered with the free OpenOffice suite of programs. It can be downloaded free of charge, and can open presentations created in PowerPoint. Apart from Impress format, you can save your...  more »

One of these useful features is the pivot table function. You can find it in all spreadsheet applications. The present guide shows how to create a pivot table in the Calc application of LibreOffice, which is the Ubuntu Linux version of Calc in...  more »