xxxxxxxxxx
import pandas as pd
# Read the Excel file
excel_file = pd.read_excel("filename.xlsx")
# Convert the Excel data to CSV
excel_file.to_csv("filename.csv", index=False)
xxxxxxxxxx
import pandas as pd
data_xls = pd.read_excel('excelfile.xlsx', 'Sheet2', dtype=str, index_col=None)
data_xls.to_csv('csvfile.csv', encoding='utf-8', index=False)
xxxxxxxxxx
import pandas as pd
data = pd.read_csv("k.csv")
data.to_excel("new_file.xlsx", index=None, header=True)
xxxxxxxxxx
import pandas as pd
# Read Excel file
excel_file = pd.read_excel('path/to/excel_file.xlsx')
# Convert to CSV
csv_file_path = 'path/to/output_file.csv'
excel_file.to_csv(csv_file_path, index=False)
print(f'Successfully converted Excel file to CSV: {csv_file_path}')
xxxxxxxxxx
#UI
File>> Save As>> Rename the file .csv>> Save
#Online
https://www.zamzar.com/convert/xls-to-csv/
xxxxxxxxxx
from pyexcel.cookbook import merge_all_to_a_book
# import pyexcel.ext.xlsx # no longer required if you use pyexcel >= 0.2.2
import glob
merge_all_to_a_book(glob.glob("your_csv_directory/*.csv"), "output.xlsx")
xxxxxxxxxx
with open('dict.csv', 'w') as csv_file:
writer = csv.writer(csv_file)
for key, value in mydict.items():
writer.writerow([key, value])