Is it possible to upload an excel file to an S3 bucket (input location = XLSX file), create a Databrew Dataset from that excel file, and create a recipe in AWS Glue Databrew that converts that excel file to a CSV file (output location which contains a transformed CSV file)?
How to convert XLSX file to CSV using AWS Glue Databrew
2.5k views Asked by GNGRDB At
1
There are 1 answers
Related Questions in AWS-GLUE
- AWS GLUE child node execution order of same level
- Is there a way to import Redshift Connection in PySpark AWS Glue Job?
- Retrieving a list of all failed Glue jobs via CLI
- How do I change the data type in a Glue Crawler?
- Loading around 50gb of parquet data to Redshift taking indefinite time to load
- Glue Notebook not starting: Failed to start notebook
- old aws-glue libraries in the Glue streaming ETL job 4.0?
- Add File name column to Dynamic Frame
- How to test Glue jobs and Athena queries locally on dummy data?
- AWS Glue throws AWSBadRequestException when loading DynamicFrame from s3 with local Glue docker
- AWS Glue Insert and update into oracle table
- SQL query to extract incremental data from a table in SQL Server
- redshift spectrum type conversion from String to Varchar
- Apply transformation on nested json column in dataframe
- Access Denied while creating crawler
Related Questions in AWS-DATABREW
- How to add new colums in AWS Databrew based on some logic and values in existing colums
- Can I have AWS Glue Databrew update a Redshift table instead of create a new one every time the job runs?
- Aws Data Brew -
- AWS S3 bucket notification lambda throws exception (Service: Amazon S3; Status Code: 404; Error Code: NoSuchKey)
- Why is Pyarrow and Pandas Dataframe Compression Create Higher Memory Files Than AWS Databrew?
- AWS Databrew DateTime format coversion error
- AWS Glue Databrew, manipulating data with code
- In AWS Databrew, how can I stop the Databrew job from partitioning the result file?
- How can I add new columns to the original dataset each month using AWS Databrew or other AWS services
- Unable to reach AWS Glue to get connection in DataBrew
- How to convert XLSX file to CSV using AWS Glue Databrew
- AWS DataBrew auto-formats XLSX DateTime column to string java.util.GregorianCalendar[time=... (GregorianCalendar) how do I format back in recipe?
- AWS DataBrew - ValueError: Could not parse datatype: decimal(1,-3317)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Popular Tags
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
The short answer to your question is Yes, but not the way you are expecting it to be done. But here's one way --
Please note -
It is worth mentioning that if you have a single file or just a couple files that needs to be converted into CSV, then there are easier ways to convert the file from XLSX to CSV using MS Excel software -- simply Open the file and "Save as" as CSV as shown in the screenshot below.