Help & FAQ

How to Import Your Excel Product List into HuggsPOS (Step by Step)

Already have your products in Excel or Google Sheets? Import the whole list at once instead of typing each item. Here's how to prepare the file, fix row errors, and avoid the common mistakes.

By the HuggsPOS Team · November 2, 2026 · 4 min read
The HuggsPOS item list with prices and stock levels

If your store already keeps a product list in Excel, you don't need to type it into a POS one item at a time. With 200 products, typing takes an afternoon. Importing takes a few minutes.

This guide walks through the whole process: preparing the file, importing it, and fixing the rows HuggsPOS can't read.

▶ Video: How to import your Excel product list to HuggsPOS

The video uses a CSV file with renamed headings. HuggsPOS now reads Excel (.xlsx) files directly and recognizes most common headings, so a few of the steps below are shorter than in the video.

Step 1: Check your file

Open your product list and look at the columns. HuggsPOS uses six:

ColumnRequired?Example
nameYesCoke 1.5L
price (selling price)Yes87
categoryNoDrinks
sku (item code or barcode)No4801234567897
stock (quantity on hand)No24
cost (your buying price)No72

Only name and price are required. You usually don't have to rename your headings either. HuggsPOS recognizes common ones such as Product Name, Item, SRP, Selling Price, Qty, Quantity, On Hand, Item Code, Barcode, Unit Cost, Puhunan and Presyo. If a heading isn't recognized, rename it to one of the six names above.

The heading row doesn't have to be the very first row. If your file has a title or a store name on top, that's fine.

Include the cost if you have it

The cost column is optional, but it's worth filling in. Without it, HuggsPOS can show your sales but not your profit, because profit is your selling price minus your cost.

Step 2: Clean up the numbers

Most import errors come from the price, stock and cost columns. Before importing:

Step 3: Import the file

  1. In HuggsPOS, go to Items → Item List and click Import.
  2. Click Choose File and pick your .xlsx or .csv file. Older .xls files can't be read. In Excel, use File → Save As → Excel Workbook (.xlsx) first.
  3. HuggsPOS checks every row before anything is added and shows a preview of the items it's ready to import.

Starting from nothing? Click Template in the same window to download a ready-made file you can fill in.

Step 4: Fix any row errors

If a row has a problem, HuggsPOS lists it, for example "Row 8: invalid price". The row number matches the row in your spreadsheet, so you can go straight to it.

  1. Go back to your file and fix that row.
  2. Save the file.
  3. In HuggsPOS, click Clear, then choose the file again.

When the preview shows the right number of items, click Import [number] Items.

Step 5: Check the result

Your items now appear in the item list with their prices, categories, codes and stock, and they're ready to sell. Your categories also show up as tabs on the POS screen, so every item is a tap away.

Spot-check a few items, especially your best-sellers, to make sure the prices and stock are right.

Two things to watch out for

Google Sheets or another POS?

Related reading

Try HuggsPOS free

Free POS for Philippine stores. Every new store gets 30 days of Pro free — no credit card.

Create your free store