Product Embedder

Generate text embeddings for Excel rows using Ollama.

Prerequisites

• Node.js 16+
• Ollama running locally with nomic-embed-text model

Installation

npm install -g product-embedder

Or use directly:

npx product-embedder

Usage

Command Line

embedder input.xlsx
embedder file1.xlsx file2.xlsx file3.xlsx

Programmatic Usage

import { embedFiles } from 'product-embedder';

await embedFiles(['data.xlsx'], 'output.xlsx');

How It Works

1. Reads Excel files (.xlsx)
2. Converts each row to text (columns joined with " | ")
3. Generates embeddings using Ollama's nomic-embed-text model
4. Saves results with original data + embeddings + source file column
5. Outputs both .xlsx and .csv formats

Output

Creates timestamped files like products_with_embeddings_20250911T173045.xlsx containing:

• Original data columns
• embedding column with JSON array of vectors
• source_file column with source filename

Configuration

Set Ollama endpoint (default: http://localhost:11434):

OLLAMA_API=http://your-ollama-server:11434 embedder input.xlsx

Requirements

• Ollama server running locally or remotely
• nomic-embed-text model installed in Ollama
• Valid Excel files (.xlsx format)

License

MIT