Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Some ideas for creating tons of useful content using your spreadsheet skills
#1
Having basic spreadsheet (Excel, CSV) skills really opens a lot of doors when it comes to creating content. This outline assumes you have these skills, more specifically the ability to move and merge cells and columns along with very basic HTML skills.

Being able to get info into a CSV lets you create tons of useful content.

First, take a look at this WordPress plugin called TablePress that adds CSV files to web pages:
https://tablepress.org/demo/

If you know basic html and Excel, you can add all sorts of stuff to niche "mini search engines". Many physical affiliate product inventories will come in CSV files...or even RSS/XML files which are easily converted to CSV.

You can create local directories and guides. Gather business info into a CSV file and add this info using TablePress. Your users can then sort by city, company or product name, rating, price, etc.

For local directories, go to Google Maps and do a search for your local niche keywords, get the map with the business listings just the way you want it, then find the "Share or Embed Map" link and embed the map along with your TablePress content below.

Note: I go into more detail about finding and scraping content in the Pheeds Leads Xtreme forum.  If you're not a member yet, join here.

Extract Title, and Meta Descriptions and Keywords - Find a good list of related resources for a top resources page. Grab their page's meta info. For example, gather a list of "top keto sites for 2021". Using the descriptions and keywords, rewrite manually or with the help of AI writers.
http://tools.buzzstream.com/meta-tag-extractor
http://www.exadium.com/tools/metadata/AnalyseMetaForm

Get Web Shots of URLs in batch - sign up for a free account and get up to 100 images a day for free. Use these to create directories of "best sites" and adding an image of each site you link to make your pages look much more interesting and professional.
https://www.page2images.com/free_convert...s_in_batch

Cities Near - Find and use "cities near" your main location for extra SEO potential and gathering resources. Scroll down your results page for the closest major cities.
https://www.travelmath.com/cities-near/

You can edit the content either in a CSV or Excel file in Excel or in the TablePress admin in Wordpress.

You can also do a lot of CSS/HTML formatting in either Excel, TablePress admin and your WP theme. IMO this can be the biggest time drain but often needed.

Getting things set up takes some time and skills, but once you get your system created for your needs you'll be a content factory. You can develop sites for your own revenue streams, sell leads, flip the domain/site, etc.

Note: I go into much more detail about finding and scraping content buying/selling domains and more in the Pheeds Leads Xtreme forum.  If you're not a member yet, join here.
Like Reply
#2
Here's an example...If you have an Etsy shop you can download a CSV of all your listings and add them to your blog articles as your own revenue stream instead of using an affiliate program.
https://help.etsy.com/hc/en-us/articles/...nt=selling

You have total control. It's your info so you can use this data to link to your listings on Etsy or set up your own order process.
Get and spend Cow Chips just for being a Pheeds Phorum member...
(Never let anyone tell you that you shouldn't spend them all in one place.)
Like Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Easy and free way to set up a social marketing network with great content Kurt 1 182 08-30-2021, 06:04 PM
Last Post: Kurt
  What are the essential tech skills for marketing online? Kurt 0 189 08-18-2021, 02:43 AM
Last Post: Kurt
  Pheeds Content Silo - The Ugly but Extremely Useful Page for Writing Content Kurt 18 8229 07-09-2021, 05:50 PM
Last Post: Kurt
  Increase the odds of creating a successful site Kurt 0 413 06-21-2021, 11:14 PM
Last Post: Kurt
  Fun, weird, wild and wacky marketing ideas Kurt 27 13117 05-27-2021, 04:07 PM
Last Post: successlane
  AI Writers and Timesaving Ideas for Content Marketing in 2021 Kurt 0 1017 05-24-2021, 11:57 PM
Last Post: Kurt
  [SHORT CONTENT] Free vertical videos for short content projects Kurt 14 5681 05-12-2021, 09:08 AM
Last Post: simbrams
  How to use Creative Commons for lots of content Kurt 2 1489 04-12-2021, 03:53 AM
Last Post: Kurt
  Content Analysers Neil797 11 4999 01-24-2021, 07:36 PM
Last Post: Claire Koch
  [SHORT CONTENT] New major content type on pretty much all major platforms Kurt 11 3609 01-22-2021, 05:28 PM
Last Post: cosmic77

Forum Jump: