Skip to main content
How to prepare a file for import

How to prepare a file for import

Success at Copper avatar
Written by Success at Copper
Updated over a week ago

This article will show you:

  • How to upload your file into Google sheets to edit using Google commands

  • Google sheets commands

How do I upload a file into Google Sheets?

1. Open up Google Drive

2. Click on New and select Google Sheets

3. In your new sheet, click File > Import...

4. Click Select a file from your computer and upload your spreadsheet into the Google sheet

What are some ways I can edit my file in Google sheets?

-How do I split columns?

1. Move the tag column to the far right side of your spreadsheet because splitting it will overwrite other columns

2. Select Data --> Split text to columns (pick your Separator)

-How do I remove commas?

Select column -> Edit -> Find and Replace -> ","
​

-How do I remove columns?

Right click on the column --> Delete column

-What if my headers are not labeled?

Make sure your headers are labeled as shown in the spreadsheet images of this doc.
​

For further help or comments, head over to our Community Section!

Did this answer your question?