Import products from a spreadsheet
Import a spreadsheet when you already have your products in a list, such as a schedule from an earlier project, a supplier’s price list, or an export from another tool. Inside Outside reads the file and suggests which column holds what. You then see a preview of every product and fix anything that’s wrong. Nothing is saved until you select Import.
You can import into a schedule or into your studio’s product library. Imports into a schedule also accept pictures, sections, supplier contacts and your notes.
Before you start:
- To import into a schedule, open the schedule first. Products go into that schedule only, so if you need a new one, add a schedule before you begin.
- Save your file as .xlsx or .csv. Older .xls files and Numbers files can’t be read. Open them in Excel or Numbers and save a copy as .xlsx.
Prepare your file
Section titled “Prepare your file”The import reads one tidy list. Before you upload, check that your file follows these rules:
- Only the first sheet is imported. Move the products onto the first sheet, or delete the other sheets.
- Put the column headers in row 1. Remove any title, logo or date rows above them.
- Use one row per product. Put each product’s pictures, or links to its images, on the same row.
- Don’t merge cells. If the file has merged cells, the import stops and names the first one to unmerge.
- To sort products into rooms, add a column for it, such as “Room” or “Area”. Heading rows between groups of products aren’t read as sections.
Files can be up to 25 MB, with up to 2,000 products and 80 columns.
Some schedule exports can be imported as they are. If your file has a “Section : …” heading above each group of products, and “Custom Spec Label” and “Custom Spec Detail” columns, you don’t need to tidy it first. Each section heading becomes a section, and each spec label becomes a custom spec. Pricing totals and statuses from the export aren’t imported.
Import a spreadsheet
Section titled “Import a spreadsheet”-
Open where the products should go:
- For a schedule, open the schedule and select Import at the top of the page.
- For your library, select Product library in the sidebar, then Add product → From spreadsheet.
-
Drag your file onto the window, or select Choose file and pick it.
-
Wait while Inside Outside reads the file. This usually takes 5 to 20 seconds.
-
Check the Columns list on the left. Each column from your file shows a few sample values and what it will be imported as. To change one, open its menu and choose a different field, or Don’t import.
-
Check the Preview on the right. It shows every product as it will be saved, grouped by section, with any warnings underneath.
-
Fix any rows marked in red. The message on the row says what’s wrong, for example a quantity that isn’t a number. To see only rows with errors or warnings, select Needs a look. Either set that column to Don’t import, or correct the cell in your file, close the window and import the file again.
-
Select Import followed by the number of products, for example Import 42 products.
When the import finishes, you see how many products and images were added, and any new sections and suppliers. Select Done to see them on your schedule or in your library.
Choose what each column becomes
Section titled “Choose what each column becomes”Most columns go straight into the matching field, such as Product name, Brand, SKU, Finish or Trade price. A few choices need more explanation:
| Choice | Use it for |
|---|---|
| Several sizes in one | A single column holding a product’s dimensions, such as “W1200 x D600 x H750” or “1200x600x750”. A second menu sets the order of sizes that have no W, D or H letters. Separate width, depth and height columns go straight into Width, Depth and Height instead. |
| Section | A column naming the room or area each product belongs to. Schedules only. |
| Images | Pictures placed in the spreadsheet, or a column of image links. |
| Custom spec | A useful detail with no matching field, such as “Bulb type” or “Fabric”. Type the label you want shown. |
| Internal notes | Comments for your studio. Your client never sees them. |
| Client notes | Notes written for your client. Schedules only. Your client sees these on their link. |
| Don’t import | Columns you don’t need, such as line totals or row numbers. |
Every column that has values needs a choice. A column still set to Choose… is highlighted, and you can’t import until you’ve chosen something for it, even if that’s Don’t import.
If sizes come out in the wrong unit: check Sizes in this file are in, at the top of the Columns list. It shows the unit Inside Outside found in your file, for example from a header like “Dimensions (mm)”. Change it if it’s wrong, or choose Not stated if your file doesn’t say.
What happens to your data
Section titled “What happens to your data”- Sections: products go into the section named in your file. If the schedule already has a section with that name, they’re added to the end of it. Otherwise a new section is created after your existing ones. If you don’t choose a section column, or a row leaves it blank, those products go into a section called “Imported”.
- Prices are saved as the numbers in your file, in the schedule’s or studio’s currency. They aren’t converted. If your file’s prices look like they’re in another currency, the preview warns you. Prices such as “POA” or “TBC” are left blank, which means unknown.
- Sizes aren’t converted either. If your file uses a different unit from the project, each size keeps its unit, so a 2200 mm sofa shows as “2200 mm” in an inches project, not “2200 in”.
- Quantity is 1 when the cell is blank.
- Lead times are matched to the nearest lead time option, rounding up. For example “6–8 weeks” becomes 8 weeks, “3 months” becomes 14 weeks, and “In stock” stays in stock. Anything over 26 weeks is saved as 26 weeks. The preview shows a warning whenever a lead time was rounded.
- Suppliers are matched to your existing suppliers by name. New ones are added with any contact details from your file: contact name, email, phone and address. For a supplier you already have, the import only fills in details that are blank. It never replaces details you’ve entered.
- Categories are matched to your existing categories by name. Names that don’t match are left blank and listed in the preview. To sort them afterwards, see Categorize products automatically.
- Images are copied into Inside Outside, so they stay even if the original file or web page changes. Each product keeps up to 10.
- Library copies: products imported into a schedule are also saved to your product library and the project’s catalog, the same as products you add one at a time.
- Skipped rows: rows with no product name, and blank rows, are skipped and listed under Skipped rows in the preview.
Good to know
Section titled “Good to know”- Inside Outside only suggests the columns. Every value comes from your file exactly as written, and the preview shows exactly what will be saved.
- Each import adds new products. It doesn’t update products you imported before, so importing the same file twice adds everything twice.
- There’s no undo for a whole import. To remove imported products, select them on the schedule and use Remove products…, which can’t be undone, or Archive products…, which you can reverse.
- Product details, prices and sizes are read from your file. Procurement dates, statuses and order details aren’t imported, so imported products start as Draft.
- Each supplier has one contact. If two rows give different details for the same supplier, the first row’s details are used and the preview lists the difference.
- The import adds products to schedules and the library. It can’t create a new schedule or project.
- Imported products appear in the schedule’s activity as added.
If something goes wrong
Section titled “If something goes wrong”- “We couldn’t read this spreadsheet right now.” Inside Outside couldn’t suggest the columns this time. Wait a minute and select Choose file to try again. Your file hasn’t been changed, and nothing was saved.
- A message says the file breaks a rule, for example “Unmerge cells B4:D4 and try again.” Fix that in your file, save it, and upload it again.
- “Choose an .xlsx or .csv file.” The file is in another format, such as .xls or Numbers. Save a copy as .xlsx and upload that.
- An image couldn’t be imported. The summary at the end lists each image that failed. The product was still imported, so add the image from the product sheet. Image links must open without signing in.
- A column of prices or sizes comes through blank. If those cells are formulas, open the file in Excel, save it, and upload it again. Some programs save formulas without their results, and the preview warns you when that’s the case.