Skip to main content

How to extract a list of my SIMs from the app?

Export a CSV file directly from the SIMs page.

Written by Jakub Kubinski

Environment

Question

  • How to extract a list of all of my SIMs from the app?

  • How to export a CSV with a SIM list?

  • Can I get an Excel export of all our SIM cards, including all associated tags?

  • How can I pull a full SIM list from the app?

  • I need a SIMs list with last active connection, IMEI, ICCID, etc.

Answer

Exporting your SIM data takes just a few clicks.

  1. Log in to the Onomondo app.

  2. Navigate to the SIMs page.

  3. Apply filters and customize columns to show the SIMs and attributes you want.

  4. Select SIMs in the table by clicking the checkbox in the top left corner of the table. If you are exporting all SIMs, click "Select all X SIMs".

  5. Click "Export SIM data".

  6. Choose between “Columns currently shown” or “All available data,” and download the CSV file.

💡 Few tips:

  • You can either export data for all SIMs in your estate, or only selected SIMs.

  • You can choose whether the table displays 20, 50 or 100 SIMs at a time.

  • You can also be selective as to which information is included in the CSV export by customizing the table using the cogwheel in the top right corner.

⚠️ Limitations:

  • Exports include only the SIMs that match your current filters and are selected.

  • There is a maximum of 5000 SIMs that can be exported at once.

Workaround

Use the Onomondo API.

  1. Set up an API Key.

  2. Retrieve all SIMs with this GET request.

  3. Convert the JSON output into a CSV file.

    1. Use a custom script, or

    2. Use an online JSON-to-CSV converter.

  4. Import the CSV file into Excel or Google Sheets.

Did this answer your question?