[How to] Extract specific cells from the OpenCelliD csv database


The OpenCelliD cells database is a ~900mb zipped file. After extracting this, it comes down to a ~3 gb CSV. You’ll not be able to view/ work on this via excel as the file is too large for Microsoft Excel to handle.

You can use something like ReCSVeditor to open and extract data from the csv. The reCsvEditor is a cross platform editor for large Csv Files. Author: Bruce Martin

1. Download the cells database from OpenCelliD downloads page
2. Extract the zipped file
3. Download, Install and Run ReCSVeditor
4. Find and Open the CSV in ReCSVeditor

5. Wait, while it reads the file

6. Wait some more

7. Apply all filters you need and click on Filter (We chose to extract all cells with MCC=228) You can find the list of MCC by country here

8. Wait, while it runs your query (If it disappears, don’t worry, it’s probably still running the query. Check your task manager to confirm this)

9. Export output as CSV

There are a number of ways to extract and play around with large CSV files, I’ve found this to be the easiest (unless you know SQL). If there is any other program you’ve used, please share it below.

Hey you! Your first time here? Introduce yourself :)
[Whether or not]Locate a country with only lac & cid?