This is surprisingly easy… once you know what to do : )
Copy and paste the contents of each table into google sheets or Excel, use Edit->Paste
This will also copy a load of background data and links into the sheet at the same time, so copy the content you’ve just pasted, and paste it into some new rows but this time use Edit->Paste Special->Values Only.
Sorry, that’s really confusing. I’ll add some screenshots…
Copy from Wikipedia:
Paste in Google Sheets:
Copy what you’ve just pasted and then use Edit->Paste Special->Values Only in the rows below, or somewhere else, and you’ll end up with a text-only version, something like this:
For this example I deleted Wikipedia’s “Date” column but kept the “Year” column. I also added the missing year in row 6 that wikipedia didn’t have.
Next go to File->Download->Comma Separated Value in Google Sheets to download a .csv file that can be imported into Aeon
I created a new file in Aeon using the Historical template. Then used File->Import csv or tsv
In the import interface (below), Column A becomes the Start Date, Column B becomes the Label. Note that I’ve unchecked “My file includes a header row”.
The click Next Confirm Date, then Next and …
It would probably take about 45 mins to get all of that wikipedia page into Aeon, and you could use the CONCAT function in Sheets to get the dates joined to the year column too.
I’m incredibly impressed with how straightforward Aeon’s import is, once the spreadsheet is formatted correctly. Let me know if you need any clarification on any of the above.
PS Had to try it for myself. It took less than 10minutes to get all the info from the Wikipedia tables (up to the 9th century) into Aeon. Let me know if you want me to email the file to you (…somehow). As you say, you’ve now got to create relationships and data types but Aeon’s search and filters should make that quite easy too, I think.