Google Sheets - Convert Screaming Frog PSI API Values Milliseconds to Seconds

Below is how you can convert Screaming Frog PageSpeed Insights (PSI) values from milliseconds to seconds in Google Sheets. This makes the data much easier to read and share with your clients.

Example Formula for Conversion​

If the PSI values are in column A (for example), you can use the following formula in column B:

=TEXT(A2/1000,"0.000")&" seconds"

This formula will:​

1. Divide the millisecond value in A2 by 1000 to convert it into seconds.
2. Format the result to three decimal places.
3. Append " seconds" to the output for clarity.

Steps:​

1. Replace A2 with the actual cell reference where your PSI values start.
2. Paste the formula in the corresponding column where you want the result (e.g., column B).
3. Drag the formula down to apply it to other cells.

This formula works for any set of PSI values you need to convert from milliseconds to seconds, maintaining consistency across large datasets and being more client-friendly.