Update tags via CSV

Youtube Video: Assign Tags to your subscribers' devices manually by uploading a CSV file

To ease your marketing segmentation, Tag values can be assigned to your subscribers’ devices via CSV. By uploading CSV files, you can set values for multiple Tags and multiple devices at once.

Please note that only existing Tags can be updated via CSV.

1. Prepare CSV

Export segment

Go to Segments, select the Segment you’d like to set tags for and export the segment. The CSV file will be downloaded.

The CSV file contains the following user’s data:

• HWIDs of devices complying with that Filter segment (in the first column of the .csv)
• Push Tokens of user’s devices (in the second column)
• types of devices (integer and humanized)
• all Tags from your Pushwoosh account (in the remaining columns)

In cells of the downloaded CSV, change Tags values or add missing ones. Save changes.

Create CSV

Caution

Make sure that:

1. You are saving a file in UTF-8 encoding
2. The delimiter used in the CSV is a comma

If exporting segments is not available for your subscription plan, create a CSV file where:

• one column is named HWID and contains hardware IDs of users’ devices, or User ID and contains user IDs,
• other columns are named exactly as Tags in your Pushwoosh account,
• cells contain values to be assigned for the identifier and Tag specified.

HWID	Name	Age	Push Alerts Enabled	SDK Version	First Install	Preferences
XXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX	Paul	25	false	6.4.12.0	2023-06-27 12:00:00	sport, news
YYYY-YYYY-YYYY-YYYY-YYYYYYYYYYYY	Anne	30	true	6.7.17.0	2025-11-14 16:00:00	fashion, travel

Representation of import.csv in plain text format:

HWID,Name,Age,Push Alerts Enabled,SDK Version,First Install,Preferences
XXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX,Paul,19,false,6.4.12.0,2023-06-27 12:00:00,"sport, news"
YYYY-YYYY-YYYY-YYYY-YYYYYYYYYYYY,Anne,25,true,6.7.17.0,2025-11-14 16:00:00,"fashion, travel"

Note

For a List Tag, the cell can hold either a plain comma-separated list (as in the example above, e.g. sport, news) or a JSON array (["sport","news"]) that follows the format shown in the previous section. Both formats are accepted. The comma-separated form is easier to produce in standard spreadsheet applications, since they don’t natively support the quoted-JSON escaping that a JSON array needs in a CSV cell. A comma-separated cell always splits values on the comma, so use the JSON array form if any single value contains a comma (e.g. ["Sports, general","news"]).

Leaving a List Tag’s cell empty keeps the subscriber’s existing value for that Tag unchanged. To clear the subscriber’s value for a List Tag, use an empty JSON array ([]) instead. For Tags of other types (String, Integer, Date), an empty cell is imported as-is and overwrites the subscriber’s existing value.

2. Upload CSV

Select the project. Be aware that Tag values are updated for the selected project only. If some identifiers in your CSV are not registered for the selected project, Tag values won’t be assigned to those rows.

Go to Import CSV -> Update Tag values.

Press Upload CSV and browse for your edited file.

Note

Please make sure that your CSV has one column with HWIDs or user IDs, and other columns are named exactly as the Tags in your account. Otherwise, columns’ data will be skipped while importing; new Tags are not created in this case.

3. Choose Tags to update

Choose the identifier type your CSV uses, HWID or User ID, and the column that contains it. This choice also determines which Tags can be updated: device-specific Tags (such as SDK Version) require HWID, and user-specific Tags (whose values belong to the user profile rather than a specific device) require User ID. Pushwoosh shows both which Tags will be imported and which will be skipped for the identifier type you picked.

Select columns to import. Values from the columns you select will be assigned to the corresponding identifiers. Columns named not as the Tags in your account will be skipped.

Press Start import.

4. Check the results

Once the import is started, you’ll see its status updated in real time. You can leave the page and check the import status later — it might take a time to process large CSV files.

When the import is completed, the report shows the quantity of Tags updated, rows processed, and rows skipped.

Processed rows are those where Tag values from the selected columns are assigned to the row’s identifier.

Rows are skipped if the identifier specified in the row is not registered for the project you’re updating Tags for. Values from such rows are not assigned.

The example below shows the results of an HWID import, where skipped rows are reported as unregistered HWIDs; a User ID import reports skipped rows the same way for unregistered user IDs.