Troubleshooting

Having trouble? Don't hesitate to contact us for help.

Unknown character detected

Just like human languages, there are many different "dialects" of computer code. This error occurs when PageFactory does not understand the "dialect" your spreadsheet is written in.

To fix this, you'll need to explicitly save your spreadsheet with UTF-8 character encoding. The process for this will be different depending on the application you're using to export the spreadsheet.

For example, if you are saving the spreadsheet using Excel on Windows, you should select "CSV (Comma delimited)" as the format to save the spreadsheet as.

Screenshot of how to save spreadsheet with correct CSV formatting


If you're unable to find a way to save your CSV with UTF-8 encoding, you can upload the spreadsheet to Google Sheets and download it as a CSV. Google Sheets will automatically encode the CSV with the correct format.

Could not read spreadsheet column names

This error occurs when PageFactory can not clearly discern the column names in the first row of your spreadsheet. Often, this is a formatting issue. Take a look at the first row of your spreadsheet and make sure each cell contains only alpha-numeric characters (underscores are ok too). Be sure each column name registers in the spreadsheet as plain text, and not as a number, currency, etc.

If you continue to have trouble, you can upload the spreadsheet to Google Sheets and download it as a CSV. Google Sheets should automatically re-format the column names for you.