Vendor - Best Practices on Adding your Products to LUZ Marketplace

Use this guide to increase your chance of creating super selling spreadsheets.

Choose a good title for your spreadsheet

When adding your spreadsheet have in mind that the name (and image) will be the frist thing that will grab potential customers attention.

If you don't choose a simple, easy to understand, and objective name, a potential buyer may not even click on the product. Good names are also very important for SEO purposes.

But how to create a good name for your product?

  1. Title structure

The structure that we like to use and that we recommend for you is divided into 5 parts. Let's see each one of them:

Part 1: "Spreadsheet" or "System"

Part 2: Utility / Function of the spreadsheet ("Cash Flow", "Customer Prospecting", "Budget")

Part 3 (Optional): If the spreadsheet is specific to a sector or industry (e.g.: for Travel Agencies, for Taxi Drivers, etc.) add it.

Part 4: "in Excel" or "in Access" or "for Power BI"

Part 5 (Optional): if you have multiple versions (e.g. version 2.0) , it makes sense to add it by the end of the name.

So your product name should be composed of: Part 1 + Part 2 + (Part 3) + Part 4 + (Part 5)

Let us show you some examples:

  • Excel 4.0 Cash Flow Worksheet (Parts 1 + 2 + 4 + 5)
  • Project Management System for Power BI (Parts 1 + 2 + 4)
  • SWOT Matrix Worksheet for Hotels and Inns in Excel 3.0 (Parts 1 + 2 + 3 + 4 + 5)
  1. What you should avoid

a. Use very large headlines

Bad Example: Project Management System with Integrated Database for Metallurgical Industries

Good Alternative: Project Management System for Metallurgical Companies in Excel

b. Put worksheet features in the title

Bad Example: Financial Management Worksheet - Registering Clients, Classes, Accounts Payable, Receiving

Good Alternative: Financial Management Worksheet in Excel

c. Call your system spreadsheet if it doesn't use VBA code or doesn't have any complexity that makes sense.

This can lead your customer to misperceive the spreadsheet and become dissatisfied afterwards.

  1. How to differentiate yourself

  • Spreadsheets of specific utility: expertise is needed
  • Spreadsheets for specific sectors: needs to have characteristics that make it work for that sector (cannot be generic) 
  • Choose the best image from the spreadsheet

The image is often the way you can make your spreadsheet tangible for your client. So it is important to take care to always have beautiful images.

As it is difficult to have beautiful images of ugly spreadsheets, I suggest you take a look at our usability tips. If you are already happy with the result of your spreadsheet, let's go to the process of taking the "photo" of your

  1. Capture tool

The vast majority of computers come with a standard image capture tool. In the case of Windows, you can use the CAPTURE TOOL, which can be accessed by clicking the windows button and, in the search field, write "tool".

As you type, windows returns search options and you can select the tool. When doing this, you will have this window:

When clicking on NEW, you will have the cursor and will be able to create images of your screen. In that case, just open your spreadsheet.

  1. Choosing images from the spreadsheet

When registering the worksheet images, separate 5 to 10 images from your worksheet. If it has few tabs, there is no need to repeat images, put a smaller number of images.

To separate the images that will be used it is necessary to have good taste to choose the best ones. Although we don't like to argue, we need to agree that some resources are more attractive than others. For example, for the first image, prioritize, in that order:

  • Dashboards
  • Graphics
  • Color Reports (Conditional Formatting)
  • Color Tables (Conditional Formatting)
  • Colorless Tables

With your decision made, just take a full screen photo of this main image and then the other images and go up to the registration area

See an example of the highlighted image of the cash flow spreadsheet (Dashboard):

  1. Examples to help you choose your images

See the hierarchy that we would use to order the images that customers would see from the cash flow spreadsheet:

  • Dashboard

  • Graphics

  • Color Report

  • Simple Table with Formatting

  • Simple Table without Colors 

What to put in your spreadsheet description

When registering your spreadsheet, in addition to the name of your spreadsheet, it is important to have a description that helps your customer to see if your product will solve their challenges. So it makes sense to explain the details of your spreadsheet objectively and clearly.

This detail will be done in the Description field of the registration of your spreadsheet.

  1. How to use the Description field when registering your spreadsheet

As you may have noticed, the description is a text editing field where you can explain more of your spreadsheet to your potential customers:

This is a free field and you can write whatever you want. Obviously, the clearer you are, the greater the chance of getting sales.

We like to use a structure that you can take advantage of:

