top of page

How to import your dahlia collection from Microsoft Excel

Importing your dahlia collection from Excel is quick and easy—it usually takes 3–5 minutes. 

​

You can import:

  • Your dahlia collection 

  • Your yearly records (if they are in Excel)

To ensure a smooth import, follow the steps below.

​

Step 0: Decide what and how to import

Would you like to import:

  • Dahlia collection only

  • Dahlia collection + yearly records

Step 1: Prepare your file

Make a copy of your original Excel file and use this copy for the import process to keep your original safe. Structure your file correctly so the system can read your data without errors.

Step 2: Name your sheet

At the bottom of your Excel window, you’ll see the sheet name (usually ‘Sheet1’). Right-click the name, choose Rename, and type: Dahlias.

If you are going to import the yearly notes, rename Sheet2: YearlyRecords

Step 3: Rename your columns in the Dahlias sheet

Your sheet should have at least these two columns:
 

image.png

Visual example of how the Excel sheet should look at this stage

A filled out Excel sheet

Additional variables in the Dahlias sheet

It is possible to add additional variables as well by naming columns.

The following variables are available for upload:

Additional available variables

Step 4: Rename your columns in the YearlyRecords sheet

This step only applies if you are going to import yearly records.

Your YearlyRecords sheet should have at least these two columns:

Required columns for yearly records

Additional variables in the YearlyRecords sheet

It is possible to add additional variables as well by naming columns. The following variables are available for upload:

Additional columns for yearly records and acceptable data formats

Step 5:  In TheDahliaLab

Log in to your account and go in to Settings (see upper menu).

Find the section for Import from Excel. Press Import Excel File.

A window will automatically open displaying your files on your computer. Choose the correct file, and press open.

​

The import starts automatically​

​

Troubleshooting

The two most common errors if the import fails

  • The sheet is not named correctly. To ensure a proper import, ensure that you have followed Step 2.

Ex. Correct: Dahlias  Incorrect: Dahlia, dahlias, dahlia​

​

  • The names in the columns and in the sheets are case-sensitive, and this might cause import errors.​

Ex. Correct: Dahlia ID  Incorrect: Dahlias ID, DahliaID, dahlia id, dahlia Id, DAHLIA ID

​

If you find these steps confusing, download the import template and arrange your Dahlia collection within that structure and jump to step 5. 

​​

If these fixes are not helping, drop us an email at mail@thedahlialab.com. We will be happy to assist you with importing your collection.

bottom of page