Import CSV into Google Sheets

How To
1

Hello

I worked with the Google Sheets “Make an API Call” before, I used to use the text aggregator to bulk import tables into Google Sheets.

But I can’t get it to work with CSV, in the text aggregator my values have to be ordened in this way [“this”,“is”,“the”,“order”,“that”,“works”]

How can i make it work with raw CSV?
This for example:

image
image1394×136 19.5 KB

Thanks
David

2

Hi @Davidof90,

I will need to delve further into this, but since you have already worked with Text Aggregrator and constructed the required format for the Make an API call, What you can simply do is,

  1. Use Parse CSV Module: In CSV, Parameter Pass the CSV Values that you are getting. If it is a file, then you can either do toString or just use Download a File Moudle
  2. Now in Text Aggregator, Just do the same that you are currently doing, i.e constructing output based on the CSV output.
1 Like
3

Well, this is getting harder than I thought.

I have a CSV from the “get a file” module.

since my input file uses “,” as decima seperator I have to use semicolon style CSV.

So my values are:
image

So I have to:
-replace . with emptystring
-replace , with .
-replace ; with “,”

That gives me:

image
image764×444 6.7 KB

Now I have to add a quotation mark on the end & beginning of each line, I would do this with:

replace(data;newline;toString(“)+newline+toString(”))

But this ruins my csv … so I’m lost here.

Actually I just need a CSV to JSON ARRAY converter I guess…