Import data from xls or csv files with other delimiters than comma

Hello!

From the Retool side, you could probably throw together a quick app that takes the data and inserts it into an already created table with matching headers but that seems a bit clunky and hyper specific.

Would it be possible to export your XLS sheet data to CSV but change the column formats to include the quotes? This can be done in Excel for any column that could contain commas:

Select the cells / Right click the column
Choose Format Cells and then pick the Custom option
Replace the default @ Type value with \”@\”

5FF92B22-7EF8-49EC-963C-D1A5608FAB5B

I think this might let you then import the CSV directly through the Retool DB

1 Like