wordpress表格筛选_如何从WordPress的CSV电子表格导入帖子提示

wordpress表格筛选

Recently, one of our users asked us if there was a way to import post ideas in WordPress from a spreadsheet. We did a quick research, and well of course there is a way. In this article, we will show you how to import post ideas as draft in WordPress.

最近，我们的一位用户问我们是否可以通过电子表格在WordPress中导入帖子提示。 我们进行了快速研究，当然可以找到一种方法。 在本文中，我们将向您展示如何在WordPress中将帖子提示作为草稿导入。

Many WordPress site owners plan their content strategy in spreadsheets containing post ideas as titles. This is specially common if you’re part of a larger organization or are working with a virtual assistant.

许多WordPress网站所有者在包含帖子提示作为标题的电子表格中计划其内容策略。 如果您是大型组织的一部分，或者正在使用虚拟助手，则这种情况特别常见。

If you plan like we do, then chances are you have quite a few posts in your spreadsheet, and adding them manually will take a lot of time. Well, let’s take a look at how to easily import post ideas from CSV into WordPress.

如果您像我们一样计划，那么您的电子表格中可能会有很多帖子，而手动添加它们将花费很多时间。 好吧，让我们看一下如何轻松地将CSV中的发布想法导入WordPress。

影片教学 (Video Tutorial)

演示地址

If you don’t like the video or need more instructions, then continue reading.

如果您不喜欢该视频或需要更多说明，请继续阅读。

First thing you need to do is install and activate the Really Simple CSV Importer plugin. Upon activation, simply go to Tools » Import and click on CSV.

您需要做的第一件事是安装并激活Really Simple CSV Importer插件。 激活后，只需转到工具»导入 ，然后单击CSV。

On the next screen, you will be asked to upload a CSV file you want to import. But before you do that, first you need to format your spreadsheet properly, so that it can be imported.

在下一个屏幕上，系统将要求您上传要导入的CSV文件。 但是在执行此操作之前，首先需要正确格式化电子表格，以便可以将其导入。

The really simple CSV importer fetches post information based on columns in your spreadsheet. The first row in your spreadsheet must contain column names recognizable by the plugin. Some of the most commonly used column names are post_title, post_content, post_date, post_author, post_type and post_status. You can find the full list of column names on the plugin’s homepage.

真正简单的CSV导入器根据电子表格中的列获取帖子信息。 电子表格中的第一行必须包含插件可以识别的列名。 一些最常用的列名是post_title，post_content，post_date，post_author， post_type和post_status 。 您可以在插件的主页上找到列名的完整列表。

You don’t need to have all the columns, and you don’t even need to have the columns in a particular order. Here is a screenshot of a sample spreadsheet that we will be importing.

您不需要所有的列，甚至不需要按特定的顺序排列列。 这是我们将导入的示例电子表格的屏幕截图。

The plugin also comes with its own sample CSV and ODT files, which are located in the plugin’s directory under sample folder. You can open these files in Microsoft Office, Google Docs, or LibreOffice Calc. Alternately, you can also open a CSV file in any plain text editor like Notepad.

该插件还带有自己的示例CSV和ODT文件，这些文件位于示例文件夹下的插件目录中。 您可以在Microsoft Office，Google文档或LibreOffice Calc中打开这些文件。 或者，您也可以在任何纯文本编辑器(如记事本)中打开CSV文件。

The default post type is set to posts, and post status to draft. However, if you would like to change that, then you can do so by defining the post_status column.

默认帖子类型设置为帖子，帖子状态设置为草稿。 但是，如果要更改此设置，则可以通过定义post_status列来进行更改。

Most spreadsheet software allow you to save your spreadsheet in CSV format. While downloading or saving your spreadsheet as CSV, make sure you use commas to separate columns, and make sure text delimiter is set to double quotes.

大多数电子表格软件都允许您将电子表格保存为CSV格式。 在将电子表格下载或保存为CSV时，请确保使用逗号分隔各列，并确保将文本定界符设置为双引号。

After you have converted your spreadsheet into CSV, you are now ready to import it into WordPress. Return back to CSV importer and click on choose file button to upload your CSV file. The plugin will then upload it and import posts into WordPress.

将电子表格转换为CSV后，现在即可将其导入WordPress。 返回CSV导入器，然后单击“选择文件”按钮以上传CSV文件。 然后，该插件将上传它并将帖子导入WordPress。

That’s all for now, we hope this article helped you import post ideas as draft in WordPress. If you’re part of a larger organization, then we highly recommend you check out Edit Flow to improve your editorial workflow. We have also compiled a list of 21 great plugins to manage a multi-author blog efficiently.

到此为止，我们希望本文能帮助您将POST想法作为草稿导入WordPress。 如果您是大型组织的成员，我们强烈建议您查看“ 编辑流程”以改善您的编辑工作流程。 我们还汇总了21个出色的插件列表， 以有效地管理多作者博客 。

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Google+.

如果您喜欢这篇文章，请订阅我们的YouTube频道 WordPress视频教程。 您也可以在Twitter和Google+上找到我们。

翻译自: https://www.wpbeginner.com/plugins/how-to-import-post-ideas-from-csv-spreadsheet-in-wordpress/

wordpress表格筛选