CSV in Excel Table in Python

Question

I'm trying to input CSV information into a table in Excel but I don't know how, it would also help if I could create the table in a python script as well as reading in the CSV file in the same script. Please help.

Look into http://www.python-excel.org/ and the python module [csv](https://docs.python.org/2/library/csv.html). — wenzul, Aug 14 '15 at 10:59
Why do you not import the csv-file into excel with standard excel import features? — wenzul, Aug 14 '15 at 11:01

score 0 · Answer 1 · answered Aug 14 '15 at 10:56

0

pandas can be very helpful:

import pandas as pd
df = pd.read_csv(csv_file_path)
df.to_excel(excel_file_path)

This is using some default parameters, you might need to provide some info to read_csv and to_excel depending on how your csv file looks and what output you are expecting.

answered Aug 14 '15 at 10:56

DeepSpace

78,697
11
109
154

How would i go about formatting a table do you know? – Shaneyg8 Aug 14 '15 at 10:59
@Shaneyg8 CSVs offer very limited flexibility in terms of formatting. The raw data is just separated by commas. – khajvah Aug 14 '15 at 11:00
@Shaneyg8 Formatting is best done with an excel module for Python. That or you could do it using Excel features itself. You want to make the Excel file first. – rassa45 Aug 14 '15 at 11:16

score 0 · Answer 2 · edited May 23 '17 at 12:32

I have used openpyxl before and I find it to be extremely useful for this purpose. We can help you out more if you tell us exactly what you need. (Install it with pip or download from the Internet)

Example code:

import csv
import openpyxl
wb = openpyxl.Workbook(write_only = True)
ws = wb.create_sheet()
with open("myfile.csv", "r") as f:
    for line in f:
        ws.append(line)
wb.save("file.xlsx")

CSV in Excel Table in Python

2 Answers2