Hello, I’m using a JSON to bulk add rows to my google sheet. The issue is that it uses periods rather than commas as separators in numbers, but my google sheets regional settings use commas rather than periods as separators for $$ amounts, for example. I tried to use the replace function after the …

Google sheets bulk add rows from JSON, but need numbers to use commas instead of periods

L_Duperval September 7, 2025, 3:04pm 6

Does this help:

Topic		Replies	Views
Formatting in combination with Google Sheets Bulk Update Questions functions , arrays , google-sheets	1	25	November 25, 2025
Proper Data Structure setup for making an array of arrays for Google Sheets Questions aggregators , arrays , json , google-sheets	3	452	May 27, 2024
Google spreadsheet putting data in 1 row, instead of separate rows out of a JSON file Questions json	8	95	October 27, 2024
JSON Array to Google sheet - new rows in same cell Questions json , google-sheets	8	180	July 15, 2024
Google spreadsheet putting data in 1 row, instead of separate rows Questions json	5	90	October 26, 2024