Getting a giant spreadsheet into Base!

Alright, I’ve tried to approach this problem from multiple angles and I just can’t seem to make any traction. I am very new at this!

I have a giant 32 sheet .xls (65000 rows per sheet, 2.5 million entries) spreadsheet I’m trying to get into Libre Base. Whenever I use the automated “import from” option when creating the database - it gives me 32 tables.

I’m simply looking for a way to run basic queries (pretty much one field range at a time) on the entire thing. I’ve tried looking up “merging tables”, “relations”? SQL commands to query all tables, copy/paste (my PC is too old, locks up).

PS: The people who made the spreadsheet screwed up by not putting the fields on each sheet after the first one, would adding a proper field row on sheets 2 thru 32 give me just one table when importing?

Hello, 2 questions

  • Did you check that LO Base can handle a sheet that huge? (LO Base specifications)
  • Did you try to use Calc (copy all the datas in your sheet / paste them directly in your base to create a new table) ?
    I use small tables though, not sure it can work for you…

It had never occurred to me tha LO might not be able to handle it. I’ll have to check. With your second question - my PC is just too old to copy 65 thousand records. It just locks up.

First, with that amount of data, you should consider using a split database for storage if you haven’t done so already. Large amounts of data in an embedded DB can be lost.

If you already have created 32 tables and the data is correct for your needs, then SQL is probably the way to go. You can INSERT records from one table into another until all are in one table. See this link: click here.