How to fix the error "Your file cannot be imported, a general error has been encountered: The header record must be an empty or a flat array with unique string values.!" in Liberation Campaign.
This error occurs when you try uploading a file that contains formatting in the file. To successfully upload a document into Liberation Campaign, your CSV needs to be a TXT-only format. Follow the steps in the below articles and then upload the new document into Liberation Campaign.
First, you need to convert your CSV Document to an Excel document. To do this you need to first open your CSV file and select either "Save as" or "Export to" an Excel file. Open your new Excel file and select
How to clear all formatting in Excel
The most obvious way to make a piece of information more noticeable is to change the way it looks. Excessive or improper formatting, however, may have an opposite effect, which makes your Excel worksheet difficult to read. The easiest way to fix this is to remove all current formatting and start embellishing the worksheet from scratch.
To remove all formatting in Excel, just do the following:
- Select the cell or range of cells from which you want to clear formatting.
- On the Home tab, in the Editing group, click the arrow next to the Clear button.
- Select the Clear Formats option.
This will erase all cell formatting (including conditional formatting, number formats, fonts, colors, borders, etc.) but keep the cell contents.
Clear Format tips
With this Excel Clear Formatting feature, you can easily remove formats not only from a single cell, but also from an entire row, column or worksheet.
- To clear out formatting from all cells on a worksheet, select the entire sheet by pressing Ctrl+A or by clicking the Select All button
at the top-left corner of the worksheet, and then click Clear Formats. - To remove formatting from a whole column or row, click the column or row heading to select it.
- To clear formats in non-adjacent cells or ranges, select the first cell or range, press and hold the CTRL key while selecting other cells or ranges.
Once the formatting has been cleared, save the Excel file as a CSV and upload it to a Liberation Campaign List
