Spreadsheet parsing is an incredibly complex tasks. Not only do our parser have to recognize the format (.xlsx, .xls, .csv, OpenOffice?), it also must understand the browser the request is coming from. In fact, it also depends if you're uploading from a Microsoft Windows computer or a Macbook computer.
To date, we've handled hundreds of spreadsheet files, and added complex logic to solve around the edge cases. If you're getting the error "File content type is invalid", it's most likely to do with your file rather than Clovi's system. We recommend the following:
- Open the file in Excel, click "Save As" and save *.csv format*. This is not a fool-proof way, and if the above doesn't work, it's an indication that your spreadsheet has macros/functions that don't work well together with our parsers. In this case, we recommend the following fool-proof way:
- Copy all the data in the spreadsheet, paste it into a Text file, and save the text file with the .csv extension. It's important to do this in a non-Word file.