Skip to content
Support
Machine-translated from Danish

How to upload a schedule or spreadsheet

Get quantities from a Revit schedule or a spreadsheet into the project without a plugin. The file arrives as a submission under Models, where you review it before it becomes a new version.

  • You have write access to the project. With read access only, you can see the submissions but not upload.
  • You have a file in one of the formats .xlsx, .xls, .csv, .tsv or .txt, or you can copy the cells from Revit or Excel.

The file can be a Revit schedule, a Molio template or an LCAbyg template. LCAbyg recognises which it is by itself and says so at Read as.

  1. Turn on showing units in the quantity columns, e.g. “197 m²”. Only metric units can be read.
  2. Use a single header row. Rows with “Total” may be included: they are not counted, but are used to check the sum.
  3. Export the schedule with tab as the delimiter (File > Export > Reports > Schedule), or save it as an Excel file.

Recommended columns are Family and Type (or Type), one quantity column (Area, Volume, Length or Count), Phase created and Phase demolished, classification (BIMTypeCode, CCS, Keynote or Assembly code), Type Mark and Description. The headers can be in Danish or English.

ColumnHeaders that are recognised
TypeFamily and Type, Familie og type, Family, Familie, Type
QuantityArea/Areal, Volume/Rumfang/Volumen, Length/Længde, Count/Antal
PhasesPhase Created/Fase oprettet, Phase Demolished/Fase nedrevet
ClassificationBIMTypeCode, CCSClassCode, CCSTypeId, Keynote, Assembly Code
OtherType Mark, Description/Beskrivelse
Pipes and ductsSize/Størrelse/Diameter/Dimension and System Type/Systemtype
  • Without a Count column, each line counts as one element.
  • For pipes and ducts, include Size (or Diameter) and System Type, so each size and system gets its own line.
  • If BIMTypeCode or CCS is on the types, LCAbyg suggests the placement from the code.
  • Plain numbers from Excel without a unit are read in the column’s own unit (m², m³ or m).

Under Schedule or spreadsheet you can download Download empty template and Download example. Use the template’s headers. Columns the template does not know are skipped. Save the sheet as an Excel file, or copy the cells and paste them. The example can be uploaded as it is, so you can try the review.

If the Excel file has several sheets, each sheet with recognised headers is read separately.

  1. Go to Models in the project menu.
  2. Click Upload file under New import.
  3. Choose the file with Choose file…, or drop it in. You can also paste the cells directly into the field Or paste the cells directly, after copying them in Revit or Excel.
  4. Under What is this file?, choose either A new version of a sheet in the project (and which sheet) or A new sheet (and give it a Name). If you choose an existing sheet, products and choices from last time are kept, and only the changes need reviewing. The file name does not matter, so a date in the file name does not make the file a new sheet.
  5. Choose Number format in the file: Danish (1.234,5) or English (1,234.5). Revit writes numbers according to the project’s unit settings, so the format cannot be read reliably from the numbers themselves. If the numbers look like the other format, LCAbyg suggests switching.
  6. Click Check file. Read the overview, see the next section.
  7. Click Import.
  8. Review the submission under Models, and approve it. Only the approval creates a new version. Nothing in the project changes until you have approved.

Check file shows how the file was read, and nothing has been created yet:

  • Read as: the file kind (workbook or text file), the profile (Revit schedule, Molio template or LCAbyg template) and which line the headers are on.
  • Columns: the columns LCAbyg recognised, and under Not read those that were not, because the header is unknown.
  • In total: total area, volume, length and count. If the file has a total row, it is shown beside it, with whether it matches the rows.
  • Rows that are skipped: with the reason. Click Download the list to save them.

If the file cannot be read, nothing is created, and the problems are listed per line. This only applies to errors that affect the schedule as a whole. A single bad row is skipped instead and mentioned in the overview.

MessageWhat you do
There is no type columnAdd a column with “Family and Type” or “Type”
There is no quantity columnAdd a column with Area, Volume, Length or Count
The schedule’s total row is not the sum of its rowsIf there are groups with subtotals, export without them
The value is <varies>Split the schedule so each line has one value
”…” is not a number in the chosen number formatSwitch Number format in the file, or fix the number
”…” has no unitTurn on showing units in the schedule
”…” is not in a metric unitShow the quantities in metric units
”…” is negativeFix the quantity
”…” is not a whole countRound the count to a whole number
The schedule has too many lines or columnsRemove the fields you do not need and export again

If none of the messages fits, check that the file has a single header row and columns as in the table above.

The file is listed as a submission under Models with the source Revit schedule or Spreadsheet and the status Awaiting review. When you approve, LCAbyg creates a new version from the lines you have marked.