[Feature]: Filepicker to support parsing xls, tsv, json along with csvs

[dilippitchika]

Is there an existing issue for this?

• [X] I have searched the existing issues

Summary

Filepicker widget can automatically parse the following filetypes and convert them to arrays and objects

Why should this be worked on?

Simplifies the workflows for users

[dilippitchika]

Within appsmith, we wish to support parsing files into arrays and objects without users having to build their own workflows to display these files in widgets.

For xls and xlsx files, the parsing will need to happen across all sheets. The format of data can be an array of objects with sheet_name and sheet_data as keys.

[dilippitchika]

@andrewdietekoki please make sure the following are present

1. TL;DR of the solution
2. Link to figma screens
3. Link to figma prototype

[andrewdietekoki]

1. TL;DR The design task was to accommodate for:

• Data Format list update if XLS(X), TSV, and JSON are parsed
• Information update to let users know the addition files that can be parsed. This is the basically the Help text when the "Array/Object" Data Format is selected.
• Letting users quickly learn more about update via documentation.

2. Screens Design

3. Prototype

[dilippitchika]

@rajatagrawal can you check this out?

[somangshu]

@rajatagrawal why is this not part of a sprint/

[rajatagrawal]

It is I think. I saw it on zenhub in the standup today and it shows here as well :