| A | B | |
|---|---|---|
1 | ||
2 | START HERE | |
3 | Spreadsheet brought to you by Freelance Honeymoon | |
4 | 1 | Use the "Airport Codes List" sheet to pick out the airports/countries you want to search by. |
5 | 2 | Put an "X" in the "E" column to select the airports you want to search. After completing your selections, right click on the "E" column header and sort the sheet by A > Z. After doing this, all of the "X" marked airports will be grouped together |
6 | 3 | With your airports sorted by preference, select the list of three digit airport codes and convert them into Comma Separated Values (CSV) by using this tool: https://convert.town/column-to-comma-separated-list |
7 | https://convert.town/column-to-comma-separated-list | |
8 | 4 | Copy the CSV list into the sheet "CSV Codes for Matrix". You will then use these lists to start your searching. You may need to adjust your list and remove invalid codes from that the matrix doesn't recognize. The ITA Matrix might not recognize smaller regional airports. https://matrix.itasoftware.com/ |
9 | 5 | You can use this type of searching to search a massive list of points of origin or destinations. You can and should make your own but there are some (on the third sheet in this doc) pre-made lists there to start with. |
10 | ||