How to convert an Excel spreadsheet to a CSV file in React?

Question

I'm creating a file upload system in my React app that allows users to upload an Excel spreadsheet to an S3 bucket which can then be converted to a CSV.

const submitFile = (substring) => {
  const ReactS3Client = new S3(config);
  ReactS3Client.uploadFile(file, substring).then(data => {
    if (data.status === 204) {
      alert("File successfully uploaded");
    } else {
      alert("Something went wrong");
    }
  })
};

I'm wondering if it's possible to take the Excel spreadsheet file and convert it to a CSV file before I upload it to the S3 bucket. I haven't been able to find much about this so I'm not sure if it's possible.

ckesplin · Accepted Answer · 2021-03-26 03:50:23Z

1

It looks like the npm package, xlsx, may have a utility for doing just that.

Take a look at the XLSX.utils.sheet_to_csv util.

answered Mar 26, 2021 at 3:50

ckesplin

1,8631 gold badge16 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to convert an Excel spreadsheet to a CSV file in React?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related