# Export data from Transfer Function qraw

Hi, can anyone explain me how to understand data that are give export data function in Qspice.
I identify frequency collum but for Gain and phase not et.

Thanks!

refer to this post
Is there a problem with Export data? - QSPICE - Qorvo Tech Forum

Code to inport csv with complex data and transform to dB and Degree into txt file.
clc;

close all;

clear all;

[csvfile csvpath] = uigetfile(‘*.csv’);

fid = fopen([csvpath csvfile]);

C = textscan(fid, ‘%s’, 1, ‘delimiter’, ‘’);

str = ‘%f’;

str = [str,‘%f,%f’];

end

csv.rawdata = textscan(fid,str);

fclose(fid);

if n == 1

csv.data{1} = csv.rawdata{1};

else

csv.data{n} = csv.rawdata{(n-1)2} + jcsv.rawdata{(n-1)*2+1};

end

end

% csv.headers and csv.data are pair for complex data format

idxx = 1; % idxx should always be 1 for frequency

idxy = 2; % user select which data to plot with idxy

% Extract frequency and complex data

freq = csv.data{1};

data = csv.data{2:3};

% Ensure frequency and data vectors are of the same length

min_length = min(length(freq), length(data));

freq = freq(1:min_length);

data = data(1:min_length);

% Check if data vectors are not empty

if isempty(freq) || isempty(data)

error(‘Data vectors are empty. Check the CSV file contents.’);

end

% Calculate gain in dB and phase in degrees

gain_dB = 20 * log10(abs(data));

phase_deg = unwrap(angle(data)) * 180 / pi;

% Plot dB and phase in degrees

figure;

subplot(2,1,1);

semilogx(freq, gain_dB);

title(['Qspice Export csv (complex format) : ', csvfile], ‘interpreter’, ‘none’);

subplot(2,1,2);

semilogx(freq, phase_deg);

% Save data to a text file

output_file = fullfile(csvpath, ‘frequency_gain_phase.txt’);

fileID = fopen(output_file, ‘w’);

if fileID == -1

error(‘Failed to create the file. Check the file path and permissions.’);

end

% Write headers and data to the text file

fprintf(fileID, ‘Frequency (Hz)\tGain (dB)\tPhase (Degrees)\n’); % Write headers

for i = 1:length(freq)

fprintf(fileID, ‘%f\t%f\t%f\n’, freq(i), gain_dB(i), phase_deg(i)); % Write data

end

fclose(fileID);

disp(['Data has been saved to ', output_file]);