BabiSender: Created page with "== Excel Description Filler Tool == Automatically populate product descriptions in your Excel spreadsheet using Python. Perfect for e-commerce product imports, inventory management, and bulk data processing. ---- == What This Tool Does == # Reads your Excel file with product names # Matches products to pre-written descriptions # Fills in blank Description cells automatically # Preserves existing descriptions (will not overwrite) # Saves a new Excel file with complete..."

2026-02-25T06:57:36Z

Created page with "== Excel Description Filler Tool == Automatically populate product descriptions in your Excel spreadsheet using Python. Perfect for e-commerce product imports, inventory management, and bulk data processing. ---- == What This Tool Does == # Reads your Excel file with product names # Matches products to pre-written descriptions # Fills in blank Description cells automatically # Preserves existing descriptions (will not overwrite) # Saves a new Excel file with complete..."

New page

== Excel Description Filler Tool ==

Automatically populate product descriptions in your Excel spreadsheet using Python. Perfect for e-commerce product imports, inventory management, and bulk data processing.

----

== What This Tool Does ==

# Reads your Excel file with product names
# Matches products to pre-written descriptions
# Fills in blank Description cells automatically
# Preserves existing descriptions (will not overwrite)
# Saves a new Excel file with completed data

----

== Files Included ==

{| class="wikitable"
|-
! File !! Description
|-
| <code>description.py</code> || The main Python script (heavily commented)
|-
| <code>QUICKSTART.md</code> || Get started in 5 minutes
|-
| <code>INSTRUCTIONS.md</code> || Complete step-by-step guide
|-
| <code>TEMPLATE_GUIDE.md</code> || Examples and formatting templates
|-
| <code>README.md</code> || Project overview
|}

----

== Requirements ==

* Python 3.7+ (Python 3.9+ recommended)
* <code>pandas</code> library (data manipulation)
* <code>openpyxl</code> library (Excel file support)

Your Excel file must have these columns:
* '''Item Name''' – product names to match
* '''Description''' – column to fill (can be empty)

----

== Quick Start (5 Minutes) ==

=== Step 1 – Install Python ===

