Add AI generated columns to CSV data

The AI CSV tool in SEO Content Machine allows you to add new columns of data to CSV files using AI to generate the data.

You can use data from existing columns to write AI prompts to generate new content.

For example: With a CSV list of restaurants and reviews, use AI to generate review summaries and listing descriptions.

Sample CSV (this CSV was generated by the CSV Google maps tool.)

You can download the CSV here to follow along.

How to add AI columns to CSV files

Create a new AI CSV task.

The first thing to do is select the CSV data file.

Under CSV file, select a CSV file on your hard drive.

If a valid CSV is selected, a list of available columns are displayed as macros.

You can use these column macros to refer to data in a CSV row for creating dynamic AI prompts.

A preview of the loaded CSV file is displayed when you select the CSV output.

How to add AI columns

Click on ‘Add column' under the AI columns section.

A new column is added.

We can use the AI to write a description of a shop using data from existing columns.

Example

Clicking on each macro label copies it to the clipboard for easy copy paste.

We can use these macros to build a dynamic prompt.

Example prompt

[write a shop description for a shop called 
%name%.
Explain the shop type %category% and review its facilities %about%.
Provide explaination of the opening hours %openingHours%.]

Create prompts by typing instructions into [ ] brackets.

You can also create new columns composed of content from other columns.

Which creates…

Run the task with ‘Run'

Task output

The AI CSV tool will load your CSV file and send instructions to the AI writer.

The output is saved to a CSV file on your hard drive.

Hover over the preview button to ‘locate' the CSV file easily.

Example output from the task:

Example of shop description generated by the AI.