Setting up a CSV File as Source #
You have two options to choose from for the input of your generated pages. One of them is the upload of a CSV File. You can also generate pages based on a location and via a Google Spreadsheet
What is a CSV File? #
CSV stands for comma-separated-values and is a file format, which allows data to be saved in a tabular format. CSV files can be editet with all common spreadsheet softwares like Excel and Google Spreadsheets.Â
Creating Placeholders and fill the CSV with Data #
To use a CSV file to generate pages, you need to fill the spreadsheet with data. Here you decide which placeholders you can use on your template page later on.Â
In the top row of the spreadsheet you fill in one placeholder per column.Â
The example above will give you the following placeholders:
{city}, {service} and {your-placeholder}
Fill in your data #
Next up you will have to add your data to the spreadsheet. Keep in mind:
Every row will equal one generated page later on.Â
The example above will give you the three pages. If you have a heading on your template page with this content:
“Your {your-placeholder} {service} service in {city}“
The result would be:
“Your best Plumbing service in New York“
“Your professional Plumbing service in London“
“Your excellent Plumbing service in Tokyo“
Â