1. Introduction

With the rapid growth of global e-commerce, analyzing customer feedback has become crucial for product optimization. This article explores how AliExpress review data can be processed in spreadsheet tools (like Google Sheets or Excel) to extract actionable insights through sentiment analysis and keyword extraction.

2. Methodology

2.1 Data Collection and Processing

Product reviews are exported from AliExpress as CSV files and imported into spreadsheets for analysis. The raw data typically includes:

• Review text content
• Star ratings (1-5)
• Date of review
• Product variations

2.2 Sentiment Analysis Techniques

Using spreadsheet add-ons like Text Analysis Toolkit

1. Positive sentiment: Expressing satisfaction (e.g., "great quality", "fast shipping")
2. Negative sentiment: Highlighting pain points (e.g., "broke after 1 week", "wrong size")
3. Neutral sentiment: Factual statements ("received in blue color")