Upload Mark Title with airSlate SignNow

Upload mark title

in this video i'll show you how to create 500 listings meaning title description and tags within the space of literally just five minutes on top of this i'll also show you how to import these listings into flying upload and connect them to your designs which will save you hundreds of hours of work and make your printer demand life a lot easier so first of all i'm going to show you a quick example of what we're going to do today so you understand everything more easily and you know what you're doing from the start basically let's imagine that we've got four niches cycling fishing gaming and sailing and we want to create listings for these designs that's a great cycling design for men who love to cycle but instead of writing these listings out manually for each of these designs and exchanging the word cycling with phishing gaming etc we can write a formula with variables that actually does the job for us and you're going to need some sort of spreadsheet editor for this i'm using excel but i believe you can also use google's spreadsheet editor for free so to get started just select the first column up here a1 and then you want to use the formula bar to type in a formula and these formulas start with an equals symbol and then two quotation marks we're going to write a text in between these quotation marks and we'll start with great which is obviously the start of a sentence now instead of writing cycling into this we want it to refer to the column over here that says cycling so we're going to put quotation mark and symbol then g1 because that's g1 another and symbol and another quotation mark now you have to write the rest of the sentence and instead of cycle once again we want to refer to this column right here quotation mark and h1 and symbol quotation marks and now full stop to make it the end of the sentence and if you now hit enter you're going to see that it actually inputs cycling and cycle within our sentence and the coolest thing about this is now that we've finished this once you can use this little square at the bottom right corner of your column drag it down and then if you let go you can see that in the first row we had g1 and h1 and in the second row it automatically changes it to g2 and h2 and you could even change these afterwards and they will update in your sentence and now moving on to the best part about this which is that we can combine the skills that i just showed you with scalable designs like these ones right here and flying upload so you can create listings to make them ready to be uploaded to all of these different marketplaces so to get started with this you don't want...