We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

in Base, how do you "import" (not link) data from an Excel spreadsheet in to a new file?

asked 2021-04-23 01:03:54 +0200

Flying COham gravatar image

updated 2021-06-01 06:51:35 +0200

Alex Kemp gravatar image

I want to pull data from an Excel spreadsheet into a new separate Libre file that has no link back to the original file. Once it's there, I can build the system I want.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2021-05-11 12:28:30 +0200

MSPhobe gravatar image

Though dated, and written for OO, I believe that what's in the following is basic enough that it still Just Works.

Blow by blow guide to getting data from spreadsheet to database.


Please let me know of anything that is a serious hurdle to using that? I.e. things that are wrong in a major way?

edit flag offensive delete link more

answered 2021-04-23 01:20:05 +0200

Ratslinger gravatar image


Open your Exel file in Calc. Save it as native .ods spreadsheet. Now you can copy and paste from Calc to Base tables. See this answer for further information in links there -> add csv or excel base

edit flag offensive delete link more


Thanks, I think this got me started in the right direction. I'll come back if I get stuck. ( : > )

Flying COham gravatar imageFlying COham ( 2021-04-23 01:30:04 +0200 )edit

If problems, will help best as I can. Please be as specific as possible.

Ratslinger gravatar imageRatslinger ( 2021-04-23 01:32:59 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-04-23 01:03:54 +0200

Seen: 42 times

Last updated: May 11