Importing an Excel file into SSA: Part 1 – Using your own file!

Do you need to complete a project with many labels? Then, save time with our Excel import!

Excel import for signs with TEXT ONLY.

Join us in our SSA (Sign Studio Advance) tool by clicking on the link here. You are now in our web tool and it’s time to locate and select the “Excel Import” button. You have 2 options, the first, is to upload your own excel file or you can create a file from a template. This tutorial is dedicated to using your own excel file. Next month we will look at how to use an excel file from a template.

Select Excel Import

THE EXCEL FILE

Make sure that each column corresponds to one line of text and each row corresponds to a new sign. You should also add the desired number of copies for each sign in one of the columns. 

In this example column A is displaying the number of copies
and column B and C are for lines 1 and 2 of each sign.

Once you have made your file you can return to the web tool and select “Excel Import”.

Import Steps

Step 1: You need to upload your file to our tool. Select “Choose File” and locate the file you wish to upload from your computer.

Select “Choose File”

Tip: Keep your file free from images and unnecessary text for the quickest and easiest import.

Step 2:

The second step is to lay the foundations, and to select which columns should be used:

• Purple – select which sheet of the excel file contains your sign data.
• Green – check this box if your first line is not part of the text you wish to import.
• Blue – Select the column that contains what will be your first line of text.
• Orange – Choose the column that contains what will be your second line of text.
• Yellow – Select the column that contains the desired quantity / number of copies of each plate.

Step 2

Step 3: The final step is creation. Choose the design of your Sign. Here are the options:

• Red – Select the material.
• Blue – Choose the shape of your signs.
• Yellow – Options concerning the visuals of the text (text size, font, alignment)
• Orange – Select the colour of your signs.
• Green – Choose the length of your signs.

Final Step

Warning: if you get the error message “ALL SIGNS CANNOT BE IMPORTED”, it means that the text is not suitable. You must then reduce the size of the text or enlarge the sign.

Verification

Once you are satisfied with the design of your signs, click on “Finish”. You will then be able to check that your signs have been imported correctly and make any final modifications if necessary. You can then save the project and order it in the usual way.

Carefully check your signs are correct

Thank you for joining us and learning about how to upload your own excel file.

Next month we will look into how to download a template and re-upload it to our web tool.

http://www.sld-ltd.co.uk

See our video tutorial for more!