<!-- WP QUADS Content Ad Plugin v. 2.0.92 -->
<div class="quads-location quads-ad1" id="quads-ad1" style="float:none;margin:0px;">

</div>
<p>You&#8217;ve setup your website with <a href="http://marketinghackers.net/website-optimization/definitive-new-website-checklist-results/" target="_blank" rel="noopener noreferrer">Yoast for SEO, Google Analytics and Google Search Console</a>, filled out your homepage, about section and setup your contact forms. Maybe you&#8217;ve even setup AMP (accelerated mobile pages) to give your SEO an additional boost. Now it is time to get some content in in the form of posts. Let&#8217;s say you have a list of data to import. For Brunchy, I had a lot of data on different deals and bars. To speed up the process dramatically, I used <a href="http://www.wpallimport.com/">WP All Import</a>. Here in this post I&#8217;ll show you how I&#8217;m importing the list of doctors into <a href="http://medicalmarijuanapa.net/">http://medicalmarijuanapa.net</a>.</p>
<ol>
<li>Get your data together in your spreadsheet program. For this we used Google Sheets. Also put in descriptive headers.</li>
<li>Export to your computer in a CSV file. Both Microsoft Excel and Google Sheets can easily do this with Save As. WP All Import likes CSV files, which are just spreadsheet files in a generic format, kind of like RTF or something for text.</li>
<li>Install WP All Import into your WordPress installation and activate it.</li>
<li>Go to the WordPress dashboard and on the left-hand side select &#8220;All Import >; New Import.&#8221;</li>
<li>Choose &#8220;Upload a file&#8221; and then select your CSV file on your computer.</li>
<li>Since this is your first import to your website, the default settings of &#8220;New Items&#8221; and &#8220;Create new Posts&#8221; are good.</li>
<li>The next step will be to arrange your data with the visual editor&#8211;drag and drop.</li>
<li>Make sure you&#8217;ve fleshed out the fields with your data and keep SEO in mind.</li>
<li>Run the import.</li>
<li>Congratulations! You&#8217;ve created a post for each entry in your spreadsheet file, Yoast and AMP work with each one, and your SEO rankings should shoot up!</li>
</ol>
<p>Have a question or better process? Let me know in the comments.</p>


I spend a lot of money on Facebook advertising for both businesses and other marketing…
I've worked as a digital marketing consultant for dozens of businesses across different industries and…
F5Bot is a free service that emails you when your selected keywords are mentioned on Reddit, Hacker…
Marketing Hackers is a new media and digital marketing consulting company that focuses on growth…
Marketers have often leveraged the internet's large platforms like social media for marketing. Nevertheless, increasing…
In Laymen's terms, Blockchain Technology can be explained as spreadsheets or ledgers which are shared…
View Comments