|Help Centre

How to import a Data Studio csv to excel

Last updated at

If you want to import a file from Data Studio you need to follow the next steps in order to do this correctly. 

Once you have downloaded the Data Studio report, you will need to open a new blank file in excel:

1_open_excel.png

Once you have the new file open, you will need to go to “File - Import”, as it is shown in the image below:

 

2_file-import.png

And once there, a new box will be shown. In this box you will need to select “Text File” and after that, “Import”. You will need to choose the file you have downloaded previously from Data Studio:

 

3_text-file.png

 

Once the file is selected you will see the following screen, and you need to make sure that the following fields are selected: “Delimited - Characters such as commas or tabs separate each field”; “Start import at row: 1” which will be the row where the file will start and “File origin” Where you will need to select depending on your own setup.

As soon as these fields are completed you can click on “Next”.

4_delimited-row1-fileorigin.png

 

 

In the following step you will need to choose how you want to delimit the information contained in the .csv from Data Studio. In order to do that you will need to select: 

“Comma” in the “Delimiters” section. Once this is completed you can click on “Next”.

5_comma_and_text_qualifier_.png

 

In this screen you will be able to choose how you want the format date to be. Please select the best format according to your preferences. You can click “Finish” as soon as you have finished with this part.

6_Date_format.png

Now you will be asked to choose where you want to open the .csv fine that now is ready to be open in Excel:

7_put_the_data.png

Once you have this finished, you will be able to start working with the file in Excel.

8_final_document.png




Can't find what you're looking for?