How to create a .csv file

1. How to create a .csv file

CSV is a simple file format used to store tabular data, such as a spreadsheet or database.

Files in the CSV format can be imported to and exported from programs that store data in tables, such as Microsoft Excel, Google Docs Spreadsheets or OpenOffice Calc.

CSV stands for 'comma-separated values'. Its data fields are most often separated, or delimited, by a semicolon (;). For example, let's say you had a spreadsheet containing the following

After completing our document with the necessary information (title of the file, title of the image and tags), we will proceed to save the file in CSV format. This format will separate the columns with a semicolon (;), and the tags with a comma (,).

The above data could be represented in a CSV-formatted file as follows:

File name; Title; Keywords; if generated with AI - Prompt; Model - adding one of the options offered in the dropdown menu on the contributor panel, written exactly as it appears in the menu.

'beautiful-sunset.jpg';'Beautiful sunset';'sunset,sun,summer,beach,mountain'; 'Beautiful sunset on the beach in summer'; 'Midjourney 5'

'abstract-background.jpg';'Abstract polygonal background';'abstract,polygonal,poly,polygon,polygons,low poly'

'business-card.jpg';'Business Card';'cards,business,employment,business cards'

A CSV is a text file, so it can be created and edited using any text editor. More frequently, however, a CSV file is created by exporting (File Menu -> Export) a spreadsheet or database in the program that created it. Click on a link below for the steps to create a CSV file in Notepad, Microsoft Excel, OpenOffice Calc, and Google Docs.

Here you can see some examples for exporting .csv files:

1. Microsoft Excel
2. Google Docs Spreadsheets
3. OpenOffice Calc

Important: After exporting the file, you need to change your .csv to the correct format. You can follow these simple steps explained here.

1.1 Create CSV with Microsoft Excel

In Document Type choose CSV (MS-DOS), this step is very important as it will save the document respecting the columns and the rows separated by the punctuation marks.

A window will pop up informing you to save the document. Click Yes.

Important: After exporting the file, you need to change your .csv to the correct format. You can follow these simple steps explained here.

1.2 Create CSV with Google Docs Spreadsheets

Complete the metadata information of your files in Google Spreadsheets:

Important: After exporting the file, you need to change your .csv to the correct format. You can follow these simple steps explained here.

1.3 Create CSV with OpenOffice Calc

Create the spreadsheet with your metadata and the three columns (filename, title, keywords). Once created, click File, choose the Save As option, and for the Save as type option, select Text CSV (.csv) (*.csv).

Important: After exporting the file, you need to change your .csv to the correct format. You can follow these simple steps explained here.

2. How to format correctly a CSV file

To ensure your .csv file is well formed, follow the following steps:

You can also also convert your document to CSV by going to http://www.convertcsv.com/csv-to-csv.htm and following these steps:

2.1 Upload your .csv file

Select the file that you want to convert to CSV.

2.2 Choosing the input options

Configure the options for the CSV format. In Field Separator select the ';' option as marked in red below.

2.3 Formatting your .csv file correctly

In the previous point, it is important that you select the 8th and the 9th options:

'Always overwrite template when generating standard CSV'

'Replace value of NULL in CSV with an empty value'

2.4 Download the new .csv file

Finally, check if the file has been converted to CSV by selecting Download Result.

After creating the csv with the correct format, upload it to the ftp server with an ftp client (Filezilla for example).

3. Upload CSV to FTP Server