Skip to content

This script will convert excel spreadsheets in the format of the examples included in this repository.

Notifications You must be signed in to change notification settings

kubilayelmas/excel-to-terraform-convertor

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Created by Joesph Gadd!! (github.com/themanontv)

Excel to Terraform Converter

This script will convert excel spreadsheets containing variables in the format of the examples included in this repository into Terraform HCL formatted configuration files. Included as an example is the foundations.xlsx spreedsheet you can use as input for the demo. This would be information gathered from the customer by the consultant. Included as an example of the output is the foundations.auto.tfvars file.

The script takes colours from the spreadsheet to denote how the output should be formatted, see comments in convertor.py for more info.

To run the script:

  1. Install python 3
  2. Install the openpyxl module - 'pip install openpyxl'
  3. Run 'python3 Converter.py .xlsx' (or 'python .\Convertor.py .py' on windows.

Enjoy!

About

This script will convert excel spreadsheets in the format of the examples included in this repository.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Python 92.3%
  • HCL 7.7%