Ask Your Question

Being able to import spreadsheets to a database and arranging the date. [closed]

asked 2018-01-03 11:12:23 +0200

ERas gravatar image

updated 2020-08-02 11:47:03 +0200

Alex Kemp gravatar image

I've got a folder of a bunch of invoices that need to be sorted by date. They don't have the dates written on the filename but they do have a date on a specific cell in the spreadsheet. So I need to import the spreadsheets in the database, pick the cell that has the date, arrange it accordingly, and see what spreadsheets are within the desired date range.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2021-02-12 12:10:08.203051

1 Answer

Sort by » oldest newest most voted

answered 2018-01-05 02:24:41 +0200

Ratslinger gravatar image


I don't believe there is an easy solution for your request. Calc data can be inputted in Base tables in two ways: linked and csv.

When linked, Base gets whatever decipherable data from the sheets in the document and creates tables based upon this. This data is rows and columns of the same type information. The same is true of creating csv files from the sheets. Now based upon provided information it doesn't appear you sheets would be arranged as such. Since they are invoices you probably have a section for name & address another section for details & yet another for totals. This would not be a format understood in simple conversion.

Unless what you have is significantly different than described, then the only solutions to get this information into a database would be custom programming to read the sheet data and transcribe it into a format acceptable for entry into table(s) or manually copy data item by item.

It may be easiest to just rename the files to include the date.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-01-03 11:12:23 +0200

Seen: 223 times

Last updated: Jan 05 '18