May I offer some things I've learned about importing from csv file? 1. My principle data store and manipulation mechanism is an MS Excel file. 2. Though satisfactory in most regards (data input, manipulation, etc.) there are at least two problems with Excel: a. It is lousy at producing csv files b. It does not properly output proper UTF8 encoding for many special characters — only some. It seems that any character with a very high Unicode code point value gets scrambled. 3. So . . . I simple save the file in native Excel format. That is, I do nothing special — just save my working Excel file. 4. Upload the Excel file to my Google Gdrive 5. Open the file with Google Sheets and then download it as a CSV file. It's ALWAYS correct, regardless of the (special) character content. 6. That CSV file can be opened with Notepad++ (excellent freeware!) if it is necessary to manipulate it further. In my case it is, since: 7. The 1st row in my spreadsheet is the labeling/header for all the columns and it is convenient/necessary to force a new line (Alt-Return) in the descriptions wit hin the cells in this row (only). 8. This produces inappropriate multiple rows at the top of the CSV file. 9 NotePad++ has powerful editing features, including several ‘line’ edit functions, one of which is ‘join’. Sweeping down all the initially ‘broken rows’ (because of the Alt-Return in the fist row of the spreadsheet) at the top of the CSV and joining them is a simple operation and eliminates the opportunities for errors when trying to do it by hand. This process has the added benefit of having the latest version of my spreadsheet backed-up on my Gdrive. Notepad++ can verify if any non-UTF8 encoding is present and convert it if necessary — though I've never seen Google Sheets do that.
Hi, If you haven't looked through it already, our support page at: http://www.aeontimeline.com/support/importing/ discusses the correct format for importing/exporting csv files. As suggested above Notepad++ is a good tool to use to convert to UTF8 format. If you export a timeline and then use this program to convert it to UTF8, the application should then be able to import the same timeline. When importing check that you are picking the right delimiters (commas or tabs) for your file. Let us know if you are still having problems Jess
Thanks for the recommendations. It turns out Excel CSV export was the problem - which I kind of figured. I use EditPad Pro for text editor and it seems to do a good job on the UTF8 formatting.