I'm looking to get the following data into an Excel format: data.charitycommission.gov.uk/
The files are .bcp and there's a table build script. I was planning to build the SQL database and filter the data (to only show 110 category charities). Then, I was planning on exporting the filtered results into an Excel document so I can use the data. But, I got stuck since I haven't used SQL before so I didn't really understand how everything worked.

So, I used a python script to convert the data into a CSV format (which might have worked). Those files as well as a Access database template I found are here: depositfiles.com/files/4sxigix1l
And I got the python script and access file from here: github.com/ncvo/charity-commission-extract

The extract_class field/file has the 'regno number' (the primary key) as well as a 'class ref'. I'm only interested in 'regno numbers' with a 'class ref' of 110. I was hoping to get a list of the 'regno numbers' with a 'class ref' of 110. Then, use that list to get information from the other worksheets for those 'regno numbers'. In the end, I'm looking to make one spreadsheet with information from all the other worksheets but only for 'regno numbers' with a 110 'class ref'. I tried to do that in Excel but apparently the CSV files are too big.

I'm not sure if I could use the Access template to make a database and import the CSV files somehow. Then, sort the data there and export to Excel. I've never used Access before so I'm not sure if that's even possible. Of course, this would probably be easier if I knew how to import to MySQL (since the data is from a database) rather than converting to CSV. Anyway, I'm not sure what the best way forward is. Whether to solve the Excel size problem, use Access or SQL. I would really appreciate some help. Thanks again!