Thread: iGO Speedcam (DISCUSSION)

Hi @Texas

As per your request, here is the way to import a Text file of spdcams into Excel and process it as you wish.

Originally Posted by kwbs

1. Open Excel.
2. Import a NEW text file of the speedcams you want to handle.
3. Mark (while uploading) the "separators" you want and see how it will look in a reduced preview.

Open a new Excel sheet and then (follow the numbered steps):

1. Highlight DATA
2. Go To NEW QUERY
3. Point On From FILE
4. Choose Import Data From a Text File

Spoiler: 1-2-3-4

5. IMPORT Text File
Sample view/total 218 spcams/file of: ISRAEL_31012024_ALLINONE_SPCDB

Spoiler: 5

6. LOAD

Spoiler: 6

7. ALL THE 218 SPDCAMS RECORDS WERE LOADED IN THE EXCEL

Spoiler: 7

8. Finally - Save It As A Text File Type
After you have finished working on the Excel, save it first as an Excel file.
Then, go to FILE > SAVE AS and, in "save as type" - You can choose any of the three file type options highlighted in the image and, give this file a new name!
Go to the folder where the new .csv file was downloaded and change its extension from .csv to .txt!
Now, the new Text file is ready for you to work again in the navigation software.

Spoiler: 8. "Save as Type"