Downloading CSV from sharepoint and read every sheet in the CSV as a table.

[Sandeep58]

Hi, 

I Have a CSV file in my sharepoint and which has 50 sheets in it. 

How do i read that CSV file in fabrics and save those 50 sheets as table in my lakehouse ? 

it is getting hard with Dataflow as there are 50 sheets in CSV. 

is there any alternate way to do that ? 

[v-sathmakuri]

Hi @Sandeep58 ,

I hope the information provided is helpful. Feel free to reach out if you have any further questions or would like to discuss this in more detail. If responses provided answers your question, please accept it as a solution so other community members with similar problems can find a solution faster.

Thank you!!

[v-sathmakuri]

Hi @Sandeep58 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you!!

[v-sathmakuri · Accepted solution]

Hi @Sandeep58 ,

Thank you for reaching out to Microsoft Fabric Community.

CSV files do not support multiple sheets, only Excel files have the concept of worksheets. Assuming you are referring to an Excel file stored on SharePoint, you can try the following approaches:

Copy the Excel file from SharePoint to your Lakehouse Files (manually or using Dataflow Gen2 once). Then use Python code to load all sheets and save them as tables.

Another approach is to use Data Factory in Fabric. Create a pipeline with a ForEach activity looping through a list of sheet names. Use the Copy Data activity to read one sheet at a time from the Excel file and write it to the Lakehouse. However, this still requires manually specifying or extracting all 50 sheet names.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Thank you!!

[lutz_bendlin]

CSV files have no sheets. Do you mean Excel files?