Prepare a CSV file

You must prepare a CSV file to upload or delete devices in bulk. Proper formatting of the CSV file differs depending on whether you are uploading or deleting for a specific customer, or for multiple customers.

Prepare a CSV file for a specific customer

To create a list of devices for a specific customer, prepare a CSV file as follows:

• Enter one device IMEI per line. Avoid commas to ensure device information is uploaded correctly to the portal.

• If you’re uploading any dual-SIM devices, enter either of the two associated IMEIs.

• Don’t add any header rows or lines.

• If you use a spreadsheet app like Microsoft Excel to create your CSV file, to prevent numeric device IDs from being converted into scientific notation, you can:

  • Select Fraction from the Number drop-down menu on the Home tab.

  • Set the cell format to Number, and set Decimal places to 0.

Prepare a CSV file for multiple customers

To create a list of up to 10,000 devices for multiple customers, prepare a CSV file as follows:

• 1st column — Customer ID. Make sure each row has only one customer ID.

• 2nd column — Device IMEI/serial number. Make sure each row has only one IMEI or serial number. If you’re uploading any dual-SIM devices, enter either of the two associated IMEIs.

• 3rd column (optional) — Order number. The order number must contain only alphanumeric characters.

• 4th column (optional) — Order date. The order date must be in YYYYDDMM format.

• Avoid commas (except for the separator commas if you’re creating the CSV file in a text editor) to ensure device information is uploaded correctly to the portal.

• If you use a spreadsheet app like Microsoft Excel to create your CSV file, to prevent numeric device IDs from being converted into scientific notation, you can:

  • Select Fraction from the Number drop-down menu on the Home tab.

  • Set the cell format to Number, and set Decimal places to 0.

Your CSV file should look something like this: