Microsoft 365 Insider | Excel | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Hi,
Import csv files into a dataframe using PY excel python function (df = pd.read_csv)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
Can I import a csv file into a dataframe using a PY excel python function? Example PY = df = pd.read_csv(file_path+file_name, header=0). The idea is to storage the csv data in a dataframe directly without having to use power query to import the CSV file into excel and then loading the excel query table into the python dataframe. That would be more efficient and save space in the excel file too.
Microsoft 365 Insider | Excel | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
2 answers
Sort by: Most helpful
-
Anonymous
2024-02-29T09:42:35+00:00 -
Anonymous
2023-10-20T00:36:25+00:00 Hi Thiago,
Thank you for posting in Microsoft Community.
We understand you wanted to import your csv files into a data frame using the Excel Python function. It appears that this feature is currently not available in Python in Excel. Upon further research, it appears that there are third-party softwares that can grant you this option but not specifically for Python in Excel. Python in Excel is still in Preview and currently still developing.
Hopefully in the near future updates this feature will added. You can bring this to our developers teams attention by submitting a feedback - Get started with Python in Excel - Excel (microsoft.com)
Thank you for your understanding
Sincerely,
Leonardo_Y