Generate Metadata Attributes
I need to combine 'Trait 1' (e.g., Trait Type) and 'Trait 2' (e.g., Trait Value) to create a JSON-friendly attribute string for my collection, such as 'Background: Blue'.
=CONCATENATE(A2, ": ", B2) How it works: The CONCATENATE function is perfect for joining multiple text strings or cell values into one single string. In this scenario, it allows an NFT creator to combine the 'Trait Type' and 'Trait Value' from separate columns, along with a custom separator like ': ', into a single, structured string. This resulting string is easily parsable and ready to be incorporated into JSON metadata files, streamlining the process of preparing attributes for a large NFT collection.
Data Setup
| Trait Type | Trait Value |
|---|---|
| Background | Blue |
| Eyes | Green |
| Headwear | Cap |
| Expression | Happy |
Step-by-Step Guide
Open your Excel spreadsheet containing your NFT trait data.
Identify the column for 'Trait Type' (e.g., Column A) and 'Trait Value' (e.g., Column B).
Select an empty cell where you want the combined attribute string to appear (e.g., C2).
Type the formula: `=CONCATENATE(`.
Click on the cell containing the first trait (e.g., `A2` for 'Trait Type').
Add a separator by typing `", ": "` (this adds a colon and a space, enclosed in double quotes and separated by commas from other arguments).
Click on the cell containing the second trait (e.g., `B2` for 'Trait Value').
Close the parenthesis `)` and press Enter.
Drag the fill handle (small square at the bottom-right of the cell) down to apply the formula to all your NFT traits.