Generate a size table from an image or spreadsheet¶

Guide type: Task guide Difficulty: Intermediate Applies to: Size chart tables

Use SmartSize to turn an existing size chart image or spreadsheet table into an editable size table.

This guide is for merchants who already have size information in another format and want to bring it into a SmartSize size chart.

Before you start¶

Make sure you have:

• a size chart open in SmartSize
• a clear source image or spreadsheet with your size measurements
• the measurement unit you want to use, such as centimeters or inches
• time to review the generated values before publishing

SmartSize can help speed up setup, but you should always check the generated table before shoppers use it.

Choose the best source¶

Use an image when your size chart is currently a PNG, JPG, or similar visual file.

Use a spreadsheet when your measurements are already in rows and columns, for example in Google Sheets.

If both are available, a spreadsheet is usually easier to review and cleaner to import. An image is useful when the only source you have is a designed size chart graphic.

Generate a table from an image¶

1. Start from a table block¶

In the size chart editor, add or select the table area where the measurements should appear.

Open the option to generate a size table from an image.

2. Choose the size chart image¶

Select the image file from your computer. Use the clearest version of the chart you have. Avoid screenshots that are blurry, cropped, or too small to read.

After you choose the file, SmartSize shows the uploaded image.

3. Let SmartSize analyze the image¶

SmartSize reads the image and looks for size rows, measurement columns, and values.

Wait for the analysis to finish before changing other parts of the table.

4. Review the generated table¶

When SmartSize generates the table, review the result carefully.

Check that:

• all sizes are included
• column names match your source chart
• measurement values are in the correct cells
• units are correct
• decimals, ranges, or fractions were read correctly

After the generated table is inserted into the editor, you can edit any value directly.

Import a table from a spreadsheet¶

1. Prepare the spreadsheet table¶

In Google Sheets or another spreadsheet tool, organize the size table clearly.

Use one row for column headings and one row for each size.

A simple structure works best:

• first column: size names, such as XS, S, M, L
• next columns: measurements, such as bust, waist, hips, or length
• one measurement unit across the table where possible

2. Copy the table values¶

Select the table cells you want to import and copy them.

Do not include unrelated notes, empty columns, or extra formatting if you can avoid it.

3. Paste the table into SmartSize¶

Return to SmartSize and paste the copied table into the size table editor.

SmartSize places the spreadsheet rows and columns into the editable table.

Check the table before saving¶

Before you save, compare the SmartSize table with your source.

Check:

• size order
• column order
• units
• ranges and decimals
• copied or generated values
• mobile readability

If something looks wrong, edit the table before publishing.

Save and preview¶

After the table is correct, save the size chart.

Then check the desktop and mobile previews. A good size table should be easy to scan and should not require shoppers to zoom in.

Make sure the chart is set to Active so shoppers can see the table on the storefront.

Troubleshooting¶

The generated image table has mistakes¶

Use a clearer image if possible. A high-resolution image with strong contrast usually works better than a small or compressed screenshot.

You can also edit the generated table manually after SmartSize inserts it.

The spreadsheet paste looks misaligned¶

Check the spreadsheet source and copy only the table area. Avoid copying hidden columns, notes, merged cells, or extra rows.

Measurement units are unclear¶

Add the unit to the column heading or confirm the chart unit in the size chart settings. Clear units help shoppers understand the values.

What to do next¶

After your size table is correct, you can:

• customize the table block style
• add text or image blocks for measuring guidance
• connect the size chart to more products
• check the Size Chart button on your storefront