Ask Your Question
0

Can I import an existing Excel sheet into Libre Base?

asked 2015-08-27 00:53:12 +0200

ChrisH218 gravatar image

updated 2015-08-27 10:26:38 +0200

Alex Kemp gravatar image

My Excel version is 14.0.7153.5000 32 bit Office 2010 and my Libre office is 4.4.52 I have imported my XLXS sheet in Libre Calc successfully.

I'm new to Windows databases. Is there a "Getting Started" text file I can down load?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2015-09-16 05:56:36 +0200

LKeithJordan gravatar image

You can save the spreadsheet from Excel or LO Calc as a csv file ande import it into LO Base. These articles should help:
https://help.libreoffice.org/Calc/Imp...
http://dominoc925.blogspot.com/2013/0...

edit flag offensive delete link more
0

answered 2015-08-27 03:56:40 +0200

doug gravatar image

For usual desktop-size data sets, it really is quite simple. This is the guide I have found most helpful. Open the dataset in Calc, select the cells you would like to export to Base, copy the cells, and then go over to Base, click on the Tables tab, and paste the clipboard, follow the remaining prompts to configure the columns. That is by far the easiest way to do it.

(if this answers your question, please accept the answer by clicking the check mark (image description) to the left)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2015-08-27 00:53:12 +0200

Seen: 4,203 times

Last updated: Sep 16 '15