Skip to main content

Import Estimate Items from CSV

Covers the template, the columns Structur reads, mapping fields, formatting numbers and units so they import cleanly, and checking the result.

Written by Support

📋 Overview

If you've priced jobs in spreadsheets for years, your best pricing lives in those files. Retyping a 200-line estimate into new software line by line is slow, and every retyped number is a chance for a typo that ends up in front of a client.

Import CSV in Estimates brings those lines in directly. You save your spreadsheet as a CSV, upload it, choose which columns to use, and Structur adds the lines to your estimate, organised into the groups and subgroups from your file. Quantities, units, unit costs, markup, allowance and tax flags come across with them.

The import adds to whatever is already in the estimate. It never replaces existing lines, so you can import into a new estimate or top up one you've started.


🔍 Understanding Import CSV

⚡ What It Does

Import CSV allows you and your team to:

  • Add many lines at once -- one row in your file becomes one line in the estimate

  • Keep your structure -- Group and Subgroup columns create the groups and subgroups, nested correctly, with their descriptions

  • Carry over pricing -- Quantity, Unit, Unit Cost and Markup come in with each line

  • Flag lines -- Allowance and Tax columns set the Allowance and Tax checkboxes

  • Choose which columns to use -- switch any column in your file on or off before importing

📅 When to Use It

Import CSV is most valuable when you want to:

  • Move existing spreadsheet estimates into Structur

  • Reuse a price list or a sub's breakdown that you already have in Excel or Google Sheets

  • Build a large estimate faster than adding lines one at a time


📝 Step-by-Step Instructions

1. Open the Import

  1. Open the estimate. If it's approved, create a New Revision first, because approved estimates are locked.

  2. Click Import at the top of the estimate

  3. Click Import CSV

The Import Estimate Items window opens with a short checklist and an upload box.


2. Prepare Your File

  1. Click clicking here in the window to download the template

  2. Put your data in the columns below, with one line per row

  3. Save the file as CSV. In Excel, use File > Save As > CSV.

Structur reads these column headers:

  • Cost Code -- the code, followed by its name, for example "09-100 Drywall"

  • Description

  • Quantity

  • Unit

  • Unit Cost

  • Markup -- the internal markup percentage

  • Group and Group Description

  • Subgroup and Subgroup Description

  • Allowance -- Yes or No

  • Tax -- Yes or No

Note: The template already has all twelve headers. Keep them spelled exactly as above. A row with no Cost Code is skipped, so give every line a cost code.


3. Format Numbers and Units So They Import Cleanly

Important: Currently, a single number with a thousands comma and no currency symbol, such as 1,000.00, stops the import. The page shows "Application error: a client-side exception has occurred". After you refresh, none of the lines from that file have been added, and any group the import created shows $0.00. Before you upload, remove the thousands commas from any number that has no currency symbol.

  • Unit Cost: enter plain numbers such as 1000 or 1000.50. Amounts with a currency symbol also import, with or without thousands separators, such as $1,000.00, "US$ 1,000.00" or "US$ 1.000,00". A thousands comma with no currency symbol, such as 1,000.00, does not.

  • Markup: 10 and 10% both import as 10%.

  • Quantity: whole numbers and decimals such as 0.5 both import. Don't use thousands commas.

  • Unit: use one of the values in the table below, written exactly as shown with no spaces. The labels in the estimate's Unit dropdown (like "Lump Sum" or "ft²") won't import, and come in blank.

  • Cost Code: use the code and a short name. A code that isn't in your cost code library is added to it as a custom cost code. Currently, the cost code name doesn't always come through as written. It can be shortened, or replaced by the name from your cost code library. Put the full wording in the Description column, which always comes through as written.

  • Description: keep each description on one line. A line break inside a cell cuts the description short and can throw off the rows around it.

Type

Values to use in the Unit column

Count and pricing

Each, LumpSum, Estimate, Quote, BudgetPlug, Allowance

Length

