Azure Table storage

Question

Hello,

How can I add my excel data to Azure Table Storage? I am unable to add my excel data via storage explorer. Please help to resolve this error.

Thanks.

Answer 1

Hi, @Krishna Rajput Welcome to Microsoft Q&A, Thanks for posting your query.
Using the Azure Storage Explorer you can import / export data to and from table storage using CSV files.
you would need some sort of application (custom code, ADF, etc.) to parse the excel file and insert each row into Azure Table Storage. upload the file to blob storage and use Azure Data Factory to transform and import the data. you can refer here for more information

Please let me know if you need any additional information

Regards
Geetha