S3 to Spreadsheet

Import data directly from S3 to a spreadsheet in Row Zero. Row Zero is a supercharged spreadsheet and can handle the biggest files.

Table of Contents

Import from S3 Presigned URL

To import from S3 using a pre-signed URL, simply visit your S3 console and select the bucket containing the file you want to import. In the bucket, select the check box next to the bucket, then choose 'Actions' and 'Share with presigned URL.' On the next screen, enter the amount of time (minutes or hours) you would like the link to be accessible. Next click the orange 'Create presigned URL' button. You will be taken back to your S3 bucket and the presigned URL will automatically copied to your clipboard.S3 create URL screen

Now go to Row Zero, click on Data > Import > Import from URL, paste your presigned URL into the text box and click 'Import.'Pasted S3 bucket URL screen in Row Zero

Browse S3 directly from the spreadsheet

For users who are regularly exploring and analyzing S3 a more efficient option is to connect S3 directly to Row Zero. Once complete, the connected S3 bucket will display in the Row Zero Data Import window, making it easy to browse and select an S3 file to import into the spreadsheet.Data import menuBrowse S3 buckets in Row Zero

Open and combine multiple S3 files

For users with multiple related files in one folder, Row Zero can combine, merge, and concatenate S3 files into one spreadsheet, making the data easier to analyze. One your S3 bucket is connected, navigate to any folder and select the files you would like to combine. Then use the import window to verify whether your data has headers and hit 'import.' Row Zero will merge the S3 files and concatenate them into one worksheet.S3 import multiple files

Connect a S3 bucket

There are 3 main steps to connect a S3 bucket and instructions can be found in our post, 'Connect S3 Bucket to Spreadsheet for Data Analysis'

  1. Click the Row Zero 'Connect Bucket' tabConnect S3 bucket screen in Row Zero
  2. Create an IAM roleIAM role details screen in Row Zero
  3. Import DataImported data preview screen in Row Zero

Row Zero can open billion row multi-GB files, so you can open big CSVs directly from S3. You can also open parquet files, xlsx, and more.

Connect S3