Frequently asked questions and answers.
columnly.io is a tool that helps you clean your data. It allows you to upload a CSV, Excel, JSON, Parquet, XML, or text file and apply plain-language rules to each column to clean the data. No code required.
columnly.io supports the following file types: CSV, Excel (XLSX and XLS), JSON, Parquet, XML, and tab-delimited text (.txt).
You'll be asked to choose which worksheet to work with before your file is processed. Only one worksheet can be cleaned per upload; if you need another one from the same workbook, upload the file again and choose it.
Follow this link to see a full list of rule types and what they do.
You can export your data in the following formats: CSV, Excel, JSON, Parquet, XML, and tab-delimited text by clicking the "Export file" button in the top right corner of the screen. You can also customze the delimiter when exporting to CSV.
Click "Save as Workflow" after cleaning a file to save your steps under a name you choose. Today that saves the steps themselves for reference; running a saved workflow automatically against a new file is on our roadmap and not yet available.
We would love to hear your suggestions! You can contact us at columnlysupport@gmail.com to suggest a new rule. We will review your suggestion and get back to you as soon as possible.
You can contact us at columnlysupport@gmail.com to ask any questions you may have. We will do our best to help you as soon as possible.