Import and Export Quotes and Tips Using CSV

The Quotes and Tips plugin allows you to import and export quotes and tips using a CSV file. To avoid errors, it is very important to keep the original CSV format unchanged.

Correct CSV File Format

The CSV file must use semicolons (;) as separators and double quotes (") for all fields.

Header (required):

"post_type";"post_title";"post_content";"name_field";"off_cap"

Example of correct data rows:

"quote";"Quote Title";"Einstein citation";"Albert";"Scientist"
"tip";"Productivity Tip";"Work in short focused sessions";"Admin";"Editor"

Each new quote or tip must be placed on a new line.

Required Fields

For both import and export, all fields must be filled. Empty fields are not allowed.

• post_type – quote or tip
• post_title – title of the quote or tip
• post_content – main text
• name_field – author name
• off_cap – author position or description

Important: If at least one field is missing, the import may fail or work incorrectly.

Do NOT Use Excel or Spreadsheet Editors

Do not open or edit the CSV file using:

• Microsoft Excel
• Google Sheets
• LibreOffice Calc

These editors automatically change the file structure and break the required CSV format.

Example of an incorrect (broken) file:

post_type,post_title,post_content,name_field,off_cap
quote,Title,test quote,Test,Test
quote,Another title,another quote,Name,Role

What goes wrong:

• Semicolons (;) are replaced with commas (,)
• Double quotes are removed
• The file becomes incompatible with the plugin

Recommended Editors

If you need to edit the CSV file manually, use plain text editors only:

• Notepad (Windows)
• Notepad++
• Visual Studio Code
• Sublime Text
• Any other plain text editor

These editors preserve the CSV structure and do not modify separators or quotes.

Summary

• Always keep the original CSV format
• Use semicolons (;) as separators
• Wrap all values in double quotes (")
• Fill all fields in every row
• Place each quote or tip on a new line
• Use only plain text editors
• Do not use Excel or spreadsheet software

Following these rules will ensure correct import and export of quotes and tips without errors.