Text to Sheets

To convert the data from a text file into an excel sheet.

Setup instructions

To set up and run the script, follow the instructions below:

1. Install the required dependencies:

   • openpyxl (Install using pip install openpyxl)

2. Run the script:

   • Execute the script using a Python interpreter.

Detailed explanation of script

The script performs the following steps:

1. Imports the necessary libraries (openpyxl).
2. Make a text file named 'input.txt'.
3. Save the text in the file, text separated by spaces which you want in different cells.
4. Execute the script, you will see the output.xlsx file generated by the script.

Output

The script saves the generated excel sheet as "output.xlsx" in the current directory which contains the data.

Author(s)

Author: Tisha Garg