Export CSV to Excel File in Python with Visual Studio Code on Windows - DevPops-Inc/windows GitHub Wiki

• Press the Windows key, type “visual studio code” and select “Open.”
•

• Press the Ctrl and N key to create a new file.
•

• Select “Select a Language.”
•

• Type “python” in the search box and select “Python (python)” from the result.
•

• Type import pandas as pd and press the Enter key to import the Pandas module as the pd variable.
•

• Type from openpyxl.workbook import Workbook and press the Enter key twice to import the Workbook object from the openpxl.workbook module.
•

• Type df_csv = pd.read_csv(‘< .csv file >.csv’, header=None) and press the Enter key to define the dataframe for the .csv file.
•

• Type df_csv.colums = [‘< colunmn 1 >’, ‘< column 2 >’, ‘< . . . >’ ] and press the Enter key to define the columns.
•

• Type print(df_csv) and press the Enter key to print the .csv file.
•

• Press the Ctrl and S keys to save the file.
•

• Browse to where you want to save the file, type the filename in the “File name:” box and select “Save.”
•

• Press the Run button to print the contents of the .csv file in the TERMINAL.
•

• Click on the last line in the editor, type df_csv.to_excel(‘< Excel filename >’.xlsx’) and press the Enter key to export the .csv file to a new Excel file.
•

• Press the Run button to export the Excel file.
•

• Browse to the location of the new Excel file and double-click it.
•

• The contents from the .csv file will be in the Excel file you’ve just exported.
•