Combine Text in Excel

Open in ChatGPT

If your keywords follow a pattern — such as product code + color + size — you can build them automatically in Excel instead of typing each one.

Step 1: Combine text in Excel

1. Put the product code, color, and size in separate columns (for example, columns A, B, and C).
2. In the column where you want the finished keyword, type a formula like =A2&B2&C2.

Excel will join the values from each column into one keyword automatically.

Step 2: Paste the combined keywords into the upload file

1. Copy the keywords you generated.
2. Right-click in the destination cell and choose Paste Special › Text.

Tip

Pasting as text prevents Excel from changing the format of your data.

Caution

If your product descriptions contain non-Latin characters, save the file in UTF-8 encoding to avoid garbled text. If you find this difficult in Microsoft Excel, use LibreOffice instead — it saves as UTF-8 by default, works the same way, and is free.

Option: Use Google Sheets instead of Excel

1. Upload the downloaded sample file to Google Drive.
2. Open a new sheet and prepare your keywords and descriptions using the formula method above.
3. Paste all the keywords and descriptions into the sample file.
4. Download the file as CSV from Google Drive.
5. Go to TOOLS › BULK UPLOAD KEYWORDS and import the CSV.

See also:

• How to download and setup Libre office
• Bulk upload keywords