How to import data sets and spreadsheets to a Google Sheet
The Google Sheets integration makes it easy to upload data to Databox. In order to import .xls, .xlsx, .xlsm, .xlt, .xltx, .xltm, .ods, .csv, .txt, .tsv, and .tab files to Google Sheets, follow the steps below.
If you prefer, you can learn directly from Google's documentation here.
- Create new spreadsheet: Create a spreadsheet from the imported data in a new browser tab.
- Insert new sheets: Adds new sheets with the imported data to your existing spreadsheet.
- Replace spreadsheet: Replace the open spreadsheet with the data in your imported file.
- Replace current sheet: Replace the current sheet’s contents with the imported data.
- Append rows to current sheet: Adds the imported data to the current sheet after the last row with any data.
- Replace data starting at selected cell: Replace the data in a range of selected cells with the imported data
If you are importing a plain text file (i.e., .csv or .txt), select a Separator type. This will letter or symbol will be used by Google Sheets to separate cells.
- Detect automatically: This will automatically find ways to split your data set. For example, it can detect fixed-width-formatted files.
- Tab: This will split your data set based on tabs.
- Comma: This will split your data set based on commas.
- Custom: Choose a custom character to split your data.
Select whether you would like to Convert text to numbers, dates, and formulas. In most cases, you should select "Yes."