Skip to Content

My Favorite (Free) Tool For Organizing My Etsy SEO Keywords! Airtable

My Favorite (Free) Tool For Organizing My Etsy SEO Keywords! As an Etsy seller I do a lot of keyword research, but organizing all those Etsy SEO keywords and phrases was really getting me down. And then I found the most amazing free tool to use for keeping track of them! Here are my best tips and tricks for organizing my Etsy SEO Keywords!

As an Etsy seller I do a lot of keyword research, but organizing all those Etsy SEO keywords and phrases was really getting me down. And then I found the most amazing free tool to use for keeping track of them! Here are my best tips and tricks for organizing my Etsy SEO Keywords!

I have tried almost everything I can think of to keep them in order from Google spreadsheets shared with a friend, to Evernote and even just a Word document.

The problem every time was that they quickly got WAY out of hand and I abandoned that method and tried something new.

Luckily I found the PERFECT tool! Airtable which is half spreadsheet and half super organizer!

Make sure to watch the video above to see this beauty in action! or save it to watch later on YouTube

Why To Keep Your Etsy SEO Keywords Organized

As you become more and more proficient in your Etsy SEO keyword research, you will have more and more “good” keywords that you can use.

Keeping track of the ones that you have already found and vetted can make doing a new listings a breeze. BUT, maybe you are like me and sorta-kinda kept them in your head or did the research each time because you weren't good at storing those keywords someplace easy to refer back to later.

Finding Keywords To Use In Your Listings

I use a number of different search tools to find keywords to use in my listings!

  • Keywords Everywhere in the Google Chrome Browser
  • Pinterest dropdown & searching
  • Etsy dropdown & searching
  • Marmalead for Keyword Research (#promo)

Oh, oh, oh, you could even check your Etsy stats and add the keywords that people have actually used to search for products like yours in the past!

Shop Manager > Stats > Search Terms

Search Term Stats - Etsy SEO

Or you could even add the ones from your promoted listings stats!

Marketing > Promoted Listings > Search Terms

Etsy SEO Promoted Listings Stats

Setting Up Your Airtable Spreadsheet

Setting up your spreadsheet is SUPER EASY! Just click the (+) button to add a new table and then put your fields across the top. I used:

  • Keyword – This is where you list all the keywords you have found to use down in a list.
  • Group – Where you set up the different “kinds” of keywords you will be sorting by (more about this later)
  • #Google – # of Google Keyword Searches from Keywords Anywhere
  • #Marmalead – #of Etsy Searches from Marmalead

Airtable Fields With Titles

I KNOW, it doesn't look very fancy yet, mostly what you can do in an Excel spreadsheet. But it is the sorting functions that will make you so happy in just a wee bit!

Setting Up Your Groups

The next thing you want to do is go to the arrow on the right side of the Group field name and click “Customize Field Type”.

Choose “Single Select” and then put your sorting options in there.

Changing Group Dropdowns In Airtable

The cool thing about these groups is that you can reorder them (and your keywords) easily later by using the “handle” on the left hand side that is six little dots.

Sort By Group

The first way I show you how to sort in the video is by group. This puts all the pretty colored tags into the right order, all grouped together.

Sort By Group - Airtable

Sort By Group > Apply

Sort By Group - Airtable

The best part about this is that you can drag and drop them to rearrange them in any order you like (in Excel you would have to add a row, cut and paste the contents in and then delete the row you copied from).

To stop sorting this way just click the X to the left of the “Sort by” words and it goes back to being just a jumble.

Group By Field

If all Airtable had done was that I might have been happy but I wouldn't be telling you about it. BUT WAIT, THERE'S MORE!

You can use the “Group by field” to put them into little bunches that you can move around too!

Group By Field - Airtable

I know, it is a little confusing that I named my Groups “group” but that made it easy for me to remember what I was supposed to be sorting by!

Grouped By Fields In Airtable

As you can see they are all in cool sorted order. But if you want to rearrange them all you have to do is go back up to the Group > Customize Field dropdown and pick the first one, “Customize Field Type”.

Group Customize Field Dropdown

And then if you want to change the order you can just use the little gray dots handle to move them around and all go together as a group!

Little Gray Dots Handle

Using Airtable for Etsy SEO Keyword Research

As an Etsy seller I am always happy to pay for things that make life easier or save me time, but I was super excited to find a free tool like this that would help you to manage your keywords.

There is a paid function that gives you more colors for your buttons (I wish I had that) but I haven't even come close to using all my records and on my blog posts sheet I have literally hundreds of posts listed with way more fields than we would use for doing keyword research!

ADDITIONAL RESOURCES

My Favorite (Free) Tool For Organizing My Etsy SEO Keywords! As an Etsy seller I do a lot of keyword research, but organizing all those Etsy SEO keywords and phrases was really getting me down. And then I found the most amazing free tool to use for keeping track of them! Here are my best tips and tricks for organizing my Etsy SEO Keywords!