Upload csv file and Parse (WeWeb-Xano)

Ask us anything How do I?
2

Hi, you should be able to read it with the native Reader feature of the browser in javascript :

Put this inside a custom js action or a formula with parameters if you want it to be reusable.

return new Promise((resolve, reject) => {
    const reader = new FileReader();
    reader.onload = function (event) {
        const formattedData = event.target.result.split("\n").map(row => row.split(","))
        resolve(formattedData);
    };
    // Read the file as text
    reader.readAsText(variables[/* File 1 - value */ '058c64ba-450d-472d-b18a-9a08947f2f18-value']);
});

The result of the action will give you an array where every item is a line, and inside every line you will have another array where every item is a column.

I choose to split it using the token “,” but you should replace it with the one used inside your CSV. And be careful, if you choose “,” but your cells contain some “,” columns will not be accurate.

Hope it help you :slight_smile:

2 Likes