How to use CSV files

Specific to Heyday, the basics of opening, editing and saving FAQs CSV files are:

• Do not delete headers (2 first rows)

• Do not delete columns

• Only edit cells in the ANSWERS column

MS Excel

Open file

You can convert an Excel worksheet to a text file by using the Save As command.

1. Open a blank Excel workbook.

2. In the Data tab, click Get Data > From File > From Text/CSV.

3. Select the file to open and click Import.

4. In the File origin area, select 65001: Unicode (UTF-8) and Comma in the Delimiters area.

5. Click Load.

Save as CSV file

You can convert an Excel worksheet to a text file by using the Save As command

1. Go to File > Save As

2. Click Browse

3. In the Save As dialog box, under Save as type box, choose the text file format for the worksheet

4. choose CSV (Comma delimited).

More here:

Import or export text (.txt or .csv) files

Google Spreadsheets

Open file

To correctly open CSV files in Google Spreadsheets, perform the following steps:

1. Open a blank Spreadsheet

2. In the File menu, click Open

3. Select the file to open and click Import.

Google spreadsheet manages the CSV automatically.

Save as CSV file

You can convert an Excel worksheet to a text file by using the Save As command.

1. Go to File > Download

2. Click Comma separated values (.csv)

3. The CSV file is downloaded automatically.

More here:

CSV file: Definition - Google Ads Help