Inch, Foot, LinearFeet, Yard, Mile, NauticalMile, Mm, Cm, Dm, Meter, Kilometer

Area

SquareInch, SquareFeet, SquareYard, SquareMile, SquareNauticalMile, MmSq, CmSq, DmSq, SquareMeters, KmSq, Square, Squares

Volume and weight

CubicYards, CubicMeter, Gallons, Pounds, Tons, Kilograms

Time

Hours, Days, Weeks, Months

All of these values import correctly.


4. Upload and Map Fields

  1. Click Click to upload the file and choose your CSV

  2. Under Map Fields, Structur lists every column header in your file, each with a Select this column toggle. The columns Structur reads start on. Any other column is off and can't be turned on.

  3. Turn off any column you don't want imported

  4. Click Continue and wait for the lines to appear. The button can't be clicked again while the import runs

The lines appear in the estimate, grouped by your Group and Subgroup columns, with each subgroup nested inside its group. The window closes and there's no confirmation message, so check the table. If a group with the same name is already in the estimate, the lines are added to it rather than to a new group. If the file has headers but no rows, you'll see "That CSV has no rows to import. Add your line items to the template and upload it again." If the import itself fails, you'll see "We couldn't import your estimate items. Please try again."


5. Check the Result

  1. Expand each imported group and subgroup

  2. Check the Unit column for blanks and fix them from the dropdown

  3. Check the cost code names and descriptions

  4. Compare the estimate's Direct Cost with your spreadsheet total

Note: If the page shows an error after you click Continue, refresh the page. Delete any empty groups the import created, fix the numbers in your file (step 3), and import again.


⭐ Best Practices

  • Clean your numbers before you upload -- remove thousands commas from any number without a currency symbol, because one bad cell stops every line from importing.

  • Test with a few rows first -- import five lines into a new estimate to check your format before you import five hundred.

  • Put the detail in Description -- cost code names can change on import, but descriptions come through in full.

  • Check units every time -- a blank unit is easy to miss on a long estimate and looks unprofessional on the proposal.

  • Import into a new revision on a priced estimate -- the import adds lines and never replaces them, so a revision keeps the old version clean if something goes wrong.


❓ Common Questions

Q: Can I import a PDF, an Excel file, or an estimate from another platform?

A: Currently, Import CSV only accepts CSV files. Open the file in Excel or Google Sheets, arrange the columns as in step 2, and save it as CSV. If you upload another file type, you'll see "That file isn't a CSV. Open it in your spreadsheet app and use Save As → CSV, then upload it here."


Q: Does importing replace the lines already in my estimate?

A: No. Imported lines are added alongside what's already there.


Q: Can I import subgroups?

A: Yes. Add Subgroup and Subgroup Description columns to your file. Each line goes into the subgroup named in its row, inside the group named in its Group column.


Q: I clicked Continue and the page showed an error. What happened?

A: Usually a number in the file has a thousands comma and no currency symbol, such as 1,000.00. Refresh the page, delete any empty groups the import created, remove the commas from your numbers, and import again.


Q: My units came in blank.

A: The unit in your file didn't match one of the accepted values in step 3. The most common cause is a space, like "Lump Sum" instead of LumpSum, or "Square Feet" instead of SquareFeet. Pick the right unit from the dropdown on each line, and use the values from step 3 next time.


⚠️ Common Mistakes to Avoid

❌ Don't

✅ Do

Upload a file with a Unit Cost like "1,000.00", with a thousands comma and no currency symbol

Use plain numbers like 1000, so the whole file imports

Type units the way they show on screen, like "Lump Sum" or "ft²"

Use the values from step 3, like LumpSum and SquareFeet

Put line breaks inside a description cell

Keep each description on one line

Save the file as .xlsx and try to upload it

Save as CSV from Excel or Google Sheets first

Rely on the cost code name to describe the work

Put the full wording in the Description column

Assume every unit imported

Check the Unit column for blanks after each import

Import a big file straight into a priced estimate

Test with a few rows, or import into a new revision first

Did this answer your question?