'''Windows:''' Download from [https://www.python.org/downloads/ python.org] → check "Add Python to PATH" during installation.

'''Linux (Ubuntu/Debian):'''
<syntaxhighlight lang="bash">
sudo apt install python3 python3-pip
</syntaxhighlight>

=== Step 2 – Install Required Libraries ===

'''Windows:'''
<syntaxhighlight lang="bash">
pip install pandas openpyxl
</syntaxhighlight>

'''Linux:'''
<syntaxhighlight lang="bash">
pip3 install pandas openpyxl
</syntaxhighlight>

=== Step 3 – Get Product Descriptions Using AI ===

Ask Claude or ChatGPT using a prompt like:

<syntaxhighlight lang="text">
I need concise product descriptions (50-80 words each)
for these products suitable for a professional webstore:

- Product Name 1
- Product Name 2
- Product Name 3

Include key specifications, features, and target use cases.
Format: Professional, B2B tone.
</syntaxhighlight>

=== Step 4 – Organize Your Files ===

Place both files in the '''same folder''':

<syntaxhighlight lang="text">
📂 Downloads/
├── description.py
└── your-data.xlsx
</syntaxhighlight>

=== Step 5 – Configure the Script ===

Open <code>description.py</code> and update these sections:

'''Input filename (line 19):'''
<syntaxhighlight lang="python">
path = "your-data.xlsx"
</syntaxhighlight>

'''Product descriptions (lines 24–50):'''
<syntaxhighlight lang="python">
descriptions = {
"Product A": "Description for Product A...",
"Product B": "Description for Product B...",
}
</syntaxhighlight>

=== Step 6 – Run the Script ===

'''Windows:'''
<syntaxhighlight lang="bash">
cd C:\Users\YourName\Downloads
python description.py
</syntaxhighlight>

'''Linux:'''
<syntaxhighlight lang="bash">
cd ~/Downloads
python3 description.py
</syntaxhighlight>

=== Step 7 – Check Output ===

Look for the file: <code>webstore_import_with_descriptions.xlsx</code>

----

== Description Dictionary Format ==

=== Basic Template ===

<syntaxhighlight lang="python">
descriptions = {
"Product Name 1": "Short description here.",
"Product Name 2": "Another short description.",
"Product Name 3": "Yet another description.",
}
</syntaxhighlight>

=== Multi-Line Template (Recommended) ===

<syntaxhighlight lang="python">
descriptions = {
"Product Name 1": (
"First part of the description. "
"Second part of the description. "
"Third part continues here."
),
"Product Name 2": (
"Another product with a longer description "
"that spans multiple lines for better readability."
),
}
</syntaxhighlight>

=== Common Mistakes ===

{| class="wikitable"
|-
! ❌ Wrong !! ✅ Correct
|-
| <code>"Dell OptiPlex"</code> (too generic, won't match) || <code>"Dell OptiPlex 7010"</code> (exact match)
|-
| <code>Dell OptiPlex 7010: "..."</code> (missing quotes on key) || <code>"Dell OptiPlex 7010": "..."</code>
|-
| Missing comma after entry || Each entry ends with a comma
|}

----

== The Full Script ==

<syntaxhighlight lang="python">
import pandas as pd

# ============================================================================
# CONFIGURATION SECTION - UPDATE THESE VALUES
# ============================================================================

# STEP 1: Change this to your Excel filename
path = "251106 netgate selling price.xlsx"

# STEP 2: Add your product descriptions here
descriptions = {
"Netgate 8300 TAA": (
"pfSense+ 1U security gateway with Intel Xeon D-1733NT (8-core/16-thread) and Intel AVX-512. "
"Ports: 4×10G SFP+, 4×1G SFP, 3×2.5G RJ-45; PCIe expansion up to 10/25/100G. "
"TAA-compliant hardware; built for medium/large sites, MSPs, and data centers."
),
# ADD MORE PRODUCTS HERE...
}

# STEP 3 (Optional): Change output filename
output_filename = "webstore_import_with_descriptions.xlsx"

# ============================================================================
# MAIN SCRIPT
# ============================================================================

print(f"Loading Excel file: {path}")
df = pd.read_excel(path, sheet_name=0)
print(f"✓ Loaded {df.shape[0]} rows and {df.shape[1]} columns")

def fill_desc(row):
name = str(row.get("Item Name", "")).strip()
existing = row.get("Description", "")
if pd.notna(existing) and str(existing).strip():
return existing
return descriptions.get(name, "")

print("\nProcessing descriptions...")
df["Description"] = df.apply(fill_desc, axis=1)

filled_count = df["Description"].notna().sum()
print(f"✓ Filled {filled_count} descriptions")

print(f"\nSaving to: {output_filename}")
df.to_excel(output_filename, index=False)
print("✓ File saved successfully!")
</syntaxhighlight>

----

== Troubleshooting ==

{| class="wikitable"
|-
! Issue !! Solution
|-
| <code>ModuleNotFoundError: pandas</code> || Run: <code>pip install pandas openpyxl</code>
|-
| <code>FileNotFoundError</code> || Check Excel file is in the same folder as the script
|-
| Descriptions not filling || Product names must match exactly (case and spacing)
|-
| <code>Permission denied</code> || Close the Excel file if it is currently open
|-
| Character encoding issues (e.g. Ã— instead of ×) || Save the <code>.py</code> file with UTF-8 encoding
|}

----

== Best Practices ==

# Always test with 2–3 products before bulk processing
# Keep a backup of your original Excel file
# Product names must match character-for-character
# Review the generated file before importing
# Use UTF-8 encoding to prevent character display issues

----

== Workflow Summary ==

<syntaxhighlight lang="text">
1. Get product names from Excel
↓
2. Generate descriptions using AI
↓
3. Format as Python dictionary
↓
4. Update description.py
↓
5. Run script
↓
6. Check output file
↓
7. Import to your system
</syntaxhighlight>

----

== Performance ==

{| class="wikitable"
|-
! Metric !! Value
|-
| Processing Speed || ~1,000 rows per second
|-
| File Size Limit || Tested up to 100,000 rows
|-
| Memory Usage || < 100 MB for typical files
|-
| Excel Compatibility || .xlsx, .xlsm formats
|}

Excel Description Filler Tool 📝 - Revision history