To output the data to a separate text file, use the SQLite command prompt and switch the output parameter to send any of the queried data to the file.