Part 1: Brief details of the spreadsheet (do not use more than 3 lines in this part)

State your purpose in general and what kind of problem it solves. See an example from our Cash Flow worksheet.

"The cash flow spreadsheet that every business needs to have a well-controlled entry and exit. It has 5 ready-made dashboards, automatic reports, account classification and payment status control. With it, you will be able to quickly view the financial health of your business to make safer decisions. "

Part 2: Worksheet features

We like to list the main spreadsheet tabs here. If there are few tabs, you can place them all. If you have too many, try not to be too repetitive and consolidate the same information. Normally a tabbed feature is sufficient. Following the example of the cash flow spreadsheet, we put it this way:

  1. Type of formatting for text and subtitles

All text already has PARAGRAPH formatting as standard and is the one that should be used. The only part of the text that you will need to edit will be the subtitles (names of features).

Each subtitle must use HEADING 3 formatting, as follows:

See the result in the edit field of the spreadsheet registration (on the website, it will look differently, with the color blue):

  1. ATTENTION: Formatting Not Allowed

Be aware that the use of Heading 1 and Heading 2 (and no other - except Heading 3 for subtitles) is not allowed - this may impair the positioning of your product on Google's search engines and this practice is prohibited, which may result in the exclusion of your spreadsheet from our website. 

How to register the demo version of your spreadsheet

* Add here what Rafa already created: https://ajuda.luz.vc/l/en/demo-file-video/demo-file

Attention: sending a demo version of the final spreadsheet is mandatory. If you have any questions, please contact us at email@luz.vc

If you don't already have a demo of your spreadsheet, I recommend that you read our article explaining how to create a demo version of your spreadsheet with our demo generator.

If you already have it, it's time to upload it together during the registration process of your spreadsheet. We have already separated a field for this:

See that it is very simple to generate the file for Excel 2007 or earlier. Just take your demo file in the XLSX version and, in the save as window, change the file type to Excel 97-2003 Workbook (* .xls)

This process will generate an XLS file that must be attached in the registration process of your spreadsheet

  1. Why we use Old and New versions

The Brazilian reality is of a very large number of people who still use old versions of Excel and it makes sense to try to include all the potential customers you may have, after all, the more people able to use the demo, the greater the chance of selling.

That said, if you still don't know Excel extensions very well, read a little more about the 3 (XLSX, XLS and XLSM that we use and why we choose only between them.

  1. What if I have an XLSM file as a demo?

In this case, you can upload the same file for both versions (2007 or earlier and 2010 or later)

  1. File size limit

As the image suggests, the maximum size of a demo file should be 3MB, so be careful with very heavy spreadsheets. In our experience, the lighter and easier to use the file, the better for the customer who is experiencing it.

Usually XLSX files are even lighter and are unlikely to go beyond 3MB. If your demo file is bigger, it may be heavier than it should be. In the case of XLS (due to its structure generating heavier files), it can happen that the file gets big. In such cases, a suggestion is to send it zipped (.zip)

If you can't, just send us the demo version by email to parc eiros@luz.vc 

How to register Google spreadsheets on the LUZ website

If you want to register a Google spreadsheet, know that practically all fields are exactly the same as registering any other spreadsheet, so if you are not sure how to login, how to choose the title of the spreadsheet, make your description or another item, see more here: https://ajuda.luz.vc/article/147-como-revender-minhas-planilhas-no-site-da-luz

There are only 2 items that have a DIFFERENT record in the case of GOOGLE SHEETS: the final file and the demonstrative file:

1 - Final Archive

This is the spreadsheet that the customer will buy. As it will be necessary to share a copy of it with the client, share this final version with the email rafael@luz.vc and leandro@luz.vc

In the registration, you will need to attach a PDF file to the registration that explains to the customer how he will receive it. To do this, open Word and use this standard text below (you can make changes if you want, but keep the email contato@luz.vc as a support channel):

Remember to change the name of the spreadsheet to the name of yours.

2 - Demo Archive

Now you will generate a copy of your final file, rename it so that it has the indication of being a demo version and adjust it so that it is only a file for VIEWING. This point is very important, because if the customer has access to the final open spreadsheet they will not buy and you will lose sales.

To make this locked version available for the customer to know the spreadsheet, create a PDF file with the following words:

Change the logo to that of your company (if you have one), change the link to access the spreadsheet to be the preview link for your demo version and KEEP email contato@luz.vc.

Okay, by registering these 2 PDF files in the process of including your google spreadsheet you will finish the process perfectly well.