[Dropped] Data extraction from Calc sheets

[DrdotHouse]

Hello, i have many invoices from an old software in pdf format. I managed to convert them into .xls files. But i dont have an idea how to make a list where i can see the invoiced product and the amount. So i would like to make one list with all invoice positions from all files. Anyone a clue how to manage this? Kind regards

[FJCC]

How many invoices are there?

[Alex1]

Welcome to the forum! Can you upload a small example of what you have and of what you wish to achieve?

[MrProgrammer]

i have many invoices from an old software in PDF format. I managed to convert them into .xls files. But i dont have an idea how to make a list where i can see the invoiced product and the amount. So i would like to make one list with all invoice positions from all files.

Perhaps you can use Merge sheets of spreadsheet documents. To provide any more specific assistance we need to know the layout of your data and what you want in your list with all invoice positions.

[Solved] Combine multiple Excel files into one

If you had converted the PDF files to CSV format, you could just concatenate those files. As long as the layout of each file is identical, it would be easy to load the single concatenated CSV file into Calc and extract the information, using Data → Filter or Data → Pivot Table. Read about those suggestions in Help → Index or in User Guides (PDF) or searching for topics about them in the Calc Forum. If your XLS files consist of only one sheet you can open each one and save it as a CSV file (File → Save As → Text CSV).

If you are a programmer you could convert them all with:

cd "directory with XLS files"
"path"/soffice --convert-to csv *.xls --outdir "directory for CSV files"

That's MacOS/UNIX syntax. I don't use Windows but the syntax there would be similar. In the second command the path is the location of the soffice program on your Windows system.