Anyone use LibreOffice Base?
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
(15,555 posts)you tried saving the spreadsheets as csv files and importing them that way ?
https://help.libreoffice.org/Calc/Importing_and_Exporting_CSV_Files
grumpyduck
(6,650 posts)LuvLoogie
(7,551 posts)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
(56,582 posts)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