Export the data from PEP_BVI_v3.0.xls to the AAVSO Extended format If you would like to save the data from your spreadsheet to the AAVSO extended format, you could save the sheet ?AAVSO.csv? as a .csv. If you open this file in a text editor, you see that you still have to do some formatting before you can submit the data to WebObs at the AAVSO site. There is also a way to export your data in a directly in WebObs submissible form. But then you should be willing to use a macro. How to install the macro in the PEP_BVI_v3.0.xls spreadsheet? Click on the toolbar , select and then . Copy and paste the following VBA program: Sub AAVSOFormatFile() 'Declaring the variables Dim FileName, sLine As String Dim LastRow, FileNumber As Integer 'Location and filename FileName = LastRow = ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).Row FileNumber = FreeFile 'Creating or overwriting a text file Open FileName For Output As FileNumber 'Reading the data from the active worksheet For i = 1 To LastRow sLine = sLine & Cells(i, 1).Value 'Writing the data in a text file Print #FileNumber, sLine sLine = "" Next i Close #FileNumber MsgBox "AAVSO format file has been generated" End Sub Take care. Line 7 of the code will light up red. This is because you have to specify behind Filename = the path to the location where you would like to store the file on your computer. For example, on my computer line 7 reads: Filename = "/Users/Erwin 1/Documents/PEP/_AAVSO/AAVSOformat.txt" Then you click on the button. Now you are set to go. When you are done entering the data, go to the sheet ?AAVSO.csv?, then to the toolbar , select and click on the name of the macro. Click then on It will now create an AAVSO Extended format file. When it is ready, you?ll see ?AAVSO format file has been generated?. You?ll find the file in the folder you specified in the path. This file you can upload directly using WebObs. Erwin van Ballegoij, February 15, 2023