Retool Database: import CSV different delimiters

Feature Requests
1

Hi,

Currently, it is possible to import CSV only with the comma as the delimiter.
It would be nice to be able to import files using other delimiters: semicolon or tabs.

regards,

1 Like
2

Hey @MicExpert! I've added the feature request internally, and I'll update this post when I have any additional information. Thanks!

1 Like
3

Could you run it through a workflow to reformat to comma delimited ?

4

Good idea. In the meanwhile, I'll do that

1 Like
5

Hi Joe,
I have a few questions regarding data import into the Retool database:

  1. Is it possible to import XLS sheets instead of CSV files?
  2. If not, can we import CSV files with delimiters other than commas?
    I'm working with files that need to be delimited with either a TAB or a semicolon. This is because the data contains lots of text with commas, making it impossible to save as a CSV with comma delimiters.
    How can we work around this issue? Thanks a lot for your help!
6

For now, it's not possible. I recommend preprocessing the data to get it into the required format. You could use a custom workflow in Retool to accomplish this or simply ask ChatGPT-4o to help with data manipulation. It's becoming quite adept at this task.

Regards,

1 Like