Anyone use LibreOffice Base?

[grumpyduck]

I'm trying to do something very simple, but having a heckuva time and getting nowhere with the Help system. I have several (three-column, nothing exotic) Excel sheets that I want to import into one table in Base in order to create a couple of simple reports. I have tried Cut and Paste per the Help system, but everything winds up in one cell in the table. I also tried (per the LibreOffice community forum) saving the Excel sheet as an .ODS file and then cutting/pasting, but it still doesn't work. All the field types match.

Can anyone help? I'm thinking either something is corrupted in my install or I'm missing one tiny simple little step somewhere.

Thanks much.

[CentralMass]

1. I'll take a peek when I fire up my laptop running Linux. Have

you tried saving the spreadsheets as csv files and importing them that way ?
https://help.libreoffice.org/Calc/Importing_and_Exporting_CSV_Files

[grumpyduck]

2. Thanks. Yup, I tried that still no-go.

[LuvLoogie]

3. You probably have to open it up in Calc.

Base is the database module, similar to Access.

You might have to do either like to like cross platform, or convert your excel doc into access first.

[Recursion]

4. Don't paste it into a cell in a table, paste directly into the "Tables" tab

It will run through a Druid (I know; it's silly -- Microsoft trademarked "Wizard" at some point) to ask you about the data and generate a new table for you.

https://help.libreoffice.org/Common/Importing_and_Exporting_Data_in_Base